[wanabavbcoder]

Dim connetionString As String
        Dim connection As SqlConnection
        connetionString = "workstation id=RIKESH;packet size=4096;user id=sa;data source=RIKESH;persist security info=False;initial catalog=Merrymeetings"
        connection = New SqlConnection(connetionString)
        Dim sqlComm As New SqlCommand
        Dim reader As SqlDataReader
        sqlComm.Connection = connection
        connection.Open()
        sqlComm.CommandType = CommandType.StoredProcedure
        sqlComm.CommandText = "valid"
        sqlComm.Parameters.Add("@Venue_Name", SqlDbType.Char, 30).Value = ComboBox2.Text
        sqlComm.Parameters("@Venue_Name").Direction = ParameterDirection.Input

Can the variable "@Venue_Name" be passed to a label in another form in the same project???
If so, How do does one do that?

[wanabavbcoder]

Is this even possible? Or maybe i am asking for a miracle.

[wanabavbcoder]

 Try

            reader = sqlComm.ExecuteReader()
            If reader.Read Then
                MessageBox.Show(reader.Item(0) & " is booked  from:" & reader.Item(1) & " Till-" & reader.Item(2), "WHOOPS!!!", MessageBoxButtons.OK, MessageBoxIcon.Information)
               ERROR IS HERE---> reader.Item(0) = cal.Label5.ToString
            ElseIf MessageBox.Show("Venue is available", "HOORAY!!!", MessageBoxButtons.OK, MessageBoxIcon.Information) Then
                Button1.Show()
            End If
        Catch sqlex As SqlException
            MessageBox.Show(sqlex.Message)
        End Try

So what do I do to fix this error?
Can Someone assist me?

The error reads : Property'item' is 'ReadOnly'

[manos364]

In order to pass parameters between forms you need to declare a string to the form you want to pass the parameter.

Public Shared passParameter As String

And then to pass the parameter to the form you need this code to the form that is going to send the parameter.

targetForm.passParameter = "parameter to pass"

[Atli]

Duplicate threads merged. Do not double post your questions!

[AdamSpeight2008]

manos364, on 09 October 2012 - 11:42 AM, said:

In order to pass parameters between forms you need to declare a string to the form you want to pass the parameter.

Public Shared passParameter As String

And then to pass the parameter to the form you need this code to the form that is going to send the parameter.

targetForm.passParameter = "parameter to pass"

Not a good idea / approach. Shared means its available to all instances.
Pass the parameters in via constructor, properties or even better an events.