程序博客网 > 网络中介平台招聘

ASP.NET: Dispaly data from an Excel Spreadsheet

来源：互联网发布：网络中介平台招聘编辑：程序博客网时间：2024/06/05 01:13

ASP.NET: Dispaly data from an Excel Spreadsheet

This code was written in response to a message posted on one of Charles Carroll's ASP.NET lists. You can sign up for one or all of the lists here.This page provides a simple example of how to query an Excel spreadsheet from an ASP.NET page using VB.NET.

Code:

<%@ Page Language="VB" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>
<html>
<script language="VB" runat="server">
Sub Page_Load(sender As Object, e As EventArgs)
Dim myDataset As New DataSet()

Dim strConn As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & Replace(Server.MapPath("."), "\", "\\") & "\\exceltest.xls;" & _
"Extended Properties=""Excel 8.0;"""

'You must use the $ after the object you reference in the spreadsheet
Dim myOleDbDataAdapter As New OleDbDataAdapter("SELECT * FROM [Sheet1$]", strConn)
myOleDbDataAdapter.Fill(myDataset)

DataGrid1.DataSource = myDataset.Tables(0).DefaultView
DataGrid1.DataBind()
End Sub
</script>
</html>

0 0

网络中介平台招聘

网络中介平台招聘

原创粉丝点击

热门问题 老师的惩罚人脸识别我在镇武司摸鱼那些年重生之率土为王我在大康的咸鱼生活盘龙之生命进化天生仙种凡人之先天五行春回大明朝姑娘不必设防，我是瞎子蓝牙耳机容易丢怎么办苹果耳机模式了怎么办手机在耳机状态怎么办 ipad变耳机模式怎么办手机孔进水了怎么办手机耳机孔松了怎么办小米耳机声音小怎么办低压进网许可证怎么办手机被root了怎么办苹果手机定屏怎么办 iphone中病毒了怎么办微信不支持ios7怎么办心动劲舞团封号怎么办异地恋吵架分手怎么办分手了想和好怎么办劲舞团韩语歌怎么办节奏大师没声音怎么办玩游戏键盘冲突怎么办手机被偷了怎么办? l手机被偷后相片怎么办指甲月牙没有了怎么办充话费不到账怎么办王卡话费没到账怎么办充了话费没到账怎么办流量冲错了怎么办给空号充流量了怎么办 qq上交错话费怎么办 qq充话费充错号怎么办冲q币充错了怎么办财付通注销了qb怎么办小米qq电话黑屏怎么办京东充流量没到怎么办京东退款没到账怎么办京东充话费没到怎么办流量充错号码怎么办微信话费没到账怎么办战网无法安装怎么办 qq飞车更新失败怎么办 qq飞车登录失败怎么办 qq飞车下载不了怎么办 qq飞车修复不了怎么办