我有一个存储过程select_by_order要有一个参数:
用SqlDataAdapter读取数据,我是这么写:
strSql = "select_by_order "+"参数";
sdAdapter = new SqlDataAdapter(strSql,conn);
sdAdapter.Fill(dsData,"table");不过这样好像不是正常用法吧?
应怎么写比较好?谢谢
用SqlDataAdapter读取数据,我是这么写:
strSql = "select_by_order "+"参数";
sdAdapter = new SqlDataAdapter(strSql,conn);
sdAdapter.Fill(dsData,"table");不过这样好像不是正常用法吧?
应怎么写比较好?谢谢
我也想知道如何做的,帮你顶一下。
SqlDataAdapter ada = new ....
SqlCommand cmd = new ...
cmd.Connection = new SqlConnection(constr);
cmd.text = "select_by_order ";
cmd.Type = CommandType.StoredProcedure;
SqlParameter para = new SqlParameter("@参数",类型,大小);
参数 = ***;//赋值
cmd.Parameter.Add(para);
ada.SelectCommand = cmd;
DataSet dt = new Dataset();
ada.Fill(dt);