'##################################################################################
'连接数据库方式
'##################################################################################
Public Shared Function GetDBConnectionString() As String
GetDBConnectionString = "driver={Microsoft Access Driver (*.mdb)}; dbq=" & Server.MapPath("DataSet/ResortgpDataset.mdb")
End Function
请大家帮帮忙看怎么改写这个????
'连接数据库方式
'##################################################################################
Public Shared Function GetDBConnectionString() As String
GetDBConnectionString = "driver={Microsoft Access Driver (*.mdb)}; dbq=" & Server.MapPath("DataSet/ResortgpDataset.mdb")
End Function
请大家帮帮忙看怎么改写这个????
解决方案 »
- vs2008做的项目 运行可以,发布到本地IIS上运行就出线如下问题
- 关于文件上传
- 简单问题,提供一个URL地址供登录!
- 如何防止多线程并发?
- 50分求如何获取用dataset添加记录后的自增ID?(必结贴)
- this.dropdowmlist.SelectedIndex = -1是什么意思啊
- datalist中如何实现文件上传?
- 为什么我关闭子窗口,父窗口也会跟着关闭呢
- IE浏览器切换到兼容性视图后,ASP.NET MVC中的HttpContext获取不到参数,为NULL值,这是什么原因?
- 求助,如何三层DataList!
- ============ 请试验过以后再回答。请教!
- vb项目中引入C#项目出现了问题?
using System;
using System.Data;
using System.Data.OleDb ;
using System.Web.Services;
using System.Configuration;
namespace FishNet.Components{
/// <summary>
/// Database 的摘要说明。
/// </summary>
///
public class Database:System.Web.Services.WebService
{
public void OpenDB(ref OleDbConnection Conn)
{
if (Conn== null)
{
string strConnect;
strConnect = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Server.MapPath("..\\MyData\\BabyFish.mdb");
Conn = new OleDbConnection(strConnect);
Conn.Open();
}
else
{
if (Conn.State ==ConnectionState.Open)
Conn.Close();
}
}
}
}
Public Sub ConnectToAccess()
Dim conn As New System.Data.OleDb.OleDbConnection()
' TODO: Modify the connection string and include any
' additional required properties for your database.
conn.ConnectionString = & _
"Provider=Microsoft.Jet.OLEDB.4.0;Data source=" & _
"C:\Documents and Settings\username\My Documents\dbFile.mdb"
Try
conn.Open()
' Insert code to process data.
Catch ex As Exception
MessageBox.Show("Failed to connect to data source")
Finally
conn.Close()
End Try
End Sub// C#
public void ConnectToAccess()
{
System.Data.OleDb.OleDbConnection conn = new
System.Data.OleDb.OleDbConnection();
// TODO: Modify the connection string and include any
// additional required properties for your database.
conn.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;" +
@"Data source= C:\Documents and Settings\username\" +
@"My Documents\AccessFile.mdb";
try
{
conn.Open();
// Insert code to process data.
}
catch (Exception ex)
{
MessageBox.Show("Failed to connect to data source");
}
finally
{
conn.Close();
}
}
Return ("provider=microsoft.jet.oledb.4.0;data source=" & HttpRuntime.AppDomainAppPath("db1.mdb")
End Function
Public Function Getconnstring() As String
Return ("provider=microsoft.jet.oledb.4.0;data source=" & HttpRuntime.AppDomainAppPath("db1.mdb")
End Function
---------------------------------------------------------------------------
这个提示出错啊!!!!
OleDbConnection bConnection=new OleDbConnection(strConnection);
bConnection.Open();
strConnection="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=k:\\a.mdb";