Data source controls in asp net Part 2 скачать в хорошем качестве

Data source controls in asp net Part 2

Text version of the video http://csharp-video-tutorials.blogspo... Healthy diet is very important both for the body and mind. If you like Aarvi Kitchen recipes, please support by sharing, subscribing and liking our YouTube channel. Hope you can help.    / @aarvikitchen5572   Slides http://csharp-video-tutorials.blogspo... All GridView Text Articles http://csharp-video-tutorials.blogspo... All GridView Slides http://csharp-video-tutorials.blogspo... All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenka... All Dot Net and SQL Server Tutorials in Arabic    / kudvenkatarabic   The following are some of the different data source controls that are available in asp.net. SqlDataSource - Use to work with SQL Server, OLE DB, ODBC, or Oracle databases ObjectDataSource - Use to work business objects, that manages data AccessDataSource - Use to work with Microsoft Access XmlDataSource - Use to work with XML files LinqDataSource - Enables us to use LINQ, to retrieve and modify data from a data object EntityDataSource - Use to work with Entity Data Model Prior to the introduction of data source controls, developers had to write a few lines of code to retrieve and bind data with data-bound controls like DataGrid, GridView, DataList etc. With the introduction of these data source controls, we don't have to write even a single line of code, to retrieve and bind data to a data-bound control. SqlDataSource - Use to work with SQL Server, OLE DB, ODBC, or Oracle databases ObjectDataSource - Use to work business objects, that manages data AccessDataSource - Use to work with Microsoft Access XmlDataSource - Use to work with XML files LinqDataSource - Enables us to use LINQ, to retrieve and modify data from a data object EntityDataSource - Use to work with Entity Data Model We will discuss about, each of these data source controls in our upcoming videos. To bind data to a data bound control, like gridview there are 2 ways 1. Without using data-source controls 2. Using data-source controls If we are not using data source controls, then we have to write code to 1. Read connection string 2. Create connection object 3. Create SQL Command object 4. Execute the command 5. Retrieve and bind the results to the data-bound control. Code to bind data to a gridview control, without using data-source controls: string cs = ConfigurationManager.ConnectionStrings["DBConnectionString"].ConnectionString; using (SqlConnection con = new SqlConnection(cs)) { SqlCommand cmd = new SqlCommand("Select * from tblProducts", con); con.Open(); GridView1.DataSource = cmd.ExecuteReader(); GridView1.DataBind(); } If we are using data source controls, we don't have to write even a single line of code. All, you have to do is, drag and drop a data-source control on the webform. Configure the data-source control to connect to a data source and retrieve data. Finally associate the data-source control, to a data-bound control using "DataSourceID" property. Points to remember: 1. "ConnectionString" property of the "SqlDataSource" control is used to determine the database it has to connect, to retrieve data 2. "SelectCommand" property specifies the command that needs to be executed. 3. DataSource control is associated, with the gridview control, using "DataSourceID" property of the GridView control. Please Note: All databound controls has DataSourceID property. A few examples of databound controls include 1. DropDownList 2. CheckBoxList 3. Repeater 4. DataList etc...