what is the error in this??? Please help

Hi all,

Im trying to insert some values in database. Among that values, am taking one value from another table.

That is selecting the distinct mobilenumber from one table and insert that value along with some other into another table.

But nw the problem is that i cant insert values.Ther wil a lot of mobileno in a table.

 Pls help as i have a little knowledge in asp.net

  Dim multicn As New SqlConnection(constr)
Dim smscn As New SqlConnection(constr)
Dim multicmd As SqlCommand
Dim smscmd As SqlCommand
Dim mb
Dim sdr As SqlDataReader
Try
smscn.Open()
multicn.Open()
multicmd = New SqlCommand("select distinct mobileno from Customer where listname='" & lname & "'", multicn)
sdr = multicmd.ExecuteReader
If sdr.Ha ...