How can I search using parameters

Hollowman 41 Reputation points
2021-08-23T10:20:38.75+00:00

Hi Parameters I want to search using but I have no idea how to do it, can you help me?

    Try


            Dim DB_Path As String = "Data Source=" & source & "\\Data" + "\" + "Data.db;"
            Dim conn As New SQLiteConnection(DB_Path)
            conn.Open()
            Dim SQL As String = "SELECT * from krp;"
            Dim da As New SQLiteDataAdapter(SQL, conn)
            Dim ds As New DataSet
            da.Fill(ds, "krp")
            conn.Close()
            FlowLayoutPanel1.Controls.Clear()
            For i As Integer = 0 To ds.Tables(0).Rows.Count - 1
                Dim Useram As New UserControl1
                Useram.no.Text = ds.Tables(0).Rows(i).Item(0).ToString()
                Useram.GunaLinkLabel1.Text = ds.Tables(0).Rows(i).Item(1).ToString()
                Useram.GunaLineTextBox1.Text = ds.Tables(0).Rows(i).Item(2).ToString()
                Useram.GunaLineTextBox2.Text = ds.Tables(0).Rows(i).Item(3).ToString()
                FlowLayoutPanel1.Controls.Add(Useram)
            Next
            Label1.Text = ds.Tables(0).Rows.Count

        Catch ex As Exception
            MsgBox(ex.Message)
        End Try
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,927 questions
VB
VB
An object-oriented programming language developed by Microsoft that is implemented on the .NET Framework. Previously known as Visual Basic .NET.
2,611 questions
{count} votes