How to return multiple at the same time using DataGridView for C#.net

[MengChee]

i just the beginner.My db is using MS SQL server 2008

[benwizzle]

I'm not quite sure what your asking. Please elaborate.

[MrMancunian]

1. Write query
2. Execute query
3. Save data in DataTable
4. Bind DataTable to Gridview

Have fun figuring it out!

Steven

[benwizzle]

If your referring to what Mr.Mancunian just said...i can help you out there.

[MengChee]

i doing a website that need to handle the search result. becoz normal the label just can handle one result. so the datagridview can solve this problem but how to implement it?

[MrMancunian]

See my first post:

1. Write query
2. Execute query
3. Save data in DataTable
4. Bind DataTable to Gridview

Steven

[benwizzle]

General this is how i do query's in asp.net.
First you must make sure you load the assembly to your page.

using System.Data.SqlClient;
 

Then declare a connection, command, datatable, and a dataadapter.

SqlConnection con = new SqlConnection("connectionstring");
SqlCommand cmd = new SqlCommand("put command here", con);
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
 
da.Fill(dt);
GridView.DataSource = dt;
GridView.DataBind();
 

Hope this helps

[Frinavale]

Please review the following article that outline how to use a database:
Database tutorial Part 1
Database tutorial Part 2