Strongly typed dataset - need help.
-
Hi, I right clicked on my project and added a dataset called 'PlntAccuracySWDst.xsd' and dragged the 'PlantInventoryAccuracy' table that I want to work with from the server Exploerer on to it. I am trying to access this dataset in my code behind PlntAccuracySWDst mySWdst = new PlntAccuracySWDst(); For some reason I can't see 'PlantInventoryAccuracyTableAdapter' and 'PlantInventoryAccuracy' datatable objects when I do the 'mySWdst. (dot)' in my codebehind file. Am I missing some thing here? I have Select, Insert, and Update stored procs defined in the database and I want to be able use those here. But as a first step I am unable to access the DataTable and Table adapters. Looks like I need to generate the Schema as a typed dataset. But when I right click on the dataset I do not see the 'Generate Dataset' option for me to select. so there is no PlntAccuracySWDst.cs file was created under my 'PlntAccuracySWDst.xsd' file in my solution explorer. I guess that is the reason why (becuase there is no Schema generated) I can't access it from my code behind file. Later on I found out that the the 'Generate Dataset' option is under the View/Tollbars/DataDesign in my VS 2005. I just selected it and this action placed a small tool bar under the Standard Tool bar. The 'Generate Dataset' is one of the icons on it. But unfortunately it is disabled. I am not sure what I am missing here. I need to be able to create the Schema by clicking the 'Generate Dataset' option. I am still looking for help. I have searched online all talk about the steps creating typed datasets but none of the articles address what to do to 'Generate Dataset'. Any help is appreciated. Thanks, L