sqldatasource控件给存储过程传参问题
前台代码：
  string kssj = TextBox2.Text;
  string jssj = TextBox4.Text;
  SqlDataSource1.ConnectionString = "Data Source=LJ-PC\\SQLEXPRESS;Initial Catalog=StudyRoom;Integrated Security=True";
  SqlDataSource1.SelectCommandType = SqlDataSourceCommandType.StoredProcedure;
  SqlDataSource1.SelectCommand = "datasum_proc";
  SqlDataSource1.SelectParameters.Add("@p_kssj", TypeCode.String, kssj);
  SqlDataSource1.SelectParameters.Add("@p_jssj", TypeCode.String, jssj);
  GridView1.DataSource = SqlDataSource1;
  SqlDataSource1.DataBind();
  GridView1.DataBind();

数据库存储过程：
create proc datasum_proc
@p_kssj varchar(10),
@p_jssj varchar(10)

as

select * from table where kssj between @p_kssj and @p_jssj

return 0



运行vs2005下该页面的时候 一直提示 未提供参数 @p_kssj

------解决方案--------------------

SqlDataSource1.DataBind();
GridView1.DataSource = SqlDataSource1;

换下顺序

或者
SqlConnection connection = new SqlConnection("Data Source=LJ-PC\\SQLEXPRESS;Initial Catalog=StudyRoom;Integrated Security=True");
connection.Open();
SqlCommand command = new SqlCommand("datasum_proc", connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@p_kssj", kssj);
command.Parameters.AddWithValue("@p_jssj", jssj);
SqlDataReader reader = command.ExecuteReader();
GridView1.DataSource = reader ;
GridView1.DataBind();