Click here to Skip to main content
15,886,067 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hello Friends,

Am working on Asp.net, C#, SqlServer 2005.

and now am working on Asp.net Gridview with Edit delete Functions in it using SqlDatasource.

Edit Delete is working fine, But i need Confirmation Message for editing and deleting the records.

For Editing i need the message as -> Are you sure you want to delete this record ?
For Updating I need the message as -> Records Updated Successfully.

This is My Gridview Code using SQL DATASOURCE.........

XML
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
                    DataSourceID="SqlDataSource1" HorizontalAlign="Center" Width="800px"
                    AllowPaging="True" AutoGenerateDeleteButton="True"
                    AutoGenerateEditButton="True" BackColor="#E0E0E0" CellPadding="5"
                    CellSpacing="1" DataKeyNames="Id">
                    <Columns>
                        <asp:BoundField DataField="Id" HeaderText="Id" InsertVisible="False"
                            ReadOnly="True" SortExpression="Id" Visible="false"/>
                        <asp:BoundField DataField="UserName" HeaderText="UserName"
                            SortExpression="UserName" />
                        <asp:BoundField DataField="Password" HeaderText="Password"
                            SortExpression="Password" />
                        <asp:BoundField DataField="FirstName" HeaderText="FirstName"
                            SortExpression="FirstName" />
                        <asp:BoundField DataField="LastName" HeaderText="LastName"
                            SortExpression="LastName" />
                        <asp:BoundField DataField="Email" HeaderText="Email" SortExpression="Email" />
                    </Columns>
                    <HeaderStyle BackColor="#FDCB0A" HorizontalAlign="Center" />
                </asp:GridView>
                <asp:SqlDataSource ID="SqlDataSource1" runat="server"
                    ConnectionString="<%$ ConnectionStrings:AdminDBConnectionString %>"

                    SelectCommand="SELECT [Id], [UserName], [Password], [FirstName], [LastName], [Email] FROM [FidsAdminLogin]"
                    DeleteCommand="DELETE FROM AdminLogin WHERE (Id = @Id)"
                    UpdateCommand="UPDATE AdminLogin SET UserName = @UserName, Password = @Password, FirstName = @FirstName, LastName = @Lastname, Email = @Email WHERE (Id = @Id)">
                </asp:SqlDataSource>




Please help me, Just i Need a Pop up message after the record deleted and the record Edited.

Thanks in ADVANCE.
Posted

1 solution

 
Share this answer
 
Comments
Software Engineer 892 27-Nov-12 1:11am    
This is done by coding, I used Sql Datasource.

Please help, How to display Confirmation Message using SqlDATASOURCE.
[no name] 27-Nov-12 1:14am    
That works behind the scene.. You should go with what I have suggested.. Try to understand all that code..

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900