| Author: Anil Kumar Pandey 04 Nov 2008 | Member Level: Diamond | Rating:  Points: 3 |
hi,
first define the Connection string in the web.config file
u can refer the following code..
Dim con As New SqlConnection(conString)
Dim cmd As SqlCommand
Dim query As String
query = "SELECT Proj_ID, Proj_Name FROM Projects"
Dim da As New SqlDataAdapter(query, con)
Regards
Anil Pandey
Thanks & Regards
Anil Kumar Pandey
|
| Author: Mohd. Azharuddin Ansari 04 Nov 2008 | Member Level: Gold | Rating: Points: 2 |
you can vist "www.connectionstrings.com/" site.
This site give you the connection string for all the databases.
hope thsi will help you
|
| Author: anita singh 04 Nov 2008 | Member Level: Gold | Rating: Points: 2 |
ODBC
Standard Security:"Driver={SQL Server};Server=UrServerName;Database=pubs;Uid=myUsername;Pwd=myPassword;"
Trusted connection:"Driver={SQL Server};Server=UrServerName;Database=pubs;Trusted_Connection=yes;"
Prompt for username and password:oConn.Properties("Prompt") = adPromptAlways
oConn.Open "Driver={SQL Server};Server=UrServerName;DataBase=pubs;"
OLE DB, OleDbConnection (.NET)
Standard Security:"Provider=sqloledb;Data Source=UrServerName;Initial Catalog=pubs;User Id=myUsername; Password=myPassword;"
Trusted Connection:"Provider=sqloledb;Data Source=UrServerName;Initial Catalog=pubs;Integrated Security=SSPI;"
(use serverName\instanceName as Data Source to use an specifik SQLServer instance, only SQLServer2000)
Prompt for username and password:
oConn.Provider = "sqloledb"
oConn.Properties("Prompt") = adPromptAlways
oConn.Open "Data Source=UrServerName;
Initial Catalog=pubs;"
Connect via an IP address:"Provider=sqloledb;Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;
Initial Catalog=pubs;User ID=myUsername;Password=myPassword;"
(DBMSSOCN=TCP/IP instead of Named Pipes, at the end of the Data Source is the port to use (1433 is the default))
SqlConnection (.NET)
Standard Security:"Data Source=UrServerName;Initial Catalog=pubs;User Id=myUsername;Password=myPassword;"
OR
"Server=UrServerName;Database=pubs;UserID=myUsername;Password=myPassword;
Trusted_Connection=False
(both connection strings produces the same result)
Trusted Connection:"Data Source=UrServerName;Initial Catalog=pubs;Integrated Security=SSPI;"
OR
"Server=UrServerName;Database=pubs;Trusted_Connection=True;"
(both connection strings produces the same result)
(use serverName\instanceName as Data Source to use an specific SQLServer instance, only SQLServer2000)
Connect via an IP address:
"Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=pubs;User ID=myUsername;
Password=myPassword;"
(DBMSSOCN=TCP/IP instead of Named Pipes, at the end of the
Data Source is the port to use (1433 is the default))
Data Shape
MS Data Shape "Provider=MSDataShape;Data Provider=SQLOLEDB;Data Source=UrServerName;Initial Catalog=pubs;
User ID=myUsername;Password=myPassword;"
|
| Author: Nandini P 04 Nov 2008 | Member Level: Gold | Rating: Points: 3 |
asp.net and sql server::
using System.data.SqlClient;
sqlconnection con=new sqlconnection("datasource='.';database=pubs;uid=sa");
sqlcommand com=new sqlcommand("select * from job");//ur sql query goes here
sqldataAdapter adp=new sqldataAdpater();
dataset ds=new dataset();
these are the basic statemaents u need for the connection.
Thanks & Regards
Nandini
|
| Author: archana 04 Nov 2008 | Member Level: Gold | Rating: Points: 2 |
hi mahesh
refer to following sites
http://www.connectionstrings.com/
http://www.startvbdotnet.com/ado/default.aspx
http://www.exforsys.com/tutorials/vb.net-2005/access-and-manipulate-data-the-ado-.net-object-model.html
http://www.15seconds.com/Issue/031013.htm
http://www.codeproject.com/KB/database/ADONETOOP.aspx
|