create a table in sql from an asp.net app

Question

Hi everyone i wonder if there is a way to create a table in sql2000 database from an asp.net application? please anyone can help? Thanks

Mahesh Chand · Answer

Yes that will do it.

trufun101 · Answer

I've never done it but I'd imagine that you'd just need to send the CREATE TABLE script through a SqlCommand such as: SqlConnection sqlConn = new SqlConnection(strSqlConnection); string strSql = CREATE TABLE ... ; SqlCommand sqlCmd = new SqlCommand(strSql sqlConn); sqlCmd.Connection.Open(); sqlCmd.ExecuteNonQuery(); sqlCmd.Connection.Close(); That should work.