ASP.NET

1. ASP.NET Introduction 2. Comp of .Net Framework 3.5 3. Sys.Req for VS 2008 4. ASP.NET Envrmnt Setup 5. VS2010 Ultimate Sys.Req 6. Installing VS 2010 7. VS 2012 Sys.Req 8. Installing VS Exp 2012 9. Start the VS 2008 10. Application Life Cycle 11. Page Life Cycle 12. Page Life Cycle Events 13. ASP.NET Example 14. Event Handling 15. Default Events 16. Server Side 17. Request Object 18. Response Object 19. Server Controls 20. Server Controls Properties 21. Server Controls Methods 22. HTML Server Controls 23. Client Side 24. ASP.NET Basic Controls 25. TextBox Control 26. CheckBox Controls 27. RadioButton Controls 28. ListBox Control 29. HyperLink Control 30. Image Control 31. BulletedList Control 32. ASP.NET Directives 33. Implements Directive 34. Master Type Directive 35. Page Directive 36. PreviousPage Type 37. Managing State 38. Control State 39. Cookies 40. Query Strings 41. Server-Side State 42. Session State 43. Validation Controls 44. Required FieldValidator 45. Range Validator 46. Compare Validator 47. RegularExpressionValidator 48. Custom Validator 49. Validation Summary 50. Data Source Control 51. AdRotator Control 52. Calendar Control 53. Calendar Control Example 54. Panel Control 55. Panel Control Example 56. Multi Views Control 57. MultiView & View controls 58. MultiView Control Example 59. FileUpload Control 60. FileUpload Control Eg 61. AJAX Control 62. UpdatePanel control 63. UpdateProgress Control 64. Custom Controls 65. Custom Control Eg 66. Personalization 67. Create Simple Profile 68. ADO.NET 69. ADO.NET Objects 70. DataTable 71. DataRow 72. DataColumn 73. Object Example 74. Error Handling 75. Tracing Errors 76. Debugger 77. Security 78. Authentication 79. Authorization 80. LINQ 81. LINQ Query Operators 82. LINQ Example 83. Caching 84. Data Caching 85. Output Caching 86. Object Caching 87. Web Services 88. Create Web Services Eg 89. Web & Machine.config 90. Settings Schema 91. ASP.NET Deployment 92. XCopy Deployment 93. Web Setup Project 94. ASP Interview Part 1 95. ASP Interview Part 2 96. ASP Interview Part 3 97. ASP Interview Part 4 98. ASP Interview Part 5 99. ASP Interview Part 6
Pr.Pg Next Pg

ADO.NET Object The DataTable tutorials

  • A DataSet contains a collection of DataTables, which allows you to add more than one table to a DataSet. Like a table in a database, the DataTable is made up of rows and columns, which represent elements and attributes respectively.

  • The names of the individual tables within the DataTable’s collection are case sensitive, so you can have both a Customers and a customers table in the same DataSet. Be sure that you use the correct case-sensitive table name when typing in your source code.

  • In order to work with a DataTable, you should be familiar with its many properties, methods, and events. In your code you can react to events that occur within a DataTable, such as the changing of a value within a row or the deletion of a row. You can also accept or reject all changes made to a DataTable.

  • The below table shows the properties of the Data Table.

 

Properties

Description

CaseSensitive

String value comparisons within the table can either be

case sensitive (True) or not (False )

Constraints

Specify the collections of Constraints.

HashErrors

Indicates that one or more data elements within this table has an error

PrimaryKey

Sets the primary key for the table

TableName

The identifying name of the table

DefaultView

Identifies a customized view of the table, if desired

DataSet

The name of the DataSet this table belongs to

 

  • The below table shows the methods of the DataTable

 

Methods

Description

AcceptChanges

This mehod accepts and commits all changes made within the table

NewRow

Adds a new DataRow to the DataTable

RejectChanges

Rejects and rolls back all changes made within the table

GetChanges

Produces a version of the DataTable containing items that have been changed since the last commit or data load

Clone

Creates a copy of the DataTables format, including the loaded schema and constraints

Copy

Creates a copy of both the DataTables format and the data currently contained in the DataTable

Clear

Removes all data from the DataTable

ImportDataRow

Loads a DataRow from an external source into your DataTable

GetErrors

Creates an array of rows that currently contain errors

Select

Allows you to create an array of rows that match a certain criteria, similar to executing a SQL SELECT statement against your DataTable

 

Pr.Pg border                                              Next Pg