C#

private void button2_Click(object sender, EventArgs e)<br />
        {<br />
<br />
            // Create a new Connection and SqlDataAdapter<br />
<br />
            NpgsqlConnection conn = new NpgsqlConnection("Server=192.168.24.24;Port=5432;User Id=postgres;Password=S3cr33t;Database=Database;");<br />
<br />
            NpgsqlDataAdapter mySqlDataAdapter = new NpgsqlDataAdapter("Select * from points", conn);<br />
            DataSet myDataSet = new DataSet();<br />
            DataRow myDataRow;<br />
<br />
            // Create command builder. <br />
            <br />
            NpgsqlCommandBuilder myCommandBuilder = new NpgsqlCommandBuilder(mySqlDataAdapter);<br />
<br />
            mySqlDataAdapter.Fill(myDataSet, "points");<br />
            myDataRow = myDataSet.Tables["points"].NewRow();<br />
           <br />
<br />
                myDataSet.Tables["points"].Rows.Add(myDataRow);<br />
<br />
                foreach (DataRow myDataRow1 in myDataSet.Tables["points"].Rows)<br />
                {<br />
                myDataSet.Tables["points"].Rows[0]["track_easting"] = "665544";<br />
            }<br />
            mySqlDataAdapter.Update(myDataSet, "points");<br />
        }

public void RunThd(object theFile)<br />
{<br />
<br />
Thread thd = new Thread(Go);<br />
<br />
thd.IsBackground = true;<br />
<br />
thd.Start(theFile);//Starting the thread, passing the StreamReader as an argument.<br />
<br />
}

void Go(object theFile)<br />
<br />
{<br />
<br />
StreamReader Reader = (StreamReader)theFile;<br />
<br />
string sqlSelect = "SELECT * FROM MYTABLE1";<br />
<br />
string sqlConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings[@"conString"].ConnectionString;<br />
<br />
try<br />
<br />
{<br />
<br />
DataTable dTable = new DataTable();<br />
<br />
OleDbConnection oleConnection = new OleDbConnection(sqlConnectionString);<br />
<br />
OleDbDataAdapter oleAdapter = new OleDbDataAdapter(sqlSelect, oleConnection);<br />
<br />
OleDbCommandBuilder cmdBuilder = new OleDbCommandBuilder(oleAdapter); //Command Builder<br />
<br />
oleAdapter.Fill(dTable);<br />
<br />
string strLine = stReader.ReadLine();<br />
<br />
//Prepare all of the Rows - around 80,000 records.<br />
<br />
DataRow thisRow = null;<br />
<br />
while (!Reader.EndOfStream)<br />
<br />
{<br />
<br />
strLine = stReader.ReadLine();<br />
<br />
//Add rows<br />
<br />
thisRow = dTable.NewRow();<br />
<br />
 <br />
<br />
thisRow["Col1"] = strLine.Substring(0, 1);<br />
<br />
thisRow["Col2"] = strLine.Substring(1, 11);<br />
<br />
thisRow["Col3"] = strLine.Substring(11, 1);<br />
<br />
dTable.Rows.Add(thisRow);//after around 30000 records, app seems slower.<br />
}<br />
<br />
//Update database<br />
oleAdapter.AcceptChangesDuringFill = true;<br />
oleAdapter.Fill(dTable);<br />
<br />
oleAdapter.Update(dTable);//updates the table in ms access database. Is it possible to refresh DataTable after 10,000 records? Just to mitigate the performance issues? Add 10,000 records, then refresh DataTable, then Add another 10000 and refresh, and so on for the rest of the records.<br />
<br />
}<br />
<br />
catch (Exception e)<br />
{<br />
MessageBox.Show(e.Message);<br />
}<br />
<br />
}<br />
<br />
}