Click here to Skip to main content
15,896,314 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
i want to fetch a data from db to which columnName is enabled by user, i sdisplayed both checked and unchecked field name in checkbox list......
this my code ........

C#
SqlCommand cmd =new SqlCommand( "select * from stckcol_header_tbl",conn);
            cmd.Connection = conn;
            conn.Open();
            using (SqlDataReader sdr = cmd.ExecuteReader())
            {
                while (sdr.Read())
                {
                    ListBox item = new ListBox();
                    item.DisplayMember = sdr["columnName"].ToString();
                    item.ValueMember = sdr["colid"].ToString();
                    item.SelectedItem = Convert.ToBoolean(sdr["status"]);
                    Chk_colHeader.Items.Add(item);
                }
            }
thanks in advance....
Posted
Updated 27-Oct-13 22:11pm
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900