In this article I am giving brief explanation about ADO.NET and Data bound control.
ADO.NET is a bundle of classes which stands for ActiveX data object. It is used to get the data from Back end to Front end. Step to work with Ado .NET
Classes which work with ADO.NET
SqlConnection SqlConnection class used to established the connection between front end and back end. Syntax:
SqlConnection obj=new SqlConnection(“Integrated Security=true;Initial Catalog=Table_Name;Data Source=.”);-- for Windows authentication SqlConnection obj=new SqlConnection(“user id= sa ; Password=sa123;server=.;database=name”); --Sql server Authentication
SqlCommand SqlCommand is used to pass the statement from front end to back end by using the following syntax. Syntax
SqlDataAdapter objda=new SqlDataAdapter(“query statement”,Connection object);
Dataset Dataset contains Table and relation as: Figure: Dataset Data bound Control Data bound control is used for displaying more than one record at a time. Here are the types of Data bound Control:
Data bound control fetch the data record by record and display the data field by field. Sample Insertion Example for working with ADO.NET
Pro WPF: Windows Presentation Foundation in .NET 3.0