-1 down vote favorite
I have done this condition to control if the elements of the row of the slq table are equal with the elements of the row of mysql table after this if the condition is true I have to overwrite the elements of the mysql table. Please I would really appreacite somebody's help coz I'm a newbie and I have been looking all over the web and I can't do this on my on. Thanks in advance.
int lengthClienti = MySqlSetClienti.Tables["clienti"].Rows.Count;
int columnClienti = 4;
//loop through all rows of Sql Server data table and add into MySql dataset
for (int i = 0; i <= lengthClienti - 1; i++)//row
{
for (int j = 0; i <= columnClienti; j++)//column
{
if (SqlDataSet.Tables["ClientiImporti"].Rows[i][j].ToString() == MySqlSetClienti.Tables["clienti"].Rows[i][j].ToString())
{
//I don't know how to make the update
}
}
}