Hi,
does anybody know any ressources about the DataSet-Designer - how to create Forms from type safe datasets, what the basics of type safe datasets are, how datasets can be created out of stored procedures, how you update type safe datasets during development time when the database still "lives", how to program and extend the functionality with the navigation toolbar, etc
Maybe I'm blind, but I didn't find anything that went really deep or covers it in context - neither in the the MSDN nor on the web.
Thanks,
Klaus
Resources for DataSet-Designer in VS2005
Hot Topic
- web page publish
- SecurityAction.DemandeChoice is obsolete ?
- VS Express - Common Modules
- CPU problems in a .NET COM+ application
- Are NGen images shareable between processes under different windows accounts
- Generic List(Of T) Unexpected Results
- SQL: Problem With Time
- Porting C++ pointer code to C#
- ASP.net 2 Xams
- Assembly and Assembly file version numbers
.NET Development
- Monitoring and changing varibles in a process
- Automation Error Raised by VB6 App on a .NET component ever since installing .NET 2.0 Framework
- Accessing Registry on a Remote Computer
- Problems linking: wininet
- Cannot invoke web service when using a external SSL device
- How to handle Windows Users in an application (C# or VB)
- Quiting remoting client causes error: System.AccessViolationException
- MySql and SqlDataAdapter
- ASP.NET_SessionId is not UNIQUE In IE7 Beta?
- Creating .DLL
Resources for DataSet-Designer in VS2005
Sachin1979
The principals should remain the same. However your implementation may need to change based on if you are building a client winform app that uses Web Services for data. In that case you would still set up the Dataset in a similar fashion on the Web Services side. When you reference the Web Service in the client the Web References should carry those strongly typed datasets so you can reference them in your client.
C
DrBob
I should have mentioned that I need that WinForms apps.
Thanks anyway!
Klaus
william_wallace
This is a really brief and rough walk through:
From the Dataset design surfece you should be able to right click and create a TableAdapter. It will ask for a connection string. If you have one saved in your web.config it should show up in the dropdown box that displays the connection strings.
Next the TableAdapter wizard will ask if you want to use SQL Statement, New Stored Procedures or Existing Stored Procedures. If you have an existing Stored Proc in the DB pick existing.
Next the wizard should allow you to assign existing stored procs to each of the Table Adapters methods (Select, Insert, Update, Delete). Simply pick the sprocs that meet the appropriate function.
Just click next and the next to create the Fill and Get methods the Table Adapter needs to retrieve data and that should be it. You should now have a TableAdapter in your dataset.
Next go to your form and add a data control (DataGrid, FormView, etc...). Drop the control on the form. An input control should appear on the upper right corner of the data control you dropped on the form, asking you to select a datasource. Pick new datasource and then select ObjectDatasource and give it a name (click next). Select the Table Adapter you just created from the drop down list and select next. Based on your Select stored procedure that fills the DataTable using the TableAdapter the DataSource wizard may ask you for input values for the Get Method of the Tableadpater. Simply make any appropriate choices. Once this wizard is complete you data control should be wired up to your TableAdapter.
Sorry for the rough explaination. I think the articles do a way better job..
Data Source Controls in ASP.NET 2.0
http://msdn.microsoft.com/msdnmag/issues/05/01/DataPoints/default.aspx
Simplified and Extended Data Binding Syntax in ASP.NET 2.0< xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />
http://www.daveandal.net/articles/databinding-syntax/ASPNET2DataBindingSyntax.htm