TheCPUWizard
January 3rd, 2003, 11:26 PM
Does anyone have a link to a really good generic ASP.NET sample for accessing an arbitrary database. Basically my goals are:
1) Text box for connection string
2) Text box for query string
Once these two are provided the "code-behind" should open the connection, execute the query and display the results in an editable grid.
The "hard-coded" material should make no assumptions about the data. It is safe to assume that every table has a primary key...
A simple connection would indicate the provider (typical Jet 4.0) and a wild card select <select * from [tablename];>. The user should then have full editing capability (including add and delete)
I am specifically looking for a solution that can be implemented as a .NET web page (ASP.NET).
Thanks in advance.
1) Text box for connection string
2) Text box for query string
Once these two are provided the "code-behind" should open the connection, execute the query and display the results in an editable grid.
The "hard-coded" material should make no assumptions about the data. It is safe to assume that every table has a primary key...
A simple connection would indicate the provider (typical Jet 4.0) and a wild card select <select * from [tablename];>. The user should then have full editing capability (including add and delete)
I am specifically looking for a solution that can be implemented as a .NET web page (ASP.NET).
Thanks in advance.