checkBoxLists
-
When I was used CheckBoxList Control. I save data through check boxes in data base. How can check the check boxes when I was retriving the data back end to front end
dfd
-
When I was used CheckBoxList Control. I save data through check boxes in data base. How can check the check boxes when I was retriving the data back end to front end
dfd
dt_News = SqlHelper.ExecuteDatatable(SqlHelper.ConnectionString, CommandType.Text, "select newsletter_type_id,newsletter_type_name from newsletter_type_master"); chkNews.DataTextField = "newsletter_type_name"; chkNews.DataValueField = "newsletter_type_id"; chkNews.DataSource = dt_News; chkNews.DataBind(); /////////Get and display checked newsletter dt_NewsClicked = SqlHelper.ExecuteDatatable(SqlHelper.ConnectionString, CommandType.Text, "select newsletter_type_id from user_newsletter_type where user_id='"+userId+"'"); int w = dt_NewsClicked.Rows.Count; int[] newsChecked = new int[20]; for (int i = 0; i < dt_NewsClicked.Rows.Count;i++) { newsChecked[i] = Convert.ToInt32(dt_NewsClicked.Rows[i]["newsletter_type_id"].ToString()); } for (int a = 0; a < w ; a++) { chkNews.Items[newsChecked[a]-1].Selected = true; } ------------------------------------------------------------------------ note : I use free SQLHelper Class to connect with database. chkNews is my Checkbox group.
Regards, Mayank Parmar Senior Software Engineer Amba Tech Gandhinagar, India