ADO Database ASP.Net

  1. Home
  2. ASP.Net
  3. ADO Database
  4. Executing Insert, Update, and Delete Commands
<%@ Page Language="C#" %>
"http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">

    protected void btnAddEntry_Click(object sender, EventArgs e)
    {
        srcGuestBook.InsertParameters["Name"].DefaultValue = txtName.Text;
        srcGuestBook.InsertParameters["Comments"].DefaultValue = txtComments.Text;
        srcGuestBook.Insert();
    }



    Execute Insert


    
    

            id="lblName"
        Text="Name:"
        AssociatedControlId="txtName"
        Runat="server" />
            id="txtName"
        Runat="server" />
            id="lblComments"
        Text="Comments:"
        AssociatedControlId="txtComments"
        Runat="server" />
            id="txtComments"
        TextMode="MultiLine"
        Columns="50"
        Rows="2"
        Runat="server" />
            id="btnAddEntry"
        Text="Add Entry"
        Runat="server" OnClick="btnAddEntry_Click" />
            id="grdGuestBook"
        DataSourceId="srcGuestBook"
        Runat="server" />
            id="srcGuestBook"
        ConnectionString="<%$ ConnectionStrings:GuestBook %>"
        SelectCommand="SELECT Name,Comments FROM GuestBook
            ORDER BY Id DESC"
        InsertCommand="INSERT GuestBook (Name,Comments)
            VALUES (@Name,@Comments)"
        Runat="server">
        
            
            
        
    
    

    


File: Web.config

  
             connectionString="Data Source=.\SQLEXPRESS;
         AttachDbFilename=|DataDirectory|MyDatabase.mdf;Integrated Security=True;User Instance=True" />