110,534
社区成员
发帖
与我相关
我的任务
分享
public static void zengjiarucang(DataRow dr)
{
string zengjiacc = "";
string zengjiaaa = "";
int pld = dtcrc.Columns.Count;
for (int i = 0; i < pld; i++)
{
string pls = dtcrc.Columns[i].Caption;
if (i == 0)
{
zengjiacc = "[" + pls + "]";
zengjiaaa = "@" + pls;
}
else
{
zengjiacc = zengjiacc + ",[" + pls + "]";
zengjiaaa = zengjiaaa + ",@" + pls;
}
}
string zengjia = "insert into [入仓](" + zengjiacc + ") values(" + zengjiaaa + ")";
OleDbCommand comm = new OleDbCommand(zengjia, conn);
zengjia = "";
//System.Windows.Forms.MessageBox.Show(zengjia);
for (int i = 0; i < pld; i++)
{
string pls = dtcrc.Columns[i].Caption;
if (dr[i].GetType().FullName.Equals("System.DateTime"))
{
OleDbParameter parm = new OleDbParameter("@" + pls, OleDbType.DBTimeStamp);
parm.Value = Convert.ToDateTime(dr[i].ToString()).ToString("yyyy-MM-dd HH:mm:ss");
comm.Parameters.Add(parm);
}
else
{
if (dr[i].GetType().FullName.Equals("System.Int32"))
{
OleDbParameter parm = new OleDbParameter("@" + pls, OleDbType.Integer);
parm.Value =Int32.Parse( dr[i].ToString());
comm.Parameters.Add(parm);
}
else
{
if (dr[i].GetType().FullName.Equals("System.Double"))
{
OleDbParameter parm = new OleDbParameter("@" + pls, OleDbType.Double);
parm.Value = double.Parse(dr[i].ToString());
comm.Parameters.Add(parm);
}
else
{
if (dr[i].GetType().FullName.Equals("System.String"))
{
OleDbParameter parm = new OleDbParameter("@" + pls, OleDbType.VarWChar);
parm.Value = dr[i].ToString();
comm.Parameters.Add(parm);
}
else
{
System.Windows.Forms.MessageBox.Show(dr[i].GetType().ToString());
}
}
}
}
}
comm.ExecuteNonQuery();
}