We help IT Professionals succeed at work.

Add List<newFiles> to a dt, save to table_1

In this code, I need help with two items:

Q1: How to code this:        // define a datatable (dt) and add newFiles List to it , see the code below.

Q2: Given cs, cn, table_1, how to do ...       // add dt to SQL Server table_1

   protected void Button1_Click(object sender, EventArgs e)
        List<ExcelFiles> newFiles = new List<ExcelFiles>();
        ExcelFiles xlFile = new ExcelFiles();

        // Put file names in the directory into array.
        string dirPath ="C:\\Users\\Mike\\Data\\"; 
        var files = Directory
                        .EnumerateFiles(dirPath, "*", SearchOption.TopDirectoryOnly)

        // store file names in xlFile object
        foreach (string name in files)
            string file =name;
            string fileExtention = name.Substring(name.Length - 5);
            if (fileExtention == ".xlsx")
                xlFile.filename = file;

                // add file name to xlFile object 
        // define a datatable (dt) and add newFiles List to it (I will need this method elsewhere as well)

       // add dt to SQL Server table_1

Open in new window

Watch Question

Top Expert 2014
If table_1 is the name of the table, cs the connection string, and cn the column name:

DataTable dt = new DataTable
    Columns = { { cn, typeof(string) } }

foreach(string file in newFiles)

Open in new window

SqlConnection connection = new SqlConnection(cs);
SqlDataAdapter adapter = new SqlDataAdapter("select * from table_1", connection);
new SqlCommandBuilder(adapter);

Open in new window

Mike EghtebasDatabase and Application Developer


Thank you.