-
- DataView v_Insider = new DataView();
- SqlDataAdapter da_Insider = new SqlDataAdapter();
- DataSet ds_Protokol;
- ds_Protokol = new DataSet();
- t_MT_Insider= new DataTable();
- string strInsider = "SELECT .."
- string strInsiderInsert = "INSERT INTO ..."
- SqlCommand cmdSelectInsider = new SqlCommand(strInsider, connaction);
- SqlCommand cmdInsertInsider = new SqlCommand(strInsiderInsert, connaction);
- SqlParameterCollection prcInsertInsider = cmdInsertInsider.Parameters;
- SqlParameter prcSelectIdentityInsider = new SqlParameter("@Id", SqlDbType.Int, 0, "Id");
- prcSelectIdentityInsider.Direction = ParameterDirection.Output;
- prcInsertInsider.Add(prcSelectIdentityInsider);
- prcInsertInsider.Add("@MemeberId", SqlDbType.VarChar, 80, "MemeberId");
- prcInsertInsider.Add("@Code", SqlDbType.VarChar, 32, "Code");
- da_Insider.SelectCommand = cmdSelectInsider;
- da_Insider.InsertCommand = cmdInsertInsider;
- da_Insider.Fill(ds_Protokol, "t_MT_Insider");
- t_MT_Insider = ds_Protokol.Tables["t_MT_Insider"];
- v_Insider.Table = t_MT_Insider;
- bs_Insider.DataSource = v_Insider;
а потом обновляешь запись в таблице
-
- DataRow NewDataRows = (DataRow)t_MT_Insider.NewRow();
- NewDataRows["OwnerId"] = (Int32)((DataRowView)bs_ProtokolValue.Current)["Id"];
- NewDataRows["ParamId"] = childForm.ParamId;
- NewDataRows["Flag"] = childForm.Flag;
- NewDataRows["Status"] = childForm.Status;
- NewDataRows["StatusValue"] = childForm.StatusValue;
- NewDataRows["RefPar"] = childForm.RefPar;
- NewDataRows["Info"] = childForm.Info;
- NewDataRows["RefInfo"] = childForm.RefInfo;
- NewDataRows.EndEdit();
- t_MT_Insider.Rows.Add(NewDataRows);
- da_Insider.Update(t_MT_Insider);
Ответить
|
Али
SHDZ