Search for a text in datatable and display the search rows in page in a dynamic table

Question

0.00/5 (No votes)

See more:

Hi,

I have a mysql table which i have imported into a datatable as below

mysqlconn.Open()
strquerry = "select * from site_details order by monitorname;"
sqlcmd = New MySqlCommand(strquerry, mysqlconn)
dadapter = New MySqlDataAdapter(sqlcmd)
dadapter.Fill(dt)

The above code is working fine.
Now I have a textbox in which when user enters a string and clicks on search, it should look into the above datatable and search it in all columns. It should collect the rows and then display the data on a dynamically created table.

i have already tried using

datatable.select()

function but to no use.

Any advice is greatly appreciated. Thanks

Posted 2-Dec-13 4:12am

Davesh Borasi

Add a Solution

Comments

Peter Leow 2-Dec-13 10:50am

Your code is too sketchy. What do you want users to enter in the search textbox? monitorname?

Davesh Borasi 3-Dec-13 4:24am

Any details present in the table. If available it should display the data other wise display messege that data is not available

Glagace_7763 2-Jan-14 16:53pm

Here is a good start you would have to add checks for nulls and integers etc.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Glagace_7763 · Answer 1 · 2014-01-02T10:51:00

Public Class Form1

    Dim returntable As DataTable = New DataTable("returnTable")

    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        Dim sSearchtext As String = "HP"

        Dim table As DataTable = New DataTable("table")

        Dim colItem As DataColumn = New DataColumn("col1", Type.GetType("System.String"))
        table.Columns.Add(colItem)
        Dim colItem1 As DataColumn = New DataColumn("col2", Type.GetType("System.String"))
        table.Columns.Add(colItem1)


        Dim NewRow As DataRow
        NewRow = table.NewRow()
        NewRow("col1") = "HP"
        NewRow("col2") = "Dell"
        table.Rows.Add(NewRow)

        Dim NewRow2 As DataRow
        NewRow2 = table.NewRow()
        NewRow2("col1") = "ViewSonic"
        NewRow2("col2") = "Generic"
        table.Rows.Add(NewRow2)

        table.AcceptChanges()

        'clone the table schema
        returntable = table.Clone

        For Each row As DataRow In table.Rows
            For Each col As DataColumn In table.Columns
                'compare each column value
                If String.Compare(row(col).ToString(), sSearchtext, True) = 0 Then
                    'if match then load value
                    LoadData(row)
                    'exit now no need to continue to search the rest of the columns
                    Exit For
                End If
            Next

        Next

        MsgBox(returntable.Rows.Count.ToString)

    End Sub

    Private Sub LoadData(ByRef rRow As DataRow)

        Try
            '
            returntable.ImportRow(rRow)

        Catch ex As Exception
            MsgBox(ex.Message)
        End Try
    End Sub
End Class