Remove From My Forums

how to empty the datetable

Question

User1865404792 posted

i have this codes in c#

///////////
    DataTable addtogv = new DataTable();
 
 
////////////
addtogv = (DataTable)ViewState["records"];
                    addtogv.Rows.Add(DropDownList3.SelectedItem.Value, DropDownList3.SelectedItem.Text, txtqnt.Text);
                    GridView1.DataSource = addtogv;
                    GridView1.DataBind();
 
 
///////////
        if (!Page.IsPostBack)
        {
            if (ViewState["records"] == null)
            {
                addtogv.Columns.Add("item_no");
                addtogv.Columns.Add("item_name");
                addtogv.Columns.Add("qun");
                ViewState["records"] = addtogv;

I want add btn to empty the datatable(addtogv) of data for the new input process

Sunday, August 9, 2020 9:03 AM

Answers

User1535942433 posted

Hi alhakimy,

Accroding to your description,as far as I think,you could create a new blank datatable to ViewState["records"].

I create a demo,just like this:

protected void bind2()
        {
            DataTable dt = new DataTable();
            //DataRow dr = null;

            dt.Columns.Add(new DataColumn("Column1", typeof(Int32)));
            dt.Columns.Add(new DataColumn("Column2", typeof(string)));
            dt.Columns.Add(new DataColumn("Column3", typeof(Int32)));
            dt.Columns.Add(new DataColumn("Column4", typeof(Int32)));
           
            DataRow dr = dt.NewRow();
            dr["Column2"] = "1-50";
            dt.Rows.Add(dr);

            DataRow dr1 = dt.NewRow();
            dr1["Column2"] = "50.1 - 100.0";
            dt.Rows.Add(dr1);

            DataRow dr2 = dt.NewRow();
            dr2["Column2"] = "100.1- 150";
            dt.Rows.Add(dr2);

            DataRow dr3 = dt.NewRow();
            dr3["Column2"] = "150.1 -200";
            dt.Rows.Add(dr3);


            ViewState["records"] = dt;
            GridView2.DataSource = ViewState["records"];
            GridView2.DataBind();
        }
 
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                bind2();
            }
        } 

protected void Button1_Click(object sender, EventArgs e)
        {
            DataTable dt_null = new DataTable();

            ViewState["records"] = dt_null;
        }

Best regards,

Yijing Sun

Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM

Monday, August 10, 2020 7:03 AM

Answered by:

how to empty the datetable

Question

Answers