ObjectDataSource and backend database : ObjectDataSource « ADO.net Database « ASP.Net






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

ObjectDataSource and backend database



<%@ Page Language="VB" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>Untitled Page</title>
</head>
<body>
    <form id="form1" runat="server">
        <asp:GridView ID="GridView1" runat="server" DataSourceID="ObjectDataSource1">
            <Columns>
                <asp:CommandField ShowEditButton="True" />
            </Columns>
        </asp:GridView>
        <asp:ObjectDataSource ID="ObjectDataSource1" runat="server" SelectMethod="getAuthors" TypeName="Authors" UpdateMethod="updateAuthors">
            <UpdateParameters>
                <asp:Parameter Name="au_id" Type="String" />
                <asp:Parameter Name="au_fname" Type="String" />
                <asp:Parameter Name="au_lname" Type="String" />
            </UpdateParameters>
        </asp:ObjectDataSource>
    </div>
    </form>
</body>
</html>

File: ~\App_Code\Authors.cs

Imports System.Data.SqlClient
Imports System.Data

Imports Microsoft.VisualBasic

Public Class Authors

    Public Function getAuthors() As DataSet
        Dim conn As New SqlConnection( ConfigurationManager.ConnectionStrings("pubsConnectionString").ConnectionString)
        Dim adapter As New SqlDataAdapter( "SELECT au_id, au_fname, au_lname FROM Authors", conn)
        Dim ds As New DataSet
        adapter.Fill(ds, "Authors")
        Return ds
    End Function

    Public Sub updateAuthors(ByVal au_id As String, ByVal au_fname As String, ByVal au_lname As String)
        Dim conn As New SqlConnection(ConfigurationManager.ConnectionStrings ("pubsConnectionString").ConnectionString)

        Dim adapter As New SqlDataAdapter( "SELECT au_id, au_fname, au_lname " & "FROM Authors WHERE au_id=@au_id", conn)

        Dim ds As New DataSet
        adapter.SelectCommand.Parameters.Add( "@au_id", SqlDbType.NVarChar, 11).Value = au_id
        adapter.Fill(ds, "Authors")

        With ds.Tables(0).Rows(0)
            .Item("au_fname") = au_fname
            .Item("au_lname") = au_lname
        End With
        Dim cb As New SqlCommandBuilder(adapter)
        adapter.Update(ds, "Authors")
    End Sub

End Class








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 ObjectDataSource Control Events
8.Handling Method Errors
9.Handling the Object Creating Event
10.Concurrency and the ObjectDataSource Control, ConflictDetection: CompareAllValues / OverwriteChanges
11.Creating a Custom ObjectDataSource Control
12.Creating Custom Parameter Objects
13.Creating a Page Property Parameter
14.Define your own collection for ObjectDataSource
15.objectdatasource with control parameter
16.GridView with ObjectDataSource
17.ObjectDataSource with selectmethod, deletemethod, updatemethod, insertmethod
18.ObjectDataSource based on XML