Create table at run time in Database by using ASP.NET

Sign in to leave a comment.

• 

  Subash10y agoPosted Sep 20, 2016, 6:03 AM

  Nice sir
• RK

  Rajesh Kumar15y agoPosted Dec 19, 2010, 10:09 AM

  how can we create tables at run time, and table name will be passed by user along with data. thaks rajesh kumar [email protected]
  • 

    Manish Dwivedi15y agoPosted Dec 20, 2010, 1:34 AM

    Hi Rajesh, For creating table, i have passed the static values, you can change it dynamically for that you have to create UI and ask to user for inserting table name and values. For ex. i have written like that string sql = "CREATE TABLE mySchoolRecord" + " (StudentId INTEGER CONSTRAINT PkeyMyId PRIMARY KEY," + "Name CHAR(50), Address CHAR(255), Contact INTEGER)"; you can change it like that string sql = "CREATE TABLE" + TextBoxTableName.Text + " (StudentId INTEGER CONSTRAINT PkeyMyId PRIMARY KEY," + "Name CHAR(50), Address CHAR(255), Contact INTEGER)"; and for passing the value dynamically. sql = "INSERT INTO mySchoolRecord (StudentId, Name ) " + "VALUES (1, '"+ TextBoxName.Text +"') " By this way you can dynamically pass values.