Member Avatar for Parth_3

how fixed this error " Table is a not member of Data set"
pls need help .. vb.net window application

 Public Function inst() As DataTable
        Dim cmd As New SqlClient.SqlCommand
        Dim tbl As New DataTable
        Dim da As New SqlClient.SqlDataAdapter
        Dim ds As New DataSet
        Dim sql_select As String





        Try

            cn.Open()
            sql_select = "SELECT EmMaster_EmploId FROM(EmMaster) WHERE EmMaster_EmploId=(SELECT max(EmMaster_EmploId) FROM EmMaster)"
            da = New SqlDataAdapter(sql_select, cn)
            da.Fill(ds, "EmMasater")
            tbl = ds.Table(0)// this line error "Table is a not member of Data set" "


            cn.Close()
  • 2 Contributors
  • 1 Reply
  • 190 Views
  • 57 Minutes Discussion Span
  • Latest Post Latest Post by Reverend Jim
Member Avatar for Reverend Jim

I don't use data tables but I think it should be ds.Tables not ds.Table. Also you have a typo in da.Fill(ds, "EmMasater").

commented: yes, it's ds.Tables +10
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.