我用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(); }
}
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(); }
}
解决方案 »
- 一个两表查询 赋 给 gridview 的问题
- 请大家帮忙看一下吧,为什么,GridView的分页功能 没反应了啊?
- 关于一个在线考试系统问题
- asp.net中radiobutton的刷新问题!!
- 在asp.net中怎么实现视频缓冲与播放不同步
- 请问用GridView用存储过程的话怎么实现点击列标题升降序排列的功能??
- 在vs.net中无法创建web项目 ,求助
- 真郁闷,谁熟悉web application stress(WAS) 性能测试工具,进来看下我的测试结果
- ASPxDateEdit赋值问题
- 关于repeater控件绑定代码的整合
- 关于验证控件 遇到的问题,大哥们进来看看
- 如何判断只选择了GridView中的一个CheckBox?
还有pageload 加 if(!IsPostBack)
{
//连接数据库
strConn = "Provider=Microsoft.Jet.OleDb.4.0;"; //数据库连接字符串
strConn += @"Data Source=D:\asp\MyData.mdb";
sms_conn = new OleDbConnection(strConn);
sms_conn.Open();
}