C# Tutorials and offshore development in India

Prizes & Awards

My Profile

AdSense Revenue

Active Members
Today

Last 7 Days

more...

New Feature: Community Sites: Create your own .NET community website and start earning from Google AdSense ! It's Free !

Data from database to Grid View

Posted Date: 22 Aug 2008 Resource Type: Code Snippets Category: ASP.NET GridView

Posted By: amit chaudhary Member Level: Silver
Rating:

Points: 8

In the following code we will display data from database to Grid View.

On design Page:
Place a grid View and a Button.

On code Page:

Include the following name space:
using System.Data.SqlClient;

and on button click:-


{
string st;
st = "select * from tbusr";
SqlDataAdapter adp = new SqlDataAdapter(st, ConfigurationManager.ConnectionStrings["cn"].ConnectionString);
DataSet ds = new DataSet();
adp.Fill(ds);
GridView1.DataSource = ds;
GridView1.DataBind();
}

where tbusr is the table name from the database.

Responses

No responses found. Be the first to respond and make money from revenue sharing program.

Feedbacks

Popular Tags

What are tags ?

Search Tags

Data from database into grid view .

Post Feedback

This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
You must Sign In to post a response.

	Next Resource: Access the content of datagrid or gridview
	Previous Resource: Bind Gridview from Session , Then Edit, Update, Delete the gridview
	Return to Discussion Resource Index
	Post New Resource
	Category: ASP.NET GridView

Post resources and earn money!

Related Resources

dotNet Slackers BizTalk Adaptors Web Design

conference calls