110,570
社区成员
发帖
与我相关
我的任务
分享
public void InsertBudgetFee(DataTable dt, int index, Database db, DbTransaction transaction)
{
DataSet ds = new DataSet();
ds.Tables.Add(dt);
string proc = "";
switch (index)
{
case 1:
proc = "PA.InsertMainBudget";
break;
case 2:
proc = "PA.InsertOtherBudget";
break;
}
DbCommand cmd = db.GetStoredProcCommand(proc);
db.AddInParameter(cmd, "pHeadId", DbType.String, KeyValue);
db.AddInParameter(cmd, "pXml", DbType.Xml, ds.GetXml());
db.AddInParameter(cmd, "pUserId", DbType.Int32, CurrentUser.UserID);
db.ExecuteNonQuery(cmd, transaction);
}
private void button3_Click(object sender, EventArgs e)
{
for (int i = 0; i < this.dataGridView1.Rows.Count - 1; i++)
{
string a = dataGridView1.Rows[i].Cells[0].Value.ToString();
string b = dataGridView1.Rows[i].Cells[1].Value.ToString();
string c = dataGridView1.Rows[i].Cells[2].Value.ToString();
insertdata(a,b,c);
}
}
public void insertdata(string s1, string s2, string s3)//插入数据库
{
SqlConnection con = new SqlConnection("Data Source=10.168.1.5;Initial Catalog=data;User ID=sa;password=sa;Integrated Security=False");
con.Open();
SqlCommand cmd = new SqlCommand(string.Format("select Count(*) from newtable where a= '{0}'", s1), con);
if ((int)cmd.ExecuteScalar() > 0)
{
listBox1.Items.Add(s1 + " 数据已经存在");
}
else
{
string sql = "insert into SC(Sno,Cno,score) values('" + s1 + "','" + s2 + "','" + s3 + "')";
cmd.CommandText = sql;
cmd.ExecuteNonQuery();
listBox1.Items.Add(s1 + " 成功添加");
}
cmd.Dispose();
con.Close();
}