tag:blogger.com,1999:blog-33753991.post1526067906408731741..comments2023-09-01T06:00:23.693-07:00Comments on Geek Goddess: DataAccess – Part IIBonniehttp://www.blogger.com/profile/11241425687786973525noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-33753991.post-22965837479908527372015-07-11T22:17:12.696-07:002015-07-11T22:17:12.696-07:00Although that's the way it's described in ...Although that's the way it's described in many places to create a Typed DataSet, that's not the way you should do it. You don't want to be dragging any data stuff onto your Form, for several reasons. Please read my blog post about this (and be sure to read the comments too):<br /><br />http://geek-goddess-bonnie.blogspot.com/2010/04/create-xsd.html<br />Bonniehttps://www.blogger.com/profile/11241425687786973525noreply@blogger.comtag:blogger.com,1999:blog-33753991.post-9914458115683901482015-07-11T14:03:43.766-07:002015-07-11T14:03:43.766-07:00Hi Bonnie
I have been trying to implement Part II...Hi Bonnie<br /><br />I have been trying to implement Part II into my application. I have a customers table and as far as I can see I have created a CustomerDataSet using Add New Item > Dataset and then dragged on my Customers table to the design area and saved it, naming it CustomerDataSet.<br /><br />When I run the code in the CustomerAccess class as you have it, the dataset returns empty.<br /><br />If I change the code to DataSet ds = new DataSet() // instead of CustomerDataSet ds = new CustomerDataSet.<br /><br />I get the dataset complete with the expected data.<br /><br />I tried with plain sql in the commandText and the stored procedure but got the same results each way. BOth work with DataSet, both Dont work with CustomerDataSet. Perhaps, I have created my dataset incorrectly. Can you advise?<br /><br />Thanks,<br /><br />J <br /><br />John Noblehttps://www.blogger.com/profile/12231532539132949878noreply@blogger.com