|
<br />
<br />
Private Sub ListBox2_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ListBox2.SelectedIndexChanged<br />
<br />
Dim myCon As OdbcConnection<br />
Dim i As Integer<br />
Dim cmd As OdbcCommand<br />
For i = 0 To ListBox2.Items.Count - 1<br />
If ListBox2.Items(i).Selected Then<br />
<br />
myCon = New OdbcConnection("Driver={MySQL ODBC 3.51 Driver};Server=myServer;Database=myDatabase;User=myUserassword=myPass;Option=3;")<br />
cmd = New OdbcCommand("SELECT * FROM myTable where Professions = '" & ListBox2.Items(i).Text & "'")<br />
<br />
End If<br />
Next<br />
If Not IsNothing(myCon) Then<br />
myCon.Open()<br />
<br />
cmd.Connection = myCon<br />
<br />
Dim ds As New DataSet<br />
<br />
Dim ad As New OdbcDataAdapter(cmd)<br />
<br />
ad.Fill(ds)<br />
<br />
Me.ListBox2.DataSource = ds<br />
<br />
Me.ListBox2.DataTextField = "ResumesID"<br />
Me.ListBox2.DataTextField = "Resumes"<br />
Me.ListBox2.DataBind()<br />
<br />
End If<br />
End Sub<br />
|
|
|
|
|
ASPnoob wrote: User=myUserassword=myPass;
This might be your problem. Please describe the error you are having.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
|
|
|
|
|
ASPnoob wrote: Me.ListBox2.DataTextField = "ResumesID"
Me.ListBox2.DataTextField = "Resumes"
For starters you're setting the DataTextField 2 times. Once should be DataTextField (Resumes) and the other should be DataValueField (ResumeID)
"It's only that urgent if you have to pee."
Dave Kreskowiak
|
|
|
|
|
Psycho-*Coder*-Extreme wrote: For starters you're setting the DataTextField 2 times
Oops, how did I miss that one? 
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
|
|
|
|
|
Paul Conrad wrote: Oops, how did I miss that one?
Not enough coffee?
"Well yes, it is an Integer, but it's a metrosexual Integer. For all we know, under all that hair gel it could be a Boolean."
Tom Welch
|
|
|
|
|
Yeah, Dr. Pepper's wearing out here 
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
|
|
|
|
|
Well you could always hook yourself up to a Dr. Pepper IV, then install a serial port to the back of your head, then even when you sleep you can answer questions here on CP
"Well yes, it is an Integer, but it's a metrosexual Integer. For all we know, under all that hair gel it could be a Boolean."
Tom Welch
|
|
|
|
|
Psycho-*Coder*-Extreme wrote: hook yourself up to a Dr. Pepper IV, then install a serial port to the back of your head, then even when you sleep you can answer questions here on CP
 That would be cool, kind of like The Matrix sort of thing 
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
|
|
|
|
|
The truly scary part is I actually think of things like that, how to find a way to install a serial port onto the back of my head and stuff, does that make me weird? 
"Well yes, it is an Integer, but it's a metrosexual Integer. For all we know, under all that hair gel it could be a Boolean."
Tom Welch
|
|
|
|
|
Psycho-*Coder*-Extreme wrote: does that make me weird?
Nah, I've thought of how cool it would be to make a world like a Star wars world or Matrix kind of thing.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
|
|
|
|
|
<br />
<br />
Private Sub ListBox2_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ListBox2.SelectedIndexChanged<br />
<br />
Dim myCon As OdbcConnection<br />
Dim i As Integer<br />
Dim cmd As OdbcCommand<br />
For i = 0 To ListBox2.Items.Count - 1<br />
If ListBox2.Items(i).Selected Then<br />
<br />
myCon = New OdbcConnection("Driver={MySQL ODBC 3.51 Driver};Server=myServer;Database=myDatabase;User=myUserassword=myPass;Option=3;")<br />
cmd = New OdbcCommand("SELECT * FROM myTable where Professions = '" & ListBox2.Items(i).Text & "'")<br />
<br />
End If<br />
Next<br />
If Not IsNothing(myCon) Then<br />
myCon.Open()<br />
<br />
cmd.Connection = myCon<br />
<br />
Dim ds As New DataSet<br />
<br />
Dim ad As New OdbcDataAdapter(cmd)<br />
<br />
ad.Fill(ds)<br />
<br />
Me.ListBox2.DataSource = ds<br />
<br />
Me.ListBox2.DataTextField = "ResumesID"<br />
Me.ListBox2.DataTextField = "Resumes"<br />
Me.ListBox2.DataBind()<br />
<br />
End If<br />
End Sub<br />
|
|
|
|
|
ASPnoob wrote: its not working. The problem is it doesn't generate any errors, no exception was thrown.
What is it doing wrong? I noticed the User in the connection string is questionable with the password...
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
|
|
|
|
|
What I wanted to do was to retrieve resumes which have been stored as text, from the database. Each resume has a corresponding profession which is stored in the Professions field and ResumesID is used as the primary key. I have created a listbox which has the names of different professions. When someone selects one or more professions from the listbox, resumes that correspond to the professions will be displayed. I have used the for loop for the multiple selection of the list items. Then I used the If statement to make sure that a list item is selected. The Select statement is suppose to pick the professions where the name of the professions match the text value of the selected list items. The problem is nothing happens when I select the list item.
-- modified at 0:45 Tuesday 24th July, 2007
|
|
|
|
|
What I would do is keep the listbox having the names of the different professions, then when the user selects the profession, a new listbox pops up with the resumes of the corresponding profession.
I think if you want to stick with the same listbox control, you have to also clear out the professions before binding the resumes. I stick to just having a new form open when the user selects something off a listbox or combobox.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
|
|
|
|
|
Can you please show an example of what you're talking about or point me to a tutorial on do this? I really need to know how to make this work. Thanks again for your help.
|
|
|
|
|
Which one? The pop-up form is the easiest one to do.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
|
|
|
|
|
You seem to be asking a lot of questions, and struggling to understand the answers. You should buy a book and work through it, so you're able to make sense of the advice you're being given.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Christian Graus wrote: advice you're being given
I don't think my advise has been that entirely difficult. I think ASPnoob is really new at this programming stuff.
Christian Graus wrote: You should buy a book and work through it
Yep, many of them out there.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
|
|
|
|
|
Paul Conrad wrote: don't think my advise has been that entirely difficult. I think ASPnoob is really new at this programming stuff.
Yeah, that's what I thought too, hence my advice.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Hi!
i would like know about if exist a method to create a imagecombo control in runtime from vba, i want use some how this: CREATEOBJECT("IMAGECOMBO"), is possible?, thanks for your help.
|
|
|
|
|
I am writing an application that has a main menu form with buttons that open other "sub" forms. The sub forms each have to have a button that takes the user back to the main menu form and I am not having any luck.
Any help would be great since I am an amateur. Thanks in advance!
Natalie
|
|
|
|
|
Hi,
in the simplest case, you have one main form, visible all the time;
and a series of dialog windows, which are forms you show with ShowDialog(),
which means as long as a dialog is visible, the form cant get focus; so you must
close the dialog, before you can continue using the main form. That does not require
any special programming, except for the ShowDialog() instead of Show().
|
|
|
|
|
Hiding main form instead of closing it
|
|
|
|
|
Afternoon all
I have a while loop that is constantly receiving data at 4 times a second. Right now I convert the data and store it as a sorted list. I have to save the first data set in order to compare it to the next incoming data set and record only the key/value pairs that changed. After the comparison the most recent data has to be stored for comparison to the next data and so on and so on. Any suggestions on how i might go about doing this
Thanks in advance
|
|
|
|
|
As the lists are sorted, it's very easy to compare them. Here's some pseudo code:
input: listA, listB
indexA = 0
indexB = 0
while indexA inside listA or indexB inside listB
begin
if indexA outside listA
changed: listB(indexB)
indexB++
else if indexB outside listB
changed: listA(indexA)
indexA++
else if listA(indexA) < listB(indexB)
changed: listA(indexA)
indexA++
else if listB(indexB) < listA(indexA)
changed: listB(indexB)
indexB++
else
indexA++
indexB++
end
---
single minded; short sighted; long gone;
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
