DataView Problem
-
I have a dataview..... When it retrieves data from the database there is a column in my data base that stores 1's and 2's. 1's mean 'Yes' and 2's mean 'No'. This column (St_Assess_Ev_Checked) has been declared as an Integer. How do you iterate through a dataview, if it see's 1 it prints yes to my datagrid and if it see's 2 it prints no. This is my code so far.... hope I'm at least close. DataSet sqlDS = new DataSet(); SqlDataAdapter sqlDA = new SqlDataAdapter(stReport, sqlConnection); sqlDA.Fill(sqlDS, "progReport"); dv = sqlDS.Tables["progReport"].DefaultView; IEnumerator iterator = dv.GetEnumerator(); foreach(DataRowView drv2 in dv) { for (int x = 0; x < dv.Count; x++) { if(dv[0]["St_Assess_Ev_Checked"].ToString() == "1") { dv.AllowEdit = true; dv[0].BeginEdit(); dv[0]["St_Assess_Ev_Checked"] = "Yes"; dv[0].EndEdit(); } else { Response.Write(dv[x].ToString()); } } } You could of guessed the error.... Cannot convert types expected Int32! Thanks in advance, appeciate it! :)
-
I have a dataview..... When it retrieves data from the database there is a column in my data base that stores 1's and 2's. 1's mean 'Yes' and 2's mean 'No'. This column (St_Assess_Ev_Checked) has been declared as an Integer. How do you iterate through a dataview, if it see's 1 it prints yes to my datagrid and if it see's 2 it prints no. This is my code so far.... hope I'm at least close. DataSet sqlDS = new DataSet(); SqlDataAdapter sqlDA = new SqlDataAdapter(stReport, sqlConnection); sqlDA.Fill(sqlDS, "progReport"); dv = sqlDS.Tables["progReport"].DefaultView; IEnumerator iterator = dv.GetEnumerator(); foreach(DataRowView drv2 in dv) { for (int x = 0; x < dv.Count; x++) { if(dv[0]["St_Assess_Ev_Checked"].ToString() == "1") { dv.AllowEdit = true; dv[0].BeginEdit(); dv[0]["St_Assess_Ev_Checked"] = "Yes"; dv[0].EndEdit(); } else { Response.Write(dv[x].ToString()); } } } You could of guessed the error.... Cannot convert types expected Int32! Thanks in advance, appeciate it! :)
Do it in your datagrid ItemDataBound event. This should help you. SG