<%@ Page Language="C#" ContentType="text/html" ResponseEncoding="gb2312" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
</head>
<body>
<script language="c#" runat="server">
string asdf;
public void btn_click(Object Sender,EventArgs e)
{string asdf=xls_file.Text;
Response.Write(asdf);
}
void Page_Load()
{
if (asdf!=null)
{
if (IsPostBack)
{
OleDbDataReader dr;
string sqlstr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=h:\\"+asdf+"; Extended Properties='Excel 8.0'";
OleDbConnection conn= new OleDbConnection(sqlstr);
conn.Open();
string xls_command="select * from [甘肃2$]";
OleDbCommand comm= new OleDbCommand(xls_command,conn);
dr=comm.ExecuteReader();
haha.DataSource=dr;
DataBind();
dr.Close();
conn.Close();}
}
else
{Response.Write("唉....!!");}
}
</script>
<asp:DataGrid AllowPaging="false" CellPadding="6" CellSpacing="6" ID="haha" runat="server" ShowHeader="true"/>
<form runat="server">
<asp:TextBox ID="xls_file" runat="server"></asp:TextBox>
<asp:Button ID="btn" Text="提交查询" OnClick="btn_click" runat="server"></asp:Button>
</form>
</body>
</html>
请问如何在Page_Load()中取得asdf传过来的tb值?
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
</head>
<body>
<script language="c#" runat="server">
string asdf;
public void btn_click(Object Sender,EventArgs e)
{string asdf=xls_file.Text;
Response.Write(asdf);
}
void Page_Load()
{
if (asdf!=null)
{
if (IsPostBack)
{
OleDbDataReader dr;
string sqlstr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=h:\\"+asdf+"; Extended Properties='Excel 8.0'";
OleDbConnection conn= new OleDbConnection(sqlstr);
conn.Open();
string xls_command="select * from [甘肃2$]";
OleDbCommand comm= new OleDbCommand(xls_command,conn);
dr=comm.ExecuteReader();
haha.DataSource=dr;
DataBind();
dr.Close();
conn.Close();}
}
else
{Response.Write("唉....!!");}
}
</script>
<asp:DataGrid AllowPaging="false" CellPadding="6" CellSpacing="6" ID="haha" runat="server" ShowHeader="true"/>
<form runat="server">
<asp:TextBox ID="xls_file" runat="server"></asp:TextBox>
<asp:Button ID="btn" Text="提交查询" OnClick="btn_click" runat="server"></asp:Button>
</form>
</body>
</html>
请问如何在Page_Load()中取得asdf传过来的tb值?
解决方案 »
- xml结构的Excel读取到dataset中
- Hibernate中distinct问题
- 如何读取多张表
- js的简单问题
- 关于page_init page_load page_unload 超级简单
- 数字类型格式化问题
- 急~~~~~~~~~~asp.net能不能这样做???
- 简单问题:关于删除前的提示信息,例如:确认删除吗?
- ● 如何查看和编辑 IIS 的配置文件 MetaBase.bin ?
- 在IIS中怎么设置HTTP代码,使得自动导向到相应的HTTP错误处理页面?
- 我将数据集里面的bollean字段怎么付给boolean变量啊?
- 想从SQL2000一个库的表中取出一些数据,插入到另一个库中的表里面!!
public void Page_Load(Object src,EventArgs e)
{
asdf=Request["asdf"]==null?"":Request["asdf"].ToString();
}
先page_load后btn不行,
asdf是在全局位声明的一个string变量,用来本页面传回来的textbox值,难道只能用request么?
倒