Display Records in Data Grid view against selection of combo box vale.

Question

0.00/5 (No votes)

See more:

I am trying to Fetch record from Sql & display it in Data Grid View against the selection of Combo Box value.I am using Vb.net & Sql Server '05.

I am using Following code:

VB

Public Function GetView(ByVal strQuery As String) As DataSet
        Dim ds As New DataSet
        Dim da As New SqlDataAdapter(strQuery, SetCon())
        da.Fill(ds, "New")
        Return ds
    End Function

Dim dsvalue As DataSet
        dsvalue = obj.GetView("Select p.PO_no,p.Date,s.Name from PO_Header p, SupplierMaster s Where p.Sup_no = " & cmbSupplierName.SelectedValue & ";" )
    DataGridView1.DataSource = dsvalue.Tables(0).DefaultView

System show me Error :Operator '&' is not defined for string "Select p.PO_no,p.Date,s.Sup_name" and type 'DataRowView'.

Posted 5-Sep-12 4:07am

Yogi ,Pune

Updated 8-Sep-12 1:21am

Sangramsingh Pawar

v6

Add a Solution

Comments

maddy_7869324 15-Feb-13 8:30am

Thnax a lot Your this question and solutions from all helped me a lot

7 solutions

Solution 8

Dim connectionstring As String = "Driver=MySQL ODBC 3.51 Driver;Server=localhost;port=3306;uid=root;pwd=admin;Database=dbname;"
Dim conn As New OdbcConnection(connectionstring)
conn.Open()
Dim da As New OdbcDataAdapter("select * from Userpass where Username like '%" & ComboBox1.Text & "%'", conn)
Dim ds As New DataSet
da.Fill(ds)
DataGridView1.DataSource = ds.Tables(0)
conn.Close()

Posted 22-Jan-13 20:38pm

saito najumi

Solution 1

GetView appears to be a custom method. Try debugging the method to find out what exactly is expected by that method.

Posted 5-Sep-12 4:12am

Abhinav S

Solution 2

I tried out.
As per your suggestion I debug the code still not able to understand why system shows that error.

Please help me.

Posted 7-Sep-12 20:41pm

Yogi ,Pune

Solution 4

Thank You for solution.

But I am facing problem in query .
System shows me message :Operator '&' is not defined for string "Select p.PO_no,p.Date,s.Sup_name" and type 'DataRowView'.

One more question: How to change data type of combobox.selected value in database.

Please Help

Posted 13-Sep-12 5:12am

Yogi ,Pune

Solution 5

That error may be due to the SelectedValue data type is not defined.

so what type should the selectedvalue be in the script?

if it is a int then you won't have to add the ' ' before and after the value.

You have look at that string as if it where in sql and make that string being sent look the same to allow it to work.

Hope that helps.

Posted 16-Jan-13 3:23am

M.Edmison

Updated 16-Jan-13 3:35am

v2

Solution 7

i think you have to write like this

dsvalue = obj.GetView("Select p.PO_no,p.Date,s.Name from PO_Header p, SupplierMaster s Where p.Sup_no = '" & cmbSupplierName.SelectedValue & "'" )

hope that helps

Posted 17-Jan-13 16:54pm

nananghermawan

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)

Raghubir_Sarkar · Accepted Answer · 2012-09-08T01:20:00

If your combobox is data bounded than try to run this code through another control event. I mean Insert a button into Form and run your code in click event of that button.Best way to do that-
1.Convert your combobox.selectedvalue into the data type of column data type in database. ( I assume it is integer type)

2.into the click event of button-

SQL

Dim supNo as integer=CInt(cmbSupplierName.SelectedValue)
Dim dsvalue As DataSet
        dsvalue = obj.GetView("Select p.PO_no,p.Date,s.Name from PO_Header p, SupplierMaster s Where p.Sup_no = " & supNo & ";" )
    DataGridView1.DataSource = dsvalue.Tables(0).DefaultView

Display Records in Data Grid view against selection of combo box vale.

7 solutions

Solution 8

Solution 1

Solution 2

Solution 3

Solution 4

Solution 5

Solution 7

Add your solution here

Preview 0

Existing Members

...or Join us