Previous Discussion	Next Discussion

MySqlDataAdapter.Update() does not insert. For some reason, MySqlDataAdapter.Update() doesn't do the commit to the database (a MySQL database). I can do a commit in my MySQL IDE, and get the results, but the .NET code doesn't do the update. Any idea why? Here's the code: try { dt = makeDataTable(); dt.TableName = "SCORES"; conn.Open(); for(int x = 0; x < 5; x++) { ptsAgainst = rndPtsAgainst.Next(2, 56); ptsFor = rndPtsFor.Next(2, 56); dr = dt.NewRow(); dr[0] = gvMainList.Rows[x].Cells[0].Text; dr[1] = ddlWeekNum.SelectedValue.ToString(); dr[2] = ptsFor; dr[3] = ptsAgainst; ptsPct = calculatePointsPercent((double)ptsFor, (double)ptsAgainst); dr[4] = ptsPct; dt.Rows.Add(dr); } ds.Tables.Add(dt); THIS IS WHERE THE UPDATE OCCURS IN THE CODE, HOWEVER THE COMMIT DOES NOT HAPPEN UNLESS I USE MY IDE. adapter.Update(ds, "SCORES"); ds.AcceptChanges(); } catch (Exception ex) { lblError.Text = ex.Message.ToString(); } finally { dt.Dispose(); ds.Dispose(); conn.Close(); } Started By Monte on Jun 2, 2011 at 8:49:38 AM

7 Response(s) | Reply

View All Replies | Goto Page: 1

jeffmain on Nov 19, 2011 at 12:15:50 AM My Dear, Our company is a distributor of herbs roots to a United Kingdom client and they have call us to supply Kamzi.H2 Root ,So we are looking for trustworthy and honest partnership for this long term transaction. I have Purchased the root called Kamzi.H2 Root before in Malaysia at the rate of $200 American dollars per packet of which I sold to my client at the rate of $900 American dollar, its been use to cure Lungs Cancer and Diabetes. But this time l will not be able to fly over to Malaysia for this business at this time, because of my position at the company now, so if you are interested, I can give you the contact of the seller in Malaysia and connect you with the Buyer who is in need of this root as the main dealer, so you and l can share the profit margin on it as the buyer is ready to fly over to Malaysia for the root at the moment and he's ready to purchase 5000 packets (Five Thousand packets). I don't want to introduce the seller over there in Malaysia to the UK buyer directly because of the profit margin. Kindly get back to me for more details if you are interested.get back to me via my personal email address (jeff_main@ymail.com) Best Regards, Jeff Mains.

View All Replies | Goto Page: 1

To respond to a discussion, you must first logon.

If you are not registered, please register yourself to become a member of the SiteExperts.community.