C#

SqlDataAdapter da;
           DataSet ds = new DataSet();

           string conString = @"server = .\sqlexpress;
                               integrated security = true;
                               database = northwind";
           da = new SqlDataAdapter("select * from employees", conString);
           da.Fill(ds);
           DataTable table = ds.Tables[0];

           string conString2 = @"server = .\sqlexpress;
                               integrated security = true;
                               database = ABZ";
           string commandString = "Create table Employees ( ";
           SqlConnection con = new SqlConnection(conString2);
           DataTable tab = new DataTable("Employees");
           foreach (DataColumn  column in table.Columns )
           {

               commandString = commandString + column.ColumnName +" nvarchar (50), "  ;

           }

           commandString = commandString + ")";

           SqlCommand cmd = new SqlCommand(commandString, con);
           con.Open();
           cmd.ExecuteNonQuery();
           con.Close();
           MessageBox.Show("Table Created");

foreach (DataColumn  column in table.Columns )
            {
              
                commandString = commandString + column.ColumnName +" nvarchar (" + column.MaxLength + "), "  ;
               
            }

Select * into

noamtzu00 wrote:

(word,pdf,xls,ppt,txt

Kevin Marois wrote:

Why would one work and the other fail?

class InitSchema
{
    // stored script in the resource of my application 
    private static string strScript = global::BuyerQty.Properties.Resources.Scheme;
    
    public static void InitSchemaScript()
    {
        // clsSetting.DataBase Is My DataBase Name 
        DBConnect.DBCommand = new OleDbCommand("USE " + clsSetting.DataBase, DBConnect.DBConnection);
        DBConnect.DBCommand.ExecuteNonQuery();

        // After each Sql Statement I replace the "GO" word with "~", 
        // so C# can easily execute one statement at a time  
        strScript = strScript.Replace("GO", "~");
        foreach (string strQuery in strScript.Split('~'))
        {
            try
            {
                DBConnect.DBCommand = new OleDbCommand(strQuery, DBConnect.DBConnection);
                DBConnect.DBCommand.ExecuteNonQuery();
            }
            catch
            {
            }
        }
    }
}