Hi Everybody!

In dropdown list i have

1. USA

2. Japan

3. UK

Now, when i select on Japan, in the database say there is table name COUNTRY with column name  ID. How can i store the corresponding country value in the ID column? I mean I have to store 2  when i select Japan.

I would appreciate your suggestion.

Thanks!

Uttam   

1) To get the value from the drop down list, use SELECTEDVALUE property

2) Open the database and call executenonquery of the command object to store the value.

Which step you  stucked on?

One suggestion: generate your SQL for the insert based on the value of the dropdownlist:

    protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
    {
        if (((DropDownList)sender).SelectedIndex > 0)
        {

            string sql = "insert into Country (ID) Values ('" + ((DropDownList)sender).SelectedValue + "')";
         {
    }

< asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True" OnSelectedIndexChanged="DropDownList1_SelectedIndexChanged" style="position: relative">
            < asp:ListItem Selected="True" Value="0">Select Value< /asp:ListItem>
            < asp:ListItem Value="1">USA< /asp:ListItem>
            < asp:ListItem Value="2">JAPAN< /asp:ListItem>
            < asp:ListItem Value="3">UK< /asp:ListItem>
            < asp:ListItem Value="4">NoWhere< /asp:ListItem>
        < /asp:DropDownList>

Thanks! Smiling4ever

 When I inserted the selected value, it showed error message

ORA-00984: column not allowed here

Wow! Excellent

 Thanks pixelsyndicate.

 thank you!

pixelsyndicate:

One suggestion: generate your SQL for the insert based on the value of the dropdownlist:

    protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
    {
        if (((DropDownList)sender).SelectedIndex > 0)
        {

            string sql = "insert into Country (ID) Values ('" + ((DropDownList)sender).SelectedValue + "')";
         {
    }

< asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True" OnSelectedIndexChanged="DropDownList1_SelectedIndexChanged" style="position: relative">
            < asp:ListItem Selected="True" Value="0">Select Value< /asp:ListItem>
            < asp:ListItem Value="1">USA< /asp:ListItem>
            < asp:ListItem Value="2">JAPAN< /asp:ListItem>
            < asp:ListItem Value="3">UK< /asp:ListItem>
            < asp:ListItem Value="4">NoWhere< /asp:ListItem>
        < /asp:DropDownList>

Thanks! Smiling4ever

I got it.

 Thanks!