连接 谁能给我一段连接ACCESS的源码啊 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 <add name="OleDbConnectionString" connectionString="provider=Microsoft.Jet.OLEDB.4.0;data source=D:\MyInfo.mdb" providerName="System.Data.OleDb"/> <%@ Import Namespace="System.Data" %><%@ Import Namespace="System.Data.OleDb" %><script Language="c#" runat="server"> void Page_Load() { string strConnection; strConnection ="Provider=Microsoft.Jet.OLEDB.4.0; Data source=" + Server.MapPath("northwind.mdb"); data_src.Text = strConnection; OleDbConnection objConnection = new OleDbConnection(strConnection); try { objConnection.Open(); con_open.Text="Connection opened successfully.<br/>"; objConnection.Close(); con_close.Text="Connection closed.<br/>"; } catch (Exception e) { con_open.Text="Connection failed to open.<br/>"; con_close.Text=e.ToString(); } }</script><html> <body onunload="return window_onunload()" onload="return window_onload()"> <h4>Testing the data connection <asp:label id="data_src" runat="server"/></h4> <asp:label id="con_open" runat="server"/><br /> <asp:label id="con_close" runat="server"/><br /> </body></html> ole--access-DataReader<%@ Import Namespace="System.Data" %><%@ Import Namespace="System.Data.OleDb" %><script Language="c#" runat="server">void Page_Load(){ string strConnection = "Provider=Microsoft.Jet.OLEDB.4.0; Data source=" + Server.MapPath("northwind.mdb"); data_src.Text = strConnection; string strSQL = "SELECT FirstName,LastName FROM Employees"; string strResultsHolder = ""; OleDbConnection objConnection = new OleDbConnection(strConnection); OleDbCommand objCommand = new OleDbCommand(strSQL, objConnection); OleDbDataReader objDataReader = null; try { objConnection.Open(); con_open.Text="Connection opened successfully.<br>"; objDataReader = objCommand.ExecuteReader(); while (objDataReader.Read() == true) { strResultsHolder += objDataReader["FirstName"]; strResultsHolder += "| "; strResultsHolder += objDataReader["LastName"]; strResultsHolder += "<br/>"; } objDataReader.Close(); objConnection.Close(); con_close.Text = "<br/>Connection closed.<br/>"; divListEmployees.InnerHtml = strResultsHolder; } catch (Exception e) { con_open.Text = "Connection failed to open successfully.<br/>"; con_close.Text = e.ToString(); }}</script><html> <body> <h4>Reading data from the connection <asp:label id=data_src runat=server/> with the DataReader object.</h4> <asp:label id=con_open runat=server/><br> <div id="divListEmployees" runat="server">list will go here</div> <asp:label id=con_close runat=server/><br> </body></html> ole--access-DataSet--datagrid<%@ Page %><%@ Import Namespace="System.Data" %><%@ Import Namespace="System.Data.OleDb" %><script Language="c#" runat="server"> void Page_Load() { string strConnection = "Provider=Microsoft.Jet.OLEDB.4.0; Data source=" + Server.MapPath("northwind.mdb"); data_src.Text = strConnection; string strSQL = "SELECT FirstName, LastName FROM Employees"; DataSet objDataSet = new DataSet(); OleDbConnection objConnection = new OleDbConnection(strConnection); OleDbDataAdapter objAdapter = new OleDbDataAdapter(strSQL, objConnection); objAdapter.Fill(objDataSet, "Employees"); //DataView objDataView = new DataView(objDataSet.Tables["Employees"]); //dgNameList.DataSource=objDataView; //dgNameList.DataBind(); dgNameList.DataSource=objDataSet.Tables["Employees"].DefaultView; dgNameList.DataBind(); }</script><html> <body> <h4>Reading data from the connection <asp:label id="data_src" runat="server"/> to the DataGrid control.</h4> <asp:datagrid id="dgNameList" runat="server" runat="server" BorderWidth="1px" BorderStyle="Groove" BorderColor="Teal" Width="200px" Font-Size="12px"> <HeaderStyle Font-Bold="True" HorizontalAlign="Center" BackColor="#CCFFCC"></HeaderStyle> <AlternatingItemStyle ForeColor="Red" BackColor="#FFFF80"></AlternatingItemStyle> </asp:datagrid><br /> </body></html> 如何让用户退出系统以后,数据库的连接好像还是没完全关闭,怎么回事? gridview中如何控制行之间的距离 如何禁止信息重复发送? 哪里有FreeTextBox下载? 我把word存进SQL数据库里面....是用IMAGE格式存,Sql全文检索支不支持检索IMAGE那种格式的数据.... 请高手急救﹗﹗ 问个SQL2005端口问题 vb中的createobject在.net中用什么替换!急! 请问在c#中如何判断查询结果为空 关于HiddenField值的问题 使用了UrlReWrite控件以后,用户控件页面中的按钮不能触发了? 请问哪里有多人博客的源代码下载?象blog.csdn那样
<%@ Import Namespace="System.Data.OleDb" %>
<script Language="c#" runat="server">
void Page_Load()
{
string strConnection;
strConnection ="Provider=Microsoft.Jet.OLEDB.4.0; Data source=" + Server.MapPath("northwind.mdb");
data_src.Text = strConnection;
OleDbConnection objConnection = new OleDbConnection(strConnection);
try
{
objConnection.Open();
con_open.Text="Connection opened successfully.<br/>";
objConnection.Close();
con_close.Text="Connection closed.<br/>";
}
catch (Exception e)
{
con_open.Text="Connection failed to open.<br/>";
con_close.Text=e.ToString();
}
}
</script>
<html>
<body onunload="return window_onunload()" onload="return window_onload()">
<h4>Testing the data connection
<asp:label id="data_src" runat="server"/></h4>
<asp:label id="con_open" runat="server"/><br />
<asp:label id="con_close" runat="server"/><br />
</body>
</html>
<%@ Import Namespace="System.Data.OleDb" %>
<script Language="c#" runat="server">
void Page_Load()
{
string strConnection = "Provider=Microsoft.Jet.OLEDB.4.0; Data source=" + Server.MapPath("northwind.mdb");
data_src.Text = strConnection;
string strSQL = "SELECT FirstName,LastName FROM Employees";
string strResultsHolder = "";
OleDbConnection objConnection = new OleDbConnection(strConnection);
OleDbCommand objCommand = new OleDbCommand(strSQL, objConnection);
OleDbDataReader objDataReader = null;
try
{
objConnection.Open();
con_open.Text="Connection opened successfully.<br>";
objDataReader = objCommand.ExecuteReader();
while (objDataReader.Read() == true)
{
strResultsHolder += objDataReader["FirstName"];
strResultsHolder += "| ";
strResultsHolder += objDataReader["LastName"];
strResultsHolder += "<br/>";
}
objDataReader.Close();
objConnection.Close();
con_close.Text = "<br/>Connection closed.<br/>";
divListEmployees.InnerHtml = strResultsHolder;
}
catch (Exception e)
{
con_open.Text = "Connection failed to open successfully.<br/>";
con_close.Text = e.ToString();
}
}
</script>
<html>
<body>
<h4>Reading data from the connection
<asp:label id=data_src runat=server/> with the DataReader object.</h4>
<asp:label id=con_open runat=server/><br>
<div id="divListEmployees" runat="server">list will go here</div>
<asp:label id=con_close runat=server/><br>
</body>
</html>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>
<script Language="c#" runat="server">
void Page_Load()
{
string strConnection = "Provider=Microsoft.Jet.OLEDB.4.0; Data source=" + Server.MapPath("northwind.mdb");
data_src.Text = strConnection;
string strSQL = "SELECT FirstName, LastName FROM Employees";
DataSet objDataSet = new DataSet();
OleDbConnection objConnection = new OleDbConnection(strConnection);
OleDbDataAdapter objAdapter = new OleDbDataAdapter(strSQL, objConnection);
objAdapter.Fill(objDataSet, "Employees");
//DataView objDataView = new DataView(objDataSet.Tables["Employees"]);
//dgNameList.DataSource=objDataView;
//dgNameList.DataBind();
dgNameList.DataSource=objDataSet.Tables["Employees"].DefaultView;
dgNameList.DataBind();
}
</script>
<html>
<body>
<h4>Reading data from the connection
<asp:label id="data_src" runat="server"/> to the DataGrid control.</h4>
<asp:datagrid id="dgNameList" runat="server" runat="server" BorderWidth="1px" BorderStyle="Groove" BorderColor="Teal"
Width="200px" Font-Size="12px">
<HeaderStyle Font-Bold="True" HorizontalAlign="Center" BackColor="#CCFFCC"></HeaderStyle>
<AlternatingItemStyle ForeColor="Red" BackColor="#FFFF80"></AlternatingItemStyle>
</asp:datagrid><br />
</body>
</html>