C#<appSettings> <add key="ConnStr" value="Content.mdb"/> </appSettings> OleDbConnection Conn = db.CreateConnection(); Conn.Open(); OleDbCommand cmd = new OleDbCommand("Select * From [PassWord] Where [PassWord] = @PassWord",Conn);VBDim connectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0; Ole DB Services=-4; Data Source=C:\Inetpub\wwwr"& _ "oot\asp.netcase\chapter1\6\address.mdb" Dim dbConnection As System.Data.IDbConnection = New System.Data.OleDb.OleDbConnection(connectionString) Dim queryString As String = "DELETE FROM [users] WHERE ([users].[id] = @id)" <appSettings> <add key="strConn" value="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\inetpub\wwwroot\shopb\database\shop.mdb" /> </appSettings>
<%@Import Namespace="System.Data"%> <%@Import Namespace="System.Data.OleDb"%> <script language="vb" runat="server"> sub Page_Load(Sender As Object,e As EventArgs) If Not IsPostBack Then Dim conn As New OleDbConnection() Dim cmd As New OleDbCommand() Dim objReader As OleDbDataReader Dim i As integer conn.ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="&Server.MapPath("C:\Inetpub\wwwroot\Web7.3\student.mdb") conn.Open() cmd.Connection=conn cmd.CommandText="Select * from students" objReader=cmd.ExecuteReader() DataGrid1.DataSource=objReader DataGrid1.DataBind() conn.close() End if End Sub </script>请问这段代码有什么错误吗?数据库student放在C:\Inetpub\wwwroot下的Web7.3文件夹中,为什么显示不了表students的内容?请求指点!!
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Server.MapPath(oleDbBase)
<add key="cn" value="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="/>
<add key="data" value="db.mdb" />代码
string MyConnString =ConfigurationSettings.AppSettings["cn"])+ HttpContext.Current.Server.MapPath(ConfigurationSettings.AppSettings["data"])+";";
<add key="ConnStr" value="Content.mdb"/>
</appSettings>
OleDbConnection Conn = db.CreateConnection();
Conn.Open();
OleDbCommand cmd = new OleDbCommand("Select * From [PassWord] Where [PassWord] = @PassWord",Conn);VBDim connectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0; Ole DB Services=-4; Data Source=C:\Inetpub\wwwr"& _
"oot\asp.netcase\chapter1\6\address.mdb"
Dim dbConnection As System.Data.IDbConnection = New System.Data.OleDb.OleDbConnection(connectionString)
Dim queryString As String = "DELETE FROM [users] WHERE ([users].[id] = @id)"
<appSettings>
<add key="strConn" value="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\inetpub\wwwroot\shopb\database\shop.mdb" />
</appSettings>
<%@Import Namespace="System.Data.OleDb"%>
<script language="vb" runat="server">
sub Page_Load(Sender As Object,e As EventArgs)
If Not IsPostBack Then
Dim conn As New OleDbConnection()
Dim cmd As New OleDbCommand()
Dim objReader As OleDbDataReader
Dim i As integer
conn.ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="&Server.MapPath("C:\Inetpub\wwwroot\Web7.3\student.mdb")
conn.Open()
cmd.Connection=conn
cmd.CommandText="Select * from students"
objReader=cmd.ExecuteReader()
DataGrid1.DataSource=objReader
DataGrid1.DataBind()
conn.close()
End if
End Sub
</script>请问这段代码有什么错误吗?数据库student放在C:\Inetpub\wwwroot下的Web7.3文件夹中,为什么显示不了表students的内容?请求指点!!
strConn += @"Data Source=X:\XXXX\XXXX\XXX.mdb";
<add key="cn" value="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="/>
<add key="data" value="db.mdb" />代码
string MyConnString =ConfigurationSettings.AppSettings["cn"])+ HttpContext.Current.Server.MapPath(ConfigurationSettings.AppSettings["data"])+";";=======================就这样写最好!
容易维护
.介意.大家使用dingsongtao兄的那种来连接.好维护!.
还有一点.!
如果你们是在类中写连接.!server.mappath点不出来.!
可以使用System.Web.HttpContext.Current.Server.MapPath.......path........