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

How to set focus on updated datagridview row after update?

Answers (13)