how to save dropdown list values in database?

Question

1.00/5 (1 vote)

See more:

, +

Hi All,
I have 3 dropdownlists are there in my task.Every dropdownlist have multiple values.Those are like state,city,mandal .Every control have multiple values.i want to save those values in database at a time.

Thanks&Regards
Hari

Posted 19-Nov-12 23:52pm

Hari Krishna Prasad Inakoti

Add a Solution

Comments

faisal23 20-Nov-12 6:17am

Please specify your question properly. On which event you have to save values and which values , etc.

Hari Krishna Prasad Inakoti 21-Nov-12 1:39am

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Untitled Page</title>
<script language="javascript" type="text/javascript">
function state()
{
var select=new Array("-Select-");
var jammu=new Array("-Select-","Srinagar","Kathua","Doda","Kishtwar","Poonch","Rajouri");
var punjab=new Array("-Select-","Ludhiana","Amritsar","Bathinda","Firozpur");
var andhrapradesh=new Array("-Select-","Adilabad","Anantapur","Chittoor","YSR Cuddaph","East Godavari",
"Guntur","Hyderabad","Karimnagar","Khammam","Krishna","Kurnool","Mahbubnagar","Medak","Nalgonda",
"Shri Potti Sriramulu Nellore","Nizamabad ","Prakasam","Rangareddi","Srikakulam","Visakhapatnam","Vizianagaram","Warangal ","West Godavari");
var tamilnadu=new Array("-Select-","Chennai","Coimbatore","Cuddalore","Dharmapuri","Dindigul","Erode","Kancheepuram","Kanyakumari","Karur","Krishnagiri","Madurai","Nagapattinam","Namakkal","Nilgiris","Perambalur","Pudukkottai","Ramanathapuram ","Salem","Sivaganga","Thanjavur","Theni","Thiruvallur","Thiruvarur","Thoothukudi","Tiruchirappalli","Tirunelveli","Tiruvannamalai","Vellore","Villupuram","Virudhunagar");
var karnataka=new Array("-Select-","Bangalore","Mangalore","Mysore","Darwad");
var i,j;
var selectedBoxValue=document.getElementById('<%=ddlstate.ClientID%>').value;
var stateLength=eval(selectedBoxValue).length;
var selectcityvalue=document.getElementById('<%=ddlcity.ClientID%>').value;
var citylength=eval(document.getElementById('<%=ddlcity.ClientID%>')).length;
document.getElementById("ddlcity").options.length = 0;
for(i=0;i

[no name] 20-Nov-12 6:30am

What have you tried so far ?? Show us your code...

Hari Krishna Prasad Inakoti 21-Nov-12 1:38am

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Untitled Page</title>
<script language="javascript" type="text/javascript">
function state()
{
var select=new Array("-Select-");
var jammu=new Array("-Select-","Srinagar","Kathua","Doda","Kishtwar","Poonch","Rajouri");
var punjab=new Array("-Select-","Ludhiana","Amritsar","Bathinda","Firozpur");
var andhrapradesh=new Array("-Select-","Adilabad","Anantapur","Chittoor","YSR Cuddaph","East Godavari",
"Guntur","Hyderabad","Karimnagar","Khammam","Krishna","Kurnool","Mahbubnagar","Medak","Nalgonda",
"Shri Potti Sriramulu Nellore","Nizamabad ","Prakasam","Rangareddi","Srikakulam","Visakhapatnam","Vizianagaram","Warangal ","West Godavari");
var tamilnadu=new Array("-Select-","Chennai","Coimbatore","Cuddalore","Dharmapuri","Dindigul","Erode","Kancheepuram","Kanyakumari","Karur","Krishnagiri","Madurai","Nagapattinam","Namakkal","Nilgiris","Perambalur","Pudukkottai","Ramanathapuram ","Salem","Sivaganga","Thanjavur","Theni","Thiruvallur","Thiruvarur","Thoothukudi","Tiruchirappalli","Tirunelveli","Tiruvannamalai","Vellore","Villupuram","Virudhunagar");
var karnataka=new Array("-Select-","Bangalore","Mangalore","Mysore","Darwad");
var i,j;
var selectedBoxValue=document.getElementById('<%=ddlstate.ClientID%>').value;
var stateLength=eval(selectedBoxValue).length;
var selectcityvalue=document.getElementById('<%=ddlcity.ClientID%>').value;
var citylength=eval(document.getElementById('<%=ddlcity.ClientID%>')).length;
document.getElementById("ddlcity").options.length = 0;
for(i=0;i

ZurdoDev 20-Nov-12 7:58am

Where are you stuck?

Hari Krishna Prasad Inakoti 21-Nov-12 1:36am

Hi ryanb31,
If i select in State drop down list i want to save that state's entire city's list into database with that state name.

ZurdoDev 21-Nov-12 7:29am

Where are the cities? You'll just need to write code to do this. I guess I'm confused on what specifically you need. We can't write the code for you because there's a million ways to do it and it depends on what you have already.

Hari Krishna Prasad Inakoti 22-Nov-12 2:34am

See below code:

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Untitled Page</title>
<script language="javascript" type="text/javascript">
function state()
{
var select=new Array("-Select-");
var jammu=new Array("-Select-","Srinagar","Kathua","Doda","Kishtwar","Poonch","Rajouri");
var punjab=new Array("-Select-","Ludhiana","Amritsar","Bathinda","Firozpur");
var andhrapradesh=new Array("-Select-","Adilabad","Anantapur","Chittoor","YSR Cuddaph","East Godavari",
"Guntur","Hyderabad","Karimnagar","Khammam","Krishna","Kurnool","Mahbubnagar","Medak","Nalgonda",
"Shri Potti Sriramulu Nellore","Nizamabad ","Prakasam","Rangareddi","Srikakulam","Visakhapatnam","Vizianagaram","Warangal ","West Godavari");
var tamilnadu=new Array("-Select-","Chennai","Coimbatore","Cuddalore","Dharmapuri","Dindigul","Erode","Kancheepuram","Kanyakumari","Karur","Krishnagiri","Madurai","Nagapattinam","Namakkal","Nilgiris","Perambalur","Pudukkottai","Ramanathapuram ","Salem","Sivaganga","Thanjavur","Theni","Thiruvallur","Thiruvarur","Thoothukudi","Tiruchirappalli","Tirunelveli","Tiruvannamalai","Vellore","Villupuram","Virudhunagar");
var karnataka=new Array("-Select-","Bangalore","Mangalore","Mysore","Darwad");
var i,j;
var selectedBoxValue=document.getElementById('<%=ddlstate.ClientID%>').value;
var stateLength=eval(selectedBoxValue).length;
var selectcityvalue=document.getElementById('<%=ddlcity.ClientID%>').value;
var citylength=eval(document.getElementById('<%=ddlcity.ClientID%>')).length;
document.getElementById("ddlcity").options.length = 0;
for(i=0;i

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)