Refreshing Gridview After Button Click

Question

on my asp.net project, how can i refresh my gridview immediately after clicking my button. my button has update codes.here is the codes;

protected void Button3_Click(object sender, EventArgs e)
    {
        string strSQL = "UPDATE [bilgiler3] SET [HAM_FM] = ISNULL(MON,0)+ISNULL(TUE,0)+ISNULL(WED,0)+ISNULL(THU,0)+ISNULL(FRI,0)+ISNULL(SAT,0)+ISNULL(SUN,0) WHERE [DATE] BETWEEN @DATE1 AND @DATE2 AND WORK_TYPE='OUT'";
        string connStr = WebConfigurationManager.ConnectionStrings["asgdb01ConnectionString"].ConnectionString;
        using (SqlConnection conn = new SqlConnection(connStr))
        {
            using (SqlCommand comm = new SqlCommand())
            {
                comm.Connection = conn;
                comm.CommandText = strSQL;
                comm.CommandType = CommandType.Text;

                comm.Parameters.AddWithValue("@DATE1", Convert.ToDateTime(TextBox1.Text));
                comm.Parameters.AddWithValue("@DATE2", Convert.ToDateTime(TextBox2.Text));
                try
                {
                    conn.Open();
                    int i = comm.ExecuteNonQuery();
                    conn.Close();
                    if (i > 0)
                    {
                        Response.Write(" SUCCESS ");
                    }
                    else
                    {
                        Response.Write(" ERROR ! ");
                    }
                }
                catch (SqlException ex)
                {
                    Response.Write(ex.ToString());
                }
            }
        }
    }

you maybe gonna say "you need to bind the data of your gridview" but i couldnt understand the method. can you help me about it ?

thank you very much.

Answer 1

I would do the following:

DataSet ds = new DataSet();
SqlDataAdapter sda = new SqlDataAdapter();
 SqlConnection sc = new SqlConnection("you connection string here Security=True");


private void loadData()
        {
            try
            {
                ds.Clear();
                SqlCommand sCmd= new SqlCommand("Load your database", sc);
                sda.SelectCommand = sCmd;
                sda.Fill(ds, "sCmd");

                datagrid.DataSource = ds.Tables["sCmd"];
            }

            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Error);
                Application.ExitThread();
            }

        }

something for c# beginners Youtube