Using sql commands in datatable

Question

Using sql commands in datatable

Don75 81

I would like to know whether it is possible to use select commands in a datatable in vb.net

In sql we could use #tablename to create, add edit temp tables. I am looking to do the same think in VB.Net. Could I use datatable to do that, if not any alternatives?

2 answers

Your answer

Answer 1

Jiachen Li-MSFT 34,221 Microsoft External Staff

Hi @Don75 ,

Have you considered using the DataTable.Select Method?

Dim rows As DataRow() = dataTable.Select("ColumnName1 > 10 AND ColumnName2 < 5")

Dim rows As DataRow() = dataTable.Select("ColumnName LIKE 'ABC%'")

Best Regards.

Jiachen Li

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Don75 81 Reputation points

2023-06-15T01:20:35.6766667+00:00

Thanks for the response. I am hoping to use a bit more complex ones (Ex: grouping and pivot, unpivot). Not sure whether these could be used here.
Jiachen Li-MSFT 34,221 Reputation points Microsoft External Staff

2023-06-16T09:08:28.97+00:00

Hi @Don75 ,

For some complex queries, you may need to use LINQ.

https://stackoverflow.com/questions/167304/is-it-possible-to-pivot-data-using-linq

Mansour_Dalir 2,036

hi @Don75

    Private Function FilterByLike(inText As String, ColumnName As String)
        'Convert 'Word1*Word2' to  [Column Name] Like 'Word1%' And [Column Name] Like '%Word2'
        '*Word1*Word2*   to [Column Name] Like '%Word1%' And [Column Name] Like '%Word2%'
        Dim stt1 As String
        Dim sttOut As String
        Dim sttResault As String = ""
        If InStr(inText, "*") = 0 Then
            stt1 = "'%" & inText & "%'"
            sttOut = "[" & ColumnName & "] Like " & stt1
        Else
            Dim SplSeparator() = Split(inText, "*")

            For idx = 1 To SplSeparator.Length
                sttResault += IIf(SplSeparator(idx - 1) = "", "", IIf(sttResault = "", "", " and ") & "[" & ColumnName & "] Like " & IIf(SplSeparator(idx - 1) = "" Or (idx > 1 And SplSeparator(idx - 1) <> ""), "'%", "'") & SplSeparator(idx - 1) & IIf(SplSeparator(idx - 1) <> "" And idx < SplSeparator.Length, "%'", ""))
            Next
            If sttResault <> "" AndAlso Mid(sttResault, sttResault.Length, 1) <> "'" Then
                sttResault += "'"
            End If
            sttOut = sttResault
        End If
        Return sttOut
    End Function

Answer 2

SurferOnWww 4,631

Can the following Microsoft tutorial help?

Get started with ASP.NET Core MVC

Try to complete up to Part5. You will be able to crate the ASP.NET Core application which can create, add and edit the table of SQL Server database.

Share via

Using sql commands in datatable

2 answers

Your answer