SqlCommand cd = new SqlCommand(); cd.CommandText = "select * from NONPRODUCTION_RESUME order by RESUMEID"; cd.Connection = con; SqlDataAdapter da = new SqlDataAdapter(cd); SqlCommandBuilder m_SQLCmdBuilder = new SqlCommandBuilder(da); DataSet ds = new DataSet(); da.Fill(ds, "resid"); //ds.Tables["resid"].Constraints.Add("rid", ds.Tables["resid"].Columns["RESUMEID"], true); int k = 1; int var = 0; for ( var = 0; var < ds.Tables["resid"].Rows.Count; var++) { // DataRow dr= ds.Tables["resid"].Rows[var]["RESUMEID"]=k; //dr.BeginEdit(); //dr["RESUMEID"] = k; //dr.EndEdit(); //dr.BeginEdit(); //dr["RESUMEID"] = k; k++; //ds.Tables["resid"].GetChanges(); da.Update(ds.Tables["resid"]); //ds.AcceptChanges(); }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)