|
Hi,
I have a VB.net project in which I attach to a MSAccess 2000 database. I have a listbox in which I want to populate the most recent records from a table. I have therefore put the following code into the GotFocus event of the listbox
Dim strConString As String = _
"Provider=Microsoft.Jet.OLEDB.4.0;" _
& "User ID=Admin;" _
& "Data Source=C:\MCS\GolfSociety\GolfSociety.mdb"
Dim ocm As New OleDb.OleDbCommand
Dim odr As OleDb.OleDbDataReader
Dim i As Integer
' ocm = New OleDbCommand
With ocm
.Connection = New OleDbConnection(strConString)
.Connection.Open()
.CommandText = "SELECT tblmembers.memID, tblmembers.Name, tblmembers.Club_Hcap, tblmembers.Soc_Hcap FROM tblmembers ORDER BY tblmembers.Name "
odr = .ExecuteReader()
End With
cmbMembers.Items.Clear()
i = 0
While odr.Read
cmbMembers.ListItems.Add(odr("MemID"))
cmbMembers.ListItems(i).ListSubItems.Add(odr("Name"))
cmbMembers.ListItems(i).ListSubItems.Add(odr("Club_Hcap"))
cmbMembers.ListItems(i).ListSubItems.Add(odr("Soc_Hcap"))
i = i + 1
End While
odr.Close()
ocm.Connection.Close()
I would have expected that this would have executed the commandtext each time the listbox got the focus and that if I changed the table in the background that the next time I clicked the listbox I would get the updated records. This does not happen. If I click the listbox and then change the table by opening the database and editing a record, the change does not come through the next time I click the listbox.
Thanks in advance
Brian
|
|
|
|
|
Without knowing where you put this code, it's impossible to tell you if what you're expecting will even work. If I were you, I would probably put this code in your ListBox's MouseEnter event. Even better, I would put a call to this code into whatever method is actually updating the database.
[EDIT]
I was that you said you put this in the GotFocus event. The focus won't change to your ListBox control unless you click on it. By that time, it's too late to update the data in it.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Hi,
I have a form for entering scores. These scores are dependant on members handicaps which may have changed since the last time the member took part. On the score form I have a drop down combobox which displays the member and his handicap. What I want to be able to do is that if the handicap is incorrect in the combobox, click a button which opens a form so I can then update the member details, and then when I drop the combo box again it will have the new details in it. I have done this and even tried editing the table directly in the background but every time I drop down the combobox it displays the original details for the member. If I open the scores form then edit the table, close the scores form and open it again it will pick up the new details. Basically I want the combobox to display the updated details without having to close and reopen the form,
Regards
Brian
|
|
|
|
|
When the form that you use to enter the new details is closed (assuming it's a modal dialog), you'll have to wipe out the data in the combobox and re-populate it, probably using the same code that populated it in the first place.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
If you look at the original code sent in, it is clearing the list box and repopulating it.
|
|
|
|
|
If it's still in the GotFocus event, it won't update the ComboBox. You have to update the combobox in another event that doesn't depend on focus. I already suggested the MouseEvent event, but it's better it you repopulate all your data dependant controls just after you update the database.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
well im actually not a newbie.. i started learning vb years ago.. but i stopped studyin about it..
anyway.. i need help. im actually creating a program. and i need help.
its just about simple text switch.
for example. you have two frames with 7 option buttons and 7 text fields (prepopulated) each.
how do i reference the textbox to the option button??
since one can only choose one option from 7options on each frame, how can i exchange the strings on the chosen textfields???
and another thing.. how can i store those 2 strings, so that the data inside the chosen text boxes will change once the strings have been exchanged.. without loading the form again??
help.. i really need help...
|
|
|
|
|
calvin0176 wrote:
how do i reference the textbox to the option button??
You don't.
calvin0176 wrote:
how can i exchange the strings on the chosen textfields???
What? What strings?
calvin0176 wrote:
how can i store those 2 strings, so that the data inside the chosen text boxes will change once the strings have been exchanged.. without loading the form again??
This doesn't make any sense. Perhaps if you setup your questions with an explanation of what is in the textboxes first, then explain what you want to happen when you click on one of the option buttons, we can understand what you want to do.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Hi,
Does anyone knows how to create a setup package that will install a custom font into the clients windows\fonts directory without prompting him.
Some People succeed because they are Destined to, but most people succeed because they are Determined to
|
|
|
|
|
the default property of font folder is that if you copy any font it automatically installs it. so you just need to add the font in your setup project and give it destination to windows\font folder and it will be installed
|
|
|
|
|
I have the following problem:
I have a project ActiveX Document (vbd) developed in vb and wanted to develop it in NET.
Everywhere I have read that this is not possible.
Somebody could help me?
Thanks
|
|
|
|
|
VB.NET doesn't build ActiveX documents or binaries.
You'll have to keep using VB6 if you want to continue the project. You'll have to scrap it and start from scratch if you want to do something equivilent in VB.NET or C#. Though, the user will have to have the .NET Framework installed on their machines if they want to use your component.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Sorry,
but my ingles is bad.
I do not understand the expression "scrap it and start from scratch"
|
|
|
|
|
Drop the original project. Rewrite the entire project in something equivilent in the .NET Framework.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
ok!!
but, what he is its equivalent one in NET that is looked like a project?
thanks again
|
|
|
|
|
There isn't any one project that replaces an ActiveX project. What you use depends on what your doing. It could be limited to client-side JavaScript, a Web Control, a mixture of both.
The only language in the .NET Framework that still targets ActiveX is C++.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
What is the easiest way to format all the items of a column to currency?
|
|
|
|
|
The listview won't do it, you need to.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
i need help in connecting Access to VB.net ..
can anyone let me know what is wrong with my code ..
Public strSQL As String
Public objCon As ADODB.Connection
objCon = New ADODB.Connection
Dim Rs As New ADODB.Recordset
objCon.ConnectionString = "MaxBufferSize=2048;FIL=MS Access;DSN=Scan;PageTimeout=5;UID=admin;DBQ=D:\VB.Net\VulnerabilityAssessment.mdb;DriverId=25"
objCon.Open()
strSQL = "Insert Into RemoteHost(HostIP, HostAddress,ScanTime)"
strSQL = strSQL & " Values(strIpAddress,Host.HostName ,Date.Now);"
objCon.Execute(strSQL)
objCon.Close()
objCon = Nothing
|
|
|
|
|
Please don't ask the same question twice.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
i need help in connecting access to vb.net ...
but i m having problem ...
can anyone let me knoe wht is wrong with my code
Public strSQL As String
Public objCon As ADODB.Connection
objCon = New ADODB.Connection
Dim Rs As New ADODB.Recordset
objCon.ConnectionString = "MaxBufferSize=2048;FIL=MS Access;DSN=Scan;PageTimeout=5;UID=admin;DBQ=D:\VB.Net\VulnerabilityAssessment.mdb;DriverId=25"
objCon.Open()
strSQL = "Insert Into RemoteHost(HostIP, HostAddress,ScanTime)"
strSQL = strSQL & " Values(strIpAddress,Host.HostName ,Date.Now);"
objCon.Execute(strSQL)
objCon.Close()
objCon = Nothing
|
|
|
|
|
fareee wrote:
strSQL = strSQL & " Values(strIpAddress,Host.HostName ,Date.Now);"
Try
strSQL = strSQL & " Values( " & strIpAddress & ", " & Host.HostName & " , " & Date.Now & " );"
You're trying to pass constant strings into the table.
This is assuming that your question is poorly worded, and you're not really having trouble connecting to Access. Either way, this is a problem in your code.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
How can I copy or save data from an MSHFlexGrid COntrol of another application? I tried the API functions, but it did not work.
Any idea
Holger
|
|
|
|
|
Ok easy one for y'all, but Im stumped. I have 2 listboxes. First listbox is populated with the 12 months and when double clicked on a month, it needs to move to the other listbox. The second listbox is initially blank.
Any ideas??
Thanks in advance
Jason
|
|
|
|
|
Remove it from the items collection on one, and add it to the other.
VB6 or VB.NET ?
Christian Graus - Microsoft MVP - C++
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
