|
I am trying to create an order form for my users. The form has a listbox where the user selects multiple names and it populates a textbox for user confirmation. The selection process also creates an array used to create a SQL database record for each name in the list. This part works. Here is the code I have so far:
Sub xxx
reader1 = dr1.ExecuteReader()
While reader1.Read()
values1.Add(reader1.Item("Name"))
values2.Add(reader1.Item("Emplid"))
End While
lbName.DataSource = values1
lbEmplid.DataSource = values2
End Sub
Sub xxx
rtbName.Text = Nothing
rtbEmplid.Text = Nothing
For i = 0 To lbName.SelectedItems.Count - 1
With arrList2
.ToArray()
End With
rtbName.Text = rtbName.Text & lbName.SelectedItems(i) & vbCrLf
Next
i = Nothing
The problem I'm running into is, I need to collect the Emplid along with the name. I'm trying to set it up by selecting only the name with the Emplid selected at the same time. I can combine the two within the SQL statement, but I need to populate each field of the database entry separately.
Any help would be greatly appreciated.
Thank you,
LWhite
|
|
|
|
|
Larry White wrote: values1.Add(reader1.Item("Name")) values2.Add(reader1.Item("Emplid"))
I suspect you want to create a struct which connects these two values and build a collection of those structs.
Larry White wrote: With arrList2 .ToArray() End With
Why would you do this to call one method ?
Larry White wrote: lbName.SelectedItems
Items in a combobox can also have a value stored against them, you can store the Id there.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"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 )
|
|
|
|
|
I am a relative beginner at VB.NET so my methods may be a little off. I am trying to pull the data from 2 fields from 1 table and creating a new record with name and employee id. I thought it would be a relatively simple process to capture an array with the name and ID, then use the array in the SQL insert variables to create each record.
Thank you for responding,
LWhite
|
|
|
|
|
OK, last question of the night.
Is there any way, so when the close button is pressed in the control box, that either:
a) A form is displayed (i have made a confirm exit screen)
or
b) The program is closed totally, including all hidden forms
|
|
|
|
|
Try the form.closing event.
|
|
|
|
|
I mean the close, minimise, maximise box.
I want to try and interact with those actions, is this possible??
If form.close is correct, where would i put this code, isnt this just a command, for example on an event?
|
|
|
|
|
|
This aint working, any ideas:
If intScoreTop < 5 Then My.Computer.Audio.Play(My.Resources.Sounds.sndMainPopupLow, AudioPlayMode.Background)
elseif intScoreTop = 10 Then My.Computer.Audio.Play(My.Resources.Sounds.sndMainPopupHigh, AudioPlayMode.Background) _
Else My.Computer.Audio.Play(My.Resources.Sounds.sndMainPopupMid, AudioPlayMode.Background)
It is saying the elseif must be proceeded by an IF, but it is!!!?
|
|
|
|
|
VB.NET sucks. I think if you but the statement all on one line, you don't need endif, nor can you use elseif
if intscoretop < 5 then
blah
elseif
blah
else
blah
endif
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"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 )
|
|
|
|
|
Sorted cheers, didnt realise they had to go on seperate lines, i was trying to concatenate them!
|
|
|
|
|
When you open a font dialog box in vb.net a change the font, how do you save the changes that was made to the font. Could someone send me some sample code on how to save changes in vb.net?
|
|
|
|
|
Save changes how/where ? Do you mean just keep the details of the font for next time ?
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"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 )
|
|
|
|
|
Yes, just keep the details of the font for next time.
|
|
|
|
|
That used to be the propertybag object in VB6 it didn't get carried over to .Net. I've used a XML file in the past to save and recall the information I needed.
Hope that helps
|
|
|
|
|
In your application properties, go to settings. Here you can add properties that can be change and saved at runtime. Click the first item that says newsetting etc. and type "SaveFont" when prompted.
Then in the type you can select system.drawing.font or something along those lines.
Then in your code:
If fontdialog.showdialog = OK then<br />
my.settings.savefont = 'font you selected<br />
end if
On form load you can then reload the setting:
dim myfont as system.drawing.font<br />
mycontrol.font = new font(myfont.fontfamily,myfont.size,myfont.style)
Note:This will not save the font colour only style, size and font family. If you want to save font colour you will have to add another setting. Also note my code might not be 100% accurate but its pretty close.
Posted by The ANZAC
|
|
|
|
|
Hi there,
I'm brand new to .Net...so forgive me if this question is basic. But i'm trying to load text files into an Oracle Database, and I wanted to use sqlldr to complete this task in VB.Net. I have the control files created, I just need to know what is needed "codewise" to utilize sqlldr. Is there a class that handles this functionality?
thanks in advance,
Darryl
|
|
|
|
|
Why is this bring up a syntax error (the error it states is on the open brackets):
---
If intScoreTop < 5 then (My.Resources.Sounds.sndMainPopupLow, AudioPlayMode.Background)
---
All i am trying to do is if the integer intScoreTop has a value of less than 5 then play a sound file!
|
|
|
|
|
Because you're not calling any method that plays a sound, it looks like the method name is what's missing, and you're just providing the params to the method which you're not specifying.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"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 )
|
|
|
|
|
Ha ha, me being dumb, needed to call the my.computer event.
Cheers
|
|
|
|
|
Hey everyone,
I am working on this project, mostly database driven.
this is what it is about:- The user interface is install on three computer in different location while the database is kept on another computer in a seperate location, which means all three computers has to connected to this sql server to enter and retrive data. That means if the server goes down.. neither of these location will be able to continue there work.
What i am thinking about now, is to install sql server on all three machine so that data is stored at each location and at the end of each day all the data from the three location would be uploaded or Synchronized to the main database.
Problem.. how do i get all three database to Synchronize with the main database? Do i have to hard code this to happen or is there a feature that does this in sql 2000...
your help would be highly appreciated...
thanks.
Nab
|
|
|
|
|
My recommendation is to have a backup server that mirrors the other server on a regular basis. I think you are going to have a real headache with trying to synchronize at the end of the day. I don't know of anyone who does it that way.
_________________________________________
You can't fix stupid, but you can medicate crazy.
|
|
|
|
|
thanks, would you suggest that i write a utility program to do so? one that copies all table to the backup database...and at the same time be able to access the information from server level or standalone at anytime..
Nab
|
|
|
|
|
No. You let SQL Server handle the replication between two servers.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
|
In Visual Basic you can do this job by Now function
|
|
|
|