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> There are safer and more complex ways to do it, but the basics include getting the SelectedValue from the DropDownList and doing an Insert statement to oracle.
Please click 'Mark as Answer' if my reply has assisted you.
"A common mistake that people make when trying to design something completely foolproof was to underestimate the ingenuity of complete fools." ~ Douglas Adams
http://wildobson.com