How to show data in GridView on the same form?

[touseef4pk]

Dear seniours,
Please tell me how can i show my data from database in gridview on the same form rather than separate form against a click event?

[QuinnJohns]

Would you mind elaborating?

If you're referring to simply displaying data in a gridview, you can do it in two ways, systematically, or manually.

If you do it systematically, you can just create, for example, a SQLDataSource, set up the columns you want to use from your tables, and then on the GridView, set the DataSource parameter to that Source.

For more details, please visit... http://msdn.microsoft.com/en-us/libr...SDN.10%29.aspx

-- or, you can load it up manually, via... opening a connection, selecting data, setting the source, and databinding, for more information visit http://www.aspnettutorials.com/tutor...spnet2-vb.aspx.

H2H,
-Quinn

If these helps, please rate my post! Thanks!

[QuinnJohns]

Would you mind elaborating?

If you're referring to simply displaying data in a gridview, you can do it in two ways, systematically, or manually.

If you do it systematically, you can just create, for example, a SQLDataSource, set up the columns you want to use from your tables, and then on the GridView, set the DataSource parameter to that Source.

For more details, please visit... http://msdn.microsoft.com/en-us/libr...SDN.10%29.aspx

-- or, you can load it up manually, via... opening a connection, selecting data, setting the source, and databinding, for more information visit http://www.aspnettutorials.com/tutor...spnet2-vb.aspx.

H2H,
-Quinn

If these helps, please rate my post! Thanks!

So, I fail miserably, for some reason I thought this was the ASP.NET forums, and you were using SQL. ADO.NET, on what front-end? ASP.NET? ASP?

[QuinnJohns]

You may find this useful, if using ASP.NET + ADO.NET:

http:// e z i n e a r t i c l e s . c o m / ? A S P - . N e t - G r i d - V i e w - D a t a b i n d i n g - S a m p l e & i d = 1 3 0 7 7 4 0

[touseef4pk]

All examples u have give are of asp.net but my question is still there because i need help regarding windows forms not in asp.net. So tell me if i hve showed my gridview on a form. how can i update changes on gridview using it like a excel sheet.