It seems that when I try to do an adapter.Fill(dt); it crashes if there is too much data. I'm trying to copy the contents from a remote database and storing it in a local database.
string sql = "SELECT * FROM TABLE"
command = new OdbcCommand(sql, (OdbcConnection)remoteconn);
command.CommandTimeout = 0;
OdbcDataAdapter adapter = new OdbcDataAdapter((OdbcCommand)command);
dtTemp = new DataTable();
This is just the fill code not counting that I have to loop through each one and do a setadded() so that it updates another data adapter.
Any clues on how I can do this differently or how much data can a datatable hold?