Refreshing my database

Question

Hi! I want to refresh my database after saving my records. I cant do that... But I wrote this line of code in red (without success): Have a look please: conn = new SqlConnection(connstr); comm = new SqlCommand(); conn.Open(); SqlParameter firstname = new SqlParameter(@firstname SqlDbType.VarChar); SqlParameter lastname = new SqlParameter(@lastname SqlDbType.VarChar); comm.Parameters.Add(firstname); comm.Parameters.Add(lastname); firstname.Value = txtfirstname.Text; lastname.Value = txtlastname.Text; comm.Connection = conn; comm.CommandText = insert into test values(@firstname@lastname); try { comm.ExecuteNonQuery(); dgv.CurrentCell = dgv.Rows[dgv.Rows.Count - 1].Cells[0]; //Here MessageBox.Show(Saved!); } catch (Exception) { MessageBox.Show(Not saved); } finally { conn.Close(); } } }

Israel · Answer

See where I put that line of code. But its doesnt. I dont know what happen? conn = new SqlConnection(connstr); comm = new SqlCommand(); conn.Open(); SqlParameter firstname = new SqlParameter(@firstname SqlDbType.VarChar); SqlParameter lastname = new SqlParameter(@lastname SqlDbType.VarChar); comm.Parameters.Add(firstname); comm.Parameters.Add(lastname); firstname.Value = txtfirstname.Text; lastname.Value = txtlastname.Text; comm.Connection = conn; comm.CommandText = insert into test values(@firstname@lastname); try { comm.ExecuteNonQuery(); dgv.CurrentCell .Value = dgv.Rows[dgv.Rows.Count - 1].Cells[0] .Value ; //Here MessageBox.Show(Saved!); } catch (Exception) { MessageBox.Show(Not saved); } finally { conn.Close(); } } }

Vulpes · Answer

Try: dgv.CurrentCell .Value = dgv.Rows[dgv.Rows.Count - 1].Cells[0] .Value ;

Israel · Answer

Not to clear. It's just like close/open to have data always refreshed. Means the last record should appear in my datagridview instantly after saving. I fill it like this in load event string connectionString = @Data Source=localhost\sqlexpress;Initial Catalog=master;Integrated Security=True; string sql = SELECT * FROM test; SqlConnection connection = new SqlConnection(connectionString); SqlDataAdapter dataadapter = new SqlDataAdapter(sql connection); DataSet ds = new DataSet(); connection.Open(); dataadapter.Fill(ds test); connection.Close(); dgv.DataSource = ds; dgv.DataMember = test; dgv.CurrentCell = dgv.Rows[dgv.Rows.Count - 1].Cells[0];

Vulpes · Answer

Do you mean that you want to clear the DGV after saving the records to the database? If so then how did you fill it in the first place - by binding to a datatable (or other data source) or manually?