Grid view to display data as soon as we hit add button i,e before refreshing not working: solved

Question

0.00/5 (No votes)

See more:

Hi
Can some one help me please.
I have a Gridview which displays the new data entered from the text box and drop downlist with a add button .But it displays once we refresh or postback the
page.

C#

<asp:GridView 
            ID="GridView1" runat="server" AllowPaging="True" AutoGenerateColumns="False" 
            CellPadding="4" DataKeyNames="SettingId" DataSourceID="SqlDataSource5" 
            ForeColor="#333333" GridLines="None" Height="55px" Width="753px">
            <AlternatingRowStyle BackColor="White" />
            <Columns>
                <asp:BoundField DataField="SettingType" HeaderText="SettingType" 
                    SortExpression="SettingType" Visible="False" />
                <asp:BoundField DataField="Auth" HeaderText="Auth" 
                    SortExpression="Auth" Visible="False" />
                <asp:BoundField DataField="Group" HeaderText="Group" 
                    SortExpression="Group" Visible="False" />
                <asp:BoundField DataField="Branches" HeaderText="Branches" 
                    SortExpression="Branches" />
                <asp:BoundField DataField="Category" HeaderText="Category" 
                    SortExpression="Category" />
                <asp:BoundField DataField="Bind" HeaderText="Bind" 
                    SortExpression="Bind" Visible="False" />
                <asp:BoundField DataField="Subject" HeaderText="Subject" 
                    SortExpression="Subject" />
                <asp:BoundField DataField="Year" HeaderText="Year" 
                    SortExpression="Year" />
                <asp:BoundField DataField="Id" HeaderText="Id" 
                    InsertVisible="False" ReadOnly="True" SortExpression="Id" 
                    Visible="False" />
                <asp:TemplateField ShowHeader="False">
                    <ItemTemplate>
                        <asp:Button ID="Button1" runat="server" CausesValidation="false" onclientclick="return confirm('Are you sure you want to delete this Setting?');"
                            CommandName="Delete" Text="" />
                    </ItemTemplate>
                    <ControlStyle CssClass="btnstyle" Height="30px" Width="30px" />
                </asp:TemplateField>
            </Columns>
            <EditRowStyle BackColor="#2461BF" />
            <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
            <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" 
                HorizontalAlign="Left" />
            <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
            <RowStyle BackColor="#EFF3FB" />
            <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
            <SortedAscendingCellStyle BackColor="#F5F7FB" />
            <SortedAscendingHeaderStyle BackColor="#6D95E1" />
            <SortedDescendingCellStyle BackColor="#E9EBEF" />
            <SortedDescendingHeaderStyle BackColor="#4870BE" />
        </asp:GridView>
        <asp:SqlDataSource ID="SqlDataSource5" runat="server" 
            ConnectionString="<% %>" 
            DeleteCommand="DELETE FROM Setting WHERE (Id = @Id)" 
            
            SelectCommand="SELECT SettingType, Code, Group, Branch, Category, Binding, Subject, Issues, Year, Id FROM Setting WHERE (SettingType = 'something')">
            <DeleteParameters>
                <asp:Parameter Name="Id" />
            </DeleteParameters>
        </asp:SqlDataSource>

I want the grid to show the data inserted as soon as i hit add without post back or refreshing.

Posted 17-Apr-13 0:02am

babli3

Updated 17-Apr-13 1:54am

v3

Add a Solution

Comments

Dnyaneshwar Kondbale 17-Apr-13 6:04am

Use Update panel for the same. put grid view in update panel and update mode is conditional.

babli3 17-Apr-13 6:05am

ok let me try thanks

babli3 17-Apr-13 6:18am

sorry its not updating still

Dnyaneshwar Kondbale 17-Apr-13 6:20am

are You adding tigers for update panel.???

babli3 17-Apr-13 6:21am

no i didnt , i will add now. thanks

babli3 17-Apr-13 6:22am

i have to add triggers to the add button isnt.

Dnyaneshwar Kondbale 17-Apr-13 6:23am

Yup like

<asp:AsyncPostBackTrigger ControlID="btnUpload" EventName="Click" />

and its work for you..

babli3 17-Apr-13 6:38am

Its working Thanks!

Rockstar_ 17-Apr-13 6:39am

You simply call the GridBind() method after inserting the data into database...

babli3 17-Apr-13 6:41am

Thanks its working now

Maciej Los 17-Apr-13 7:44am

Is your issue solved?
Please, mark it as "solved".

babli3 17-Apr-13 7:48am

HOW TO MARK AS SOLVE ... I CANT FIND ANYTHING

Maciej Los 17-Apr-13 7:50am

Use "Improve question" widget and add to subject word: [SOLVED] ;)

ZurdoDev 17-Apr-13 7:55am

Add a solution and then accept it as the answer.

1 solution

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)

babli3 · Accepted Answer · 2013-04-17T02:00:00

C#

<asp:scriptmanager id="ScriptManager1" runat="server" xmlns:asp="#unknown">
    </asp:scriptmanager>
<asp:updatepanel xmlns:asp="#unknown">
            ID="UpdatePanel1" runat="server" UpdateMode="Conditional">
            <contenttemplate>
         
// you will have your grid here

</contenttemplate>
<asp:asyncpostbacktrigger controlid="btnUpload" eventname="Click" />
</asp:updatepanel>

in code behind:

on button click event

SQL

GridView1.DataBind();
   UpdatePanel1.Update();