asp.net 3.5中 connectionstring 里的 name 是什么

name 表示这个connection标签的名称 ，可以在后台根据这个name名称 获取相应的connectionString 值

public static string ConnString = ConfigurationManager.ConnectionStrings["dingxiConnectionString"].ConnectionString;

就是后台调用连接数据库的，很简单。

public static DataTable GetDataTable(string sql, SqlParameter[] sqlpar)
{
SqlConnection sqlcon = null;
try
{
sqlcon = new SqlConnection(ConnString);
sqlcon.Open();
SqlCommand sqlcom = new SqlCommand();
sqlcom.CommandText = sql;
sqlcom.Connection = sqlcon;
sqlcom.Parameters.AddRange(sqlpar);
SqlDataAdapter sqldata = new SqlDataAdapter();
sqldata.SelectCommand = sqlcom;
DataTable dt = new DataTable("newTable");
sqldata.Fill(dt);
sqlcon.Close();
return dt;
}
catch (Exception ex)
{
throw ex;
}
finally
{
sqlcon.Close();
}
}

public static int ExecSQL(string sql, SqlParameter[] sqlpar)
{
SqlConnection sqlcon = null;
try
{
sqlcon = new SqlConnection(ConnString);
sqlcon.Open();
SqlCommand sqlcom = new SqlCommand();
sqlcom.CommandText = sql;
sqlcom.Connection = sqlcon;
sqlcom.Parameters.AddRange(sqlpar);

return sqlcom.ExecuteNonQuery();
}
catch (Exception ex)
{
throw ex;
}
finally
{
sqlcon.Close();
}
}