Binding FormView with Datatable, using ObjectDataSource C#

How to Bind FormView with Datatable using ObjectDataSource C#

---

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

•  Add 4 methods

1. GetStudentDetails
2. DeleteStudentInfo
3. UpdateStudentInfo
4. AddStudentInfo
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.  public class StudentInfo
7.     {
8.         [Key]
9.         public Int32 SerialNo { get; set; }
10.         [Required(ErrorMessage="Student Name Required")]
11.         public String StudentName { set; get; }
12.         [Required]
13.         public String Course { get; set; }
14.     }



15.   public class DATATABLECRUD
16.     {
17.         private DataTable brandsTable = new DataTable();
18. 
    
19.         //This explains how to access & use Session object in Class Library or Class.
20. 
    
21.         HttpContext context = HttpContext.Current;
22.         System.Web.SessionState.HttpSessionState session = null;
23.         
24.         public DATATABLECRUD()
25.         {
26.             AddDataTableColumns();
27.             AddDataTableRows();
28. 
    
29.             session=context.Session;
30.             if (session["tbl"] == null)
31.             {
32.                 session["tbl"] = brandsTable;
33.             }
34.             else brandsTable = (DataTable)session["tbl"];
35. 
    
36.         }
37.         //Add same number of columns/names specified by StudentInfo class.
38.         void AddDataTableColumns()
39.         {
40.             DataColumn ID = new DataColumn("SerialNo", typeof(System.Int32));
41.             ID.AutoIncrement = true;
42.             ID.AutoIncrementSeed = 1000;
43.             ID.AutoIncrementStep = 16;
44. 
    
45.             DataColumn BrandName = new DataColumn("StudentName", typeof(System.String));
46.             BrandName.MaxLength = 100;
47. 
    
48.             DataColumn BrandImage = new DataColumn("Course");
49.             BrandImage.DataType = typeof(String);
50.             brandsTable.Columns.Add(ID); brandsTable.Columns.Add(BrandName); brandsTable.Columns.Add(BrandImage);
51.             
52.         }
53.         //Add sample data for display  
54.         void AddDataTableRows()
55.         {
56.             DataRow row1 = brandsTable.NewRow();
57.             row1[1] = "Beta";
58.             row1[2] = "C#"; brandsTable.Rows.Add(row1);
59.             row1 = brandsTable.NewRow();
60.             row1[1] = "'Brands";
61.             row1[2] = "ASP.NET"; brandsTable.Rows.Add(row1);
62.             row1 = brandsTable.NewRow();
63.             row1[1] = "MODULES";
64.             row1[2] = "JAVA"; brandsTable.Rows.Add(row1);
65. 
    
66.         }
67.         //FormView GET        
68.         public List<StudentInfo> GetStudentTable()
69.         {
70.             var studentquery = from st in brandsTable.AsEnumerable()
71.                                select new StudentInfo
72.                                {
73.                                    SerialNo = st.Field<System.Int32>(0),
74.                                    StudentName = st.Field<String>(1),
75.                                    Course = st.Field<String>(2)
76.                                };
77.             return studentquery.ToList();
78.         }
79.       //FormView Insert
80.         public bool AddRows(StudentInfo sInfo)
81.         {
82.             
83.            
84.             brandsTable = (DataTable)session["tbl"];
85.             //brandsTable = (DataTable)HttpContext.Current.Session["tbl"];
86.             DataRow row =brandsTable.NewRow();
87.             row[1] = sInfo.StudentName;
88.             row[2] = sInfo.Course;
89.             brandsTable.Rows.Add(row);
90.             HttpContext.Current.Session.Add("tbl", brandsTable);
91.             return true;
92.         }
93.                 //FormView Update
94.         public bool UpdateRows(StudentInfo sInfo)
95.         {
96.             bool bRet = false;
97.             brandsTable = (DataTable)session["tbl"];
98.             DataRow row = brandsTable.AsEnumerable().SingleOrDefault(s => s.Field<Int32>(0) == sInfo.SerialNo);
99.             if (row != null)
100.             {
101.                 row[1] = sInfo.StudentName;
102.                 row[2] = sInfo.Course;
103.                 bRet = true;
104.                 session["tbl"] = brandsTable;
105.             }
106.             return bRet;
107.         }
108.         //FormView Delete
109.         public bool DeleteRows(StudentInfo sInfo)
110.         {
111.             bool bRet = false;
112.             brandsTable = (DataTable)session["tbl"];
113.             DataRow row = brandsTable.AsEnumerable().SingleOrDefault(s => s.Field<Int32>(0) == sInfo.SerialNo);
114.             if (row != null)
115.             {
116.                 brandsTable.Rows.Remove(row);
117.                 session["tbl"] = brandsTable;
118.                 bRet = true;
119.             }
120.             return bRet;
121.         }
122.     
123.     }
124. 
     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.