Update Gridview using Datatable

Question

0.00/5 (No votes)

See more:

i am using datatable as datasource to bind Gridview
but i was done bind the data but how to update and Delete

DataTable Details = new DataTable();

           Details.Columns.Add("ID", typeof(Int32));
           Details.Columns.Add("Name", typeof(string));
           Details.Columns.Add("Number", typeof(string));

           Details.Rows.Add("1", "Vicks400", "456789456");
           Details.Rows.Add("2", "Nitrose", "468795124");
           Details.Rows.Add("3", "Nitrored", "154657894");

           ViewState["Drugs"] = Details;

C#

private void bindGrid()
       {
           DataTable dt = (DataTable)ViewState["Drugs"];
           gvDrug.DataSource = dt;
           gvDrug.DataBind();

       }

protected void gvDrug_RowUpdating(object sender, GridViewUpdateEventArgs e)
        {
            GridViewRow row = gvDrug.Rows[e.RowIndex];

           String str = ((TextBox)(row.Cells[1].Controls[0])).Text;

            int id = Convert.ToInt32(e.NewValues[0]);
           
            string name = e.NewValues[1].ToString();
            string numberR = e.NewValues[2].ToString();

            DataTable dt = (DataTable)ViewState["Drugs"];

            dt.Rows[0]["Name"] = name;
            dt.Rows[0]["Number"] = numberR;

            dt.AcceptChanges();

            gvDrug.DataSource = dt;
            gvDrug.DataBind();

but above code not updating how to do? need helpfull

Posted 16-Apr-12 22:58pm

Abhi KA

Add a Solution

Comments

P.Salini 17-Apr-12 4:59am

Are you getting any error?

Abhi KA 17-Apr-12 5:00am

not updated not showing errors

Saroj Kumar Sahu 17-Apr-12 5:06am

check ur database query for update.

Abhi KA 17-Apr-12 5:29am

here is this sufficient
dt.Rows[0]["Name"] = name;
dt.Rows[0]["Number"] = numberR;

dt.AcceptChanges();

5 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Kuldeep B · Answer 1 · 2012-04-17T17:46:00

Solution 5

Place One button for update
update datatable dt.upadate.
and call bindGrid(); on that click event.

Posted 17-Apr-12 17:46pm

Kuldeep B

Updated 17-Apr-12 17:51pm

v2

Abhi KA · Answer 2 · 2012-04-17T05:07:00

This code is working Fine

C#

protected void gvDrug_RowUpdating(object sender, GridViewUpdateEventArgs e)
       {
           string name = e.NewValues[1].ToString();
           string numberR = e.NewValues[2].ToString();

           DataTable dt = (DataTable)ViewState["Drugs"];

           dt.Rows[e.RowIndex]["Name"] = name;
           dt.Rows[e.RowIndex]["Number"] = numberR;

           dt.AcceptChanges();

           gvDrug.EditIndex = -1;
           gvDrug.DataSource = dt;
           gvDrug.DataBind();

       }

Saed Leghaee · Answer 3 · 2012-04-17T01:45:00

you can use this

C#

//Fill your data in DataAdapter
SqlDataAdapter da = new SqlDataAdapter(cmdselect);
                DataSet ds = new DataSet();
                da.Fill(ds);

//find edited row from gridview in DataSet 
DataRow[] drresult = ds.Tables[0].Select("ID == " + id + "");


//if You set PrimaryKey in DataTable you can find data row whith this method
     ds.Tables[0].Rows.Find(ID) 'Your primary key value'

//and set datarow value

ds.tables[].rows[0]['Title'] = "value"

da.Update(ds);

Edit: code formatted

Deepak_Sharma_ · Answer 4 · 2012-04-17T00:23:00

Solution 2

Try this link

Insert, Update, Delete with Gridview....simple way[^]

Posted 17-Apr-12 0:23am

Deepak_Sharma_

Saroj Kumar Sahu · Answer 5 · 2012-04-16T23:11:00

Solution 1

http://www.aspdotnetcodes.com/GridView_Insert_Edit_Update_Delete.aspx[^]

Posted 16-Apr-12 23:11pm

Saroj Kumar Sahu

Updated 16-Apr-12 23:12pm

v2

Comments

Prasad_Kulkarni 17-Apr-12 5:12am

Link formatted