to generate strongly typed dataset, from the toolbox drag and drop dataset onto ur form, a window will appear asking u the type of the dataset you want to generate either typed or untyped. choose the typed and set the database then walk in the wizard steps. this should work
On Tue, Dec 15, 2009 at 11:34 PM, Learner <[email protected]> wrote: > 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. > > 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 define 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 > and 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 in 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. > > Thanks, > > L > -- Akram Mellice
