Last post Apr 18, 2016 12:02 PM by Yohann Lu
Apr 17, 2016 04:52 AM|Hameed_Khan|LINK
I'm working on "SQL EDITOR" Project and I'm stuck at one point,that how user create a table.I solve the database problem,but i don't know how can i resolve he create table problem.Here is my logic:
1: User login
2: Create Database
3: Click create table then select db
4: after selecting db,I've created a textbox(for col name),dropdownlist(for data type), and two checkboxes(one for primary other for allow null)
5: User insert and select values from control and click "insert" button then values shows in gridview,user can also edit and delete column.After inserting values,USER CLICK ON "Create Table" button then values successfully save in database( tbl_field) table
but issue with table,Only "First row" of gridview insert in query and table created but only contain one column,because i used for loop and condition gridview.rows.count ,when first time loop start execution then table created just first row inserted inside
the query,when second iteration come then table is already created error etc.Can you help me about this,how can i do this in better way or how can resolve this issue?
Apr 18, 2016 12:02 PM|Yohann Lu|LINK
You can try the following two ways to implement your needs.
1: SQL Server Web Tools
SQL Server Web Tools is a Web-based Administration tool to manage SQL Server databases. With SSWT, you can administer accounts, manage databases and tables, write and run queries and Stored Procedures, and much more.
2: Table Smart Editor
The Table Smart Editor is a .Net Online Database Editor for Access, SQL Server / Web Site CMS: