infolink

Friday 31 August 2012

Filter GridView in .Net - ASP.Net


This tutorial is about how to add filter in gridview  in asp.net. It is very simple.
First you bind the GridView with database. if you not know how to bind than check the following tutorial:
http://developerqueries.blogspot.com/2012/08/display-data-in-gridview-from-database.html
Now add the DropDownList and fill it with all alphabets.

DropDownList
DropDownList

insert into database - ASP.Net

This Tutorial is about insert data into database in asp.net. Here is steps:

Step 1:

First create the form where you enter the record.

Insert Form
Insert Form

Monday 27 August 2012

Edit Delete data in GridView

This Example is about how to Edit/Delete data in GridView. here is the step by step explain about this example.

Step 1:

Select new data source
Select new data source

Bind GridView using DataSet

This tutorial is about bind gridview using dataset. First add dataset and drop the table in the dataset. then go to the page load our any button event and write the code.
These are the simple steps to bind the gridview:

Add DataSet
Add DataSet

Add table in DataSet
Add table in DataSet

Now go to the page load event and write this code:

DataSet1TableAdapters.tbl_PersonInfoTableAdapter obj_adapter = new DataSet1TableAdapters.tbl_PersonInfoTableAdapter();
        DataSet1.tbl_PersonInfoDataTable obj_dt = obj_adapter.GetData();
        GridView1.DataSource = obj_dt;
        GridView1.DataBind();

Sunday 26 August 2012

Display Data in the GridView from database using SqlDataSource in asp.net

This tutorial is about how to retrieve data from the database and display in the GridView using SqlDataSource in ASP.NET. It is very simple with the SqlDataSource.
Here is steps.

Step 1:

On the page add the GridView control. after that select the GridView and click on the top right side button a GridView Tasks window will appear now from this window choose the new data source from the DropDownList. Like this:
Select new data source
Select new data source

Saturday 25 August 2012

Show data in grid view in ASP.NET

This tutorial is about  the grid view control. grid view Control is a very powerful control. it is a table structure where data show in the rows and columns.
Here we can see how to show data in the grid view when user press the button.
When the user Click on the button every time a new row will added in the grid view.
Below mention code is used for this purpose.

Step1:

In the Default.aspx page write these code: