How to set focus on updated datagridview row after update?

Question

Hello How to set focus on updated datagridview row after update in c# .net windows application? Please help me. Thanks in Advance. Ankit Agarwal Software Engineer

Iftikar Hussain · Answer

you need to write code for getting clicked row index this.dataGridView1.CellContentClick += new System.Windows.Forms.DataGridViewCellEventHandler(this.dataGridView1_CellContentClick); private void dataGridView1_CellContentClick(object sender DataGridViewCellEventArgs e) { this.dataGridView1.Rows[e.RowIndex].Selected = true; } Regards Iftikar

Ankit Agarwal · Answer

I did not write any other code for  click on row and then display value in combobox.

Iftikar Hussain · Answer

i am asking about the below point code. if you don't provide necessary information then it will be difficult to solve your query when we click on row and then display value in combobox and then we can update.

Ankit Agarwal · Answer

I have already shared all code regarding display and update data.

Iftikar Hussain · Answer

share your complete code Regards Iftikar

Ankit Agarwal · Answer

First of all i clicked on view button It's work for data display in the datagridview and then when we click on row and then display value in combobox and then we can update. Display value in cmbStndrditemgrp.Text this combobox. I am writing loadstandarditemgroup() for display data.

Iftikar Hussain · Answer

to set focus only I am asking how you are reading rows value for updating. The reason is to set the focus of the updated row need row index. Regards Iftikar

Ankit Agarwal · Answer

It was updating successfully but focus it's not correct focus set on first row every time because my datagridview fully refreshed.

Iftikar Hussain · Answer

you are not reading the value from datagridview and updating them? string Stndrditemgrp = cmbStndrditemgrp.Text; string StnItem = txtBoxStnItem.Text; Regards Iftikar

Ankit Agarwal · Answer

string Stndrditemgrp = cmbStndrditemgrp.Text; string StnItem = txtBoxStnItem.Text; if (con.State == ConnectionState.Closed)//check whether connection to database is close or not con.Open();//if connection is close then only open the connection SqlCommand cmd = new SqlCommand(UpdateStndrditem con);//create a SQL command object by passing name of the stored procedure and database connection cmd.CommandType = CommandType.StoredProcedure; //set command object command type to stored procedure type cmd.Parameters.Add(@Stndrditemgrp  SqlDbType.VarChar).Value = Stndrditemgrp; cmd.Parameters.Add(@StnItem SqlDbType.VarChar).Value = StnItem; cmd.ExecuteNonQuery();//execute command MessageBox.Show( Updated Successfully!! Information MessageBoxButtons.OK MessageBoxIcon.Information); loadstandarditemgroup(); public void loadstandarditemgroup() { try { dataGridView1.ReadOnly = true; SqlConnection con = new SqlConnection(cnString1); con.Open(); dadapter = new SqlDataAdapter(select distinct [Item Group][Standard Item] from BAN_ItemDataMaster order by [Item Group] ASC con); data = new DataTable(); dadapter.Fill(data); dataGridView1.DataSource = data; cmbStndrditemgrp.DataSource = data; cmbStndrditemgrp.ValueMember = Item Group; cmbStndrditemgrp.DisplayMember = Item Group; con.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }

Iftikar Hussain · Answer

please share the code for updating record Regards Iftikar

Ankit Agarwal · Answer

I am using datagridview only show records. i am using button and text box for update. My datagridview whole refreshing and focus go on first row.

Iftikar Hussain · Answer

Hi Try like this after updating this.dataGridView1.Rows[e.RowIndex].Selected = true; Regards Iftikar