How to fill my table with the data table

Question

Hi Plz help DataSet1TableAdapters.myL listTableAdapter myAdapter = new DataSet1TableAdapters.myL istTableAdapter (); DataSet1 . liste1DataTable myTable = new DataSet1 . liste1DataTable (); myTable = How do i fill my table? Label1.Text = myTable.Count.ToString(); The count is 0 so i need to fill my table with the data. How?

Elizabeth · Answer

Dim da As SqlDataAdapter da = New SqlDataAdapter(select * from T_CONTMASTER where CONTACTID= + '99' sqlcon) Dim ds As New DataSet da.Fill(ds) label1.text = ds.Tables(0).rows.count