DataRelation object in ADO.NET is used to add relationship between two or more datatable objects.
ReadXml(Stream): Uses System.IO.Stream to read XML schema and data into the DataSet
ReadXml(String): Reads XML data from the specified file.
ReadXmlSchema(): Reads XML schema from the specified file.
GetXml(): Get XML data in a Dataset as a single string.
GetXmlSchema(): Get XSD Schema in a Dataset as a single string.
WriteXml(): Writes the contents of Dataset to the specified file.
WriteXmlSchema(): Writes XSD Schema into the specified file.
Yes, stored procedures are used in ADO.Net and it can be used for common repetitive functions.
Following are the benefits of using ADO.Net:
No, it is not possible to edit data in the Repeater control.
Yes, it is possible to load multiple tables in a single dataset.
There are two types of authentication:
Windows Authentication: Use authentication using Windows domain accounts only.
SQL Server and Windows Authentication Mode: Authentication provided with the combination of both Windows and SQL Server Authentication.
Following are the Data Providers used in ADO.Net:
Sort() method of GridViewControl is used to sort the data in a datatable.
Language-Integrated Query (LINQ), is a component released within the .NET 3.5 Framework. LINQ provides a native query language for C# and VB.Net to update and retrieve data from different data sources like MS, Access, MS SQL Server Database, XML etc.