Problem in Dropdownlist During Fetch and insert data in database

Question

0.00/5 (No votes)

See more:

I Want to Insert Some data into Datbase, i take four field two dropdownlist and two textbox,
when i save data in database, after submit the button , this genrate an error message. that is

SQL

'proDropDownList1' has a SelectedValue which is invalid because it does not exist in the list of items. Parameter name: value

and my dropdownlist code is -

ASP.NET

<asp:DropDownList ID="DropDownList1" runat="server" OnSelectedIndexChanged="DropDownList1_SelectedIndexChanged" Width="161px">

Can you Help Me Please?

Posted 29-Aug-11 20:16pm

ManavGuru

Updated 29-Aug-11 20:17pm

Prerak Patel

v2

Add a Solution

Comments

hitech_s 30-Aug-11 2:20am

how u r binding data to dropdownlist?
check data exist or not in dropdownlist
if dropdown doesnot contain data then such type of error will raise
thats it

4 solutions

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)

hitech_s · Answer 1 · 2011-08-29T20:19:00

Solution 1

bind data to dropdownlist before u r accessing dropdownlist.selectedvale.
first see whether u r dropdownlist has items or not.

Posted 29-Aug-11 20:19pm

hitech_s

Updated 29-Aug-11 20:27pm

v3

Abhinav S · Answer 2 · 2011-08-29T20:31:00

Highlight functionality
http://support.microsoft.com/kb/181440[^] - an old link but useful if you are using the ListView in report mode.

Search functionality
Doing a search on the internet will give you tons of results for this.

However, you can start with http://msdn.microsoft.com/en-us/library/ms171644.aspx[^] or A User-Searchable TextBox, RichTextBox, ListView, and TreeView in C#[^].

deepakalyani · Answer 3 · 2011-08-29T20:50:00

Solution 3

http://www.w3schools.com/aspnet/aspnet_examples.asp
use this for reference

Posted 29-Aug-11 20:50pm

deepakalyani

ABHI9278 · Answer 4 · 2011-12-17T04:58:00

.................PROGRAM FOR SAVING DATA IN DATABASE USING DROPDOWNLIST..........

using System;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;

public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{

}
protected void TextBox1_TextChanged(object sender, EventArgs e)
{

}
protected void Button1_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(@"Data Source=INFOSYS-E28D9BC\SQLEXPRESS;Initial Catalog=abhinav;Integrated Security=True");
con.Open();
SqlCommand cmd = new SqlCommand("save_record", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@ename",TextBox1.Text);
cmd.Parameters.Add("@fname", TextBox2.Text);
cmd.Parameters.Add("@country",DropDownList1.SelectedItem.Text);
cmd.Parameters.Add("@city",DropDownList2.SelectedItem.Text);
cmd.Parameters.Add("@mob", Convert.ToInt32(TextBox3.Text));
int i = cmd.ExecuteNonQuery();
if (i == 1)
Label1.Text = "Record is inserted successfully";
else
Label1.Text = "Please Try Again";
con.Close();
}
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{

}
protected void TextBox2_TextChanged(object sender, EventArgs e)
{

}
protected void DropDownList2_SelectedIndexChanged(object sender, EventArgs e)
{

}
protected void Button2_Click(object sender, EventArgs e)
{
TextBox1.Text = "";
TextBox2.Text= "";
TextBox3.Text= "";

}
}

..............DESIGN CODE................
PASTE IT IN YOUR VISUAL STUDIO 2008 IDE SOURCE.......

XML

<%@ Page Language="C#" AutoEventWireup="true"  CodeFile="Default.aspx.cs" Inherits="_Default" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title>Untitled Page</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>

    &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
        ...........USER INFORMATION FORM...........<br />
        <br />
        Enter Name&nbsp;&nbsp;
        <asp:TextBox ID="TextBox1" runat="server" ontextchanged="TextBox1_TextChanged"></asp:TextBox>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Father Name
        <asp:TextBox ID="TextBox2" runat="server" ontextchanged="TextBox2_TextChanged"></asp:TextBox>
        <br />
        <br />
        Country&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
        <asp:DropDownList ID="DropDownList1" runat="server"
            onselectedindexchanged="DropDownList1_SelectedIndexChanged">
            <asp:ListItem>INDIA</asp:ListItem>
            <asp:ListItem>PAKISTAN</asp:ListItem>
        </asp:DropDownList>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
        City&nbsp;&nbsp;&nbsp;
        <asp:DropDownList ID="DropDownList2" runat="server"
            onselectedindexchanged="DropDownList2_SelectedIndexChanged"
            style="height: 22px">
            <asp:ListItem>KASHIPUR</asp:ListItem>
            <asp:ListItem>LAHOR</asp:ListItem>
        </asp:DropDownList>
        <br />
        <br />
        <br />
        Mob No.&nbsp;&nbsp;&nbsp;&nbsp;        <asp:TextBox ID="TextBox3" runat="server"></asp:TextBox>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
        <br />
        <br />
        <br />
        <br />
        <asp:Button ID="Button1" runat="server" onclick="Button1_Click" Text="Submit" />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
        <asp:Button ID="Button2" runat="server" Text="Cancel" onclick="Button2_Click" />
        <br />
        <br />
        <asp:Label ID="Label1" runat="server" Text="Label"></asp:Label>

    </div>
    </form>
</body>
</html>

Problem in Dropdownlist During Fetch and insert data in database

4 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Add your solution here

Preview 0