Heres the address where you can go and view my UserDB sample data access class.

http://65.193.79.4/usersdb/User_Form.aspx

I was asked to create this as a test for a job interview. Since I did the work I figured I might as well share it with all. You can simply modify it for any table structures.

I am probably going to make it alittle bit more intelligent so that you can pass it just a coneection string and table name and it will construct it self internally. I haven't done this yet but it sounds like a good thing to try...

I hope this saves you some time in the future. It is a fully functional example utilizing the datagrid, a drop down box, several label and a data entry screen for the Create() method.

It supports, LoadCombo(), CreateDatasorce() {for the grid with a overloaded strSQL property} Delete(), Update(), Read() and everything else you need generally to manipulate an interface screen and dataconnection.

One intersting thing I did when writing this was I generally hate the interface for aspx grid functionality so I decided to put it through the paces and see what it could do. I don't know if any of you have faced the Edit Mode field size issue. When you enter edit mode it replaces the cells with text boxs by default with a rather long width and the user hased to scroll for miles if their is alot of fields. Well I took the time and figured out how to access these textboxes and adjust their properties so the edit screen can be used without scolling for miles.

I'm an old school SQL/ASP/RDS/OCX kind of guy who loved building killer interfaces with OCX's and RDS manipulating the data on the client and hiding all that ASP back and forth to the server from my users. I finally bit the bullet and went down to Barnes and Noble and bought a C# book containing Visual Studio .NET C# because I couldn't afford to give Microsoft thousands again for another devlopment environment. I decided to test the framework and wrote a POP3/SMTP/Document collaboration site with encryption PGP 8.0 built in. I have to say that .NET is pretty nice and it made it simple to create the POP# client and server application.

http://www.musicgogo.com

Well I hope someone can use this snippet class for something since I pujt the work into it.

Regards,

Dean Meyers
bahamapapa@musicgogo.com
or
javabase@hotmail.com

Hi Dean,

I can't access the address that you have provided (http://65.193.79.4/usersdb/User_Form.aspx )

Is there other way to access/view youre sample code.

 

Regards