Using ADO RecordSet in ADO.NET

Sign in to leave a comment.

• DH

  Daniel Heath17y agoPosted Mar 29, 2009, 9:14 AM

  I can now access the data using adodb and an ado recordset. The reason that I wanted to use the ado recordset, is because inserting and updating is so much easier with the recordset and MS Access databases. However, I keep getting an error that the recordset is not updatable and have done everything that I can find on Google, to solve the problem, but it won't go away. Any suggestions?
• DT

  Denis Toby19y agoPosted Oct 24, 2007, 7:21 AM

  Hi Mahesh, I hope you can help me out with this. I have a lot of trouble finding out how to export data from a dataset to a MS Excel spreadsheet using a stylesheet. I use Dataset.WriteXML(filename) to export the data but I don't know how to write the stylesheet file that can match/transform the XML file that Excel recognises. I have tried using RecordSet/StyleSheet to export but this method turns all the unicode (chinese characters) to rubbish. I am stuck. Can you give me some pointers??
• J

  jats19y agoPosted Feb 2, 2007, 12:20 AM

  Hi Mahesh, I am Jats. I hav used the code in the article but there is no output in the display, no error even. Waiting for any suggestions. Dought: Can this code be used on Internet. Can i access the database(in server) from a client machine in LAN. Jats
  • 

    Mahesh Chand19y agoPosted Feb 2, 2007, 11:11 AM

    You will have to debug the code to see if data is actually coming from the database.
  • S

    stealth18y agoPosted Jan 14, 2008, 7:20 PM

    You need to modify this line.. DataGrid1.DataSource = ds.DefaultViewManager Change to.. DataGrid1.DataSource = ds.Tables(0) Hope this would help..