Search data from SQL Server and Display onto textbox and data grid VB.Net

Question

I want to retrieve data from SQL Server and display into Textbox and DataGrid. I want the data from request box to be display into the textbox and the leftjoin table to be diplayed in datagrid.

 con.Open()
    cmd.Connection = con
    cmd.CommandText = "select * from requestbox left join requisitiondata on requisitiondata.requestdata_id = requisitiondata.requestdata_id where request_box = '" & txtsearch.Text & "'"

    cmd.ExecuteNonQuery()

    Dim TABLE As New DataTable

    With da
        .SelectCommand = cmd
        .Fill(TABLE)
    End With


    cbspayment.Text = ("spayment").ToString()
    cbsoption.Text = ("soption").ToString()
    txtto.Text = ("to1").ToString()
    txtsupplier.Text = ("supplier").ToString()
    txtterms.Text = ("terms").ToString()
    txtreference.Text = ("reference").ToString()
    txtfrom.Text = ("from1").ToString()
    txtcharge.Text = ("charge").ToString()

Ronel you don't appear to know SQL, it seems you are setting some SQL variables in the statement and then you expect somehow to get the same value back into the textbox. — Motomotes
– Motomotes, Commented Oct 30, 2020 at 1:46
Why are you calling ExecuteNonQuery when you want to execute a query and are already doing so when you call Fill? — jmcilhinney
– jmcilhinney, Commented Oct 30, 2020 at 2:06
NEVER concatenate strings with user input for sql statements. Always use parameters to avoid sql injection. — Mary
– Mary, Commented Oct 31, 2020 at 4:23

jmcilhinney · Accepted Answer · 2020-10-30 02:05:12Z

0

If you only want some columns of your data to be displayed in your grid then you should add the desired columns to the grid in the designer. You can specify what column in the data source a grid column should bind to by setting its DataPropertyName. You can then bind your data to the grid and other controls as well if desired. As an example:

Add a DataGridView, a BindingSource and a TextBox to your form.
Add a single text box column to the grid and set its DataPropertyName to "Name".
Create a handler for the Load event of the form and add the following code:

Dim table As New DataTable

With table.Columns
    .Add("Name", GetType(String))
    .Add("Description", GetType(String))
End With

With table.Rows
    .Add("One", "First")
    .Add("Two", "Second")
    .Add("Three", "Third")
End With

BindingSource1.DataSource = table
DataGridView1.AutoGenerateColumns = False
DataGridView1.DataSource = BindingSource1
TextBox1.DataBindings.Add("Text", BindingSource1, "Description")

When you run the project, you will see the Name column's data displayed in the grid and, when you select a row, you will see the corresponding value from the Description column displayed in the TextBox. You can apply the same principle no matter how many columns you want displayed in the grid, no matter how many TextBoxes you have and no matter how you populate your DataTable.

answered Oct 30, 2020 at 2:05

jmcilhinney

54.9k5 gold badges30 silver badges52 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Ronel Over a year ago

just want to ask about the rows...what is that mean the "One","First","Two","Second","Three","Third"

jmcilhinney Over a year ago

@Ronel, there's no "meaning". It's just example data. The Rows.Add method adds a new row with the two specified values in the two columns of the DataTable. The actual data could be anything at all. I just chose something simple that would enable you to see the principle in action. Your columns and data will be determined by your database query.

Collectives™ on Stack Overflow

Search data from SQL Server and Display onto textbox and data grid VB.Net

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related