Select where statement

Question

0.00/5 (No votes)

See more:

I am trying to get specific data to show up in gridview. I am trying to use a select where statement, but it is not giving any data back.

'fill funeral home comboboxes, this displays data in your combobox through an sql connection

VB

        Dim funcon As New SqlConnection("sqlconstring")


        Dim sqladapt As New SqlDataAdapter

        funcon.Open()

        Dim command As SqlCommand = New SqlCommand("Select county from [business] where [state] = @state", funcon)
      command.Parameters.AddWithValue("@State", Businesscombobox.SelectedItem)
        sqladapt.SelectCommand = command
        sqladapt.SelectCommand.ExecuteNonQuery()
        command.CommandTimeout = False
        Dim dts As New DataTable
        Dim dss As New DataSet
        sqladapt.Fill(dts)

        DataGridView1.DataSource = dts
funcon.close

Not sure why I cannot get data to appear

What I have tried:

I have tried to change the way the text is selected in the combobox. I even tried to use a state that is in the datatable to see it directly implanting a state into the statement would result in data feedback and still nothing. If I do not use the where statement it brings up all my data, where I am going wrong?

Posted 22-Sep-17 11:58am

Member 11856456

Updated 22-Sep-17 14:26pm

PIEBALDconsult

v2

Add a Solution

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)

Dave Kreskowiak · Answer 1 · 2017-09-22T13:22:00

First, "@State" is not the same as "@state".

Next, Businesscombobox.SelectedItem doesn't return what you think it does. It's going to call .ToString on whatever that selected item is, and that may not return the string you want.

Do yourself a favor and move the Businesscombobox.SelectedItem into its own variable and inspect the content in the debugger.

VB

Dim selected As String = Businesscombobox.SelectedItem
command.Parameters.AddWithValue...

Put a breakpoint on the AddWithValue line and run the code. When the debugger stops on this line, you can hover the mouse over selected to see the content that you're passing to the Parameter object.