Binding FormView and Datatable using Object DataSource in VB.NET

Binding FormView with Datatable, using ObjectDataSource VB.NET

How to Bind FormView with Datatable using ObjectDataSource VB.NET

---

Step 1) Create a class name it as DATATABLECRUD.VB

•  Add 4 methods  for CRUD Operations

1. GetStudentDetails   --> R for Get Records
2. DeleteStudentInfo  --> D for Delete Record
3. UpdateStudentInfo --> U for Update recor
4. AddStudentInfo   -->         C for Create Record
5. 
   
   Add One more class called StudentInfo

• It has 3 public properties

1. SerialNo   int
2. StudentName  String
3. Course   String
4. 
   U can add as many fields u want,because this is a demo ,Explains how to use Databinding in FormView using DataTable as DataSource,CRUD operations managed by ObjectDataSource.
5. 
   //You can add DataAnnotations using System.ComponentModel.DataAnnotations; otherwise remove
6. 
   
7. Imports System
8. Imports System.Collections.Generic
9. Imports System.Linq
10. Imports System.Web
11. Imports System.Data
12. Imports System.ComponentModel.DataAnnotations
13. Namespace WebApplication1
14. Public Class StudentInfo
15. <Key> _
16. Public Property SerialNo() As Int32
17. Get
18. Return m_SerialNo
19. End Get
20. Set
21. m_SerialNo = Value
22. End Set
23. End Property
24. Private m_SerialNo As Int32
25. <Required(ErrorMessage := "Student Name Required")> _
26. Public Property StudentName() As [String]
27. Get
28. Return m_StudentName
29. End Get
30. Set
31. m_StudentName = Value
32. End Set
33. End Property
34. Private m_StudentName As [String]
35. <Required> _
36. Public Property Course() As [String]
37. Get
38. Return m_Course
39. End Get
40. Set
41. m_Course = Value
42. End Set
43. End Property
44. Private m_Course As [String]
45. End Class
46. Public Class DTOP
47. Private brandsTable As New DataTable()
48. Private context As HttpContext = HttpContext.Current
49. Private session As System.Web.SessionState.HttpSessionState = Nothing
50. 
    
51. Public Sub New()
52. AddDataTableColumns()
53. AddDataTableRows()
54. 'HttpContext context = HttpContext.Current;
55. 'System.Web.SessionState.HttpSessionState session = context.Session;
56. session = context.Session
57. If session("tbl") Is Nothing Then
58. session("tbl") = brandsTable
59. Else
60. brandsTable = DirectCast(session("tbl"), DataTable)
61. 
    
62. End If
63. End Sub
64. Private Sub AddDataTableColumns()
65. Dim ID As New DataColumn("SerialNo", GetType(System.Int32))
66. ID.AutoIncrement = True
67. ID.AutoIncrementSeed = 1000
68. ID.AutoIncrementStep = 16
69. 
    
70. Dim BrandName As New DataColumn("StudentName", GetType(System.String))
71. BrandName.MaxLength = 100
72. 
    
73. Dim BrandImage As New DataColumn("Course")
74. BrandImage.DataType = GetType([String])
75. 'typeof(System.Web.UI.WebControls.Image);
76. brandsTable.Columns.Add(ID)
77. brandsTable.Columns.Add(BrandName)
78. brandsTable.Columns.Add(BrandImage)
79. 
    
80. End Sub
81. Private Sub AddDataTableRows()
82. Dim row1 As DataRow = brandsTable.NewRow()
83. row1(1) = "Bata"
84. row1(2) = "C#"
85. brandsTable.Rows.Add(row1)
86. row1 = brandsTable.NewRow()
87. row1(1) = "'Brands"
88. row1(2) = "ASP.NET"
89. brandsTable.Rows.Add(row1)
90. row1 = brandsTable.NewRow()
91. row1(1) = "MODULES"
92. row1(2) = "JAVA"
93. brandsTable.Rows.Add(row1)
94. 
    
95. End Sub
96. 
    
97. Public Function GetStudentTable() As List(Of StudentInfo)
98. Dim studentquery = 
99. Return studentquery.ToList()
100. End Function
101. Public Function AddRows(sInfo As StudentInfo) As Boolean
102. 
     
103. 
     
104. brandsTable = DirectCast(session("tbl"), DataTable)
105. 'brandsTable = (DataTable)HttpContext.Current.Session["tbl"];
106. Dim row As DataRow = brandsTable.NewRow()
107. row(1) = sInfo.StudentName
108. row(2) = sInfo.Course
109. brandsTable.Rows.Add(row)
110. HttpContext.Current.Session.Add("tbl", brandsTable)
111. Return True
112. End Function
113. Public Function UpdateRows(sInfo As StudentInfo) As Boolean
114. Dim bRet As Boolean = False
115. brandsTable = DirectCast(session("tbl"), DataTable)
116. Dim row As DataRow = brandsTable.AsEnumerable().SingleOrDefault(Function(s) s.Field(Of Int32)(0) = sInfo.SerialNo)
117. If row IsNot Nothing Then
118. row(1) = sInfo.StudentName
119. row(2) = sInfo.Course
120. bRet = True
121. session("tbl") = brandsTable
122. End If
123. Return bRet
124. End Function
125. Public Function DeleteRows(sInfo As StudentInfo) As Boolean
126. Dim bRet As Boolean = False
127. brandsTable = DirectCast(session("tbl"), DataTable)
128. Dim row As DataRow = brandsTable.AsEnumerable().SingleOrDefault(Function(s) s.Field(Of Int32)(0) = sInfo.SerialNo)
129. If row IsNot Nothing Then
130. brandsTable.Rows.Remove(row)
131. session("tbl") = brandsTable
132. bRet = True
133. End If
134. Return bRet
135. End Function
136. 
     
