Show successful message after Insert, Update and Delete using C# in ASP.Net

Last Reply 3 months ago By dharmendr

Posted 3 months ago

Hello, 

I created a griedview in asp and I want when inserted, deleted and updated a record, it shows a message that a record has been inserted or deleted or updated successfully.

 

<%@ Page Title="" Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="EmployeesFemale.aspx.cs" Inherits="Employees" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
    <br />
    <br />
    <br />
    
    <asp:GridView ID="GridView1" runat="server" style="margin-left: 28px; margin-top: 76px; margin-bottom: 58px;" Width="776px" AutoGenerateColumns="False" CellPadding="1" DataSourceID="ObjectDataSource1" DataKeyNames="EmployeeF_ID" ForeColor="#333333" ShowFooter="True" ReadOnly="False" EnablePersistedSelection="True" AllowPaging="True">
        <AlternatingRowStyle BackColor="White" />
        <Columns>
              <asp:TemplateField>
                <FooterTemplate>
                  <asp:LinkButton ValidationGroup="INSERT" OnClick="lbInsert_Click" ID="lbInsert" runat="server">Insert</asp:LinkButton>
                </FooterTemplate>
            </asp:TemplateField>
            <asp:CommandField ShowDeleteButton="True" ShowEditButton="True" ShowHeader="True" />
            <asp:TemplateField HeaderText="First Name" SortExpression="EmployeeF_FName">
                <EditItemTemplate>
                    <asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("EmployeeF_FName") %>'></asp:TextBox>
                </EditItemTemplate>
                <ItemTemplate>
                    <asp:Label ID="Label1" runat="server" Text='<%# Bind("EmployeeF_FName") %>'></asp:Label>
                </ItemTemplate>
                 <FooterTemplate>
                  <asp:TextBox ID="TxtFName" runat="server" BorderStyle="None"></asp:TextBox>
                </FooterTemplate>
            </asp:TemplateField>
            <asp:TemplateField HeaderText="Middle Name" SortExpression="EmployeeF_MName">
                <EditItemTemplate>
                    <asp:TextBox ID="TextBox2" runat="server" Text='<%# Bind("EmployeeF_MName") %>'></asp:TextBox>
                </EditItemTemplate>
                <ItemTemplate>
                    <asp:Label ID="Label2" runat="server" Text='<%# Bind("EmployeeF_MName") %>'></asp:Label>
                </ItemTemplate>
                 <FooterTemplate>
                  <asp:TextBox ID="TxtMName" runat="server" BorderStyle="None"></asp:TextBox>
                </FooterTemplate>
            </asp:TemplateField>
            <asp:TemplateField HeaderText="Last Name" SortExpression="EmployeeF_LName">
                <EditItemTemplate>
                    <asp:TextBox ID="TextBox3" runat="server" Text='<%# Bind("EmployeeF_LName") %>'></asp:TextBox>
                </EditItemTemplate>
                <ItemTemplate>
                    <asp:Label ID="Label3" runat="server" Text='<%# Bind("EmployeeF_LName") %>'></asp:Label>
                </ItemTemplate>
                 <FooterTemplate>
                  <asp:TextBox ID="TxtLName" runat="server" BorderStyle="None"></asp:TextBox>
                </FooterTemplate>
            </asp:TemplateField>
            <asp:TemplateField HeaderText="National ID" SortExpression="EmployeeF_ID">
                <EditItemTemplate>
                    <asp:TextBox ID="TextBox4" runat="server" Text='<%# Bind("EmployeeF_ID") %>'></asp:TextBox>
                    <asp:RequiredFieldValidator ID="rfvEditId" runat="server" ErorrMessage="ID is a required field"
                          ControlToValidate="TextBox4" Text="* ID is a required field" ForeColor="Red" ValidationGroup="INSERT">
                        </asp:RequiredFieldValidator>
                </EditItemTemplate>
                <ItemTemplate>
                    <asp:Label ID="Label4" runat="server" Text='<%# Bind("EmployeeF_ID") %>'></asp:Label>
                </ItemTemplate>
                 <FooterTemplate>
                  <asp:TextBox ID="TxtID" runat="server" BorderStyle="None"></asp:TextBox>
                      <asp:RequiredFieldValidator ID="rfvInsertId" runat="server" ErorrMessage="ID is a required field"
                          ControlToValidate="TxtID" Text="* ID is a required field" Font-Size="9" ForeColor="Red" ValidationGroup="INSERT">
                        </asp:RequiredFieldValidator>
                </FooterTemplate>
            </asp:TemplateField>
            <asp:TemplateField HeaderText="Mobile" SortExpression="EmployeeF_Mobile">
                <EditItemTemplate>
                    <asp:TextBox ID="TextBox5" runat="server" Text='<%# Bind("EmployeeF_Mobile") %>'></asp:TextBox>
                </EditItemTemplate>
                <ItemTemplate>
                    <asp:Label ID="Label5" runat="server" Text='<%# Bind("EmployeeF_Mobile") %>'></asp:Label>
                </ItemTemplate>
                 <FooterTemplate>
                  <asp:TextBox ID="TxtMobile" runat="server" BorderStyle="None"></asp:TextBox>
                </FooterTemplate>
            </asp:TemplateField>
            <asp:TemplateField HeaderText="Email" SortExpression="EmployeeF_Email">
                <EditItemTemplate>
                    <asp:TextBox ID="TextBox6" runat="server" Text='<%# Bind("EmployeeF_Email") %>'></asp:TextBox>
                </EditItemTemplate>
                <ItemTemplate>
                    <asp:Label ID="Label6" runat="server" Text='<%# Bind("EmployeeF_Email") %>'></asp:Label>
                </ItemTemplate>
                 <FooterTemplate>
                  <asp:TextBox ID="TxtEmail" runat="server" BorderStyle="None"></asp:TextBox>
                </FooterTemplate>
            </asp:TemplateField>
            <asp:TemplateField HeaderText="Position" SortExpression="EmployeeF_Position">
                <EditItemTemplate>
                    <asp:TextBox ID="TextBox7" runat="server" Text='<%# Bind("EmployeeF_Position") %>'></asp:TextBox>
                </EditItemTemplate>
                <ItemTemplate>
                    <asp:Label ID="Label7" runat="server" Text='<%# Bind("EmployeeF_Position") %>'></asp:Label>
                </ItemTemplate>
                 <FooterTemplate>
                  <asp:TextBox ID="TxtPosition" runat="server" BorderStyle="None"></asp:TextBox>
                </FooterTemplate>
            </asp:TemplateField>
        </Columns>
        <EditRowStyle BackColor="#2461BF" />
        <FooterStyle BackColor="White" Font-Bold="True" ForeColor="White" />
        <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
        <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>
    <br />
    <asp:Label ID="lblmessage" runat="server" Text="Label" ForeColor="Green" Visible="False"></asp:Label>
    <p><asp:Button ID="Button1" ForeColor="White" BackColor="#507CD1" runat="server" Text="Back" PostBackUrl="~/HomeFemale.aspx" style="margin-left: 77px" Width="61px" Height="28px" />
    </p>
    <asp:ValidationSummary ValidationGroup="INSERT" ID="ValidationSummary1" ForeColor="Red" runat="server" />
    <asp:ObjectDataSource ID="ObjectDataSource1" runat="server" SelectMethod="GetAllEmployees" TypeName="Demo.EmployeeF.EmployeeDataAccessLayer" UpdateMethod="UpdateEmployee" DeleteMethod="DeleteEmployee"  InsertMethod="InsertEmployee">
        <DeleteParameters>
            <asp:Parameter Name="EmployeeF_ID" Type="Int32" />
        </DeleteParameters>
        <InsertParameters>
            <asp:Parameter Name="EmployeeF_ID" Type="Int32" />
            <asp:Parameter Name="EmployeeF_FName" Type="String" />
            <asp:Parameter Name="EmployeeF_MName" Type="String" />
            <asp:Parameter Name="EmployeeF_LName" Type="String" />
            <asp:Parameter Name="EmployeeF_Mobile" Type="String" />
            <asp:Parameter Name="EmployeeF_Email" Type="String" />
            <asp:Parameter Name="EmployeeF_Position" Type="String" />
        </InsertParameters>
        <UpdateParameters>
            <asp:Parameter Name="EmployeeF_ID" Type="Int32" />
            <asp:Parameter Name="EmployeeF_FName" Type="String" />
            <asp:Parameter Name="EmployeeF_MName" Type="String" />
            <asp:Parameter Name="EmployeeF_LName" Type="String" />
            <asp:Parameter Name="EmployeeF_Mobile" Type="String" />
            <asp:Parameter Name="EmployeeF_Email" Type="String" />
            <asp:Parameter Name="EmployeeF_Position" Type="String" />
        </UpdateParameters>
    </asp:ObjectDataSource>
