Modifying default ASP.net template

[Cyrax.NET]

OK first of all this is my first time delving into ASP(Winform is my normal area) so please bare with me.

I'm playing around and created a new Web Form project and trying to make way with the default template. I've created the pages I need but trying to leverage the existing membership pages and ASPNETDB.
I'm having trouble grasping how the asp pages are connecting to the database(and thus make my own changes). I cannot see any SQL syntax in the aspx pages or the code behind? I can tell the project is making use of the stored procedures but where is the actual connection configured or the command that is being run, for example when the "create" button is pressed on the CreateUserWizard control. Looking at the createUserWizrd I cannot see any adapters it might be using?

Perhaps my mindset is trying to apply, tableadapter and datasets way of working to asp controls. All the information and tutorials I'm looking at, seem to bypass the connection to the database and somehow there controls are 'taking care' of the I/O to the database.

So if I wanted to add an additional field to the createwizard process, what do I need to do? Alter the db and the stored procedure, then?

Any help appreciated.

[sapator]

I take it that your are using the asp.net membershp database?
Ye my advise would be to create another table for any extra stuff you want and leave that db at peace.
If you want something specific let us know.I'll try to help but in order for you to add stuff to the membership database you would have to modify the db sprocs.Not such a good idea if you don't know exactly what you are doing.Unless if there are any oveload methods i've missed on the membership object (don't use VS2010 a lot since it adds thousand of useless stuff to my hard drive(useless for my needs anyhow).
P.S. The connection configuration will be inside your web.config.

[Cyrax.NET]

I've taken an alternative route and have switched to ASP.NET web page model instead of Web Forms. I've also switched to using WebMatrix 2 for this as I find it a nice light weight tool for a relatively simple project.

So I've got what I need now but I have a question related to ASP.NET web pages for something I'm about to tackle...

What do web page developers do/use for more sophisticated controls. i.e. I need to now display data from the local sdf database. I'm using ordinary HTML tables but of course there is no functionality. I want something similar to datagridview from Win Forms where the user can filter/edit. Anything like this to suggest other than coding the whole functionality myself? I'm not looking at expensive 3rd party grid controls. Fee alternatives?


Thanks for any info.

[sapator]

There is a gridview in your tools.Anyhow just go to design mode and look at your data tools.
There is also the jquery way that one of our esteemed colleagues here is busting our @@ with (lol, joking) but it will take a whole lotta reading again.I think the control u have to use this way is a jquery slickgrid.

[Cyrax.NET]

Just to re-iterate, I'm not working on a Web Forms project any more but a Web Pages approach i.e. CSHTMl etc
Hence as far as I can tell, I cannot make use of server side controls like gridview. I can mix the two types of pages, i.e. have aspx pages in my project where I can insert asp gridview but the issue then is, I cannot apply my SiteLayout to my newly created Web Form page as it needs to be a master page. If you know how to do this please let me know.

I really do need to sit down and do alot of reading as I'm getting confused with the differences between the three approaches to asp. Web Page vs Web Form vs MVC. This is something I really will read up on but I need to finish this project first. Lol I know, not great but hey it's where I am.

I'm taking your other bit of advice and looking for a jquery grid that will work with my current project so if you have any suggestions (preferably simple to use), feel free to throw them at me.

Thanks

[sapator]

Cannot help you on web pages, haven't touched them enough yet.