Skip to main content

How to Create a DataSet, DataTables, Table Adapter Using C#.NET Wizard

To create a DataSet First you need to add a data connection to visual studio (Read…). 

Assume we are having a table called CusTransactions and having columns CustomerName , InvoiceNum, TotalAmount , Paid , Balance.

In my scenario I want to add a Data table to my data set including CustomerName , InvoiceNum and TotalAmount. therefore  first we want to add a dataset. Thus go to Project –> Add new item –> DataSet. And named it as CusDataSet.

When you add the data set visual studio shows DataSet Designer. This is the space you can configure your data adapters  and  data tables. ( To add data adapters you can straightway drag and drop tables from your data connection also.)

To add a data adapter right click the dataset  designer window and goto Add—> TableAdapter. Then the coming window select the relevant data connection. (You can also create new data connection here)  

 image 

After the selecting the connection click next to proceed.  Then you select Use SQL Statement because we are going to create SQL statements in the next screen.

  image

Though our table had five columns I’m using this table adapter to select three columns CustomerName , InvoiceNum , TotalAmont by CustomerName. To generate the SQL you can use Query Builder or just type what you want. Use @symbol to give a parameter to the query or in the QueryBulder in Filter Field type @Cusname.  Using this Data adapter we can also insert and delete . But all methods should match data table schema . Means In here we are selecting customerName, InvoiceNum, TotalAmount thus all creating method contains only those three columns. In the Advanced Options Button you can decide whether   you want Insert or Delete methods.

image

In here you can select what are the methods you want. And click finish. As we did previous add another table adapter for same table allowing to select InvoiceNumber and Balance by Customer name . Finally you can save your dataset by closing it or using save button. Then you can see the data set in designer as follows.

image

To rename the table adapters you can right click the adapter and rename it.

Read.. (Select Record using Data Grid,Dataset and Table Adapters in C#.Net)

Labels:

Comments

Anonymous said…
Your blog keeps getting better and better! Your older articles are not as good as newer ones you have a lot more creativity and originality now keep it up!
January 8, 2010 at 2:29 AM
Unknown said…
This is very useful...
December 1, 2011 at 2:46 PM
Post a Comment

Popular posts from this blog

How to Link Two List and Create a combine view in the SharePoint 2010

In this way you can join multiple list together and can create a combine view. for an example assume that you are managing a list for some events. And also you are having a participants in separate list. Thus you want to join the two list and create a composite view. SharePoint 2010 allows you to create this kind of view using  Linked Data Source. in this approach you can create your own custom list in the SharePoint. How to Create a Linked Data source Go to SharePoint designer and  go to the link called data sources. And Click the Linked Data Source button in the ribbon. Then SharePoint designer will prompt following kind of a dialog. In there add two list, that you wan to linked together. I'm adding airline schedule and booking list. those are the two list that i wan to merge. then click next. And it will guide you another screen. it will ask you to select either Merge Merge use to combine list which are having same columns definition. for and example we can s...
32 comments
Read more

How to Improve Workflow Performance in SharePoint Server 2010

SharePoint workflows are getting  slow for several reasons. in my environment I'm having a problem with following performance issues, therefore in my environment i got following problems. When a item added to the library it takes some times to initiate the workflow. Workflow mail generating is not very fast sometimes. Workflows takes more time to process “Due to heavy load, the latest workflow operation has been queued. It will attempt to resume at a later time” is coming sometimes. I had a custom workflow approval web part and it is taking more than 30 seconds to proceed. Work Done I had a custom workflow approval web part and it is taking more than 30 seconds to proceed. here in my custom web part there is the function which is programmatically updating the workflow. SPWorkflowTask.AlterTask(item, data, false) the last parameter mentioning whether it is synchronous asynchronous. if  is it true it it will wait until workflow schedule accept the workflow task. ...
5 comments
Read more

Use Microsoft Sway Integrated with SharePoint Online /SharePoint 2013/2016

Microsoft Sway Microsoft Sway is a great online Presentation and Online Creativity Stack. Why we need Sway Assume that you are about to so a cooperate presentation for your colleagues. what are the options you have Firstly,You can create a PowerPoint presentation which you need a PowerPoint to run and if you want to share you need end users have PowerPoint client for view the deck. Secondly, You can create a simple web pages and share it with users where it can be access from all devices if it is responsive. Microsoft Sway address the second point. How to Access the Sway There are many ways that you can do this. Since I'm trying  use Sway with SharePoint Online; I will describe using SharePoint Online. First Login to the SharePoint Online Office 365 Login | Microsoft Office There You can go to all Apps   Then you can find the Sway as a App in the Menu   Click on the Sway and go the Sway web site. Here you can find standard available temples or you can start from the stre...
Post a Comment
Read more