Executing Insert, Update, and Delete Commands : SqlDataSource « ADO.net Database « ASP.Net

Home
ASP.Net
1.ADO.net Database
2.Ajax
3.Asp Control
4.Collections
5.Components
6.Data Binding
7.Development
8.File Directory
9.HTML Control
10.Language Basics
11.Login Security
12.Mobile Control
13.Network
14.Page
15.Request
16.Response
17.Server
18.Session Cookie
19.Sitemap
20.Theme Style
21.User Control and Master Page
22.Validation by Control
23.Validation by Function
24.WebPart
25.WPF
26.XML
ASP.Net » ADO.net Database » SqlDataSource 
Executing Insert, Update, and Delete Commands


<%@ Page Language="C#" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN"
"http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
<script runat="server">
    protected void btnAddEntry_Click(object sender, EventArgs e)
    {
        srcGuestBook.InsertParameters["Name"].DefaultValue = txtName.Text;
        srcGuestBook.InsertParameters["Comments"].DefaultValue = txtComments.Text;
        srcGuestBook.Insert();
    }
</script>

<html xmlns="http://www.w3.org/1999/xhtml" >
<head id="Head1" runat="server">
    <title>Execute Insert</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
    <asp:Label
        id="lblName"
        Text="Name:"
        AssociatedControlId="txtName"
        Runat="server" />
    <asp:TextBox
        id="txtName"
        Runat="server" />
    <asp:Label
        id="lblComments"
        Text="Comments:"
        AssociatedControlId="txtComments"
        Runat="server" />
    <asp:TextBox
        id="txtComments"
        TextMode="MultiLine"
        Columns="50"
        Rows="2"
        Runat="server" />
    <asp:Button
        id="btnAddEntry"
        Text="Add Entry"
        Runat="server" OnClick="btnAddEntry_Click" />
    <asp:GridView
        id="grdGuestBook"
        DataSourceId="srcGuestBook"
        Runat="server" />
    <asp:SqlDataSource
        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">
        <InsertParameters>
            <asp:Parameter Name="Name" />
            <asp:Parameter Name="Comments" />
        </InsertParameters>
    </asp:SqlDataSource>
    </div>
    </form>
</body>
</html>

File: Web.config

<configuration>
  <connectionStrings>
    <add name="GuestBook" 
         connectionString="Data Source=.\SQLEXPRESS;
         AttachDbFilename=|DataDirectory|MyDatabase.mdf;Integrated Security=True;User Instance=True" />
  </connectionStrings>
</configuration>

 
Related examples in the same category
1.Connection to Sql Express (VB.net)
2.Static Sql connection data source (C#)
3.Cache Sql data source (C#)
4.SqlDataSource for Oracle
5.Typical SqlDataSource control generated by Visual Studio
6.Adding the DataSourceMode property to a SqlDataSource control
7.SqlDataSource Simple
8.SqlDataSource Update
9.SqlDataSource Update Stored Procedure
10.SqlDataSource with Parameters
11.Change parameters of SqlDataSource in your own code
12.Executing Inline SQL Statements: SelectCommand, InsertCommand, UpdateCommand, DeleteCommand
13.Programmatically Executing SqlDataSource Commands
14.Executing Select Commands
15.SqlDataSource with select command
16.Adding the ConflictDetection property to a SqlDataSource control
17.Detecting concurrency errors after updating data (C#)
18.Detecting concurrency errors after updating data (VB)
19.Adding an InsertCommand to the SqlDataSource control
20.Filtering SqlDataSource data with a FilterExpression
21.Adding delete functionality to the SqlDataSource Control
22.Adding a section to the SqlDataSource control
23.Adding an UpdateCommand to a SqlDataSource control
24.Adding UpdateParameters to the SqlDataSource control
25.Adding the AutoGenerateEditButton attribute to a SqlDataSource control
26.Executing a Stored Procedure using SqlDataSource Control
27.Handling Null values in the SqlDataSource Control
28.Renaming Parameters passed to a Stored Procedure by handling the SqlDataSource Events
29.Deletion using SqlDataSource Control
30.Programmatically adding a SqlDataSource control to the Page
31.Set sqlCacheDependency
java2s.com  | Contact Us | Privacy Policy
Copyright 2009 - 12 Demo Source and Support. All rights reserved.
All other trademarks are property of their respective owners.