Friday, February 24, 2012

I need help with this sql string....({0}, {1},{2}, {3});", Chr(64 + j)

I was looking around on the internet and need something like this:
Dim NumberOfRows As Integer = 10
Dim NumberOfColumns As Integer = 4
Dim PlaneID As String = "3434278231"
Dim SeatType As String
Dim i As Integer
Dim j As Integer

For i = 1 To NumberOfRows
For j = 1 To NumberOfColumns
If j = 2 Or j = 4 Then
'Assuming B & D are Window Seats (j=1 For A, 2 for B and so on)
SeatType = "Window"
Else
SeatType = "Aisle"
End If
Qry = String.Format("INSERT INTO TBL_SEAT (SEAT_NUM, SEAT_ROW, SEAT_TYPE, PLANE_ID) VALUES ('{0}', {1},'{2}', '{3}');", Chr(64 + j), i, SeatType, PlaneID)
MsgBox(Qry)
Next j
Next i

i figured out most of it but need help figureing out how it inserts the seat number and row?

what does all this do: ('{0}', {1},'{2}', '{3}');", Chr(64 + j)

thanks for any advice.Assigns:

SEAT_NUM Chr(64 + j) to '{0}',
SEAT_ROW i to {1},
SEAT_TYPE SeatType to '{2}' and
PLANE_ID PlaneID to '{3}'.

:rolleyes:

No comments:

Post a Comment