GridView Question ?!

Hello,

I am getting a little bit frustrated now.

I have a drop down menu holding different types of an item. when i choose that item from drop down menu, those items under that type show up in a Grid View. up to here everything is perfect.

then I have a detailview that let me add new items to that list (grid View) and eveything is perfect even up to here.

the only problem is when I add the new item the GridView doesnt show the newly added item, I have to change the drop down to something else and then select another one again to see the newly added one.

This is really annoying, I want to see that new item straight away in my Grid View. What is wrong ? do I need to do something to refresh my gridview ?

Thank you.

Re: GridView Question ?!

you possibly need to re-bind your gridview when a new item is inserted. GridView1.DataBind();

Re: GridView Question ?!

Thanks but this didnt help also.

By the way, I am using two update panels one for Grid View and one for Detail View. Update mode for Grid View is Always and for Detail View is conditional !

The drop down menu is at the top out side of any Update Panel.

Is there anything that might cause the problem ?

On the same page I have another similare situation where I add the new element using Detail View and I see the changes in GridView but there is no drop down menu there.

So I am assuming that the drop down menu is doing something wrong here or is it ?

Re: GridView Question ?!

try putting the dropdownlist inside of the first update panel (where the gridview is) with the default settings. make sure that your dropdownlist postback property is set to true.

Below is a snippet from a project im working on that uses the gridview and details view in pretty much the same fashion you are describing. It doesnt allow for you to insert data, but you can see how I use it for deleting an item and the gridview updates accordingly. Pretty much uses the same guidelines. (the sample below is a simple resume viewer for a list of job applicants)

aspx:

<!-- Update Panel -->
<asp:UpdatePanel ID="UpdatePanel1" runat="server" >
<ContentTemplate>
                         

<!-- Search template -->
<table style="border:solid 1 white;">
    <tr>
         <td style="width:170px;" class="header">Applicant Name</td>
         <td style="width:170px;" class="header">Position</td></tr>
    <tr>
        <td style="width:170px;">
            <asp:Panel ID="pnlSearch" runat="server"  DefaultButton="lnkbtnSearch">
                <asp:TextBox ID="txtName" runat="server" />
                <asp:ImageButton ID="lnkbtnSearch" runat="server"
                                 ImageUrl="~/images/search.gif"
                                 OnClick="FilterExpression" /></asp:Panel></td>
        <td style="width:170px;">
            <asp:DropDownList ID="ddlPosition" runat="server"
                              AutoPostBack="true"
                              DataSourceID="sqldsPositions"
                              DataTextField="fldPosition"
                              AppendDataBoundItems="true"
                              Width="173px"
                              OnSelectedIndexChanged="FilterExpression" >
                <asp:ListItem>All</asp:ListItem>
            </asp:DropDownList></td>
    </tr>
</table>
                        

<!-- Grid View -->
<asp:GridView ID="gvJobApplicants" runat="server" CssClass="gridviewstyle"
              DataSourceID="sqldsJobApplicants"
              DataKeyNames="idJobApp"
              AutoGenerateColumns="false"
              GridLines="Vertical"
              AllowPaging="true"
              AllowSorting="true">
    <Columns>


        <asp:TemplateField HeaderText="Sort" SortExpression="fldLastName" >
            <ItemTemplate>
                <asp:LinkButton ID="lnkbtnName" runat="server"
                                Text='<%# Eval("fldLastName") + ", " + Eval("fldFirstName") %>'
                                CommandName="Select" />
            </ItemTemplate>
            <ItemStyle CssClass="itemstyle" />
            <HeaderStyle CssClass="header" />
        </asp:TemplateField>


        <asp:BoundField HeaderText="Sort"
                        DataField="fldPosition"
                        SortExpression="fldPosition" >
            <ItemStyle CssClass="itemstyle" />
            <HeaderStyle CssClass="header" />
        </asp:BoundField>


    </Columns>
    <EmptyDataTemplate>
        <div class="norecords"><img src="../images/caution.gif" alt="" />
            No records found.</div>
    </EmptyDataTemplate>
</asp:GridView>
</ContentTemplate>
</asp:UpdatePanel>


<!-- DataSource Block -->
<asp:SqlDataSource ID="sqldsDetails" runat="server"
                   SelectCommand="GetApplicantDetails"
                   SelectCommandType="StoredProcedure"
                   ConnectionString="<%$ ConnectionStrings: connString %>">
    <SelectParameters>
        <asp:ControlParameter Name="idJobApp" ControlID="gvJobApplicants" PropertyName="SelectedValue" />
    </SelectParameters>
