C#创建数据库表

SqlConnection   conn=new   SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["conn"]);  
  SqlCommand   comm=new   SqlCommand();  
  comm.Connection=conn;  
   
  string   sql="";  
  sql="CREATE   TABLE   @tablename";  
  sql+="(   ";  
  sql+="date_in   datetime,";  
  sql+="user_id   int,";  
  sql+="myuser_name   varchar(200)";  
  sql+=")";  
  comm.CommandText=sql;  
  SqlParameter   parm1=new   SqlParameter("@tablename",SqlDbType.VarChar(20));  
  parm1.Value=s;  
  comm.Parameters.Add(parm1);  
  conn.Open();  
  comm.ExecuteNonQuery();