VB.NET Late-binding problem

[chathura86]

Hi
i have bounded a dataset to a listbox and i want to get the selected values when i clicked add and write them to a text box. here is the code i'v used

Imports System.Data.SqlClient
 
Public Class frmContactList
    Private conContacts As SqlConnection
    Private cmdContacts As SqlCommand
    Private dtaContacts As SqlDataAdapter
    Private dtsContacts As DataSet
 
    Private Sub frmContactList_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Me.Load
        txtNumberList.Text = frmSendSMS.txtTo.Text
 
        conContacts = New SqlConnection("Data Source=localhost;Initial Catalog=ABC;Integrated Security=True")
        cmdContacts = New SqlCommand("SELECT ('<' + PHONE_MOBILE + '> ' + TITLE + '. ' + F_NAME + ' ' + L_NAME) AS NAME, PHONE_MOBILE AS MOBILE FROM CONTACTS", conContacts)
        dtaContacts = New SqlDataAdapter
        dtsContacts = New DataSet
 
        dtaContacts.SelectCommand = cmdContacts
 
        Try
            conContacts.Open()
            dtaContacts.Fill(dtsContacts, "CONTACTS")
        Catch ex As Exception
            MessageBox.Show(ex.Message.ToString)
        Finally
            conContacts.Close()
        End Try
 
        lstContacts.DataSource = dtsContacts.Tables("CONTACTS")
        lstContacts.DisplayMember = "NAME"
        lstContacts.ValueMember = "MOBILE"
    End Sub
 
    Private Sub btnSelect_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSelect.Click
        frmSendSMS.txtTo.Text = txtNumberList.Text
        Me.Close()
    End Sub
 
    Private Sub btnAdd_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnAdd.Click, lstContacts.DoubleClick
        For i As Integer = 0 To lstContacts.Items.Count - 1
            If lstContacts.Items(i).Selected Then          'Error comes here
                txtNumberList.Text += lstContacts.Items(i).Text & ";"
            End If
        Next
    End Sub
 
    Private Sub btnClear_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnClear.Click
        txtNumberList.Text = ""
    End Sub
End Class
 

when i run the program it loads the values in to the listbox.but when i select a item and press the add button it gives an error (something about late-binding)

Error:
Missing Member Exception was unhandled
Public member 'Selected' on type 'DataRowView' not found.


please tell me how to fix this or is their a better way to do this?

chathura

[Shashi Sadasivan]

could you please point to the line at which the error is thrown,
and be specific rather than "some kind of error" .. dosent help us anyways, and neither will it to you

[chathura86]

could you please point to the line at which the error is thrown,
and be specific rather than "some kind of error" .. dosent help us anyways, and neither will it to you

Error is in the line 40 it is indicated with a comment also.
and the error message i'v got is mentioned under "Error:"

Thank you.

[Shashi Sadasivan]

you mean to say that there is no other description of the error!!!!

could you please let us know what kind of datatype is "lstContacts"

It is not declared in the code sniuppet provided by you (Sorry if i missed the fine print amongst the haystack there)

[chathura86]

you mean to say that there is no other description of the error!!!!

could you please let us know what kind of datatype is "lstContacts"

It is not declared in the code sniuppet provided by you (Sorry if i missed the fine print amongst the haystack there)

it's ok i should have mentioned line nuber cz it is bit hard to see.

Visual Studio 2005 givs the following tip:
***********************************************
if a member in a class library has been moved, recompile any assemblies that reference that library.
if you are atempting to access members on a late-bounded object variable, make sure it is declared public.
***********************************************

lstContact is ListBox which i draged and droped into the form. must say that im not very good with vb

is there a way to early bind this listbox. but may have to change the sql query on runtime to get different items to the listbox accoring to a query which can be typed on a textbox