为什么怎么老是不认识我的表
<%@ Page Language="C#" Debug="true" %>
<%@ Import Namespace="System.Data"%>
<%@ Import Namespace="System.Data.OleDb"%>
<script runat="server">
private DataSet CreateDataSource()
{
string strConn;
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" +"Data Source=d:\\tc-zc-biao\\biao.xls;"+"Extended Properties=Excel 8.0;";
OleDbConnection conn = new OleDbConnection(strConn);
OleDbDataAdapter myCommand = new OleDbDataAdapter("SELECT * FROM [biao]", strConn);
DataSet myDataSet = new DataSet();
myCommand.Fill(myDataSet);
return myDataSet;
}
public void Page_Load(Object sender, EventArgs e)
{
if (!IsPostBack)
{
mygrid.DataSource = CreateDataSource();
mygrid.DataBind();
}
}
</script>
<center>
<form runat="server">
<asp:datagrid runat="server" AutoGenerateColumns="false" width="500" id="mygrid">
<HeaderStyle BorderColor="White" BackColor="black"
ForeColor="White"
Font-Bold="True"
Font-Name="Arial"
Font-Size="9" HorizontalAlign="Center"/>
<ItemStyle BorderColor=""
BackColor="#FFFFF0"
ForeColor="Black"
Font-Name="Arial"
Font-Size="8"
Font-Bold="False" HorizontalAlign="Center"/>
<Columns>
<asp:BoundColumn HeaderText="姓名" ReadOnly="true" DataField="姓名"/>
<asp:BoundColumn HeaderText="性别" ReadOnly="true" DataField="性别"/>
<asp:BoundColumn HeaderText="Email" ReadOnly="true" DataField="地址"/>
</Columns>
</asp:datagrid>
</form>
提示我"biao"找不到。为什么？？？还有就是在[]应该怎么填写
问题点数：20、回复次数：3Top
1 楼webdiyer（.net资源精华—www.dotneturls.com）回复于 2003-03-03 10:06:03 得分 5
"select * from biao"Top
2 楼saucer（思归）回复于 2003-03-03 10:11:55 得分 10
biao是什么？是你EXCEL页的名字么？试试
SELECT * FROM [Sheet1$]
DateSet ds = CreateDataSource();
mygrid.DataSource = ds.Tables[0].DefaultView;
mygrid.DataBind();
Top
3 楼gOODiDEA（无语）回复于 2003-03-03 10:21:52 得分 5
SELECT * FROM [biao]
这里的 [biao]应该为你的单元格的名，一般为[Sheet1$]Top
