How can we specify the database connection string in the “web.config” file?

The database connection string is specified in the <connectinString> tag of the web.config file


Comments

Post a Comment

Popular posts from this blog

What is the difference between a Page Layout and Master Page in SharePoint?

A Page Layout is nothing but a template which when used in conjuncture with the Master Page gives the look and feel and contents of the page. Each page layout has an associated content type that determines the kind of content that can be stored on pages based on that page layout. Master Pages and Page Layouts dictate the overall look and feel of your SharePoint site. Master Pages contain controls that are shared across multiple page layouts, such as navigation, search, or language-preference for multilingual sites. Page layouts contain field controls and Web Parts. All page layouts reference a master page that is based on the CustomMasterUrl property of the SPWeb class. The top-level SharePoint Server site for a site collection hosted on SharePoint Server 2010 has a special document library called the Master Page and Page Layout Gallery. All Page Layouts and Master Pages are stored in this document library. Reference: http://blog.beckybertram.com/Lists/Posts/Post...
Read more

Accessing data from SharePoint 2010 to an ASP.NET application

Image
In order to access the SharePoint lists and document libraries data from a native ASP.NET application we need to make use of the web services that have been provided. The full list of the web services available from within SharePoint 2010 can be found here http://www.etechplanet.com/blog/sharepoint-web-services-7c-list-of-all-web-services-available-with-wss-30moss-2007.aspx The steps to access the web service are as follows: Create a native ASP.NET web application Add a reference of the web service Create an object of the web site Pass on to the web service object the credentials using which the access will be authorized Retrieve the results using the appropriate method
Read more

What is the difference between DDL, DML and DCL?

Data Definition Language (DDL) There are called data definition cause they define the data Create - creates objects in the database Alter - alters objects in the database Drop - deletes objects in the database Truncate - deletes all records from the table along with the space Rename - renames objects in the database Data Manipulation Language (DML) These are used for data manipulation Select - selects records from the table Insert - create a new record in the table Update - updates the records in the table Delete - deletes all the records in the table, but the space remains Lock Table - locks a table for controlling data concurrency Data Control Language (DCL) This is used to control the data, that the data that can be accessed by the user based on his privilege Grant - grants users access to the database Revoke - removes the access of the user to the database Transaction Control Language (TCL) This is used to control the changes done by the DML statemets C...
Read more