Display selected row from datagridview C#

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.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sachin Singh5y ago
Accepted 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 Hawaldar5y ago
https://www.c-sharpcorner.com/UploadFile/1e050f/insert-update-and-delete-record-in-datagridview-C-Sharp/