how to assigning variables from gridview to database table in C#?

by saying assign a variable what exactly do you mean, you need to update the DB with changes...

do you want to retrieve data by filter ?

can you provide some more specific information for me to help you out

Hi

You can write code like this way.

private void SaveDataToDatabase()

{
  using (SqlConnection con = new SqlConnection("connection"))
            {
                using (SqlCommand cmd = con.CreateCommand())
                {
                    foreach (DataGridViewRow item in dataGridView1.Rows)
                    {
                        cmd.CommandText = "insert tableName(columns name here) values(" + item.Cells[0] + ")"; cmd.CommandType = CommandType.Text;
                        cmd.ExecuteNonQuery();
                    }

                }
            }

}

Note:You can read cell data by index and set to query value.
thank you