Control Panel Forum Hosting Help 6 Months free Hosting (New!) Resources

Total members: 80998
Average new registrations per day (in last 7 days): 41

New Registration: Open

Register Now

Home » Resources » Creating Database Connections

ASP.NET	ADO.NET	Web Services	Remoting	Visual Studio 2005
Error Bank	Interview Questions	Tips & Tricks	XML	HTML
Jscript/Javascript	IIS	Windows		General

Submit Resource or code snippet ... and get surprise gifts ASP.NET web hosting

Win Digital camera, ASP.NET Books, Free softwares!!

Creating Database Connections

19 Apr, 2008

Author: yansoft

Summary
By default, the SqlDataSource control is configured to connect to Microsoft SQL Server version 7.0 or higher. The default provider used by the SqlDataSource control is the ADO.NET provider for Microsoft SQL Server.

.NET Classes used :

<%@ Page Language="VB" %>
"http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">

Show Local Connection

id="grdMovies"
DataSourceID="srcMovies"
Runat="server" />

id="srcMovies"
SelectCommand="SELECT * FROM Movies"
ConnectionString="Data Source=.\SQLEXPRESS;
AttachDbFilename=|DataDirectory|MyDatabase.mdf;
Integrated Security=True;User Instance=True"
Runat="server" />

Feedbacks about this page from members:

- No Feedbacks yet !! -

Submit Feedback View All Feedbacks