Handling ObjectDataSource Control Events : ObjectDataSource « ADO.net Database « ASP.Net






  1. ASP.Net
  2. ADO.net Database
  3. ObjectDataSource

Handling ObjectDataSource Control Events


<%@ 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 srcGuestbook_Inserting(object sender, ObjectDataSourceMethodEventArgs e)
    {
        e.InputParameters.Add("IPAddress", Request.UserHostAddress);
    }
</script>
<html xmlns="http://www.w3.org/1999/xhtml">
<body>
    <form id="form1" runat="server">
    <div>
    <asp:FormView
        id="frmGuestbook"
        DataSourceID="srcGuestbook"
        DefaultMode="Insert"
        Runat="server">
        <InsertItemTemplate>
        <asp:Label
            ID="lblComment"
            Text="Comment:"
            AssociatedControlID="txtComment"
            Runat="server" />
        <asp:TextBox
            id="txtComment"
            Text='<%# Bind("comment") %>'
            TextMode="MultiLine"
            Columns="50"
            Rows="4"
            Runat="server" />
        <asp:Button
            id="btnInsert"
            Text="Add Entry"
            CommandName="Insert"
            Runat="server" />
         </InsertItemTemplate>
    </asp:FormView>
    <asp:GridView
        id="grdGuestbook"
        DataSourceID="srcGuestbook"
        CssClass="guestbook"
        Runat="server" />

    <asp:ObjectDataSource
        id="srcGuestbook"
        TypeName="Guestbook"
        SelectMethod="GetEntries"
        InsertMethod="AddEntry"
        OnInserting="srcGuestbook_Inserting"
        Runat="server" />

    </div>
    </form>
</body>
</html>

File: Guestbook.cs

using System;
using System.Data;
using System.Data.SqlClient;
using System.Web.Configuration;
public class Guestbook
{
    private string _conString;

    public SqlDataReader GetEntries()
    {
        SqlConnection con = new SqlConnection(_conString);

        SqlCommand cmd = new SqlCommand();
        cmd.Connection = con;
        cmd.CommandText = "SELECT Id,IPAddress,Comment,EntryDate FROM Guestbook";

        con.Open();
        return cmd.ExecuteReader(CommandBehavior.CloseConnection);
     }

     public void AddEntry(string IPAddress, string comment)
     {
         SqlConnection con = new SqlConnection(_conString);

         SqlCommand cmd = new SqlCommand();
         cmd.Connection = con;
         cmd.CommandText = "INSERT Guestbook (IPAddress,Comment)" + " VALUES (@IPAddress, @Comment)";

         cmd.Parameters.AddWithValue("@IPAddress", IPAddress);
         cmd.Parameters.AddWithValue("@Comment", comment);

         using (con)
         {
             con.Open();
             cmd.ExecuteNonQuery();
         }
     }

     public Guestbook()
     {         
         _conString = WebConfigurationManager.ConnectionStrings["Guestbook"]. ConnectionString;
     }
}

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.Binding to a LINQ to SQL Query
2.Binding to a Web Service
3.Using Parameters with the ObjectDataSource Control
4.Using Different Parameter Types
5.Passing Objects as Parameters
6.Filtering Data
7.Handling Method Errors
8.Handling the Object Creating Event
9.Concurrency and the ObjectDataSource Control, ConflictDetection: CompareAllValues / OverwriteChanges
10.Creating a Custom ObjectDataSource Control
11.Creating Custom Parameter Objects
12.Creating a Page Property Parameter
13.Define your own collection for ObjectDataSource
14.objectdatasource with control parameter
15.GridView with ObjectDataSource
16.ObjectDataSource with selectmethod, deletemethod, updatemethod, insertmethod
17.ObjectDataSource based on XML
18.ObjectDataSource and backend database