September 7, 2008 05:32am pdt

1. TheLearn... 775,423
2. samtran0... 434,218
3. raterus 383,115
4. Velio 343,985
5. prairiedog 331,488
6. naspinski 308,444
7. Dhaest 213,719
8. tedbilly 196,960
9. angelIII 181,413
10. dusion 178,123
11. jpaulino 177,853
12. ororiole 158,646
13. TheMegaL... 138,829
14. Rejojohny 135,765
15. GreenGho... 135,085
16. renjurdevan 134,162
17. NazoUK 134,160
18. jcoehoorn 133,808
19. TimCottee 132,355
20. pratima_... 131,018
21. zkeown 123,565
22. sachintana 109,165
23. hielo 105,594
24. sammy1... 104,772
25. philipjonat... 101,800

1. TheLearn... 2,889,004
2. samtran0... 2,503,877
3. raterus 2,003,354
4. nauman_... 1,214,228
5. sammy1... 1,158,812
6. Rejojohny 1,079,584
7. mmarinov 996,221
8. scolja 960,492
9. lem2802 624,688
10. AerosSaga 600,606
11. Edwin_C 568,753
12. tusharashah 517,701
13. angelIII 493,145
14. Justin_W 489,746
15. TimCottee 474,685
16. GavinMan... 469,710
17. praneetha 449,555
18. YZlat 443,942
19. b1xml2 441,009
20. carl_tawn 415,581
21. Dhaest 408,714
22. DreamMa... 399,379
23. pratima_... 397,144
24. ihenry 396,673
25. naveenko... 393,063

12.11.2007 at 05:54PM PST, ID: 23017376

	[x] Attachment Details

Dataset Update to Database with OLEDBDataAdapter??

Asked by Kelvin81 in Programming for ASP.NET, Sybase Database, ADO.Net Class Library

Tags: dataset, oledbdataadapter, update, database

Hi,

I've been working for several months to get data back into a Sybase database. I have gotten to the point where I can retrieve data into a grid view, then edit the data in the gridview, and hit the update button and update the gridview and the dataset.

I am stuck on trying to push the dataset changes back into the database. I have tried several different ways, and a number of them don't give me errors, but don't make the changes either. I am guessing it is because I don't have the proper .UpdateCommand in my DataAdapter?

Below is the latest incarnation of the code that I have been trying to use.

As you can see below, I have tried several different ways, and there are still remnants from other attempts in there. Most of the online references that I found have ObjectDataAdapters, but that approach didn't seem to work for me, and anything thats working with a dataset directly only uses a SQL adapter with a SQLServer DB.

Can someone help me make this work? Am I going about this the wrong way (I would rather not have anything strongly typed to give it the scalability and flexibility that I'm looking for)?

Start Free Trial

         
           
             1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:

           
           
             if (ViewState["ds"] != null)
            {
                DataSet ds = (DataSet)ViewState["ds"];
                string strConn = "Provider=Sybase.ASEOLEDBProvider.2;Data Source=DSRFCLDD02;Initial Catalog=SDAPSLDN5;Password=xxxx;User ID=xxxxxxx";
                OleDbConnection conn = new OleDbConnection(strConn);
                OleDbDataAdapter da = new OleDbDataAdapter
                        ("Select top 50 UserID, UserName, FullName, TraderID from users", strConn);
               da.UpdateCommand = new OleDbCommand("UPDATE users SET" +
                            "UserID = ?, UserName = ?, FullName = ?, TraderID = ?", conn );
 
                da.UpdateCommand.Parameters.Add("UserID", OleDbType.LongVarBinary);
                da.UpdateCommand.Parameters.Add("UserName", OleDbType.VarChar);
                da.UpdateCommand.Parameters.Add("FullName", OleDbType.VarChar);
                da.UpdateCommand.Parameters.Add("TraderID", OleDbType.LongVarBinary);
 
                DataTable dt = ds.Tables[0].GetChanges(DataRowState.Modified);
                try
                {
 
                    foreach (DataRow dataRow in ds.Tables[0].Rows)
                    {
                        dt.ImportRow(dataRow);
                        dt.AcceptChanges();
                    }
                   // ds.AcceptChanges();
                    da.Update(dt);
                }
                catch (Exception err) { lblErrLabel.Text = err.ToString(); }
            }

           
         

Keywords: Dataset Update to Database with OLED…

	Title
1	Strongly typed DataSets and a Busines…
2	add/edit/delete from dataset, and b…
3	typed dataset's datatable to gridview
4	datarow to dataadapter
5	Having trouble binding a ReportViewer …
6	Autonumber isn't returned from new …

Loading Advertisement...

20080716-EE-VQP-32 / EE_QW_2_20070628

Dataset Update to Database with OLEDBDataAdapter??

Asked by Kelvin81 in Programming for ASP.NET, Sybase Database, ADO.Net Class Library

Tags: dataset, oledbdataadapter, update, database

About this solution