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

Complete guide to Install SharePoint in a Three Server Farm using AutpSPInstaller

This article will be divided to three sections Setting up the Environment and Service Accounts Getting Ready with AutoSPInstaller Online Configuring the XML using Online Editor and Installation Setting up the Environment and Service Accounts AutoSPInstaller Online is one of a great project that facilitate Automated SharePoint installation including Sharepoint 2010, 2013 and 2016. Auto SP Installer provides a powerful way to deploy and configure a single-server development environment to multiple-server SharePoint farm. Reference: https://autospinstaller.com/ Before doing anything we will set up the environment for SharePoint three server Farm. Will name these servers as SPWFE - Share Point Front End Server SPAPP - Share Point App server SPDB - DB server Please find the reference for SharePoint minimum requirement and practices from https://docs.microsoft.com/en-us/SharePoint/install/install-sharepoint-server-2016-across-multiple-servers For the the medium segregation, we have to create...
Post a Comment
Read more

How to Customize New Item Form to take parameters from Query String in the SharePoint 2010

In here I'm going to explain how to customize the SharePoint Item From to take parameters from Query String and set them as default values using SharePoint designer. Using this you can open a new Item From by providing parameters as query string. For an example you can customize one item Display form and taking query String Parameter from that and view New Item view for another list by providing default values using the Query String.     Steps Open the SharePoint designer and go to list and libraries and open the list that you want. Click the New and create a New Insert View by providing the name of the view.   Then created one will come to the list. then click and open the view. Then default New Item Screen will be loaded as follows. Then Delete the default list view and make that empty. You can delete the controls by selecting the area in the design view, If it fully cleared you can view the following message from the designer. Then go to SharePoint...
6 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