ASP.Net GridView Error: RadioButtonList has a SelectedValue which is invalid because it does not exist in the list of items

chetan

SOLVED CLOSED ACTIVE ANSWERED
User: chetan
Posted: on Feb 12, 2018 10:18 PM
Forum: Data Controls
Answer: 1
Views: 6915
Sample Code: Download

I am getting a "has a SelectedValue which is invalid because it does not exist in the list of items. Parameter name: value" error when clicking the edit button on a gridview. i can click "insert" and insert a new record without issue, but when i try to edit the same record, the error appears. This doesn't make sense to me since the datasource and controls in both the insert statement and the edit statement are identical.

Source code:

                                                   <asp:TemplateField HeaderText="TT Status" SortExpression="TT Status">
                                                       <EditItemTemplate>
                                                           <asp:RadioButtonList ID="rdottstatus" runat="server" Text='<%# Bind("TTStatus") %>' Width="100" RepeatDirection="Horizontal">
                                                               <asp:ListItem Value="0" Text ="Received"></asp:ListItem>
                                                               <asp:ListItem Value="1" Text ="Not Received"></asp:ListItem>
                                                           </asp:RadioButtonList>
                                                       </EditItemTemplate>
                                                       <ItemTemplate>
                                                           <asp:Label ID="Label3" runat="server" Text='<%# Bind("TTStatus") %>'></asp:Label>
                                                       </ItemTemplate>
                                                       <FooterTemplate>
                                                            <asp:RadioButtonList ID="ftrrdottstatus" runat="server" Width="100" RepeatDirection="Horizontal">
                                                               <asp:ListItem Value="0" Text ="Received"></asp:ListItem>
                                                               <asp:ListItem Value="1" Text ="Not Received"></asp:ListItem>
                                                           </asp:RadioButtonList>
                                                       </FooterTemplate>
                                                   </asp:TemplateField>

                                                    <asp:TemplateField HeaderText="Confirmation Status" SortExpression="Confirmation Status">
                                                       <EditItemTemplate>
                                                           <asp:RadioButtonList ID="rdoConfirmation" runat="server" Text='<%# Bind("confirmationstatus") %>' Width="100" RepeatDirection="Horizontal">
                                                               <asp:ListItem Value="0" Text ="Confirmed"></asp:ListItem>
                                                               <asp:ListItem Value="1" Text ="Not Confirmed"></asp:ListItem>
                                                           </asp:RadioButtonList>
                                                       </EditItemTemplate>
                                                       <ItemTemplate>
                                                           <asp:Label ID="Label4" runat="server" Text='<%# Bind("confirmationstatus") %>'></asp:Label>
                                                       </ItemTemplate>
                                                       <FooterTemplate>
                                                            <asp:RadioButtonList ID="ftrrdoConfirmation" runat="server" Width="100" RepeatDirection="Horizontal">
                                                               <asp:ListItem Value="0" Text ="Confirmed"></asp:ListItem>
                                                               <asp:ListItem Value="1" Text ="Not Confirmed"></asp:ListItem>
                                                           </asp:RadioButtonList>
                                                       </FooterTemplate>
                                                   </asp:TemplateField>

