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

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.