I have a GridView with id value I want to show another value instead of IdI use this code to do that but I faced an errorSpecified cast is not valid ltaspGridView ID34GridView134 runat34server34 AutoGenerateColumns34False34 AutoGenerateEditButton34True34 BackColor34White34 BorderColor34CCCCCC34 BorderStyle34None34 BorderWidth341px34 CellPadding34334 DataSourceID34SqlDataSrcAddMark34 OnRowUpdating34GridVie

I Use this code and my problem solved protected void GridView1RowDataBoundobject sender GridViewRowEventArgs e if eRowRowTypeDataControlRowTypeDataRow SystemDataDataRow dr SystemDataDataRowVieweRowDataItemRow if dr34ExamAttendanceTypeId34ToString 34134 LabeleRowFindControl34Label334Text 34Present34 else if dr34ExamAttendanceTypeId34ToString 34234 LabeleRowFindControl34Label334Text 34UnAcceptable Absent34 else if dr34ExamAttendanceTypeId34ToString34334 LabeleRowFindControl34Label334Text 34 Acceptable Absent34

Hi dorsaCheck your datatype may you have used int type and you are using in your code byte for that reason you are getting error cast is not valid so you need to chek your datatype according to your columns type use datatype in your codeRefer below sample code is runningHTMLltaspGridView ID34GridView134 runat34server34 AutoGenerateColumns34False34gt ltColumnsgt ltaspTemplateField HeaderText34 34 SortExpression34ExamAttendanceTypeId34gt ltItemTemplategt ltaspLabel ID34Label334 runat34server34 Text39lt ShowAttendanceStatusEval34AttendanceStatus34 gt39gtltaspLabelgt ltItemTemplategt ltaspTemplateFieldgt ltaspBoundField DataField34Title34 HeaderText34 34 SortExpression34LastName34 gt ltaspBoundField DataField34StudentId34 HeaderText34Studen

[Solved] ASP.Net GridView Error: Specified cast is not valid

dorsa

SOLVED CLOSED ACTIVE ANSWERED
User: dorsa
Posted: on Jun 19, 2019 10:52 PM
Forum: Data Controls
Answer: 2
Views: 9869

I have a GridView with id value. I want to show another value instead of Id.

I use this code to do that but I faced an error.

Specified cast is not valid

    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" AutoGenerateEditButton="True" BackColor="White" BorderColor="#CCCCCC"
        BorderStyle="None" BorderWidth="1px" CellPadding="3" DataSourceID="SqlDataSrcAddMark" OnRowUpdating="GridView1_RowUpdating" HorizontalAlign="Center" Font-Names="Tahoma" Width="719px">
        <Columns>
            <asp:TemplateField HeaderText="وضعیت حضور و غیاب" SortExpression="ExamAttendanceTypeId" HeaderStyle-CssClass="Header-center">
                <EditItemTemplate>
                    <asp:DropDownList ID="DropDownList1" runat="server">
                        <asp:ListItem Value="1">حاضر</asp:ListItem>
                        <asp:ListItem Value="2">غیبت غیرمجاز</asp:ListItem>
                        <asp:ListItem Value="3">غیبت مجاز</asp:ListItem>
                    </asp:DropDownList>
                </EditItemTemplate>
                <ItemTemplate>
                    <asp:Label ID="Label3" runat="server" Text='<%# ShowAttendanceStatus(Eval("ExamAttendanceTypeId")) %>'></asp:Label>
                </ItemTemplate>
            </asp:TemplateField>
            <asp:BoundField DataField="LastName" HeaderText="نام خانوادگی" SortExpression="LastName" HeaderStyle-CssClass="Header-center" InsertVisible="false" />
            <asp:BoundField DataField="FirstName" HeaderText="نام" SortExpression="FirstName" HeaderStyle-CssClass="Header-center" InsertVisible="false" />
            <asp:BoundField DataField="StudentId" HeaderText="--" SortExpression="StudentId" HeaderStyle-CssClass="Header-center" InsertVisible="false" />
        </Columns>
    </asp:GridView>

        protected string ShowAttendanceStatus(object i)
        {
            if ((byte)i == 1)
            {
                return "Present";
            }
            else if ((byte)i == 2)
            {
                return "UnAcceptable Absent";
            }
            else
            {
                return " Acceptable Absent ";
            }
        }

How can I fix this problem?

Download FREE API for Word, Excel and PDF in ASP.Net

dorsa

0 3

Reply
ANSWER
User: dorsa
Replied: on Jun 19, 2019 11:38 PM
Report

I Use this code and my problem solved.

        protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
        {
            if (e.Row.RowType==DataControlRowType.DataRow)
            {
                System.Data.DataRow dr = ((System.Data.DataRowView)e.Row.DataItem).Row;
                if (dr["ExamAttendanceTypeId"].ToString() == "1")
                {
                    ((Label)e.Row.FindControl("Label3")).Text = "Present";
                }
                else if (dr["ExamAttendanceTypeId"].ToString() == "2")
                {
                    ((Label)e.Row.FindControl("Label3")).Text = "UnAcceptable Absent";
                }
                else if (dr["ExamAttendanceTypeId"].ToString()=="3")
                {
                    ((Label)e.Row.FindControl("Label3")).Text = " Acceptable Absent";
                }
            }
        }

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

[Solved] ASP.Net GridView Error: Specified cast is not valid

Company

Explore

Follow us

Contact Us