Code behind:

    protected void gvDetails_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {
        TextBox txtam = (TextBox)gvDetails.Rows[e.RowIndex].FindControl("txtamtt");
        TextBox txtper = (TextBox)gvDetails.Rows[e.RowIndex].FindControl("txtper");
        TextBox txtconf = (TextBox)gvDetails.Rows[e.RowIndex].FindControl("txtconfirm");
        TextBox txtdiff = (TextBox)gvDetails.Rows[e.RowIndex].FindControl("txtdifference");
        RadioButtonList rdott = (RadioButtonList)gvDetails.Rows[e.RowIndex].FindControl("rdottstatus");
        RadioButtonList rdoconfirm = (RadioButtonList)gvDetails.Rows[e.RowIndex].FindControl("rdoConfirmation");
        Int64 currInvoiceId = Convert.ToInt64(Request.QueryString["edit_invoice_id"]);

        try
        {

            MySqlConnection connect;
            string connectStr = ConfigurationManager.ConnectionStrings["ExpoCrmConnectionString"].ToString();
            connect = new MySqlConnection(connectStr);
            // string queryStr = "insert into payment_receipt_status(invoic_id,Amount,Percentage,TTStatus,confirmationstatus,confirmationamount,Differenceamount)values(?iid,?Amount,?Percentage,?TTStatus,?confirmationstatus,?confirmationamount,?Differenceamount)";
            string queryStr = "update payment_receipt_status set Amount=?Amount,Percentage=?Percentage,TTStatus=?TTStatus,confirmationstatus=?confirmationstatus,confirmationamount=?confirmationamount,Differenceamount=?Differenceamount where invoic_id=?iid";
            connect.Open();
            MySqlCommand command = new MySqlCommand(queryStr, connect);
            command.Parameters.AddWithValue("?iid", currInvoiceId);
            command.Parameters.AddWithValue("?Amount", txtam.Text);
            command.Parameters.AddWithValue("?Percentage", txtper.Text);
            command.Parameters.AddWithValue("?TTStatus", rdott.SelectedItem.Text);
            command.Parameters.AddWithValue("?confirmationstatus", rdoconfirm.SelectedItem.Text);
            command.Parameters.AddWithValue("?confirmationamount", txtconf.Text);
            command.Parameters.AddWithValue("?Differenceamount", txtdiff.Text);
            command.ExecuteNonQuery();
            connect.Close();
            FillVendorGrid();
            txtam.Text = "";
            txtper.Text = "";
            txtconf.Text = "";
            txtdiff.Text = "";
            connect.Close();
        }
        catch (Exception ex)
        {

        } 
    }

dharmend...

0 4

Reply
ANSWER
User: dharmendr
Replied: on Feb 13, 2018 01:16 AM
Modified: on Feb 13, 2018 06:41 AM
Report

Hi chetan,

Check this example. Now please take its reference and correct your code.

HTML

<asp:GridView ID="gvCustomers" DataKeyNames="CustomerId" runat="server" AutoGenerateColumns="false"
    OnRowEditing="EditCustomer" OnRowDataBound="RowDataBound" OnRowUpdating="UpdateCustomer"
    OnRowCancelingEdit="CancelEdit">
    <Columns>
        <asp:BoundField DataField="Name" HeaderText="Name" />
        <asp:TemplateField HeaderText="Country">
            <ItemTemplate>
                <asp:Label ID="lblCountry" runat="server" Text='<%# Eval("Country")%>'></asp:Label>
            </ItemTemplate>
            <EditItemTemplate>
                <asp:Label ID="lblCountry" runat="server" Text='<%# Eval("Country")%>' Visible="false"></asp:Label>
                <asp:RadioButtonList ID="rdoCountry" runat="server" Width="100" RepeatDirection="Horizontal">
                    <asp:ListItem Value="India" Text="India"></asp:ListItem>
                    <asp:ListItem Value="Austria" Text="Austria"></asp:ListItem>
                    <asp:ListItem Value="France" Text="France"></asp:ListItem>
                    <asp:ListItem Value="Brazil" Text="Brazil"></asp:ListItem>
                    <asp:ListItem Value="Ireland" Text="Ireland"></asp:ListItem>
                </asp:RadioButtonList>
            </EditItemTemplate>
        </asp:TemplateField>
        <asp:CommandField ShowEditButton="True" />
    </Columns>
</asp:GridView>

Namespace

using System.Data.SqlClient;
using System.Configuration;
using System.Data;

VB.Net

Imports System.Data.SqlClient
Imports System.Data
Imports System.Configuration

Code

protected void Page_Load(object sender, EventArgs e)
{
    if (!IsPostBack)
    {
        this.BindData();
    }
}

private void BindData()
{
    string query = "SELECT * FROM Customers";
    SqlCommand cmd = new SqlCommand(query);
    gvCustomers.DataSource = GetData(cmd);
    gvCustomers.DataBind();
}

