怎么把datase的数据添加到数据库中
答案:1 悬赏:0
解决时间 2021-01-24 13:42
- 提问者网友:且恨且铭记
- 2021-01-24 04:32
怎么把datase的数据添加到数据库中
最佳答案
- 二级知识专家网友:低血压的长颈鹿
- 2021-01-24 04:55
把数据添加到sql中
string sql = "INSERT INTO tbStudent VALUES (@Name,@Ware,@Model,@Number,@Sale,@Opinion,@Bonus)";
//string sql = "INSERT INTO tbStudent VALUES(@sNo,@sName,@sSex,@sAge)";
// 产生命令对象
SqlDataAdapter sqlAdap = new SqlDataAdapter();
SqlCommand cmd = new SqlCommand(sql, sqlcon);
sqlAdap.InsertCommand = cmd;
// 设置参数
SqlParameter pa = cmd.Parameters.Add("@Name", SqlDbType.VarChar, 20);
pa.SourceColumn = "Name";
pa.SourceVersion = DataRowVersion.Current;
pa = cmd.Parameters.Add("@Ware", SqlDbType.VarChar, 20);
pa.SourceColumn = "Ware";
pa.SourceVersion = DataRowVersion.Current;
pa = cmd.Parameters.Add("@Model", SqlDbType.VarChar, 20);
pa.SourceColumn = "Model";
pa.SourceVersion = DataRowVersion.Current;
pa = cmd.Parameters.Add("@Number", SqlDbType.Int, 4);
pa.SourceColumn = "Number";
pa.SourceVersion = DataRowVersion.Current;
pa = cmd.Parameters.Add("@Sale", SqlDbType.Money, 20);
pa.SourceColumn = "Sale";
pa.SourceVersion = DataRowVersion.Current;
pa = cmd.Parameters.Add("@Opinion", SqlDbType.VarChar, 20);
pa.SourceColumn = "Opinion";
pa.SourceVersion = DataRowVersion.Current;
pa = cmd.Parameters.Add("@Bonus", SqlDbType.Float, 8);
pa.SourceColumn = "Bonus";
pa.SourceVersion = DataRowVersion.Current;
try
{
sqlAdap.Update(ds.Tables[0]);
ds.Tables[0].AcceptChanges();
MessageBox.Show("添加成功!");
}
catch (Exception ex)
{
MessageBox.Show("添加失败!错误描述为:" + ex.Message);
}
}
string sql = "INSERT INTO tbStudent VALUES (@Name,@Ware,@Model,@Number,@Sale,@Opinion,@Bonus)";
//string sql = "INSERT INTO tbStudent VALUES(@sNo,@sName,@sSex,@sAge)";
// 产生命令对象
SqlDataAdapter sqlAdap = new SqlDataAdapter();
SqlCommand cmd = new SqlCommand(sql, sqlcon);
sqlAdap.InsertCommand = cmd;
// 设置参数
SqlParameter pa = cmd.Parameters.Add("@Name", SqlDbType.VarChar, 20);
pa.SourceColumn = "Name";
pa.SourceVersion = DataRowVersion.Current;
pa = cmd.Parameters.Add("@Ware", SqlDbType.VarChar, 20);
pa.SourceColumn = "Ware";
pa.SourceVersion = DataRowVersion.Current;
pa = cmd.Parameters.Add("@Model", SqlDbType.VarChar, 20);
pa.SourceColumn = "Model";
pa.SourceVersion = DataRowVersion.Current;
pa = cmd.Parameters.Add("@Number", SqlDbType.Int, 4);
pa.SourceColumn = "Number";
pa.SourceVersion = DataRowVersion.Current;
pa = cmd.Parameters.Add("@Sale", SqlDbType.Money, 20);
pa.SourceColumn = "Sale";
pa.SourceVersion = DataRowVersion.Current;
pa = cmd.Parameters.Add("@Opinion", SqlDbType.VarChar, 20);
pa.SourceColumn = "Opinion";
pa.SourceVersion = DataRowVersion.Current;
pa = cmd.Parameters.Add("@Bonus", SqlDbType.Float, 8);
pa.SourceColumn = "Bonus";
pa.SourceVersion = DataRowVersion.Current;
try
{
sqlAdap.Update(ds.Tables[0]);
ds.Tables[0].AcceptChanges();
MessageBox.Show("添加成功!");
}
catch (Exception ex)
{
MessageBox.Show("添加失败!错误描述为:" + ex.Message);
}
}
我要举报
如以上问答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息,可以点下面链接进行举报!
大家都在看
推荐资讯