我用vs2005连接access数据库,想实现一个Stat表的查询功能,以下代码编译后不显示结果,请问哪里有问题,谢谢!using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.OleDb;public partial class SelectWeb : System.Web.UI.Page
{    OleDbConnection sms_conn;
   
   String strConn;    protected void Page_Load(object sender, EventArgs e)
    {
        
        //连接数据库
        
            strConn = "Provider=Microsoft.Jet.OleDb.4.0;"; //数据库连接字符串
            strConn += @"Data Source=D:\asp\MyData.mdb";
            sms_conn = new OleDbConnection(strConn);
            sms_conn.Open();
       
         
    }
       protected void Button1_Click(object sender, EventArgs e)
    {        string sqlstr = "select * from Stat where 手持机编号='" + this.TextBox1.Text + "'";        OleDbCommand cmd = new OleDbCommand(sqlstr, sms_conn);
        DataSet sms_ds = new DataSet();        OleDbDataAdapter sms_da = new OleDbDataAdapter(cmd);
        
        sms_da.Fill(sms_ds, "Stat");
        this.GridView1.DataSource = sms_ds;
        this.GridView1.DataBind();
        
        sms_conn.Close();            }
    
}

解决方案 »

  1.   

    单步调试下
    还有pageload 加  if(!IsPostBack)
      

  2.   

    先把IsPostBack加上试试        if (!this.IsPostBack)
            {
                //连接数据库 
                strConn = "Provider=Microsoft.Jet.OleDb.4.0;"; //数据库连接字符串 
                strConn += @"Data Source=D:\asp\MyData.mdb";
                sms_conn = new OleDbConnection(strConn);
                sms_conn.Open();
            }