public void db3ToSqlServer(string tblName)
{
SqlCommand mycmd = new SqlCommand();
mycmd.Connection = connect;
mycmd.CommandType = CommandType.Text;
mycmd.CommandText = "select * from " + tblName;
SqlDataAdapter myDataAdapter = new SqlDataAdapter(mycmd);
DataSet myDataSet = new DataSet();
myDataAdapter.Fill(myDataSet, tblName);
DataTable myTable = myDataSet.Tables[tblName];
KrDAO krDAO = KrDAO.getKrDAO();
DataSet dsKR = new DataSet();
dsKR = krDAO.getDataSet();
DataTable dtKR = dsKR.Tables[tblName];
Console.WriteLine(myTable.Rows.Count);
Console.WriteLine(dsKR.Tables[tblName].Rows.Count);
foreach (DataRow row in dtKR.Rows)
{
DataRow r = myTable.NewRow();
r.ItemArray = (object[])row.ItemArray.Clone();
myTable.Rows.Add(r);
}
Console.Write(myTable.Rows.Count);
SqlCommandBuilder mySqlCommandBuilder = new SqlCommandBuilder(myDataAdapter);
myDataAdapter.Update(myDataSet, tblName);
connect.Close();
}
public static KrDAO getKrDAO()
{
if (_krDAO == null)
{
_krDAO = new KrDAO();
_krDAO.krConnect();
}
return(_krDAO);
}