c#中,用存储过程怎么做,最好能举个例子,给个简单的示范 主要是为了结果能返回到datagrid中显示出来,切、且要用到Sqldataadapter 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 /// <summary> /// 执行存储过程 /// </summary> /// <param name="stocreProcName">存储过程名</param> /// <returns></returns> public static DataSet GetDataSetFromProcedure(string stocreProcName) { SqlConnection con = DB.sqlcon(); SqlCommand cmd = new SqlCommand(); cmd.Connection = con; con.Open(); cmd.CommandText = stocreProcName; cmd.CommandType = CommandType.StoredProcedure; SqlDataAdapter sdr = new SqlDataAdapter(); sdr.SelectCommand = cmd; DataSet ds = new DataSet(); sdr.Fill(ds); return ds; } /// <summary> /// 执行带参数存储过程,返回DATASET /// </summary> /// <param name="storedProcName">存储过程名</param> /// <param name="where">查询条件</param> /// <returns></returns> public static DataSet RunProcedureWhere(string storedProcName,string where) { SqlConnection con = DB.sqlcon(); SqlCommand selectCMD = new SqlCommand(); selectCMD.CommandText = storedProcName; selectCMD.Connection = con; selectCMD.CommandType = CommandType.StoredProcedure; SqlParameter myParm = new SqlParameter("@ID", SqlDbType.NVarChar, 10); myParm.Direction = System.Data.ParameterDirection.Input; myParm.Value = where; selectCMD.Parameters.Add(myParm); SqlDataAdapter myCommand = new SqlDataAdapter(); myCommand.SelectCommand = selectCMD; DataSet myDataSet = new DataSet(); myCommand.Fill(myDataSet); return myDataSet; } 再补充一下,将数据显示在DataGridView中:DataGridView1.DataSource=ds.Tables[0]; /// <summary> /// 执行存储过程 /// </summary> /// <param name="stocreProcName">存储过程名</param> /// <returns></returns> public static DataSet GetDataSetFromProcedure(string stocreProcName) { SqlConnection con = DB.sqlcon(); SqlCommand cmd = new SqlCommand(); cmd.Connection = con; con.Open(); cmd.CommandText = stocreProcName; cmd.CommandType = CommandType.StoredProcedure; SqlDataAdapter sdr = new SqlDataAdapter(); sdr.SelectCommand = cmd; DataSet ds = new DataSet(); sdr.Fill(ds); return ds; } 如果是DataGrid,则使用SetDataBinding方法:DataGrid1.SetDataBinding(ds,"表名"); http://www.webdiyer.com/Controls/AspNetPager/SpGenerator如果是SqlServer楼主去这个地方看看。 求大神指导,浅度复制和深度复制的问题 页面A以HttpWebRequest方式调用页面B,页面B如何获取页面A的Url? Office文件处理的问题 VS2008 乱码 正则匹配 请各位给看看这个文件下载的问题出在哪? 设计期无法显示继承的窗体,报错"未将对象引用设置到对象的实例"?怎么回事啊? 急,实习第一个测试啊 如何在 tabpages 控件 按页内控件 刷新数据? C#如何将一个字符串中的指定一个字符转变成Char型的变量?? vs2008打包C#程序 想在 其他没装.NET 的XP下安装 想在C#中,用调用SQL2000中的存储过程怎么调用
/// 执行存储过程
/// </summary>
/// <param name="stocreProcName">存储过程名</param>
/// <returns></returns>
public static DataSet GetDataSetFromProcedure(string stocreProcName)
{
SqlConnection con = DB.sqlcon();
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
con.Open();
cmd.CommandText = stocreProcName;
cmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter sdr = new SqlDataAdapter();
sdr.SelectCommand = cmd;
DataSet ds = new DataSet();
sdr.Fill(ds);
return ds;
}
/// <summary>
/// 执行带参数存储过程,返回DATASET
/// </summary>
/// <param name="storedProcName">存储过程名</param>
/// <param name="where">查询条件</param>
/// <returns></returns>
public static DataSet RunProcedureWhere(string storedProcName,string where)
{
SqlConnection con = DB.sqlcon();
SqlCommand selectCMD = new SqlCommand();
selectCMD.CommandText = storedProcName;
selectCMD.Connection = con;
selectCMD.CommandType = CommandType.StoredProcedure;
SqlParameter myParm = new SqlParameter("@ID", SqlDbType.NVarChar, 10);
myParm.Direction = System.Data.ParameterDirection.Input;
myParm.Value = where;
selectCMD.Parameters.Add(myParm);
SqlDataAdapter myCommand = new SqlDataAdapter();
myCommand.SelectCommand = selectCMD;
DataSet myDataSet = new DataSet();
myCommand.Fill(myDataSet);
return myDataSet;
}
DataGridView1.DataSource=ds.Tables[0]; /// <summary>
/// 执行存储过程
/// </summary>
/// <param name="stocreProcName">存储过程名</param>
/// <returns></returns>
public static DataSet GetDataSetFromProcedure(string stocreProcName)
{
SqlConnection con = DB.sqlcon();
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
con.Open();
cmd.CommandText = stocreProcName;
cmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter sdr = new SqlDataAdapter();
sdr.SelectCommand = cmd;
DataSet ds = new DataSet();
sdr.Fill(ds);
return ds;
}