Combo box Selected value is not stored properly in Database using c#

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

, +

I am working on windows application, in which I am saving combo box selected value to database. I wrote the code as follows:-

C#

slc.Parameters["@Cust_Name"].Value = cmbCust_Name.SelectedValue.ToString();

cmbCust_Name is the name of combo box. when I am saving the data to the database, System.Data.DataRowView is saved instead of actual data.

Any Help ??

Thanks In Advance !!!

Posted 5-Dec-12 7:52am

Ank_ush

Add a Solution

2 solutions

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)

Surendra0x2 · Answer 1 · 2012-12-05T08:06:00

Solution 1

don't have idea about windows but in web
we do like(Query-insert into emp(state) values(@a))
slc.parameters.add("@a",sqldbtype.varchar,100).value=dropdownlist1.selecteditem.text;

Posted 5-Dec-12 8:06am

Surendra0x2

Comments

Ank_ush 5-Dec-12 14:12pm

you are right, I tried to use cmbCust_Name.SelectedItem.toString() and even cmbCust_Name.SelectedText, but still it is saving System.Data.DataRowView

Surendra0x2 5-Dec-12 14:20pm

refer this Link
may be this can sortout ur problem
http://social.msdn.microsoft.com/Forums/en/wpf/thread/491bd566-82e3-4f01-88a0-681f56358694

Surendra0x2 5-Dec-12 14:23pm

slc.Parameters["@Cust_Name"].Value = cmbCust_Name.SelectedValue.Text;

try this

Ank_ush 5-Dec-12 14:32pm

Not working. I tried this slc.Parameters["@Cust_Name"].Value = cmbCust_Name.Text;
value was properly saved. if you use cmbCust_Name.SelectedValue, then the code should be cmbCust_Name.SelectedValue.TOStrting();

Surendra0x2 5-Dec-12 14:39pm

yes because value is integer so we need typecasting

Surendra0x2 5-Dec-12 14:46pm

Post your full code so that otherone can understand your problem and can give answer.

ridoy · Answer 2 · 2012-12-05T08:13:00

Solution 2

http://social.msdn.microsoft.com/Forums/is/sqlgetstarted/thread/9881f691-daa5-48b1-8e17-af52148c8d2f[^]
how to insert data from combo box to sql database in connected mode?[^]

Posted 5-Dec-12 8:13am

ridoy