Add Dataset value in listbox / checklistbox

Question

0.00/5 (No votes)

See more:

i am trying to add value in listbox or checklistbox on comboBox3_SelectedIndexChanged event.

for this i used query.......
query correct because i want select all field with releted MainTest from database
but after selecting this i cant possible to add these selected item in listbox or checklistbox.
i know,
suppose in query i used particularly column name then that will be add in listbox/checklistbox
but i dont want do that task, i want all selected value/item from given query.

please provide some help on this topic!!!

VB

commObj = New OleDbCommand("SELECT ALL * FROM MainTest WHERE MainT = '" & h & "'", cnn)
       myDataSet1.Clear()
       myAdapter = New OleDbDataAdapter(commObj)
       myAdapter.Fill(myDataSet1, "cDetails")
        Dim ds As DataRow
        ds = myDataSet1.Tables("cDetails").Rows
       For Each ds As DataRow In myDataSet1.Tables("cDetails").Rows

           CheckedListBox1.Items.Add(ds(" what i do here      ").ToString())

       Next

Posted 7-Feb-12 21:11pm

harishtaware

Updated 7-Feb-12 21:24pm

v4

Add a Solution

Comments

Herman<T>.Instance 8-Feb-12 3:27am

in "what i do here" you have to state the columnname.
What sql server are you using? If MS SQL server you can omit the ALL keyword. with select * you get all.

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)

Jyothikarthik_N · Answer 1 · 2012-02-07T21:34:00

Solution 1

CheckedListBox has a DataBindings property.

Try using that.

VB

commObj = New OleDbCommand("SELECT ALL * FROM MainTest WHERE MainT = '" & h & "'", cnn)
       myDataSet1.Clear()
       myAdapter = New OleDbDataAdapter(commObj)
       myAdapter.Fill(myDataSet1, "cDetails")
       CheckedListBox1.DataSource = myDataSet1

Use this link for referencehttp://msdn.microsoft.com/en-us/library/system.windows.forms.control.databindings.aspx[^]

*Mark as answer if this solved your query.

Posted 7-Feb-12 21:34pm

Jyothikarthik_N

Updated 7-Feb-12 22:08pm

v2

Comments

harishtaware 8-Feb-12 4:02am

i cant get databinding part when i saw checkedlist box property that time
in databinding also having 4 different section what part are changed there.

and when i modify my code according to your changed then

error shows
Cannot bind to the property 'Value' on the target control. Parameter name: PropertyName

[no name] 8-Feb-12 4:09am

Hi,
I've updated, there is a datasource property. Just that it doesn't show up in Intellisense. Try it and tell me

harishtaware 8-Feb-12 4:16am

i cant find datasource property.
i jst see databinding in that selectindex,value,item and tag

no any datasource property available there
i am using vs2008

[no name] 8-Feb-12 4:32am

It doesn't appear in intellisense. Just code and build.

harishtaware 8-Feb-12 5:06am

Jyothikarthik_N its working but till the dataset item are not added in checklist box...:(

in list content shows system.data.DataViewManagerListItemType

[no name] 8-Feb-12 5:12am

You might have to set
CheckedListBox1.DisplayMember="ColumnName"
CheckedListBox1.ValueMember="ColumnName"

And (you've not mentioned if it is a web application)
You might need
CheckedListBox1.DataBind() or Page.DataBind()

harishtaware 8-Feb-12 5:13am

Hey Here i am using select * from then how to use column name for that instance & thts realy issue

[no name] 8-Feb-12 5:15am

You can use, no issues with that. Hope you know the column names.

harishtaware 8-Feb-12 5:21am

sir i am using
SELECT * FROM MainTest WHERE MainT = '" & h & "'"

Maintest- table name
MainT for required where clause
so i dont have column name.

[no name] 8-Feb-12 5:25am

Use this to get the column name:

myDataSet1.Tables(0).Columns(0).ColumnName

harishtaware 8-Feb-12 6:33am

thnks for help i got column name but yet database value are not filled in checklistbox :(

graciax8 · Answer 2 · 2012-02-07T21:50:00

try this one.

VB

commObj = New OleDbCommand("SELECT ALL * FROM MainTest WHERE MainT = '" & h & "'", cnn)
Dim dt as dataTable
       myDataSet1.Clear()
       myAdapter = New OleDbDataAdapter(commObj)
       myAdapter.Fill(myDataSet1, "cDetails")
 dt = myDataSet1.Tables(0)

 'checklistbox
        chkData.DataSource = dt
        chkData.DataTextField = "textfield" 'text you want to appear
        chkData.DataValueField = "idvaluefield"  'value of the field
        chkData.DataBind()

VB

Regards,
@iamsupergrasya