в 15:30, 26 мая 2010

2010-05-26T15:30:47Z

Admin: 1 версия

2010-05-26T11:50:59Z

1 версия

Новая страница

==Use OleDbDataReader retrieve data from database by column name (C#)==



<source lang="csharp">
<%@ 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;";
strConnection += @"Data Source="+MapPath("EmployeeDatabase.mdb");
data_src.Text = strConnection;
string strSQL = "SELECT FirstName,LastName FROM Employee";
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>

</source>

<A href="http://www.nfex.ru/Code/ASPDownload/EmployeeDatabase.zip">EmployeeDatabase.zip( 10 k)</a>

← Предыдущая	Версия 15:30, 26 мая 2010
(нет различий)

ASP.Net/ADO.net Database/OleDbDataReader - История изменений

в 15:30, 26 мая 2010

Admin: 1 версия