</asp:SqlDataSource>


<!-- Update Panel -->
<asp:UpdatePanel ID="updtepnlClientNews" runat="server" >
<ContentTemplate>


<!-- Details View -->
<div>
<asp:DetailsView ID="dvJobApplicants" runat="server" CssClass="gridviewstyle"
                 AutoGenerateRows="false"
                 DataSourceID="sqldsDetails"
                 DataKeyNames="idJobApp"
                 DefaultMode="ReadOnly"
                 GridLines="None"
                 width="450px" >
    <HeaderTemplate>
        <div style="text-align:center;" class="header">
             <asp:Label ID="ltlName" runat="server"
                     Text='<%# Eval("fldFirstName") + " " + Eval("fldLastName") %>' />
             <asp:ImageButton ID="imgbtnDelete" runat="server"
                     AlternateText="Delete"
                     ToolTip="Delete applicant"
                     ImageUrl="~/images/delete.gif"
                     OnClientClick='return confirm("Are you sure you want to delete this applicant?")'
                     CommandName="DeleteApplicant"/>
        </div>
    </HeaderTemplate>
    <Fields>
        <asp:BoundField HeaderText="Address" DataField="fldAddress1" />
        <asp:BoundField DataField="fldAddress2" />
        <asp:TemplateField>
            <ItemTemplate>
                <asp:Label ID="lblAddress3" runat="server"
                            Text='<%# Eval("fldCity") + ", " + Eval("fldState") + "&nbsp;" + Eval("fldZip") %>' />
            </ItemTemplate>
        </asp:TemplateField>
        <asp:BoundField HeaderText="Day Phone" DataField="fldDayphone" />
        <asp:BoundField HeaderText="Evening Phone" DataField="fldEveningPhone" />
        <asp:BoundField HeaderText="Email" DataField="fldEmail" />
        <asp:BoundField HeaderText="Cover Letter" DataField="fldCoverLetter" />
        <asp:TemplateField>
            <ItemTemplate>
                <asp:HiddenField ID="hiddenFile" runat="server" Value='<%# Eval("fldResume") %>' />
                <asp:HyperLink ID="hyperResume" runat="server"
                               Text="View Resume"
                               NavigateUrl='<%# Eval("fldResume", "resume.ashx/{0}") %>'
                               Visible='<%# Visible(Eval("fldResume"))  %>' />
            </ItemTemplate>
        </asp:TemplateField>
      

    </Fields>
    <AlternatingRowStyle BackColor="#2B4D6F" />
    <FieldHeaderStyle Width="100px" Font-Bold="true" CssClass="itemstyle"/>
</asp:DetailsView>
</div>
</ContentTemplate>
</asp:UpdatePanel>

Code Behind:

    protected void dvJobApplicants_ItemCommand(object sender, DetailsViewCommandEventArgs e)
    {
        if (e.CommandName == "DeleteApplicant")
        {
            string filePath = Request.PhysicalApplicationPath +
                              ((HyperLink)dvJobApplicants.FindControl("hyperResume")).NavigateUrl.Replace("~/", string.Empty);

            sqldsDetails.DeleteCommand = "DeleteApplicant";
            sqldsDetails.DeleteCommandType = SqlDataSourceCommandType.StoredProcedure;
            sqldsDetails.DeleteParameters.Add("idJobApp", TypeCode.Int32, dvJobApplicants.DataKey.Value.ToString());
            sqldsDetails.Delete();

            if (File.Exists(filePath))
            {
                File.Delete(filePath);
            }

            gvJobApplicants.DataBind();
        }
    }

    protected void FilterExpression(object sender, EventArgs e)
    {
        string name = txtName.Text;
        string position = ddlPosition.SelectedItem.Text;

        if (position == "All")
        {
            sqldsJobApplicants.FilterExpression = "(fldFirstName LIKE '%" + name + "%' OR fldLastName LIKE '%" + name + "%')";
        }
        else
        {
            sqldsJobApplicants.FilterExpression = "(fldFirstName LIKE '%" + name + "%' OR fldLastName LIKE '%" + name + "%') AND (fldPosition='" + position + "')";
        }
    }

// I but this method in my basepage class -->


    protected bool Visible(object data)
        {
            if (String.IsNullOrEmpty(data.ToString()))
                return false;
            else
                return true;
        }

Hope this helps.