How to refresh datagrid immediately after update data in C#

Asked Jan 30 '16 at 15:30

Active Mar 13 '19 at 14:57

Viewed 191 times

I have one form in which I have one tab control and on that tab control. one tab page is for entering data in data grid. and in second tab page. that data grid is show. the problem is when I enter data in data grid and switch to view tab. data grid is not update its new values. so I have to reopen the form then entered values is shown. how I can see data in Data Grid immediately after entering in it? the code of my save button is as follows...

private void btnSave_Click(object sender, EventArgs e)
{
    try
    {
        if (isValidated2())
        {
            con.ConnectionString = constr;
            con.Open();

            comnd.Connection = con;
            comnd.CommandText = "INSERT INTO CoaEntry(AccName,[Amount],[Desc]) VALUES('" + cmboName.Text + "','"
            + txtAmount.Text + "','" + txtDesc.Text + "')";
            reader = comnd.ExecuteReader();
            MessageBox.Show("Record has been saved successfully", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
        }
    }
    catch (Exception ex)
    {
        MessageBox.Show(ex.Message);
    }

    con.Close();
}

edited Mar 13 '19 at 14:57

Cœur

37,241
25
195
267

asked Jan 30 '16 at 15:30

Rana Rashid

1

You have to make a connection to the DB and fetch the source then bind it to the grid using grid.DataBind() method – User2012384 Jan 30 '16 at 15:35
should i have to write insert query again? – Rana Rashid Jan 30 '16 at 15:38
1

No...select data, not insert – User2012384 Jan 30 '16 at 15:40
i did this after con.close() but i did not work con.Open() comnd.CommandText = "SELECT * FROM CoaEntry"; reader = comnd.ExecuteReader(); //dataadapter.Fill(); con.Close(); – Rana Rashid Jan 30 '16 at 15:56

How to refresh datagrid immediately after update data in C#

0 Answers0