Unable to cast a dropdownlist in GridView and Convertible

Aktham Mahmoud

Greeting all

I have a gridView as photo below

A position dropdownlist connect alone with (SQLDATASOURC) to get Brunch name and Id and implement them to Dropdownlist......Anyway..when I select any item from dropdownlist showing that mistake

as photo beow:

I used many many many solutions to resolve that no way..

Have anyone a perfect way to resolve that mistake..

Take a view a bout code below:

protected void gvjobsshow_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
try
{
using (SqlConnection sqlcon = new SqlConnection(connectionString))
{
sqlcon.Open();
string query = "UPDATE Jobs SET Job_title = @Job_title, Job_desc = @Job_desc,P_date = @P_date, C_date = @C_date,Branch_Id = @Branch_Id, JType_Id = @JType_Id, JEnable = @JEnable WHERE (Jobs.Id = @Id)";
string Pday = ((TextBox)gvjobsshow.Rows[e.RowIndex].FindControl("TB_PDate")).Text;
string Cday = ((TextBox)gvjobsshow.Rows[e.RowIndex].FindControl("TBCdate_E")).Text;
//====That solution to get DropDownlist value and imlement it is Variable, and then implement a variable in SQL Upadate=====
DropDownList DDLBrID1 = (DropDownList)gvjobsshow.Rows[e.RowIndex].FindControl("DDl_Po_E");
string DDLBrID2 = DDLBrID1.SelectedItem.Value.ToString();
SqlCommand sqlcmd = new SqlCommand(query, sqlcon);
sqlcmd.Parameters.AddWithValue("@Job_title", (gvjobsshow.Rows[e.RowIndex].FindControl("TB_Tit_E") as TextBox).Text.Trim());
sqlcmd.Parameters.AddWithValue("@Job_desc", (gvjobsshow.Rows[e.RowIndex].FindControl("TbDes_E") as TextBox).Text.Trim());
sqlcmd.Parameters.AddWithValue("@P_date", Pday);
sqlcmd.Parameters.AddWithValue("@C_date", Cday);
sqlcmd.Parameters.AddWithValue("@Branch_Id", DDLBrID2);
//sqlcmd.Parameters.Add("@Branch_Id", SqlDbType.Int).Value = ((DropDownList)gvjobsshow.Rows[e.RowIndex].FindControl("DDl_Po_E"));
//==== I used that solution to access to dropdownlist value and return it with [[Convert.ToInt32]] but no way...
//sqlcmd.Parameters.AddWithValue("@Branch_Id", Convert.ToInt32((gvjobsshow.Rows[e.RowIndex].FindControl("DDl_Po_E"))));
sqlcmd.Parameters.AddWithValue("@JType_Id", Convert.ToInt32((gvjobsshow.Rows[e.RowIndex].FindControl("DDl_Miss_E"))));
sqlcmd.Parameters.AddWithValue("@JEnable", Convert.ToBoolean((gvjobsshow.Rows[e.RowIndex].FindControl("Ch_E") as CheckBox).Checked));
sqlcmd.Parameters.AddWithValue("@Id", Convert.ToInt32(gvjobsshow.DataKeys[e.RowIndex].Value.ToString()));
sqlcmd.ExecuteNonQuery();
gvjobsshow.EditIndex = -1;
GVShowJobs();
JobSuUp.Text = "Selected Record has been Updated.";
}
}
catch (Exception ex)
{
JobFaUp.Text = ex.Message;
}
}

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Aktham Mahmoud6y ago
HI, am tryieng but not working!!!
Ramachandran M6y ago
Hi Aktham

var DDLBrID2 = DDLBrID1.SelectedItem;
Aktham Mahmoud6y ago
Greeting Mr
Ramachandran M

Actually in C# is not allwed this way
string DDLBrID2 = DDLBrID1.SelectedItem;
is necessary to add value
any way
is last code worked on patform correctly with no errors and updated correctly.

The errore still with me.
Ramachandran M6y ago
Hi Aktham,

in my local your codings are working fine.

My suggestions are

1. if you are using update panel add attribute UpdateMode="Conditional"

