Member Avatar for Saikumar Adep

Is This Possible
Select * from Dataset

  • 2 Contributors
  • 3 Replies
  • 97 Views
  • 11 Hours Discussion Span
  • Latest Post Latest Post by ShahanDev
Member Avatar for ShahanDev

One possibility is that you can query on DataSets' Table using LINQ. I will provide you example if required.

Member Avatar for Saikumar Adep

Please Provide The Example For The Above Query

Member Avatar for ShahanDev

Hi!

Have a look at this code:

I have a DataSet named "Db1DataSet" and a table in it named "Table1", it has one of the column named ID and the query gets the result for ID=1 and show it in the Datagridview.

Dim query = (From c In Db1DataSet.Table1 _
                     Where c.ID = 1)
        DataGridView1.DataSource = query.CopyToDataTable()

I hope it will help you.

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.