Loading

Create SQL Database Table using Asp.net

Faisal Ansari

hello guys how r u ?

my question is that, how we can create table in our database and its columns using asp.net interface, is there any way to do like this, so please tell me its urgent.

reply soon

thanks.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Javeed M Shaikh15y ago
It is not specific to asp.net and it is more of the DDL command to execute, following are a few steps you can follow:

Dim strSQL as StringBuilder = new StringBuilder()
strSQL.Append("CREATE TABLE tblTest " & vbCrLf)
strSQL.Append(""(" & vbCrLf")
strSQL.Append(""ID int NOT NULL " & vbCrLf")
strSQL.Append(""FirstName varchar (30) NOT NULL, " & vbCrLf")
...add more columns here
strSQL.Append("")" & vbCrLf")

' Open the Connection here
Create Command
Execute NonQuery(strSQL)
Close connection