Configure SQL Data Sources for Web Applications
"Learn how to create, define connections, and save SQL data sources in web applications. Follow step-by-step instructions for setting up database connections, saving connection strings in web.config files, and managing custom statements and stored procedures."
Download Presentation
Please find below an Image/Link to download the presentation.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author. If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.
You are allowed to download the files provided on this website for personal or commercial use, subject to the condition that they are used lawfully. All files are the property of their respective owners.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author.
E N D
Presentation Transcript
How to use SQL data sources SANTOSHI ELLANKI PRESENTATION ID #22
Outline How to create an SQL data source control. How to define connection and save it in web web.config file. How to use custom statements and stored procedures.
How to create an SQL data source control To create a SQL data source control, drag the control item from the data group of the Toolbox onto the form. Then choose configure data source from the control smart tag menu and proceed from their. You can also create a SQL data source using the choose data source command in the smart tag menu of bindable control.
THE STARTING DIALOG BOX OF THE DATASOURCE CONFIGUARATION WIZARD
HOW TO DEFINE THE CONNECTION The configure data source dialog box asks you to identify connection for the database you want to use. If you have previously created a connection for the database, you can select it from drop-down list. To create a new connection, click the new connection button to display the add connection dialog box. Then enter the name of the database server in the server name text box.
For SQL server express, you can use localhost\sqlexpress as the server name. After you enter the server name, select the authentication mode you want to use. Then select the database you want to connect to from the drop-down box or enter a database name. To be sure that the connection is configured properly, you can click the test connection button.
HOW TO SAVE THE CONNECTION STRING IN WEB.CONFIG FILE ASP.NET applications can store connection strings in the web.config file. If you choose to save the connection string in the web.config file, the connection string attribute of data source control will include a special code that retrieves connection string from web.config file otherwise it will specify actual connection string.
It is recommended to save the connection in web.config file. Then if the location of the database changes, you can change the connection string in web.config file rather than in each data source that uses the connection.
THE DIALOG BOX FOR SAVING THE CONNECTION STRING IN WEB.CONFIG FILE
How to configure the select statement To configure the select statement you choose whether you want to use custom SQL statement or specify the columns from the table or view in the database. You can click the ORDER BY button to specify how the records should be stored. You can click the WHERE button to specify the selection criteria
The dialog box for defining the select statement
HOW TO CREATE A WHERE CLAUSE The add WHERE clause dialog box lets you specify a where clause for select statement. To create a condition, you select the column you want to compare, the operator you want to use for the comparison and the source of the data that you want to use for the comparison. Then you must click Add to add the condition to the list of where clause condition.
The where clause section after a condition has been added
HOW TO USE CUSTOM STATEMENTS AND STORED PROCEDURES How to select custom statements and stored procedures To use custom statements with SQL data source, select the SQL statement option and then enter the statement into text box. You can enter select, update, insert, and delete statements by selecting the appropriate tab. To use stored procedures, select stored procedure option and then select stored procedure you want to use from the drop-down list.
THE DIALOG FOR ENTERING A CUSTOM SELECT STATEMENT
