Below is the code i wrote, you'll find where the error is at below "bold & red" the error states... "property access must assign to the property or use its value."

what does that mean????

Dim cn As New SqlConnection
        Dim cmd As New SqlCommand
        Dim dad As New SqlDataAdapter
        Dim dset As New DataSet
        Try
            cn = New SqlConnection("Server=localhost;database=CMS;Integ rated Security=SSPI")
            cmd = New SqlCommand("PRO_VEND_TRANSACTION_DDL")
            If cn.State = ConnectionState.Closed Then
                cn.Open()
            End If
            cmd.Parameters.Clear()
            cmd.CommandText = "PRO_VEND_TRANSACTION_DDL"
            cmd.CommandType = CommandType.StoredProcedure
            dad.SelectCommand = cmd
            dad.Fill(dset, "Accenture")
            ddlvendname.DataSource = dset.Tables("Accenture")
            ddlvendname.DataBind()

        Catch ex As Exception

        End Try

    End Sub

With the SqlCommand, pass your connectionstring cn too like

cmd = New SqlCommand("PRO_VEND_TRANSACTION_DDL",cn)

and then try.

Regards
Mike

Fortune favours the brave, so don't regret on missed oppurtunities.

Hi Mike,

I was included that cn(Connection) also but still i am getting same error. pls help me out.

Regards,
Ananth.B

Thanks a lot Mike. Its working fine.

Regards,
Ananth.B