62,047
社区成员
发帖
与我相关
我的任务
分享
public void AddProduct(DataTable dt)
{
SqlDataAdapter sda = new SqlDataAdapter();
SqlCommand cmd = new SqlCommand("insert into OrderProduct(TradeID,ProductID,number) values(@TradeID,@ProductID,@number)", DB.CreateDB());
cmd.Parameters.Add(new SqlParameter("@TradeID", SqlDbType.Int, 4, "TradeID"));
cmd.Parameters.Add(new SqlParameter("@ProductID", SqlDbType.Int, 4, "ProductID"));
cmd.Parameters.Add(new SqlParameter("@number", SqlDbType.Int, 4, "number"));
sda.InsertCommand = cmd;
sda.Update(dt);
}
public void AddProduct(DataTable dt)
{
SqlDataAdapter sda = new SqlDataAdapter("select TradeID,ProductID,number from OrderProduct", DB.CreateDB());
SqlCommand cmd = new SqlCommand("insert into OrderProduct(TradeID,ProductID,number) values(@TradeID,@ProductID,@number)", DB.CreateDB());
cmd.Parameters.Add(new SqlParameter("@TradeID", SqlDbType.Int, 4, 101)); // <-- 晕哦
cmd.Parameters.Add(new SqlParameter("@ProductID", SqlDbType.Int, 4, 202));// <-- 晕哦
cmd.Parameters.Add(new SqlParameter("@number", SqlDbType.Int, 4, 6)); // <-- 晕哦
sda.InsertCommand = cmd;
sda.Update(dt);
}
public void AddProduct(DataTable dt)
{
SqlDataAdapter sda = new SqlDataAdapter("select TradeID,ProductID,number from OrderProduct", DB.CreateDB());
SqlCommand cmd = new SqlCommand("insert into OrderProduct(TradeID,ProductID,number) values(@TradeID,@ProductID,@number)", DB.CreateDB());
cmd.Parameters.Add(new SqlParameter("@TradeID", SqlDbType.Int, 4, "TradeID"));
cmd.Parameters.Add(new SqlParameter("@ProductID", SqlDbType.Int, 4, "ProductID"));
cmd.Parameters.Add(new SqlParameter("@number", SqlDbType.Int, 4, "number"));
sda.InsertCommand = cmd;
sda.Update(dt);
}