databinding in Checkboxlist

Question

0.00/5 (No votes)

See more:

Hi,

I have a query on data binding in checkboxlist

for example i have saved the data in the database in the following manner as below

ExmpName Country

ravi india , US, UK , China
manan india , germany , japan

the above mentioned data exist in my table now how can i show the same data for empname in the textbox and country in the checkbox list in the asp.net page using C# , pls guide me in this regard

Posted 6-Feb-13 6:24am

lalitkr

Updated 6-Feb-13 6:34am

v2

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Surendra0x2 · Answer 1 · 2013-02-06T07:35:00

C#

SqlConnection sqlconn = new SqlConnection("server=.\\sqlexpress;database=forum;integrated security=true");
       SqlCommand sqlcomm = new SqlCommand("select country from countryname ", sqlconn);
       sqlconn.Open();
       SqlDataReader dr = sqlcomm.ExecuteReader();
       if (dr.Read())
       {
           string Country = dr["Country"].ToString();
           var toArray = Country.Split(',');
           foreach (var s in toArray)
           {
               CheckBoxList1.Items.Add(s);
           }



           dr.Close();
           sqlconn.Close();


       }

I have Updated My Answer this is working i have Checked :) i saw that solution given below and applied according to ur requirement.

Jameel VM · Answer 2 · 2013-02-06T07:41:00

Solution 2

Try this

C#

//for example this is your countries column from the table
           string country = "UK,London,America";
           var toArray = country.Split(',');
           foreach (var s in toArray)
           {
               CheckBoxList1.Items.Add(s);
           }

Hope this helps

Posted 6-Feb-13 7:41am

Jameel VM

Updated 6-Feb-13 7:42am

v2

Comments

Surendra0x2 7-Feb-13 8:30am

+5 Dude :)