Display selected row from datagridview C#

Question

Hello, dears I want help finding a code that will help me when I click on select, which will transfer the data in Gridview to the box The picture shows

Sachin Singh · Answer

This is the complete code for insert ,update and delete private void BindGrid() { using (SqlConnection con = new SqlConnection(ConnectionString)) { using (SqlCommand cmd = new SqlCommand( "SELECT * from table " , con)) { cmd.CommandType = CommandType.Text; using (SqlDataAdapter sda = new SqlDataAdapter(cmd)) { using (DataTable dt = new DataTable()) { sda.Fill(dt); dataGridView1.DataSource = dt; } } } } } private void DataGridView_CellClick(object sender, DataGridViewCellEventArgs e) { //Check to ensure that the row SelectButton is clicked. if (e.RowIndex >= 0 && e.ColumnIndex == 0) { txtId.Text = row.Cells[0].Value.ToString(); txtName.Text = row.Cells[1].Value.ToString(); txtCountry.Text = row.Cells[2].Value.ToString(); } } private void Form1_Load(object sender, EventArgs e) { this .BindGrid(); DataGridViewButtonColumn buttonColumn = new DataGridViewButtonColumn(); { button.Name = " buttonColumn " ; button.HeaderText = "Select" ; button.Text = "Select" ; button.UseColumnTextForButtonValue = true ; //dont forget this line this .dataGridView1.Columns.Insert(3, buttonColumn ); this .dataGridView1.CellContentClick += new DataGridViewCellEventHandler(DataGridView_CellClick); } } private void Insert(object sender, EventArgs e) { using (SqlConnection con = new SqlConnection(ConnectionString)) { using (SqlCommand cmd = new SqlCommand( "INSERT INTO Customers(Name,Country) VALUES(@Name,@Country)" , con)) { cmd.Parameters.AddWithValue( "@Name" , txtName.Text); cmd.Parameters.AddWithValue( "@Password" , txtPassword.Text); con.Open(); cmd.ExecuteNonQuery(); con.Close(); } } this .BindGrid(); txtId.Clear(); txtName.Clear(); txtCountry.Clear(); } private void Update(object sender, EventArgs e) { using (SqlConnection con = new SqlConnection(ConnectionString)) { using (SqlCommand cmd = new SqlCommand( "UPDATE table SET Name = @Name , Password= @Password WHERE Id = @Id" , con)) { cmd.Parameters.AddWithValue( "@Name" , txtName.Text); cmd.Parameters.AddWithValue( "@Password= " , txtPassword.Text); cmd.Parameters.AddWithValue( "@Id" , txtId.Text); con.Open(); cmd.ExecuteNonQuery(); con.Close(); } } this .BindGrid(); txtId.Clear(); txtName.Clear(); txtCountry.Clear(); } private void Delete(object sender, EventArgs e) { using (SqlConnection con = new SqlConnection(ConnectionString)) { using (SqlCommand cmd = new SqlCommand( "DELETE FROM Table WHERE Id = @rId" , con)) { cmd.Parameters.AddWithValue( "@Id" , txtId.Text); con.Open(); cmd.ExecuteNonQuery(); con.Close(); } } this .BindGrid(); txtId.Clear(); txtName.Clear(); txtCountry.Clear(); } Note :- Add one more textbox txtId (readonly) and you are done just copy paste.Now when you will click select all textboxes including id will be set as values to respective textboxes.

Rajanikant Hawaldar · Answer

https://www.c-sharpcorner.com/UploadFile/1e050f/insert-update-and-delete-record-in-datagridview-C-Sharp/