http://nfex.ru/index.php?action=history&feed=atom&title=ASP.Net%2FADO.net_Database%2FExcel
ASP.Net/ADO.net Database/Excel - История изменений
2026-04-29T19:52:14Z
История изменений этой страницы в вики
MediaWiki 1.30.0
http://nfex.ru/index.php?title=ASP.Net/ADO.net_Database/Excel&diff=1650&oldid=prev
в 15:30, 26 мая 2010
2010-05-26T15:30:47Z
<p></p>
<table class="diff diff-contentalign-left" data-mw="interface">
<tr style="vertical-align: top;" lang="ru">
<td colspan="1" style="background-color: white; color:black; text-align: center;">← Предыдущая</td>
<td colspan="1" style="background-color: white; color:black; text-align: center;">Версия 15:30, 26 мая 2010</td>
</tr><tr><td colspan="2" style="text-align: center;" lang="ru"><div class="mw-diff-empty">(нет различий)</div>
</td></tr></table>
http://nfex.ru/index.php?title=ASP.Net/ADO.net_Database/Excel&diff=1651&oldid=prev
Admin: 1 версия
2010-05-26T11:51:03Z
<p>1 версия</p>
<p><b>Новая страница</b></p><div>==Load data from Excel data source (C#)==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="csharp"><br />
<%--<br />
<%@ Page Language="C#" %><br />
<%@ import Namespace="System.Data" %><br />
<%@ import Namespace="System.Data.OleDb" %><br />
<script runat="server"><br />
void Page_Load(object sender, EventArgs e) {<br />
<br />
string ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\Yourspreadsheet.xls; Extended Properties=""Excel 8.0;HDR=Yes"";";<br />
string CommandText = "select * from [Book$]";<br />
<br />
OleDbConnection myConnection = new OleDbConnection(ConnectionString);<br />
OleDbCommand myCommand = new OleDbCommand(CommandText, myConnection);<br />
<br />
myConnection.Open();<br />
<br />
DataGrid1.DataSource = myCommand.ExecuteReader(CommandBehavior.CloseConnection);<br />
DataGrid1.DataBind();<br />
<br />
myConnection.Close();<br />
}<br />
</script><br />
<html><br />
<head><br />
</head><br />
<body style="FONT-FAMILY: arial"><br />
<h2>Simple Data Report <br />
</h2><br />
<hr size="1" /><br />
<form runat="server"><br />
<asp:datagrid id="DataGrid1" runat="server" EnableViewState="False" ForeColor="Black" BackColor="White" CellPadding="3" GridLines="None" CellSpacing="1"><br />
<HeaderStyle font-bold="True" forecolor="white" backcolor="#4A3C8C"></HeaderStyle><br />
<ItemStyle backcolor="#DEDFDE"></ItemStyle><br />
</asp:datagrid><br />
</form><br />
</body><br />
</html><br />
<br />
--%><br />
<br />
</source><br />
<br />
<br />
<br />
<br />
==Reading from an Excel Workbook (VB.net)==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="csharp"><br />
<%@ Import namespace="System.Data" %><br />
<%@ Import namespace="System.Data.OleDb" %><br />
<html><br />
<head><br />
<title>Reading from an Excel Workbook</title><br />
</head><br />
<body><br />
<H3>Reading from an Excel Workbook</H3><br />
<asp:DataGrid id="dgInventory" runat="server" /><br />
</body><br />
</html><br />
<script language="VB" runat="server"><br />
Sub Page_Load(Source As Object, E As EventArgs)<br />
Dim strConnection As String = "Provider=Microsoft.Jet.OleDb.4.0;" & _<br />
"data source=C:\yourExcellFileName.xls;" & _<br />
"Extended Properties=Excel 8.0;"<br />
Dim objConnection As New OleDbConnection(strConnection)<br />
Dim strSQL As String = "SELECT * FROM Items WHERE Source="Dell""<br />
Dim objCommand As New OleDbCommand(strSQL, objConnection)<br />
objConnection.Open()<br />
dgInventory.DataSource = objCommand.ExecuteReader()<br />
dgInventory.DataBind()<br />
objConnection.Close()<br />
End Sub<br />
</script><br />
<br />
</source></div>
Admin