有数组传递sqlparameter的参数sample没 谁能给个sqlparameter的参数 用数组传递sqlparameter的参数进行处理的 谢谢 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 private static void AssignParameterValues(SqlParameter[] commandParameters, DataRow dataRow) oledbcommand = new System.Data.OleDb.OleDbCommand("insert into SlabSpec(Code,Spec)values(?,?)",oledbconnection);oledbcommand.Parameters.Add(new System.Data.OleDb.OleDbParameter("Code",System.Data.OleDb.OleDbType.TinyInt,8,"规格编号"));oledbcommand.Parameters.Add(new System.Data.OleDb.OleDbParameter("Spec",System.Data.OleDb.OleDbType.VarChar,10,"断面规格"));oledbdataadapter.InsertCommand = oledbcommand; SqlParameter[] coll = new SqlParameter[3];coll[0] = new SqlParameter("@ID",SqlDbType.Int);coll[0].Value = ID;coll[1] = new SqlParameter("@Kind",SqlDbType.Int);coll[1].Value = Kind;coll[2] = new SqlParameter("@RootKind",SqlDbType.Int);coll[2].Value = RootKind;/////////////////////////////////////////////public static void ExecutePorcedure(string procName,SqlParameter[] coll,ref DataSet ds) { try { SqlDataAdapter da=new SqlDataAdapter(); openConnection(); for(int i=0;i<coll.Length;i++) { comm.Parameters .Add(coll[i]); } comm.CommandType=CommandType.StoredProcedure ; comm.CommandText =procName; da.SelectCommand =comm; da.Fill(ds); } catch(Exception e) { throw new Exception(e.Message); } finally { comm.Parameters.Clear(); closeConnection(); } //数据调用层//////////////////////////////////////////////////////public int InsertCalendar(int uKey,DateTime cTime,int cTimes,int cFreq,string cTitle,string cContent) { int Num = 0; SqlParameter[] parameters = { new SqlParameter("uKey",SqlDbType.Int), new SqlParameter("cTime",SqlDbType.DateTime), new SqlParameter("cTimes",SqlDbType.Int), new SqlParameter("cFreq",SqlDbType.Int), new SqlParameter("cTitle",SqlDbType.VarChar), new SqlParameter("cContent",SqlDbType.VarChar) }; parameters[0].Value = uKey; parameters[1].Value = cTime; parameters[2].Value = cTimes; parameters[3].Value = cFreq; parameters[4].Value = cTitle; parameters[5].Value = cContent; //调用数据操作类DataOper(自己写的) //"Insert_Calender"是存储过程名称,parameters是传给存储过程的数据集 Num = DataOper.RunParaMeters_Int("Insert_Calender", parameters); return Num; }//数据操作类//////////////////////////////////////////////////////////////////// <summary> /// 根据传过来的"存储过程名称"和"值/集合"返回[Int]数值,这里引用了SqlHelp.cs文件,如果需要与我联系:QQ7999450 /// </summary> /// <param name="ProcName">存储过程名称</param> /// <param name="parameters">值/集合</param> /// <returns>int</returns> public int RunParaMeters_Int(string ProcName,SqlParameter[] parameters) { int Count = 0; using (SqlConnection conn = new SqlConnection(ConnString)) { conn.Open(); using (SqlTransaction trans = conn.BeginTransaction()) { try { Count = SqlHelper.ExecuteNonQuery(trans,CommandType.StoredProcedure,ProcName,parameters); trans.Commit(); } catch { trans.Rollback(); throw; } } conn.Close(); } return Count; } JS中 时间推算的问题 关于C#中Winform的频繁写数据库的问题 如何捕捉Form窗口最小化事件? 关于yield web控件中如何调用javaScript进行有效性检查! 这个错误是什么意思? 求注释程序!!!最好一段一注释!!!,不行一行也行!!!! 怎么把控制台readline读出的string 转成 args? 求排队论程序 怎么热搜索"C#"的时候,第2页时却变成了"C"! 查看 设置windows服务 简单登陆问题,说明原理立刻结贴。
oledbcommand.Parameters.Add(new System.Data.OleDb.OleDbParameter("Code",System.Data.OleDb.OleDbType.TinyInt,8,"规格编号"));
oledbcommand.Parameters.Add(new System.Data.OleDb.OleDbParameter("Spec",System.Data.OleDb.OleDbType.VarChar,10,"断面规格"));
oledbdataadapter.InsertCommand = oledbcommand;
coll[0] = new SqlParameter("@ID",SqlDbType.Int);
coll[0].Value = ID;
coll[1] = new SqlParameter("@Kind",SqlDbType.Int);
coll[1].Value = Kind;
coll[2] = new SqlParameter("@RootKind",SqlDbType.Int);
coll[2].Value = RootKind;
/////////////////////////////////////////////
public static void ExecutePorcedure(string procName,SqlParameter[] coll,ref DataSet ds)
{
try
{
SqlDataAdapter da=new SqlDataAdapter();
openConnection();
for(int i=0;i<coll.Length;i++)
{
comm.Parameters .Add(coll[i]);
}
comm.CommandType=CommandType.StoredProcedure ;
comm.CommandText =procName; da.SelectCommand =comm;
da.Fill(ds);
}
catch(Exception e)
{
throw new Exception(e.Message);
}
finally
{
comm.Parameters.Clear();
closeConnection();
}
public int InsertCalendar(int uKey,DateTime cTime,int cTimes,int cFreq,string cTitle,string cContent)
{
int Num = 0;
SqlParameter[] parameters =
{
new SqlParameter("uKey",SqlDbType.Int),
new SqlParameter("cTime",SqlDbType.DateTime),
new SqlParameter("cTimes",SqlDbType.Int),
new SqlParameter("cFreq",SqlDbType.Int),
new SqlParameter("cTitle",SqlDbType.VarChar),
new SqlParameter("cContent",SqlDbType.VarChar)
}; parameters[0].Value = uKey;
parameters[1].Value = cTime;
parameters[2].Value = cTimes;
parameters[3].Value = cFreq;
parameters[4].Value = cTitle;
parameters[5].Value = cContent;
//调用数据操作类DataOper(自己写的)
//"Insert_Calender"是存储过程名称,parameters是传给存储过程的数据集
Num = DataOper.RunParaMeters_Int("Insert_Calender", parameters);
return Num;
}//数据操作类/////////////////////////////////////////////////////////////////
/// <summary>
/// 根据传过来的"存储过程名称"和"值/集合"返回[Int]数值,这里引用了SqlHelp.cs文件,如果需要与我联系:QQ7999450
/// </summary>
/// <param name="ProcName">存储过程名称</param>
/// <param name="parameters">值/集合</param>
/// <returns>int</returns>
public int RunParaMeters_Int(string ProcName,SqlParameter[] parameters)
{
int Count = 0;
using (SqlConnection conn = new SqlConnection(ConnString))
{
conn.Open();
using (SqlTransaction trans = conn.BeginTransaction())
{
try
{
Count = SqlHelper.ExecuteNonQuery(trans,CommandType.StoredProcedure,ProcName,parameters);
trans.Commit();
}
catch
{
trans.Rollback();
throw;
}
}
conn.Close();
} return Count;
}