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(); } }
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?.