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 say th
32 comments
Read more

Motion Eye Docker compose File

Docker compose files are comes in handy when considering container orchestration. Below example shows my docker compose files and folder structure. ---- Your Folder (motioneye)   -- etc   -- lib   -- docker-compose.yaml You can run the docker compose file using docker-compose -d , and etc and lib folder will be automatically populated in the initiation. --- Below shows the content of the docker-compose.yaml file. version: '3' services:   nodered:    image: "ccrisan/motioneye:master-amd64"    container_name: motioneye    restart: always    user: root    ports:      - 8765:8765    volumes:      - "/etc/localtime:/etc/localtime:ro"      - "./etc:/etc/motioneye"      - "./lib:/var/lib/motioneye"
Post a Comment
Read more

The content database has a schema version which is not supported this version

How to copy you production SharePoint  database to development environment. I had my production environment as SharePoint 2013 SQL Server 2012 and I want to move the instance to another environment , which is freshly installed and different environment and different KBs Share Point 2013 SQL Server 2016 How to migrate SharePoint 2013 , SQL Server 2012 Content Database to SharePoint 2013 SQL Server 2016. Method 1. This is a general method, which is used for upgrading your content database. 1 . Get the back up of the current Content Database 2. Copy SQL backup to new environment 3. Restore the SQL Back Up in to the new environment 4. Go to the Security Login section and grant permission to content database for existing SharePoint Users.   5. You need to select the User mapping and DBO for the content database. 6 Then, execute below PS in SharePoint PowerShell. Make sure you executed as Run as Administrator 7 Firstly, You need to Update the content database. 8. then, mount the using the co
Post a Comment
Read more