How to connect wpf with database
- how can I connect a WPF project to SQL Server 2005
I try to do it like I do in past with Windows Form Application
but I cant do it
I think that their is a new way to connect to database with WPF Application , so plz tell me about it and if any examples or links for help
thank you alot
解答
In WPF you could also use ADO.NET and bind e.g. to the tables in a dataset. But up to now there are now wizards in Visual Studio for data connection. E.g. you can't drop tables out of DataSource-Explorer onto your form. Possibilities:
-
Add a typed DataSet to your Project, add Tables and TableAdapters, use TableAdapters to load data and bind your UI to the Data
-
Instead of DataSets you could also use Linq to SQL and bind to your special objects.
-
...
You should take a look at Data Binding (which is much more than only binding to data from a dataset) and especially at the interface ICollectionView and the three classes CollectionView, ListCollectionView and BindingListCollectionView. In WPF you don't use a BindingSource-Objekt (and so a CurrencyManager) to manage the currentItem. Instead you use an ICollectionView that manages the currentItem and Position of the Collection it points to.
-
I highly recommend you take a look at a new technology we released with .NET 3.5 called LINQ to SQL. LINQ stands for "Language Integrated Query", and allows you to write really intuitive code to interface with your database. Here's a link to a short 10-minute video that should be able to help you get up and running.
所有回覆
In WPF you could also use ADO.NET and bind e.g. to the tables in a dataset. But up to now there are now wizards in Visual Studio for data connection. E.g. you can't drop tables out of DataSource-Explorer onto your form. Possibilities:
-
Add a typed DataSet to your Project, add Tables and TableAdapters, use TableAdapters to load data and bind your UI to the Data
-
Instead of DataSets you could also use Linq to SQL and bind to your special objects.
-
...
You should take a look at Data Binding (which is much more than only binding to data from a dataset) and especially at the interface ICollectionView and the three classes CollectionView, ListCollectionView and BindingListCollectionView. In WPF you don't use a BindingSource-Objekt (and so a CurrencyManager) to manage the currentItem. Instead you use an ICollectionView that manages the currentItem and Position of the Collection it points to.
-
I highly recommend you take a look at a new technology we released with .NET 3.5 called LINQ to SQL. LINQ stands for "Language Integrated Query", and allows you to write really intuitive code to interface with your database. Here's a link to a short 10-minute video that should be able to help you get up and running.
- thankx alot for ur answers
and really thank you for the video
