Copy data into local databse

See more:

C#

SQL

In my Porject, I have local Database which is crearted by adding new item to my windows form application (Service-base-Database)and within server explorer I built my own columns for example (ID,X,Y,Z).

The idea of project is I want to read text or csv file and display my data into GridView and save all values into my Local Database (*.mdf). Currently I am looking for a function or a way how to store my data into my local databse.

Of course, I searched a lot about this issue but I found nothing similar to my issue, I found how to insert data into sql server by using sqlBULKcopy which does not work in my case.

Any Idea?

What I have tried:

<pre>public void ImportData()
        {
            OpenFileDialog ofd = new OpenFileDialog();
            ofd.Title = "Import text file";
            ofd.InitialDirectory = @"C:\";
            ofd.Multiselect = true;
            ofd.Filter = "txt file (*.txt)|*.txt| all files (*.*)|*.*";

            try
            {
                if (ofd.ShowDialog() == DialogResult.OK)
                {
                    path = ofd.FileName;

                }

                string[] lines = File.ReadAllLines(ofd.FileName);  // read all lines 
                string[] value;     // contents
                
              //  int count = 0;
                for (int i = 0; i < lines.Length; i++)
                {
                    char c = ',';
                    value = lines[i].ToString().Split(c);    //    -  -  - 
                                                             //    -  -  -
                    string[] rows = new string[value.Length];

                    for (int j = 0; j < value.Length; j++)
                    {
                        rows[j] = value[j].Trim();
                       // listBox1.Items.Add(rows[j]);
                       // listBox1.Items.Add(value.Length);
                      //  listBox1.Items.Add(lines.Length);
                    }
                    dt.Rows.Add(rows); 
                    MessageBox.Show("The data has been successfully read");
                }
                
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }

Above code just to read my text file and get DataTable (dt)

Now I want to insert dt into my local database and save

I tried this code

tabledatagridview.datasource =dt; 
this.validate()
this.tableInfoBindingSource.EndEdite()
this.tableAdapterManager.UpdateAll(this.Dataset)