62,067
社区成员
发帖
与我相关
我的任务
分享
public DataSet getDataSet(string pSql, bool pIsPro, params SqlParameter[] paramenters)
{
DataSet ds = new DataSet();
if (isConnect())
{
try
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = mConn;
cmd.CommandText = pSql;
cmd.CommandTimeout = 0;
if (paramenters != null)
{
foreach (SqlParameter parm in paramenters)
cmd.Parameters.Add(parm);
}
if (pIsPro)
cmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter ada = new SqlDataAdapter();
ada.SelectCommand = cmd;
ada.Fill(ds);
cmd.Dispose();
ada.Dispose();
}
catch
{
}
}
return ds;
}
public DataSet getDataSet(string pSql, bool pIsPro, params SqlParameter[] paramenters)//实例化Connection对象
SqlConnection connection = new SqlConnection("Data Source=(local);Initial Catalog=AspNetStudy;Persist Security Info=True;User ID=sa;Password=sa");
//实例化Command对象
SqlCommand command = new SqlCommand("select * from UserInfo where sex=@sex and age>@age", connection);
//第一种添加查询参数的例子
command.Parameters.AddWithValue("@sex", true);
//第二种添加查询参数的例子
SqlParameter parameter = new SqlParameter("@age", SqlDbType.Int);//注意UserInfo表里age字段是int类型的
parameter.Value = 30;
command.Parameters.Add(parameter);//添加参数
//实例化DataAdapter
SqlDataAdapter adapter = new SqlDataAdapter(command);
DataTable data = new DataTable();