Tom's Guide | Tom's Hardware | Tom's Games
![]() |
![]() |
![]() |
Hi i' new C# programming and i am trying to create an SQL command viewer same as ISQL * Plus using Visual Studio 2005 in C# Baicially querying a gridview using SQL statements via a textbox
I have a database created using SQLDataSource which is called customer. It contains ID, firstname, surname, address. This is linked to a Gridview which display the information within the database.
Want i want is to bind the textbox some how to the database or Gridview so when the user type in any SQL command/statement via the textbox such as "SELECT firstname from Customer; or "INSERT INTO customer(firstname,surname,adress) VALUES ('Alan','Smith','Boston') It will show the results in the Gridview.
However, i want some type of validation to ensure the SQL command entered by the user is correct and is shown to the user.For example In a form of an error message on the web page stating either correct or incorrect if they miss out the ; <-- (cant remember what you call it again)
I would also like to expand this by allowing the user to create a database using the text box and perform othe SQL statement such as SQL ORDER BY, SQL DELETE, SQL UNION,SQL GROUP BY etc

![]() |
Suggest some Free Java Ho...
|
Adding Border to Image ov...
|

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.
| Ads by Google |