C# SqldataAdapter 更新一张表的数据，增加另一张表的数据要怎么做

 SqlConnection sqlConnection = new SqlConnection();
                sqlConnection.ConnectionString =
                   ConfigurationManager.ConnectionStrings["Sql"].ToString();






                SqlCommand insqlCommand = new SqlCommand();
                insqlCommand.Connection = sqlConnection;
                insqlCommand.CommandText =
                   "insert tb_门店配货信息 (ph,ypbh,ypsl,mdbh,rq) "
                          + " values (@ph,@ypbh,@ypsl,@mdbh,@rq)";

                insqlCommand.Parameters.AddWithValue("@ph", textBox_ph.Text);
                insqlCommand.Parameters.Add("@ypbh", SqlDbType.VarChar, 0, "ypbh");
                insqlCommand.Parameters.Add("@ypsl", SqlDbType.VarChar, 0, "数量");
                insqlCommand.Parameters.AddWithValue("@mdbh", cmb_md.SelectedValue);
                insqlCommand.Parameters.AddWithValue("@rq", DateTime.Now.ToLocalTime());


                SqlCommand upsqlCommand = new SqlCommand();
                upsqlCommand.Connection = sqlConnection;
                upsqlCommand.CommandText = "UPDATE tb_药品库存表  "
                                              + " set ypsl=@ypsl "
                                              + "where ypbh=@ypbh ;";

                upsqlCommand.Parameters.AddRange(new SqlParameter[]
                {
                    new SqlParameter ("@ypbh", SqlDbType.VarChar, 0, "ypbh")
                    ,new SqlParameter ("@ypsl", SqlDbType.VarChar, 0, "剩余数量")
                });

                SqlDataAdapter sqlDataAdapter = new SqlDataAdapter();

                sqlDataAdapter.UpdateCommand = upsqlCommand;


                sqlDataAdapter.InsertCommand = insqlCommand;
                sqlDataAdapter.Update(this.SDrug );

代码如上，运行结果只能插入数据，更新操作无法完成，想问一下要怎么实现更新操作

SDrug在哪里定义的，是datatable还是dataset。它的列是不是叫做ypbh和剩余数量，特别是剩余数量，它是文本类型么
最后没看到你往Parameters传你要更新以后的值