初学ASP.NET数据库连接问题 1.必须知道数据库名,不能自动设置2.如果服务器名是datacenter,则server=datacenter给个连接的网页参考http://www.connectionstrings.com/ 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 SQLServer 数据库不能向你说那样连接,initial catalog=MovieMSDE,这个数据库是在本地计算机建立的数据库,那么你用data source=localhost(如果不是本机就用服务器的IP地址),那么Asp.Net就知道你要调用本机(或服务器)上的名为MovieMSDE的数据库了,不需要知道数据库存放的物理位置。 在asp.net中的WEB程序的设置中我们必须用到Web.config来存储数据库连接字.事实上这是个很好的做法,因为可以省去我们很多的麻烦还可以帮助我们避免不必要的错位,是的很多情况下我就是这样做.它通过XML来记录这些信息.具体的是在<appSettings>....</appSettings>这个标记中来记录的.这里请看一个ORACLE的例子如下:<appSettings> <add key="ORACLEConnectionString" value="Provider=OraOLEDB.Oracle.1;Persist Security Info=False;Password=blah;User ID=greg;Data Source=sph;" /> <add key="SQLConnectionString" value="data source=SQL1;initial catalog=ID_V;integrated security=SSPI;persist security info=False;workstation id=TH03D374;packet size=4096"/> <appSettings>而在你的应用程序中你只要这样写,就可以了,如下:string conn = ConfigurationSettings.AppSettings["ORACLEConnectionString"];OleDbConnection myConnection = new OleDbConnection(conn);很轻松是吗?不必每次都输入同样的连接字,也不要记住那些讨厌的信息了,只需要起一个好记的名字就可以.好了下面我在来给出其他的一些连接字MYSQL的连接字:ConnectionString = "Data Source=localhost;" + "Database=mySQLDatabase;" + "User ID=myUsername;" + "Password=myPassword;" + "Command Logging=false";OLE DB的:IBM AS/400 OLE DB 的' VB.NETDim oOleDbConnection As OleDb.OleDbConnectionDim sConnString As String = _ "Provider=IBMDA400.DataSource.1;" & _ "Data source=myAS400DbName;" & _ "User Id=myUsername;" & _ "Password=myPassword"oOleDbConnection = New OleDb.OleDbConnection(sConnString)oOleDbConnection.Open() JET OLE DB 的' VB.NETDim oOleDbConnection As OleDb.OleDbConnectionDim sConnString As String = _ "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=C:\myPath\myJet.mdb;" & _ "User ID=Admin;" & _ "Password=" oOleDbConnection = New OleDb.OleDbConnection(sConnString)oOleDbConnection.Open() Oracle OLE DB 的' VB.NETDim oOleDbConnection As OleDb.OleDbConnectionDim sConnString As String = _ "Provider=OraOLEDB.Oracle;" & _ "Data Source=MyOracleDB;" & _ "User ID=myUsername;" & _ "Password=myPassword" oOleDbConnection = New OleDb.OleDbConnection(sConnString)oOleDbConnection.Open() SQL Server OLE DB 的' VB.NETDim oOleDbConnection As OleDb.OleDbConnectionDim sConnString As String = _ "Provider=sqloledb;" & _ "Data Source=myServerName;" & _ "Initial Catalog=myDatabaseName;" & _ "User Id=myUsername;" & _ "Password=myPassword" oOleDbConnection = New OleDb.OleDbConnection(sConnString)oOleDbConnection.Open() Sybase ASE OLE DB 的' VB.NETDim oOleDbConnection As OleDb.OleDbConnectionDim sConnString As String = _ "Provider=Sybase ASE OLE DB Provider;" & _ "Data Source=MyDataSourceName;" & _ "Server Name=MyServerName;" & _ "Database=MyDatabaseName;" & _ "User ID=myUsername;" & _ "Password=myPassword" oOleDbConnection = New OleDb.OleDbConnection(sConnString)oOleDbConnection.Open()SQL Server在System.Data.SqlClient SqlConnection oSQLConn = new SqlConnection();oSQLConn.ConnectionString = "Data Source=(local);" + "Initial Catalog=mySQLServerDBName;" + "Integrated Security=SSPI";oSQLConn.Open(); 打印时将打印网页保存pdf格式 问一个GOOGLE搜索器功能的问题 关于身份验证的问题 asp.net程序发布问题(唉,不要笑话我!!) 如何用C#代码作出类似于JavaScript的confirm函数一样的效果,或者象messagebox那样的效果? 如果从数据库读取图片? 这个论坛用xml做的大家看看 我的IIS不能新建虚拟目录了,???? 跪求:请帮我看一下这段程序 关于Asp.net的Forms认证,个人认为。。。 帮忙,大家来看看 DataGrid删除的问题和大家探讨
<appSettings>
<add key="ORACLEConnectionString" value="Provider=OraOLEDB.Oracle.1;
Persist Security Info=False;Password=blah;User ID=greg;Data Source=sph;" />
<add key="SQLConnectionString" value="data source=SQL1;initial catalog=ID_V;
integrated security=SSPI;persist security info=False;workstation id=TH03D374;
packet size=4096"/>
<appSettings>
而在你的应用程序中你只要这样写,就可以了,如下:
string conn = ConfigurationSettings.AppSettings["ORACLEConnectionString"];
OleDbConnection myConnection = new OleDbConnection(conn);
很轻松是吗?不必每次都输入同样的连接字,也不要记住那些讨厌的信息了,只需要起一个好记的名字就可以.好了下面我在来给出其他的一些连接字MYSQL的连接字:
ConnectionString = "Data Source=localhost;" +
"Database=mySQLDatabase;" +
"User ID=myUsername;" +
"Password=myPassword;" +
"Command Logging=false";
OLE DB的:IBM AS/400 OLE DB 的
' VB.NET
Dim oOleDbConnection As OleDb.OleDbConnection
Dim sConnString As String = _
"Provider=IBMDA400.DataSource.1;" & _
"Data source=myAS400DbName;" & _
"User Id=myUsername;" & _
"Password=myPassword"
oOleDbConnection = New OleDb.OleDbConnection(sConnString)
oOleDbConnection.Open()
JET OLE DB 的
' VB.NET
Dim oOleDbConnection As OleDb.OleDbConnection
Dim sConnString As String = _
"Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=C:\myPath\myJet.mdb;" & _
"User ID=Admin;" & _
"Password="
oOleDbConnection = New OleDb.OleDbConnection(sConnString)
oOleDbConnection.Open()
Oracle OLE DB 的
' VB.NET
Dim oOleDbConnection As OleDb.OleDbConnection
Dim sConnString As String = _
"Provider=OraOLEDB.Oracle;" & _
"Data Source=MyOracleDB;" & _
"User ID=myUsername;" & _
"Password=myPassword"
oOleDbConnection = New OleDb.OleDbConnection(sConnString)
oOleDbConnection.Open()
SQL Server OLE DB 的
' VB.NET
Dim oOleDbConnection As OleDb.OleDbConnection
Dim sConnString As String = _
"Provider=sqloledb;" & _
"Data Source=myServerName;" & _
"Initial Catalog=myDatabaseName;" & _
"User Id=myUsername;" & _
"Password=myPassword"
oOleDbConnection = New OleDb.OleDbConnection(sConnString)
oOleDbConnection.Open()
Sybase ASE OLE DB 的
' VB.NET
Dim oOleDbConnection As OleDb.OleDbConnection
Dim sConnString As String = _
"Provider=Sybase ASE OLE DB Provider;" & _
"Data Source=MyDataSourceName;" & _
"Server Name=MyServerName;" & _
"Database=MyDatabaseName;" & _
"User ID=myUsername;" & _
"Password=myPassword"
oOleDbConnection = New OleDb.OleDbConnection(sConnString)
oOleDbConnection.Open()
SQL Server在System.Data.SqlClient
SqlConnection oSQLConn = new SqlConnection();
oSQLConn.ConnectionString = "Data Source=(local);" +
"Initial Catalog=mySQLServerDBName;" +
"Integrated Security=SSPI";
oSQLConn.Open();