110,538
社区成员
发帖
与我相关
我的任务
分享
public DataSet ExcuteQuery(string sql,SqlParameter[]paras,CommandType ct)
{
DataSet ds=new DataSet();
using (SqlDataAdapter sda=new SqlDataAdapter(sql,GetConn()))
{
//SqlDataAdapter sda = new SqlDataAdapter("ImageMessage", myCon);//ImageMessage为存储过程名
//sda.SelectCommand.CommandType = CommandType.StoredProcedure;
//SqlParameter spt = new SqlParameter("@mvName", SqlDbType.VarChar, 20);
//spt.Direction = ParameterDirection.Input;
//spt.Value = mvName;
//sda.SelectCommand.Parameters.Add(spt);
//DataSet ds = new DataSet();
//sda.Fill(ds, "ffc");
//return ds;
sda.Fill(ds);
}
return ds;
}
public DataSet ExcuteQuery(string sql, SqlParameter[] paras, CommandType ct)
{
DataSet ds = new DataSet();
using (SqlDataAdapter sda = new SqlDataAdapter(sql, GetConn()))
{
try
{
sda.SelectCommand.Parameters.AddRange(paras);
sda.Fill(ds);
}
catch (System.Exception ex)
{
throw ex;
}
finally
{
ds.Dispose();
}
}
return ds;
}
我改成这样,好像还是报错,说没传入参数.
sda.SelectCommand.Parameters.AddRange(paras);
更多的信息:
http://msdn.microsoft.com/zh-cn/library/ms136441.aspx