Hi, All,
I have a problem to populate a comma delimited string from the database stored in Arabic like this (????? ????,???? ????? ?????,???? ???? ?????,???? ?????,) to a checkboxlist inside a gridview edit template?
here what my Code Look like:
string checkBoxValues = "";
if (e.Row.RowType == DataControlRowType.DataRow)
{
CheckBoxList chkBrand = (CheckBoxList) e.Row.FindControl("CheckBoxList1");
String SQL = "SELECT * FROM TransactionDetail";
string sConstr = ConfigurationManager.ConnectionStrings["conStr"].ConnectionString;
using (SqlConnection conn = new SqlConnection(sConstr))
{
using (SqlCommand comm = new SqlCommand(SQL, conn))
{
conn.Open();
SqlDataReader myReader = null;
myReader = comm.ExecuteReader();
while (myReader.Read())
{
checkBoxValues = (myReader["Steps"].ToString());
}
foreach (string value in checkBoxValues.Split(','))
{
ListItem item = new ListItem();
item.Text = value;
item.Value = value;
chkBrand.Items.Add(item);
}
}
}
}
Jegadeesh ShanmugavelPosted Feb 28, 2017, 12:46 PM
What is the issue you are getting. As per my understanding you are always binds the last record for all the row