SqlConnection conn = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);
string sql="select webid,webname,weburl from webinfo where daishen='0'";
conn.Open();
DataSet ds = new DataSet();
SqlDataAdapter sqlAdapter = new SqlDataAdapter(sql,conn);
sqlAdapter.Fill(ds,"webinfo");
DataView dataview = new DataView();
dataview = ds.Tables[0].DefaultView;dgshenghe.DataSource = ds.Tables[0].DefaultView;
dgshenghe.DataBind();
怎么样才能把上面的SQL变成一个存储过程来调用啊?我的数据很大,这们直接用sql,页面总越时
不能显示!最好是有实例让我看一下!~
string sql="select webid,webname,weburl from webinfo where daishen='0'";
conn.Open();
DataSet ds = new DataSet();
SqlDataAdapter sqlAdapter = new SqlDataAdapter(sql,conn);
sqlAdapter.Fill(ds,"webinfo");
DataView dataview = new DataView();
dataview = ds.Tables[0].DefaultView;dgshenghe.DataSource = ds.Tables[0].DefaultView;
dgshenghe.DataBind();
怎么样才能把上面的SQL变成一个存储过程来调用啊?我的数据很大,这们直接用sql,页面总越时
不能显示!最好是有实例让我看一下!~
DataSet ds = new DataSet();
SqlDataAdapter sqlAdapter = new SqlDataAdapter("存储过程名",conn);
SqlAdapter.Fill(ds,"webinfo");
DataView dataview = new DataView();
dataview = ds.Tables[0].DefaultView;dgshenghe.DataSource = ds.Tables[0].DefaultView;
dgshenghe.DataBind();把定义好的存储过程名替换就可以了。
SqlDataAdapter会自动打开连接的了,不需要conn.Open()
SqlConnection conn = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);
DataSet ds = new DataSet();
SqlDataAdapter sqlAdapter = new SqlDataAdapter("存储过程名",conn);
SqlAdapter.SelectCommand.CommandType = CommandType.StoredProcedure;
SqlAdapter.Fill(ds,"webinfo");
DataView dataview = new DataView();
dataview = ds.Tables[0].DefaultView;dgshenghe.DataSource = ds.Tables[0].DefaultView;
dgshenghe.DataBind();把定义好的存储过程名替换就可以了。
SqlDataAdapter会自动打开连接的了,不需要conn.Open()
SqlCommand cmd = conn.CreateCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "StoreProcName";
DataSet ds = new DataSet();
SqlDataAdapter sqlAdapter = new SqlDataAdapter(cmd);
sqlAdapter.Fill(ds,"webinfo");
DataView dataview = new DataView();
dataview = ds.Tables[0].DefaultView;dgshenghe.DataSource = ds.Tables[0].DefaultView;
dgshenghe.DataBind();
cmd.CommandType = CommandType.StoredProcedure;// 1 fields, 存储过程入口参数
cmd.Parameters.Add(new SqlParameter("@daishen", SqlDbType.NVarChar, 50));
cmd.Parameters["@daishen"].Value = "0";SqlDataAdapter sqlAdapter = new SqlDataAdapter(cmd);
...==========================
但愿雨水皆化酒,只恨今生已非人.
...
_conn.Open();
SqlCommand _comm = new SqlCommand( "Procedure's Name", _conn );
DataSet ds = new DataSet();
try
{
_comm.CommandType = CommandType.StoredProcedure;
_comm.Parameter.Add( ……).…… = ……;
_comm.ExecuteNonQuery();
SqlDataAdapter da = new SqlDataAdapter( _comm );
da.Fill( ds );
}
catch( Exception Message )
{ catch Error }_conn.Close();
return ds;