private DataTable GetData(SqlCommand cmd)
{
    string strConnString = ConfigurationManager.ConnectionStrings["conString"].ConnectionString;
    using (SqlConnection con = new SqlConnection(strConnString))
    {
        using (SqlDataAdapter sda = new SqlDataAdapter())
        {
            cmd.Connection = con;
            sda.SelectCommand = cmd;
            using (DataTable dt = new DataTable())
            {
                sda.Fill(dt);
                return dt;
            }
        }
    }
}

protected void EditCustomer(object sender, GridViewEditEventArgs e)
{
    gvCustomers.EditIndex = e.NewEditIndex;
    this.BindData();
}

protected void CancelEdit(object sender, GridViewCancelEditEventArgs e)
{
    gvCustomers.EditIndex = -1;
    BindData();
}

protected void RowDataBound(object sender, GridViewRowEventArgs e)
{
    if (e.Row.RowType == DataControlRowType.DataRow && gvCustomers.EditIndex == e.Row.RowIndex)
    {
        RadioButtonList rdoCountries = (RadioButtonList)e.Row.FindControl("rdoCountry");
        rdoCountries.Items.FindByValue((e.Row.FindControl("lblCountry") as Label).Text).Selected = true;
    }
}

protected void UpdateCustomer(object sender, GridViewUpdateEventArgs e)
{
    string country = (gvCustomers.Rows[e.RowIndex].FindControl("rdoCountry") as RadioButtonList).SelectedItem.Value;
    //  Write Update code
    ClientScript.RegisterClientScriptBlock(this.GetType(), "", "alert('" + country + "')", true);
    gvCustomers.EditIndex = -1;
    BindData();
}

VB.Net

Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) Handles Me.Load
    If Not IsPostBack Then
        Me.BindData()
    End If
End Sub

Private Sub BindData()
    Dim query As String = "SELECT * FROM Customers"
    Dim cmd As SqlCommand = New SqlCommand(query)
    gvCustomers.DataSource = GetData(cmd)
    gvCustomers.DataBind()
End Sub

Private Function GetData(ByVal cmd As SqlCommand) As DataTable
    Dim strConnString As String = ConfigurationManager.ConnectionStrings("conString").ConnectionString
    Using con As SqlConnection = New SqlConnection(strConnString)
        Using sda As SqlDataAdapter = New SqlDataAdapter()
            cmd.Connection = con
            sda.SelectCommand = cmd
            Using dt As DataTable = New DataTable()
                sda.Fill(dt)
                Return dt
            End Using
        End Using
    End Using
End Function

Protected Sub EditCustomer(ByVal sender As Object, ByVal e As GridViewEditEventArgs)
    gvCustomers.EditIndex = e.NewEditIndex
    Me.BindData()
End Sub

Protected Sub CancelEdit(ByVal sender As Object, ByVal e As GridViewCancelEditEventArgs)
    gvCustomers.EditIndex = -1
    BindData()
End Sub

Protected Sub RowDataBound(ByVal sender As Object, ByVal e As GridViewRowEventArgs)
    If e.Row.RowType = DataControlRowType.DataRow AndAlso gvCustomers.EditIndex = e.Row.RowIndex Then
        Dim rdoCountries As RadioButtonList = CType(e.Row.FindControl("rdoCountry"), RadioButtonList)
        rdoCountries.Items.FindByValue((TryCast(e.Row.FindControl("lblCountry"), Label)).Text).Selected = True
    End If
End Sub

Protected Sub UpdateCustomer(ByVal sender As Object, ByVal e As GridViewUpdateEventArgs)
    Dim country As String = (TryCast(gvCustomers.Rows(e.RowIndex).FindControl("rdoCountry"), RadioButtonList)).SelectedItem.Value
    ' Write Update code 
    ClientScript.RegisterClientScriptBlock(Me.[GetType](), "", "alert('" & country & "')", True)
    gvCustomers.EditIndex = -1
    BindData()
End Sub

Screenshot

ASP.Net GridView Error: RadioButtonList has a SelectedValue which is invalid because it does not exist in the list of items

Company

Explore

Follow us

Contact Us