How to retrieve data from database using C#

In Asp.net there are many techniques through which you can retrieve data from database either your data is in sql server or MS Access. In this article we will discuss, How to retrieve data from database using C# and how can we get specific data from databases and what are the basic techniques. Specific data means, when you will develop a big project in which lots of data in the table and you want to get specific data form your database then you can use this technique to find your data by searching their id.

We have discussed about grid view technique in the last article, this is also similar to that one. First of all you have to create tables in your database and stored some data by using forms.

Adding Gridview :

Step 1: After storing data in the database, open your designing page,  go to DATA option and select GridView . You will see a table, on the top of the table there will be a small arrow, click there and go to GridView Taks and select New data source form the Choose Data Source .  here is a screen shot below:

gridview0

Step 2:  If your will select New Data source there will be new tap opened with the named Data Source Configuration Wizard. In this tap you have to choose your Data source type. If your database in Access then you will go with Access Database. Here we will select SQL database because our database is in SQL server, so select SQL database and click on ok. When you will click on SQL database there will automatically show an Id (Sqldatasoure1) in the below text box. here is screen shot below:

gridview

Step 3: In the next step you will choose your Data Connection. In this step there will show a small arrow, click there and select your data connection and then click on next. In this project we have select KIU_SQL because we have named earlier KIU_SQL when we were creating database. So just select your connection that you have been given during creating database.

Step 4:  This step is very important because in this step you will select table and as well as columns that will be shown on grid view. In this project we have selected asp_record because this is our table name which we are going to display, and we have also click on *  because we need whole data form this table therefore we have selected here *. You can select specific columns that you want to display and click on next. a screen shot below:

gridview3

After clicking on next you will test query also on the next step and then click on finish, after that the table will be displayed on designing page.

Step 5: In this step we will add parameters and insert some query to get specific data from the database. So right click on SqlDataSoure and go to properties, from the properties go to SelectQuery and  then click there,  as shown in the below screen shot.

How to retrieve data from database using C#

Step 6: After clicking to Select Query you will see a new tap with the name, Command and Parameter editor. In this step we will add parameters and as well as select commands. So Add parameter and go to parameter source, select Control from there, then go to ControlID , and select the text box name, here we have selected TextBox because this is our text box name. So select control id and then click on OK. here is a screen shot below:

gridview5

Step 7: In the last step you will see how the data will retrieve from database by searching unique id. Now go to you aspx design page and run your page. When your page will open on browser enter id on the search text box and press search you will see your specific data. Have a look below screen shot:

Designing Phase:

gridview-output

These are the steps through which you can get your specific data from the database. Hopefully this article will be helpful for you and you will do this with no any trouble.

Leave a Reply

Your email address will not be published.