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

LVL 34
Mike EghtebasDatabase and Application DeveloperAsked:
Who is Participating?
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 DeveloperAuthor Commented:
Thank you.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.