137. End Class
138. End Namespace
139. 
     
140. 
     Adding ObjectDataSoure to aspx page as shown below
     
     
     Goto  View --> Toolbox

   In Toolbox Under data category  select ObjectDataSource , just drag/double click into aspx 
  as shown below

Step 2)  Goto  design view of aspx page click on object data source

Step 3) Choose a Business Object  i.e  CRUD operations class in our case it is DATATABLECRUD.cs ==> webApplication1.DATATABLECRUD

Step 4)  Use SelectMethod  as GetStudentTable
               as shown below

Step 5) Use UpdateMethod as UpdateRows

 Step 6) InsertMethod as AddRows

 Step 6) UpdateMethod as UpdateRows

 These steps configures ObjectDataSource  for CRUD Operations , here we choose DataTable as Data Source. In same way u can configure for MS-ACCESS/SQL-Server/MYSQL/ORACLE.

Step 4)  Now add FormView to aspx page  and select  datasource (i.e created just now objectdatasourceid1)

 as shown below

        <asp:FormView ID="FormView1" Caption="<h1>FormView Data Operations/CRUD operations/Insert,Update,Delete Operations<h1>" DataKeyNames="SerialNo" runat="server"   EmptyDataText="no data found"  DataSourceID="ObjectDataSource1" GridLines="Both" AllowPaging="True" Width="295px"  >
                    <ItemTemplate>
                        SerialNo:
                <asp:Label ID="SerialNoLabel" runat="server" Text='<%# Bind("SerialNo") %>'></asp:Label><br />
                        StudentName:
                <asp:Label ID="StudentNameLabel" runat="server" Text='<%# Bind("StudentName") %>'></asp:Label><br />
                        Course:
                 <asp:Label ID="CourseLabel" runat="server" Text='<%# Bind("Course") %>'></asp:Label><br />
                        <asp:LinkButton ID="EditButton" runat="server" CausesValidation="False" CommandName="Edit" Text="Edit" />
                        &nbsp;<asp:LinkButton ID="DeleteButton" runat="server" CausesValidation="False" CommandName="Delete" Text="Delete" />
                        &nbsp;<asp:LinkButton ID="NewButton" runat="server" CausesValidation="False" CommandName="New" Text="New" />
            </ItemTemplate>
                    <EditItemTemplate>
                        SerialNo:
                        <asp:TextBox ID="SerialNoTextBox" runat="server" Text='<%# Bind("SerialNo") %>'  />
                        <br />
                        StudentName:
                        <asp:TextBox ID="StudentNameTextBox" runat="server" Text='<%# Bind("StudentName") %>' />
                        <br />
                        Course:
                        <asp:TextBox ID="CourseTextBox" runat="server" Text='<%# Bind("Course") %>' />
                        <br />
                        <asp:LinkButton ID="UpdateButton" runat="server" CausesValidation="True" CommandName="Update" Text="Update" />
                        &nbsp;<asp:LinkButton ID="UpdateCancelButton" runat="server" CausesValidation="False" CommandName="Cancel" Text="Cancel" />
                    </EditItemTemplate>
            <InsertItemTemplate>
                SerialNo:
                <asp:TextBox runat="server"  ID="SerialNoTextBox" Text='<%# Bind("SerialNo") %>'></asp:TextBox> <br />
                StudentName:
                <asp:TextBox runat="server" Text='<%# Bind("StudentName") %>' ID="StudentNameTextBox"></asp:TextBox> 
                <br />
                Course:
                <asp:TextBox ID="CourseTextBox" runat="server" Text='<%# Bind("Course") %>'  />
                <br />
                <asp:LinkButton ID="InsertButton" runat="server" CausesValidation="True" CommandName="Insert" Text="Insert" />
                &nbsp;<asp:LinkButton ID="InsertCancelButton" runat="server" CausesValidation="False" CommandName="Cancel" Text="Cancel" />
                </InsertItemTemplate>

        </asp:FormView>

Step 5)  Above step will automatically generate ItemTemplate, EditTemplates,InsertTemplate in FormView.

FormView SelectMethod OUTPUT

FormView Insert Operation Output

FormView Update Operation Output

FormView Delete Operation

Above article explains databind to FormView in ASP.NET USING c#, Object data Source used for Data Source Navigator. This process Simplifies coding . Makes easier to maintain.