有数组传递sqlparameter的参数sample没

[ttlrwdl]

谁能给个sqlparameter的参数 用数组传递sqlparameter的参数进行处理的 谢谢

[chenyuming2004]

private static void AssignParameterValues(SqlParameter[] commandParameters, DataRow dataRow)

[vshake]

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;

[zsgbox]

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();
}

[Csharpbull]

为什么不用存储过程呢？

[hyb3280660]

//数据调用层//////////////////////////////////////////////////////
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;
}