forum

Home / DeveloperSection / Forums / how to select specific columns from a data table in vb.net?

how to select specific columns from a data table in vb.net?

Anonymous User 2615 05-Dec-2014

I have a data table from which i am filtering data based on condition,but how to display specific columns only from the data table? 

Dim Dt As New DataTable
                Dim SQlDa As SqlDataAdapter = New SqlDataAdapter(SqlCmd)
                SQlDa.Fill(TrackingDt)
                Dim Rows() As DataRow = Dt.Select("State = " + "'" + State + "'")
                Dim TempDt As New DataTable
                If Rows.Length > -1 Then
                    TempDt = Rows.CopyToDataTable()
                End If
                Return TempDt


Updated on 06-Dec-2014
I am a content writter !

Can you answer this question?


Answer

2 Answers

Liked By