how to use drop downlist boxes using asp.net?

Question

1.15/5 (3 votes)

See more:

Dear All,

I developed one page here requirement is

Name: textbox1.text
Address: textbox2.text
Mobile: textbox3.text
Joining Date:dropdownlist1 and dropdownlist2

once fill these like name: qqqq, address:ssss, Mobile:1234567890, joiningdate:10(month) 2001(year)

like above output i want how write the logic please reply me

Posted 17-Jun-14 19:43pm

member258

Add a Solution

Comments

Sergey Alexandrovich Kryukov 18-Jun-14 1:49am

What the beast is that, "drop downlist boxes"?! There are "drop-down list boxes". You did not explain anything like a problem. So far, this post makes no sense at all. You can improve it using "Improve question".
—SA

member258 18-Jun-14 2:14am

here once fill name, address, mobile and select dropdownlist(march)dropdownlist(2014)

output is:
name:qqqq
address:rrrr
mobile:1234567890
joining date:march 2014

this output i want

and my code is:
protected void Button1_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["connectionstring"].ConnectionString);
con.Open();
string str = "insert into PlaceTable values('" + TextBox1.Text + "','" + TextBox2.Text + "','" + TextBox3.Text + "','" + DropDownList1.Text + "','" + DropDownList2.Text + "')";
SqlCommand cmd = new SqlCommand(str, con);
cmd.ExecuteNonQuery();
con.Close();
Label1.Text = "data inserted sucessfully";
}

this is my code data base how i create like my columns is:name,address,mobile,joiningdate

these are database table columns

here proper code and table please reply me

KaushalJB 18-Jun-14 1:50am

What logic ?? Your question is not clear about what you actually want..you want dropdownlist text or something else... Please be specific

member258 18-Jun-14 2:10am

here once fill name, address, mobile and select dropdownlist(march)dropdownlist(2014)

output is:
name:qqqq
address:rrrr
mobile:1234567890
joining date:march 2014

this output i want

and my code is:
protected void Button1_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["connectionstring"].ConnectionString);
con.Open();
string str = "insert into PlaceTable values('" + TextBox1.Text + "','" + TextBox2.Text + "','" + TextBox3.Text + "','" + DropDownList1.Text + "','" + DropDownList2.Text + "')";
SqlCommand cmd = new SqlCommand(str, con);
cmd.ExecuteNonQuery();
con.Close();
Label1.Text = "data inserted sucessfully";
}

this is my code data base how i create like my columns is:name,address,mobile,joiningdate

these are database table columns

here proper code and table please reply me

Paulo Augusto Kunzel 18-Jun-14 8:24am

Hi member258,
Please help me clarify:
1) Are name, address, mobile and joiningdate the columns on your database? If yes, are there other columns?
2) Do you have 1 or 2 DropDownLists on your page?
3) Is your problem related to get the value from the DropDownList or to Save it?

regards

member258 18-Jun-14 8:40am

Dear Paulo,

Design:

<head runat="server">
<title></title>
<style type="text/css">
.style1
{
width: 100%;
}
</style>
</head>
<body>
<form id="form1" runat="server">
<div>

</div>
<table class="style1">
<tr>
<td align="right">
Name :</td>
<td>
<asp:TextBox ID="TextBox1" runat="server">
</td>
</tr>
<tr>
<td align="right">
Address :</td>
<td>
<asp:TextBox ID="TextBox2" runat="server">
</td>
</tr>
<tr>
<td align="right">
Mobile :</td>
<td>
<asp:TextBox ID="TextBox3" runat="server">
</td>
</tr>
<tr>
<td align="right">
Joining Date :</td>
<td>
<asp:DropDownList ID="DropDownList1" runat="server">
<asp:ListItem>-Month-
<asp:ListItem>1
<asp:ListItem>2
<asp:ListItem>3
<asp:ListItem>4

<asp:DropDownList ID="DropDownList2" runat="server">
<asp:ListItem>-Year-
<asp:ListItem>2001
<asp:ListItem>2002
<asp:ListItem>2003

