update mantığı asp.net

        int id = 1;

 

        for (int i = 0; i < 136; i++)

        {

            SqlDataAdapter adp = new SqlDataAdapter("update Tbl_Kategoriler set Sira='"+id+"' where ID='"+id+"'", con);

            DataTable dt = new DataTable();

            adp.Fill(dt);

            id++;

        }