show record in text box as per selection of combo box.

Question

0.00/5 (No votes)

See more:

I want to display value in text box as per selection of combo box.For that I am using following code.(using direct value Part No=51)

VB

Dim disp As String = " Select Item_desc From Item_Master where Part_no=51"
obj.SetCon()
cmd.CommandText = disp
cmd.Connection = obj.SetCon
rd = cmd.ExecuteReader

If rd.Read = True Then
    txtItemDesc.Text = rd("Item_desc")
End If
con.Close()

using above code I am getting value from database.
but I want dynamically for that I am using following query:

VB

Dim disp As String = (" Select Item_desc From Item_Master where Part_no='" & cmbPartNo.Text & "'")

for this query system give me error: Operator '&' is not defined for string " Select Item_desc From Item_Mast" and type 'DataRowView'.

Thanks in advance

Posted 9-Jan-13 2:36am

Yogi ,Pune

Updated 9-Jan-13 3:29am

v3

Add a Solution

Comments

thomasriley 9-Jan-13 8:41am

Is your Part_no an INT in your database?

Yogi ,Pune 9-Jan-13 9:31am

No . Part_No is varchar

Orcun Iyigun 9-Jan-13 8:47am

IN which code block you are doing this process? I think you need to do it in combobox's selectedindexchanged event

Yogi ,Pune 9-Jan-13 9:30am

Yes I did it in Com box selectedindexchanged event

4 solutions

Solution 1

If Part_no is an INT in the database then use the following query:

SQL

SELECT Item_desc 
FROM Item_master 
WHERE Part_no = '" + CInt(cmbPartNo.SelectedText) + "'

Posted 9-Jan-13 2:44am

thomasriley

Solution 3

Use this instead:

SQL

SELECT Item_desc 
FROM Item_master 
WHERE Part_no = '" + cmbPartNo.SelectedItem.ToString + "'

This should work for you!

Posted 9-Jan-13 4:24am

thomasriley

Updated 9-Jan-13 4:25am

v2

Solution 2

My Part_no is varchar so as per your suggestion i update my query:

Dim disp As String = ("Select Item_desc FROM Item_master WHERE Part_no = '" + cmbPartNo.SelectedText + "'")

Now system not showing any error but problem is :
when i debug the string + cmbPartNo.SelectedText + through this statement system not taking any value. so not showing expected result.

Posted 9-Jan-13 3:47am

Yogi ,Pune

Comments

thomasriley 9-Jan-13 10:10am

On which event does the query run? When you click a button or on Form_Load?

thomasriley 9-Jan-13 10:14am

Your query now seems right as the SelectedText option will output as a string. What do you mean by:
"debugging the string + cmbPartNo.SelectedText + through this statement"?

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)

sarathsprakash · Accepted Answer · 2013-01-09T05:56:00

Solution 4

hi,
instead of cmbPartNo.SelectedText give cmbPartNo.Text

Posted 9-Jan-13 5:56am

sarathsprakash

Comments

Yogi ,Pune 10-Jan-13 9:39am

Thanks for suggestion.

Now I want to show Item Type also with Item description.
As per selection of cmbPartNo combo box Item Type & Item Description should be display in respective text boxes.