</asp:Content>

code behind

 

public partial class Employees : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void lbInsert_Click(object sender, EventArgs e)
    {
        ObjectDataSource1.InsertParameters["EmployeeF_FName"].DefaultValue = ((TextBox)GridView1.FooterRow.FindControl("TxtFName")).Text;
        ObjectDataSource1.InsertParameters["EmployeeF_MName"].DefaultValue = ((TextBox)GridView1.FooterRow.FindControl("TxtMName")).Text;
        ObjectDataSource1.InsertParameters["EmployeeF_LName"].DefaultValue = ((TextBox)GridView1.FooterRow.FindControl("TxtLName")).Text;
        ObjectDataSource1.InsertParameters["EmployeeF_ID"].DefaultValue = ((TextBox)GridView1.FooterRow.FindControl("TxtID")).Text;
        ObjectDataSource1.InsertParameters["EmployeeF_Mobile"].DefaultValue = ((TextBox)GridView1.FooterRow.FindControl("TxtMobile")).Text;
        ObjectDataSource1.InsertParameters["EmployeeF_Email"].DefaultValue = ((TextBox)GridView1.FooterRow.FindControl("TxtEmail")).Text;
        ObjectDataSource1.InsertParameters["EmployeeF_Position"].DefaultValue = ((TextBox)GridView1.FooterRow.FindControl("TxtPosition")).Text;
        ObjectDataSource1.Insert();
    }
    
    
}

