为什么在调用存储过程时,不能用objCommand.CommandType = CommandType.StoredProcedure?
芝城游侠 2003-08-18 05:50:03 private void Page_Load(object sender, System.EventArgs e)
{
SqlConnection strConnection = new SqlConnection("server=alex;database=northwind;uid=sa;pwd=coolsoon");
strConnection.Open();
SqlCommand objCommand = new SqlCommand();
objCommand.Connection = strConnection;
objCommand.CommandText = "[Sales by Year] [1996-10-23],[1997-10-23]";
objCommand.CommandType = CommandType.Text; //指定如何解释命令字符串
DataGrid1.DataSource = objCommand.ExecuteReader(CommandBehavior.CloseConnection);
DataGrid1.DataBind();
}
我上面的写法可以正确执行,但是我明明调用的是存储过程,为什么用objCommand.CommandType = CommandType.StoredProcedure时反而出错呢?