When search and filter richtextbox1 not showing datagridview value

Question

0.00/5 (No votes)

See more:

Hi,

I have Textbox4 as a code search and filtering and it was successfully filtering in datagridview1 but in same form i have Richtextbox1 to show Datagridview1 value to showing this large text in Richtextbox1 but when search and filtering this data in textbox4 filtering happened and successfully showing in datagridview1 but Richtextbox1 not showing this value...

What I have tried:

Private Sub TextBox4_TextChanged(sender As Object, e As EventArgs) Handles TextBox4.TextChanged
        con.Open()
        Dim dt As New DataTable
        Dim ds As New DataSet
        ds.Tables.Add(dt)
        Dim da As New OleDbDataAdapter
        da = New OleDbDataAdapter("Select *from SONGS where CODE like '%" & TextBox4.Text & "%'", con)
        da.Fill(dt)


        DataGridView1.DataSource = dt.DefaultView

        con.Close()
    End Sub

Posted 11-Nov-19 4:52am

Member 14621280

Add a Solution

Comments

ZurdoDev 11-Nov-19 14:18pm

What are you asking us to do?

Richard Deeming 12-Nov-19 10:03am

da = New OleDbDataAdapter("Select *from SONGS where CODE like '%" & TextBox4.Text & "%'", con)

Don't do it like that!

Your code is vulnerable to SQL Injection[^]. NEVER use string concatenation to build a SQL query. ALWAYS use a parameterized query.

Everything you wanted to know about SQL injection (but were afraid to ask) | Troy Hunt[^]
How can I explain SQL injection without technical jargon? | Information Security Stack Exchange[^]
Query Parameterization Cheat Sheet | OWASP[^]

da = New OleDbDataAdapter("Select * from SONGS where CODE like ?", con)
da.SelectCommand.Parameters.AddWithValue("Code", "%" & TextBox4.Text & "%")

Member 14621280 15-Nov-19 5:50am

Thanks for the valuable code.... my question is

1. Code searching and filtering it was successfully happened in Datagridview1
2. In same form i have Richtextbox1 which is contain long text will show here
3. when i normally click the datagridview1 row content it was successfully showing in richtextbox1 but when i search through code it won't show in richtextbox1 but filtering happened in datagridview1.

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)