Abdullah Ayhan

Abdullah Ayhan

  • 2k
  • 3
  • 1.2k

Checkboxlist shows only 1 data from database instead of 3

May 20 2013 7:21 PM

am trying to bind my Checkboxlist programatically based on two input variables ; but i get only one checkbox instead of 3 .

Here are my codes

This is my Business Layer

 public class BALDisplayPanel2 { private string _mylabel; public string MyLabel { get { return _mylabel; } set { _mylabel = value; } } private string _conditionlabel; public string ConditionLabel { get { return _conditionlabel; } set { _conditionlabel = value; } } private string _checkboxquestion; public string CheckBoxQuestion { get { return _checkboxquestion; } set { _checkboxquestion = value; } }

This is my Data access Layer

 public List<BALDisplayPanel2> DisplaySPanelQ(int tbid, int grdid) { SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["mynewdbConnectionString"].ConnectionString);
conn.Open(); SqlCommand cmd = new SqlCommand("esp_MyCheckboxProc", conn);
cmd.CommandType = CommandType.StoredProcedure; List<BALDisplayPanel2> lst = new List<BALDisplayPanel2>();
cmd.Parameters.AddWithValue("@Emp", tbid);
cmd.Parameters.AddWithValue("@UnitNumber", grdid); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { BALDisplayPanel2 unt = new BALDisplayPanel2();
unt.CheckBoxQuestion = dr["CheckQuest"].ToString();
unt.MyLabel = dr["MyLabel"].ToString();
unt.ConditionLabel = dr["ConditionLabel"].ToString(); //unt.LabelS = dr["LabelQ2"].ToString();
lst.Add(unt); }
conn.Close(); return lst; }

This is my Default.cs file i call my checkbox

 BALDisplayPanel2 bl = new BALDisplayPanel2(); DALDisplayPanel2 dal = new DALDisplayPanel2(); List<BALDisplayPanel2> lst = new List<BALDisplayPanel2>();
lst = dal.DisplaySPanelQ(Convert.ToInt32(tbEmpID.Text), Convert.ToInt32(GridView1.SelectedRow.Cells[2].Text)); foreach (var item in lst) {
chbklstpanel3.Items.Clear();
chbklstpanel3.DataSource = lst;
chbklstpanel3.DataTextField = item.CheckBoxQuestion;
lblpanel3.Text = item.MyLabel;
lblCondition.Text = item.ConditionLabel; }

any help appriciate


Answers (1)