Visual Basic

dim QuestionCollection as new collection

Sub Initialize_Collection
    QuestionCollection.clear 

    for i as integer = 1 to 10
       dim myBank as new Bank
       myBank.QuestionNo = ""    ' assign the Question-No. here
       myBank.Question = ""      ' assign the Question-Text here
       myBank.OptionA = ""       ' assign the Option-Value A here
       myBank.OptionB = ""       ' assign the Option-Value B here
       myBank.OptionC = ""       ' assign the Option-Value C here
       myBank.CorrectAnswer = "" ' assign the correct Answer-Text here
       myBank.Result = false     ' you should add a boolean as result for the question to 
your class
       QuestionCollection.add (myBank) 
    next  
End Sub

satc wrote:

I want to put all the 3 lines in a single field ( column )

command AS SqlCommand = new SqlCommand("INSERT INTO MyTable (Col1) VALUES (@colvalue)", connection)
command.Parameters.AddWithValue("@colvalue", "abc cde ght" & vbCrLf & _
"1234 5678" & vbCrLf & _
"567")
command.ExecuteNonQuery()

Myobject.Mytext = "abc cde ght" & vbCrLf & "1234 5678" & vbCrLf & "567"