2. Change the code as below and check the
DDLBrID2 value in quick window . if value is not null then found which property has value in quick window after that change the code as runnable.
var DDLBrID2 = DDLBrID1.SelectedItem;
Aktham Mahmoud6y ago
Greeting Mr.Ramachandran M
That's a DetailsView Fornt End Code:
<asp:GridView ID="gvjobsshow" runat="server" AutoGenerateColumns="False" OnRowEditing="gvjobsshow_RowEditing" OnRowDeleting="gvjobsshow_RowDeleting" OnRowUpdating="gvjobsshow_RowUpdating" OnRowCancelingEdit="gvjobsshow_RowCancelingEdit" DataKeyNames="Id">
            <Columns>
                <asp:TemplateField HeaderText="Title">
                    <EditItemTemplate>
                        <asp:TextBox ID="TB_Tit_E" runat="server" Text='<%# Bind("Job_title") %>'>asp:TextBox>
                    EditItemTemplate>
                    <ItemTemplate>
                        <asp:Label ID="lab_Ti_I" runat="server" Text='<%# Eval("Job_title") %>'>asp:Label>
                    ItemTemplate>
                asp:TemplateField>
                <asp:TemplateField HeaderText="Desceription">
                    <EditItemTemplate>
                        <asp:TextBox ID="TbDes_E" runat="server" Text='<%# Bind("Job_desc") %>' TextMode="MultiLine">asp:TextBox>
                    EditItemTemplate>
                    <ItemTemplate>
                        <asp:Label ID="LB_Dsc_I" runat="server" Text='<%# Eval("Job_desc") %>'>asp:Label>
                    ItemTemplate>
                asp:TemplateField>
                <asp:TemplateField HeaderText="Position">
                    <EditItemTemplate>
                        <asp:DropDownList ID="DDl_Po_E" runat="server" AutoPostBack="True" DataSourceID="SDS_Br_E" DataTextField="B_Name" DataValueField="Id" SelectedValue='<%# Bind("Branch_Id") %>'>
                        asp:DropDownList>
                        <asp:SqlDataSource ID="SDS_Br_E" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>" SelectCommand="SELECT [Id], [B_Name] FROM [Branchs]">asp:SqlDataSource>
                    EditItemTemplate>
                    <ItemTemplate>
                        <asp:Label ID="Lab_br_e" runat="server" Text='<%# Eval("B_Name") %>'>asp:Label>
                    ItemTemplate>
                asp:TemplateField>
                <asp:TemplateField HeaderText="Mission">
                    <EditItemTemplate>
                        <asp:DropDownList ID="DDl_Miss_E" runat="server" AutoPostBack="True" DataSourceID="SDS_MISS_E" DataTextField="Mission" DataValueField="Id" SelectedValue='<%# Bind("JType_Id") %>'>
                        asp:DropDownList>
                        <asp:SqlDataSource ID="SDS_MISS_E" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>" SelectCommand="SELECT [Id], [Mission] FROM [J_Type]">asp:SqlDataSource>
                    EditItemTemplate>
                    <ItemTemplate>
                        <asp:Label ID="Lab_mi_e" runat="server" Text='<%# Eval("Mission") %>'>asp:Label>
                    ItemTemplate>
                asp:TemplateField>
                <asp:TemplateField HeaderText="Publishing Date" SortExpression="P_date">
                    <EditItemTemplate>
                        <asp:TextBox ID="TB_PDate" runat="server" Text='<%# Bind("P_date", "{0:d}") %>'>asp:TextBox>
                        <ajaxToolkit:CalendarExtender ID="TextBox1_CalendarExtender" runat="server" TargetControlID="TB_PDate" />
                    EditItemTemplate>
                    <ItemTemplate>
                        <asp:Label ID="Label1" runat="server" Text='<%# Eval("P_date", "{0:d}") %>'>asp:Label>
                    ItemTemplate>
                asp:TemplateField>
                <asp:TemplateField HeaderText="Closing Date" SortExpression="C_date">
                    <EditItemTemplate>
                        <asp:TextBox ID="TBCdate_E" runat="server" Text='<%# Bind("C_date", "{0:d}") %>'>asp:TextBox>
                        <ajaxToolkit:CalendarExtender ID="TBCdate_E_CalendarExtender" runat="server" TargetControlID="TBCdate_E" />
                    EditItemTemplate>
                    <ItemTemplate>
                        <asp:Label ID="Label2" runat="server" Text='<%# Eval("C_date", "{0:d}") %>'>asp:Label>
                    ItemTemplate>
                asp:TemplateField>
                <asp:TemplateField HeaderText="Status">
                    <EditItemTemplate>
                        <asp:CheckBox ID="Ch_E" runat="server" Checked='<%# Bind("JEnable") %>' Text="Yes Or NO" />
                    EditItemTemplate>
                    <ItemTemplate>
                        <asp:CheckBox ID="CheckBox1" runat="server" Checked='<%# Eval("JEnable") %>' Text="Yes Or NO" />
                    ItemTemplate>
                asp:TemplateField>
                <asp:TemplateField ShowHeader="False">
                    <EditItemTemplate>
                        <asp:LinkButton ID="LnB_U" runat="server" CausesValidation="True" CommandName="Update" Text="Update" CssClass="btn btn-outline-success">asp:LinkButton>
                         <asp:LinkButton ID="LnB_C" runat="server" CausesValidation="False" CommandName="Cancel" Text="Cancel" CssClass="btn btn-outline-dark">asp:LinkButton>
                    EditItemTemplate>
                    <ItemTemplate>
                        <asp:LinkButton ID="LnB_E" runat="server" CausesValidation="False" CommandName="Edit" Text="Edit" CssClass="btn btn-outline-warning">asp:LinkButton>
                    ItemTemplate>
                asp:TemplateField>
                <asp:TemplateField ShowHeader="False">
                    <ItemTemplate>
                        <asp:LinkButton ID="LnB_D" runat="server" CausesValidation="False" CommandName="Delete" Text="Delete" CssClass="btn btn-outline-danger">asp:LinkButton>
                    ItemTemplate>
                asp:TemplateField>
            Columns>
            <EditRowStyle BackColor="#3399FF" />
        asp:GridView>
and below a Tabels:
Ramachandran M6y ago
Hi ,

Can you share Grid view Details ?