</td>
</tr>
<tr>
<td align="right">
</td>
<td>
</td>
</tr>
<tr>
<td align="right">
</td>
<td>
<asp:Button ID="Button1" runat="server" onclick="Button1_Click" Text="Submit" />
</td>
</tr>
<tr>
<td align="right">
</td>
<td>
<asp:Label ID="Label1" runat="server" Text="Label">
</td>
</tr>
<tr>
<td align="right">
</td>
<td>
</td>
</tr>
<tr>
<td align="right">
</td>
<td>
</td>
</tr>
<tr>
<td align="right">
</td>
<td>
</td>
</tr>
</table>
</form>
</body>
</html>

here once fill: name, address, mobile,joiningdate
this data store in database table(datetable)

table column: name varchar(50),address varchar(50), mobile varchar(50), joiningdate varchar(50)

here after fill( name, address, mobile, joiningdate ) store database table(datetable)

table columns correct or not:
1. name varchar(50),address varchar(50), mobile varchar(50), joiningdate varchar(50)
2. name varchar(50),address varchar(50), mobile varchar(50), year varchar(50), month varchar(50)

in the above which is correct 1 or 2 other wise any another way please reply me any examples am waiting for your reply

code:

protected void Button1_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["connectionstring"].ConnectionString);
con.Open();
string str = "insert into PlaceTable values('" + TextBox1.Text + "','" + TextBox2.Text + "','" + TextBox3.Text + "','" + DropDownList1.SelectedItem.Text + "','" + DropDownList2.SelectedItem.Text + "')";
SqlCommand cmd = new Sql

Paulo Augusto Kunzel 18-Jun-14 9:10am

Wow.... you could have answered with 1, 2, 3 like I asked.. Lol, but I think I got it.

Anyway, if you have a column named "joinDate" with data from both DropDownLists, why are you inserting them separately? Is there something not stated in any code you showed so far or would that be the issue?

To answer your question I would say number 1 is correct. Did you try both of them to see what would happen?
You may want to wrap you connection around a try{}catch{}. But that is another story.

member258 19-Jun-14 0:21am

Dear Paulo,
Thanks for your replying and one thing u told 1st one is correct ok but table columns: name varchar(50),address varchar(50), mobile varchar(50), joiningdate varchar(50) here store data means dropdownlists: year and month how store in joiningdate varchar(50) please check and reply me

Paulo Augusto Kunzel 24-Jun-14 7:46am

Hi,

I said that the 1st one is the way to do it because I understood that you have a column on the database called "joiningdate". If I'm wrong, please let me know.

Having said that, in the current condition, you could store them by either getting the property SelectedValue or SelectedItem.Text from your dropdownList.

For more information, have look on MSDN documentation. If you are using visual studio, click on the property and type F1. :)

Let me know if it worked and I'll post it as an answer

member258 18-Jun-14 2:22am

Dear kaushal please reply me any examples

Ramug10 18-Jun-14 2:53am

what is your problem you want to get joining date from two dropdowns? in your code you wrote like 'dropdownlist1.text' instead you can write 'dropdownlist1.selecteditem.text'

member258 18-Jun-14 2:59am

thats fine dropdownlist1.selecteditem.text

In designing page only : name, address, mobile,joiningdate

after fill these like output:name:dddd,address:tttt,mobile:1234567890,joiningdate:july 2014

this output store in database table please reply me table creation of this output please dont mind please reply me and this is possible or not

KaushalJB 18-Jun-14 4:59am

Your question still doesn't make any sense... The readers are totally confused about your questions.. Me too unclear to answer your question...

member258 18-Jun-14 6:10am

Dear kaushal15,

i am sorry and thanks for your reply

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)

NitinDhapte · Answer 1 · 2014-06-19T20:10:00

Solution 1

C#

Name: textbox1.Text
Address: textbox2.Text
Mobile: textbox3.Text
Joining Date: dropdownlist1.SelectedItem.Text + " " +  dropdownlist2.SelectedItem.Text

Posted 19-Jun-14 20:10pm

NitinDhapte