Click here to Skip to main content
16,005,080 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: Help with saving Printdocument data to a file Pin
Dave Kreskowiak10-Feb-07 5:11
mveDave Kreskowiak10-Feb-07 5:11 
QuestionIterate through Array Pin
Larry White9-Feb-07 7:27
Larry White9-Feb-07 7:27 
AnswerRe: Iterate through Array Pin
Dave Kreskowiak9-Feb-07 7:38
mveDave Kreskowiak9-Feb-07 7:38 
GeneralRe: Iterate through Array Pin
Larry White9-Feb-07 8:01
Larry White9-Feb-07 8:01 
AnswerRe: Iterate through Array Pin
Guffa9-Feb-07 7:39
Guffa9-Feb-07 7:39 
GeneralRe: Iterate through Array Pin
Larry White9-Feb-07 8:35
Larry White9-Feb-07 8:35 
AnswerRe: Iterate through Array Pin
Guffa10-Feb-07 3:57
Guffa10-Feb-07 3:57 
GeneralRe: Iterate through Array Pin
Larry White12-Feb-07 4:33
Larry White12-Feb-07 4:33 
Here are the other relevant parts of my code. I build the textbox entries with the following, which also drops the selected names into the array:

Private Sub lbName_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles lbName.SelectedIndexChanged
        editName.Text = Nothing
For i = 0 To lbName.SelectedItems.Count - 1
            arrList2.Add(strName)
            With arrList2
                .ToArray()
            End With
            editName.Text = editName.Text & lbName.SelectedItems(i) & vbCrLf
            strName = lbName.SelectedItems(i) & vbCrLf
Next
End Sub

Here is my complete code that is supposed to create a new database record with each iteration of the name array:
For i = 0 To arrList2.Count - 1
       strName = arrList2.Item(i)
       x = arrList2.Item(i)

Dim strCommandText As String = "INSERT INTO Orders(OrderDate, DeliverDate, DeliverLocation, Name, Special, Comments, Rate, EMPLID, LoggedIP)" _
& "VALUES('" & strOrderDate & "','" & strDeliverDate & "','" & strDeliverLocation & "','" & strName & "','" & strSpecial & "','" & strComments & "','" & strRate & "','" & strEMPLID & "','" & strLoggedHost & "')"

Dim cmd As New SqlClient.SqlCommand(strCommandText, SqlConnection1)
cmd.ExecuteNonQuery()
Next


Thank you for your assistance.Smile | :)




LWhite

AnswerRe: Iterate through Array Pin
Guffa12-Feb-07 4:57
Guffa12-Feb-07 4:57 
GeneralRe: Iterate through Array Pin
Larry White12-Feb-07 5:21
Larry White12-Feb-07 5:21 
AnswerRe: Iterate through Array Pin
Guffa13-Feb-07 11:34
Guffa13-Feb-07 11:34 
GeneralRe: Iterate through Array Pin
Larry White15-Feb-07 4:29
Larry White15-Feb-07 4:29 
QuestionXML Serialisation Pin
Sebastian T Xavier9-Feb-07 6:45
Sebastian T Xavier9-Feb-07 6:45 
AnswerRe: XML Serialisation Pin
TwoFaced9-Feb-07 17:26
TwoFaced9-Feb-07 17:26 
GeneralRe: XML Serialisation Pin
Sebastian T Xavier11-Feb-07 23:26
Sebastian T Xavier11-Feb-07 23:26 
Questionopen sound file button Pin
comicsuperfan19-Feb-07 5:26
comicsuperfan19-Feb-07 5:26 
QuestionReconnaître un répertoire en lecture seul Pin
prady929-Feb-07 4:23
prady929-Feb-07 4:23 
AnswerRe: Reconnaître un répertoire en lecture seul Pin
Dave Kreskowiak9-Feb-07 5:24
mveDave Kreskowiak9-Feb-07 5:24 
AnswerRe: Reconnaître un répertoire en lecture seul Pin
Garth J Lancaster9-Feb-07 13:29
professionalGarth J Lancaster9-Feb-07 13:29 
QuestionData Report of vb 6 Not refresh help required Pin
amjad ali shah9-Feb-07 3:06
amjad ali shah9-Feb-07 3:06 
Questionclass library Pin
dalbhide bipin9-Feb-07 1:35
dalbhide bipin9-Feb-07 1:35 
AnswerRe: class library Pin
Bassam Saoud9-Feb-07 2:42
Bassam Saoud9-Feb-07 2:42 
QuestionHow to get combobox value in a textbox Pin
rrrriiizz9-Feb-07 0:31
rrrriiizz9-Feb-07 0:31 
AnswerRe: How to get combobox value in a textbox Pin
amjad ali shah9-Feb-07 1:05
amjad ali shah9-Feb-07 1:05 
GeneralRe: How to get combobox value in a textbox Pin
rrrriiizz9-Feb-07 17:32
rrrriiizz9-Feb-07 17:32 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.