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

pipipeng on Feb 6, 2012 at 12:33:42 AM NY Escorts Girls, arrange you [url=http://www.nyasiangirls.com]New York Escort[/url] to meet with our professional New York Escort. They come from many [url=http://www.nyasiangirls.com]New York Escorts[/url] different backgrounds. They are happy and fun to be [url=http://www.nyasiangirls.com]New York Asian Escort[/url] accompanying with, let our escorts bring you the total enjoyment of [url=http://www.nyasiangirls.com]New York Asian Escorts[/url] life. Call us now! Let our New York Asian Escort show you how much fun you can get just being in New York.

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.