dataaccesslayer

 

public class EmployeeDataAccessLayer
    {
        public static void UpdateEmployee(int EmployeeF_ID, string EmployeeF_FName, string EmployeeF_MName, string EmployeeF_LName, string EmployeeF_Mobile, string EmployeeF_Email, string EmployeeF_Position)
        {
            string CS = "server=localhost; userid=; password=; database=; allowuservariables=True";
            using (MySqlConnection connection = new MySqlConnection(CS))
            {
                string UpdateQuery = " Update Employees_female SET EmployeeF_FName=@EmployeeF_FName," + " EmployeeF_MName=@EmployeeF_MName," + " EmployeeF_LName=@EmployeeF_LName," + " EmployeeF_Mobile=@EmployeeF_Mobile," + "EmployeeF_Email=@EmployeeF_Email," + "EmployeeF_Position=@EmployeeF_Position WHERE EmployeeF_ID=@EmployeeF_ID";
                MySqlCommand cmd = new MySqlCommand(UpdateQuery, connection);
                cmd.Connection.Open();
                MySqlParameter paramEmployeeF_FName = new MySqlParameter("@EmployeeF_FName", EmployeeF_FName);
                cmd.Parameters.Add(paramEmployeeF_FName);
                MySqlParameter paramEmployeeF_MName = new MySqlParameter("@EmployeeF_MName", EmployeeF_MName);
                cmd.Parameters.Add(paramEmployeeF_MName);
                MySqlParameter paramEmployeeF_LName = new MySqlParameter("@EmployeeF_LName", EmployeeF_LName);
                cmd.Parameters.Add(paramEmployeeF_LName);
                MySqlParameter paramEmployeeF_ID = new MySqlParameter("@EmployeeF_ID", EmployeeF_ID);
                cmd.Parameters.Add(paramEmployeeF_ID);
                MySqlParameter paramEmployeeF_Mobile = new MySqlParameter("@EmployeeF_Mobile", EmployeeF_Mobile);
                cmd.Parameters.Add(paramEmployeeF_Mobile);
                MySqlParameter paramEmployeeF_Email = new MySqlParameter("@EmployeeF_Email", EmployeeF_Email);
                cmd.Parameters.Add(paramEmployeeF_Email);
                MySqlParameter paramEmployeeF_Position = new MySqlParameter("@EmployeeF_Position", EmployeeF_Position);
                cmd.Parameters.Add(paramEmployeeF_Position);
                cmd.ExecuteNonQuery();
                cmd.Connection.Close();

            }
        }
        public static List<Employee> GetAllEmployees()
        {
            List<Employee> listEmployees = new List<Employee>();
            string CS = "server=localhost; userid=; password=; database=; allowuservariables=True";
            using (MySqlConnection connection = new MySqlConnection(CS))
            {
                MySqlCommand cmd = new MySqlCommand("Select * from employees_female", connection);
                connection.Open();
                MySqlDataReader rdr = cmd.ExecuteReader();
                while (rdr.Read())
                {
                    Employee employee = new Employee();
                    employee.EmployeeF_FName = rdr["EmployeeF_FName"].ToString();
                    employee.EmployeeF_MName = rdr["EmployeeF_MName"].ToString();
                    employee.EmployeeF_LName = rdr["EmployeeF_LName"].ToString();
                    employee.EmployeeF_ID = Convert.ToInt32(rdr["EmployeeF_ID"]);
                    employee.EmployeeF_Mobile = rdr["EmployeeF_Mobile"].ToString();
                    employee.EmployeeF_Email = rdr["EmployeeF_Email"].ToString();
                    employee.EmployeeF_Position = rdr["EmployeeF_Position"].ToString();

                    listEmployees.Add(employee);


                }
            }
            return listEmployees;
        }
        public static void DeleteEmployee(int EmployeeF_ID)
        {
            string CS = "server=localhost; userid=; password=; database=; allowuservariables=True";
            using (MySqlConnection connection = new MySqlConnection(CS))
            {
                string UpdateQuery = " Delete from employees_female WHERE EmployeeF_ID=@EmployeeF_ID";
                MySqlCommand cmd = new MySqlCommand(UpdateQuery, connection);
                MySqlParameter param = new MySqlParameter("@EmployeeF_ID", EmployeeF_ID);
                cmd.Parameters.Add(param);
                cmd.Connection.Open();
                cmd.ExecuteNonQuery();
                cmd.Connection.Close();

            }

        }

        public static void InsertEmployee(int EmployeeF_ID, string EmployeeF_FName, string EmployeeF_MName, string EmployeeF_LName, string EmployeeF_Mobile, string EmployeeF_Email, string EmployeeF_Position)
        {
            string CS = "server=localhost; userid=; password=; database=; allowuservariables=True";
            using (MySqlConnection connection = new MySqlConnection(CS))
            {
                string UpdateQuery = " INSERT INTO Employees_female (EmployeeF_FName, EmployeeF_Mname, EmployeeF_LName, EmployeeF_ID, EmployeeF_Mobile, EmployeeF_Email, EmployeeF_Position)" + " VALUES (@EmployeeF_FName,@EmployeeF_MName,@EmployeeF_LName,@EmployeeF_ID,@EmployeeF_Mobile,@EmployeeF_Email,@EmployeeF_Position)";
                MySqlCommand cmd = new MySqlCommand(UpdateQuery, connection);
                MySqlParameter paramEmployeeF_FName = new MySqlParameter("@EmployeeF_FName", EmployeeF_FName);
                cmd.Parameters.Add(paramEmployeeF_FName);
                MySqlParameter paramEmployeeF_MName = new MySqlParameter("@EmployeeF_MName", EmployeeF_MName);
                cmd.Parameters.Add(paramEmployeeF_MName);
                MySqlParameter paramEmployeeF_LName = new MySqlParameter("@EmployeeF_LName", EmployeeF_LName);
                cmd.Parameters.Add(paramEmployeeF_LName);
                MySqlParameter paramEmployeeF_ID = new MySqlParameter("@EmployeeF_ID", EmployeeF_ID);
                cmd.Parameters.Add(paramEmployeeF_ID);
                MySqlParameter paramEmployeeF_Mobile = new MySqlParameter("@EmployeeF_Mobile", EmployeeF_Mobile);
                cmd.Parameters.Add(paramEmployeeF_Mobile);
                MySqlParameter paramEmployeeF_Email = new MySqlParameter("@EmployeeF_Email", EmployeeF_Email);
                cmd.Parameters.Add(paramEmployeeF_Email);
                MySqlParameter paramEmployeeF_Position = new MySqlParameter("@EmployeeF_Position", EmployeeF_Position);
                cmd.Parameters.Add(paramEmployeeF_Position);
                cmd.Connection.Open();
                cmd.ExecuteNonQuery();
                cmd.Connection.Close();
                
            }      
        }
    }

What the code should i write and where?

You are viewing reply posted by: dharmendr 3 months ago.
Posted 3 months ago

Hi yara,

Refer the below.

ScriptManager.RegisterStartupScript Method

Registers a startup script block with the ScriptManager control and adds the script block to the page.

https://msdn.microsoft.com/en-us/library/system.web.ui.scriptmanager.registerstartupscript%28v=vs.110%29.aspx

ClientScriptManager.RegisterStartupScript Method

Registers the startup script with the Page object using a type, a key, a script literal, and a Boolean value indicating whether to add script tags.

https://msdn.microsoft.com/en-us/library/z9h4dk8y%28v=vs.110%29.aspx

 

I agree, here is the link: http://e-iceblue.com/free-api