_flori 0 Newbie Poster

-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 
            }
        }
    }
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.