I wanted to save dropdown option into sql server table 2008

Question

0.00/5 (No votes)

See more:

I was created a html dropdown list for job recruitment

XML

<option value="select">-------------------------------Select----------------------------------</option>
<option value="1" id="koi">Accounts / Finance / Tax / CS / Audit</option>
<option value="46">Agent</option>
<option value="81">Analytics &amp; Business Intelligence</option>

am select agent option in dropdown list and submited the entire details to sql server 2008 using sqlparameter method..after submit i was checked my datbase i can see that the agent option value"46" saved in the database.. Only I wanted to save option into the database dont wanted to save option value.

Posted 19-Jan-14 19:24pm

RajeeshMenoth

Add a Solution

Comments

Gitanjali Singh 20-Jan-14 1:26am

Please share your code for saving data to database.

[no name] 20-Jan-14 4:20am

protected void act(object sender, EventArgs e)
{

try
{

Connection = ConfigurationManager.AppSettings["mycon"];
SqlParameter[] reg_para = new SqlParameter[3];
string sss = Drd_job_category.Items[Drd_job_category.SelectedIndex].Text.ToString();
reg_para[0] = new SqlParameter("@intmode", 1);
reg_para[1] = new SqlParameter("@fullname", txt_Fullname.Value.Trim());
reg_para[2] = new SqlParameter("@email", Txt_Email.Value.Trim());
int i = SqlHelper.ExecuteNonQuery(Connection, CommandType.StoredProcedure, "[jobconsultency]", reg_para);

if (i>0)
{

completed.Text = "Succsusfully Registered";

cleartext();

}
else
{

completed.Text = "sorry...Try Again";
}
}
catch (Exception ex)
{

completed.Text = "Sorry..... Server error. refresh your page !";
}
}

Christian Graus 20-Jan-14 4:23am

It would be better if you edited your post so this would be more readable, but you'll notice, both the other answers you got were correct, but we couldn't give you the exact text because we did not have the code.

[no name] 20-Jan-14 4:15am

I can't get you? what u need ? sql inserting code

3 solutions

Solution 1

try

C#

string text =  DropDownList1.Text;
                       //(Or)
          string value = DropDownList1.SelectedItem.Text;

Posted 19-Jan-14 19:27pm

Karthik_Mahalingam

Solution 2

What Karthik is saying is that you've stored the value, because you stored the value. The Text property is what you need, not the value property. You should show the code that has the issue, in future, the code you posted is working, unless you want to show 46 in your list and store the string, this is not what has to change. you should also learn to use your debugger so you can see what your code is doing and fix it from there. Of course, Karthik did not give you a copy and paste solution, again because you did not give us the actual code that has the issue, only some code that's somewhat related, but really irrelevant to your issue.

Posted 19-Jan-14 21:14pm

Christian Graus

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)

RajeeshMenoth · Accepted Answer · 2014-01-19T22:02:00

Solution 3

string sss = Drd_job_category.Items[Drd_job_category.SelectedIndex].Text.ToString();

Posted 19-Jan-14 22:02pm

RajeeshMenoth

Comments

Christian Graus 20-Jan-14 4:23am

Why call ToString, when you're already accessing the Text property ?