mahesh waghela

mahesh waghela

  • NA
  • 93
  • 113.9k

Add Row To Bound DGV By Textbox

Nov 20 2010 6:32 AM

I have demonstrate the DGV as per following way.

bound DGV:-

I am trying to add input of textbox into DGV as below.

 private void Form1_Load(object sender, EventArgs e)

        {

            string connstr = "server=.;initial catalog=maa;uid=mah;pwd=mah";

            SqlConnection con = new SqlConnection(connstr);

            con.Open();

            DataSet mydatasett;

            string dgv = " select srno,particulars,carats,rate,debit from depurchaseA";

            SqlCommand dgvcmd = new SqlCommand(dgv, con);

            SqlDataAdapter dgvdap = new SqlDataAdapter(dgvcmd);

            mydatasett = new DataSet();

            dgvdap.Fill(mydatasett);

            bindingsource2 = new BindingSource();

            bindingsource2.DataSource = mydatasett;

            bindingsource2.DataMember = mydatasett.Tables[0].TableName;

            dataGridView1.DataSource = bindingsource2;

           

        }



 And textbox Event handler :

 

 private void textBox1_KeyPress(object sender, KeyPressEventArgs e)

        {

            if ((Keys)e.KeyChar == Keys.Enter)

            {

                    int i = dataGridView1.CurrentCell.RowIndex;

                    dataGridView1[1, i].Value = textBox1.Text;

                    dataGridView1.Focus();

 

            }

           

        }


       

The above works fine on UnBound DGV but the same not works in Bound DGV. I wants to add the input of textBox into Bound DGV. Is there any simple way?.


Answers (1)