public partial class _Default : System.Web.UI.Page
{
string sqlstr;
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
sqlstr = "select * from bts";
gridsql();
}
protected void Button1_Click(object sender, EventArgs e)
{
string txtbox = TextBox1.Text;
if (DropDownList1.SelectedValue == "-1")
{
if (!Page.IsPostBack)
sqlstr = "select * from bts where Pt_No='a'";
gridsql();
}
}
public void gridsql()
{
string connStr = ConfigurationManager.ConnectionStrings["BTS"].ConnectionString;
SqlConnection conn = new SqlConnection(connStr);
conn.Open();
DataSet ds = new DataSet();
SqlCommand comm = new SqlCommand();
SqlDataAdapter sqlad = new SqlDataAdapter();
comm.Connection = conn;
comm.CommandText = sqlstr;
sqlad.SelectCommand = comm;
Response.Write(sqlad.SelectCommand.CommandText);
sqlad.Fill(ds, "bts");
GridView1.DataSource = ds.Tables["bts"];
GridView1.DataBind();
}
{
string sqlstr;
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
sqlstr = "select * from bts";
gridsql();
}
protected void Button1_Click(object sender, EventArgs e)
{
string txtbox = TextBox1.Text;
if (DropDownList1.SelectedValue == "-1")
{
if (!Page.IsPostBack)
sqlstr = "select * from bts where Pt_No='a'";
gridsql();
}
}
public void gridsql()
{
string connStr = ConfigurationManager.ConnectionStrings["BTS"].ConnectionString;
SqlConnection conn = new SqlConnection(connStr);
conn.Open();
DataSet ds = new DataSet();
SqlCommand comm = new SqlCommand();
SqlDataAdapter sqlad = new SqlDataAdapter();
comm.Connection = conn;
comm.CommandText = sqlstr;
sqlad.SelectCommand = comm;
Response.Write(sqlad.SelectCommand.CommandText);
sqlad.Fill(ds, "bts");
GridView1.DataSource = ds.Tables["bts"];
GridView1.DataBind();
}
解决方案 »
- js怎么将text文本框内容设为斜体字?
- Global.asax-Application_Error事件问题
- 如何实现选项卡异步加载
- 请教一正则表达式写法
- 在后台代码中如何获取javascript方法的返回值?
- 更改标签title样式
- 想深入 .net 的, 但是 想 深入 jscript .net 的, 要到那里找大本营?
- 我用:Request.QueryString["yonghu"].ToString()取页面上的地址,为何只取到2个字?
- 急,关于修改.cs文件
- Microsoft ASP.NET Web Matrix为什么不支持Code-Behind???
- 缓存问题,插入,更新,删除时的问题
- 关于访问DataView时出现"回发或回调参数无效"的问题
因为每次页面一提交,sqlstr变量就释放了。这样的话这个值永远是空的。当然提示“ExecuteReader: CommandText 属性尚未初始化。”
全局变量不是这么用的。
{
string txtbox = TextBox1.Text;
if (DropDownList1.SelectedValue == "-1")
{
if (!Page.IsPostBack)
//////////////////// 此段代码永远不执行,因为既然是 Click,那么 IsPostBack = true
sqlstr = "select * from bts where Pt_No='a'";
gridsql();
////////////////////
}
应该将sqlstr 当作参数代入 gridsql()函数把。
因为每次页面一提交,sqlstr变量就释放了。这样的话这个值永远是空的。当然提示“ExecuteReader: CommandText 属性尚未初始化。”
全局变量不是这么用的。
========
同意!
{
if (!Page.IsPostBack)
{
sqlstr = "select * from bts";
gridsql(sqlstr);
}
}
protected void Button1_Click(object sender, EventArgs e)
{
string txtbox = TextBox1.Text;
if (DropDownList1.SelectedValue == "-1")
{
if (!Page.IsPostBack)
{
sqlstr = "select * from bts where Pt_No='a'";
gridsql(sqlstr);
}
}
}
public void gridsql(string sqlstr)
{
string connStr = ConfigurationManager.ConnectionStrings["BTS"].ConnectionString;
SqlConnection conn = new SqlConnection(connStr);
conn.Open();
DataSet ds = new DataSet();
SqlCommand comm = new SqlCommand();
SqlDataAdapter sqlad = new SqlDataAdapter();
comm.Connection = conn;
comm.CommandText = sqlstr;
sqlad.SelectCommand = comm;
Response.Write(sqlad.SelectCommand.CommandText);
sqlad.Fill(ds, "bts");
GridView1.DataSource = ds.Tables["bts"];
GridView1.DataBind();
}
......輸出了select * from bts但我一點Button時就報錯了,,,,