Loop through DataTable rows and update record in Database using C# in ASP.Net

sajinabo...

SOLVED CLOSED ACTIVE ANSWERED
User: sajinaboo
Posted: on Dec 04, 2017 02:08 AM
Forum: Data Controls
Answer: 1
Views: 14610

I have three gridviews. First one is the parent grid which contains following fields

ItemCode  Itemname  NewCode   SellingPrice   PurchasePrice   MRP
1         Soap         1         
2         Bag          2         
3         Cycle        3         
4         Scissors     4         
5         Pen          5

Second Gridview has the following fields

ItemCode   NewCode
1          55874
2          889746210
5          466897

Third Grdview have following fields

ItemCode   SellingPrice   PurchasePrice   MRP
1            25               20          25
2            150              130         150
3            7500             6500        7500
4            20               17          17
5            10               8           10

I want to combine these values and update the parent gridview as follows

ItemCode  Itemname  NewCode   SellingPrice   PurchasePrice   MRP
1         Soap       55874         25            20          25
2         Bag        889746210     150           130         150
3         Cycle      3             7500          6500        7500   
4         Scissors   4             20            17          17    
5         Pen        466897        10            8           10

I want to use ASP.net code for this.

Please help

sajinabo...

0 18

Reply
ANSWER
User: sajinaboo
Replied: on Dec 05, 2017 06:47 AM
Report

This is what I was looking for

            string connectionstring = ConfigurationManager.ConnectionStrings["Dbconnection"].ConnectionString;
            SqlConnection con = new SqlConnection(connectionstring);
            con.Open();
            SqlCommand cmd = new SqlCommand("select * from tbl_eon",con);
            DataTable dt = new DataTable();
            SqlDataAdapter da = new SqlDataAdapter(cmd);
            da.Fill(dt);
            if (dt.Rows.Count > 0)
            {
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    SqlCommand cmd2 = new SqlCommand("Update tbl_All set NewCode='" + dt.Rows[i]["EanCode"].ToString() + "' where ItemCode='" + dt.Rows[i]["ItemCode"] + "'", con);
                    cmd2.ExecuteNonQuery();
                }
            }

Loop through DataTable rows and update record in Database using C# in ASP.Net

Company

Explore

Follow us

Contact Us