一个窗体中有多个TextBox,一个DataGrid(已绑定数据)
如果要新建一个新的记灵,TextBox是不是一个一个的清空,然后DataGrid的行一个一个Remove掉请问大家是怎么做的?

解决方案 »

  1.   

    ,一个DataGrid(已绑定数据)
    怎么绑定啊,朋友
      

  2.   

    this.BindingContext[dt].AddNew();
    //dt為DataGrid的數據源
     //確定
            private void toolStripButton4_Click(object sender, EventArgs e)
            {
                using (SqlConnection cnn = new SqlConnection(Data.Data_Connection.ConnectionString))
                {
                    try
                    {
                        SqlCommand cmd = new SqlCommand();
                        cmd.Connection = cnn;
                        cnn.Open();
                        cmd.CommandType = CommandType.StoredProcedure;
                        cmd.CommandText = "P_EIP_INSUPDSALES";
                        cmd.Parameters.Add(new SqlParameter("@NOSALES", SqlDbType.VarChar, 10, "NO_SALES"));
                        cmd.Parameters.Add(new SqlParameter("@NMSALES", SqlDbType.VarChar, 20, "NM_SALES"));
                        cmd.Parameters.Add(new SqlParameter("@IDDEPT", SqlDbType.Int, 4, "ID_DEPT"));
                        cmd.Parameters.Add(new SqlParameter("@IDJOB", SqlDbType.Int, 4, "ID_JOB"));
                        cmd.Parameters.Add(new SqlParameter("@NOTEL", SqlDbType.VarChar, 20, "NO_TEL"));
                        cmd.Parameters.Add(new SqlParameter("@NOMOBLE", SqlDbType.VarChar, 20, "NO_MOBLE"));
                        cmd.Parameters.Add(new SqlParameter("@NOSALESID", SqlDbType.VarChar, 20, "NO_SALESID"));
                        cmd.Parameters.Add(new SqlParameter("@ADHOME", SqlDbType.VarChar, 20, "AD_HOME"));
                        cmd.Parameters.Add(new SqlParameter("@ADNOWIN", SqlDbType.VarChar, 20, "AD_NOWIN"));
                        cmd.Parameters.Add(new SqlParameter("@CDMERRY", SqlDbType.VarChar, 20, "CD_MERRY"));
                        cmd.Parameters.Add(new SqlParameter("@ADEMAIL", SqlDbType.VarChar, 20, "AD_EMAIL"));
                        cmd.Parameters.Add(new SqlParameter("@IDSALESEDU", SqlDbType.VarChar, 20, "ID_SALESEDU"));
                        cmd.Parameters.Add(new SqlParameter("NMSCHOLL", SqlDbType.VarChar, 20, "NO_SCHOLL"));
                        //cmd.Parameters.Add(new SqlParameter(""));                    cmd.Parameters[0].Value = this.txtSalesNo.Text.Trim();
                        cmd.Parameters[1].Value = this.txtSalesName.Text.Trim();
                        cmd.Parameters[2].Value = this.dt.Rows[this.BindingContext[dt].Position]["ID_DEPT"];
                        cmd.Parameters[3].Value = this.dt.Rows[this.BindingContext[dt].Position]["ID_JOB"];
                        cmd.Parameters[4].Value = this.txtTel.Text.Trim();
                        cmd.Parameters[5].Value = this.txtMoble.Text.Trim();
                        cmd.Parameters[6].Value = this.txtSalesID.Text.Trim();
                        cmd.Parameters[7].Value = this.txtAddrHome.Text.Trim();
                        cmd.Parameters[8].Value = this.txtAddrNow.Text.Trim();
                        cmd.Parameters[9].Value = this.cmbMerry.ValueMember;
                        cmd.Parameters[10].Value = this.txtEmail.Text.Trim();
                        cmd.Parameters[11].Value = this.dt.Rows[this.BindingContext[dt].Position]["ID_SALESEDU"];
                        cmd.Parameters[12].Value = this.txtScholl.Text.Trim();                    cmd.ExecuteNonQuery();
                    }
                    catch (Exception elx)
                        {
                            MessageBox.Show(elx.ToString() );
                        }
                    finally 
                        {                        cnn.Close();
                        }            }        }
      

  3.   

    将textbox.text也绑定在数据源上,清数据源就行了