How to create sql connection, populate DataGrid from code-behind

[capella07]

This really is such a simple problem I know that many of you will be able to answer it. I think my not knowing the answer really is the result of learning Web design in the "drag-n-drop" design environment VS2005 allows... but that's for another thread...

Anyway, due to the functionality I know I am going to need to introduce in a Web page I'm building, instead of using the aspx-side sqlDataSource control to work with a database and filling a DataGrid, I need to do all that (connect to the database, run a query, do updates, inserts, etc) in the code-behind page.

I've searched the Web and found examples, but I'm just not getting how it's done.

I'd appreciate it if someone could, if not provide an example directly, point me to a good online source to go to, that has good examples of this.

Thanks

 

[cjard]

i'd have posted this thread in the ASP.NET data access forum..

 

[capella07]

Sure, can do if it'd be more appropriate there...

Then again, this IS the ADO.NET forum, is it not?

 

[cjard]

yes, but youre asking a question about building your own data access layer, not specifically ado.net (as far as i can see)