Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- mAD.Fill(MySqldSet, "tbltrackshipment");//Got the empty table of Mysql
- // Loop through all rows of Sql server data table and add into MySql dataset
- DataRow NewRow;
- foreach (DataRow row in SqldSet.Tables["tblStatusTracking"].Rows)
- {
- NewRow=MySqldSet.Tables[0].NewRow();
- NewRow["BL"] = row["BL"];
- NewRow["ContainerNumber"] = row["ContainerNumber"];
- NewRow["Status"] = row["Status"];
- NewRow["FinalDest"] = row["Location"];
- NewRow["StatusDate"] = row["StatusDate"];
- MySqldSet.Tables[0].Rows.Add(NewRow);
- }
Add Comment
Please, Sign In to add comment