using System;
using System.Data;
using System.Configuration;
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 _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{ }
protected void Button1_Click(object sender, EventArgs e)
{
OleDbConnection Conn = new OleDbConnection();
Conn.ConnectionString ="Provider=Microsoft.Jet.OLEDB.4.0;"+
"Data Source="+Server.MapPath("access.mdb");
Conn.Open();
string sql = "select * from employs_Infos";
if (TextBox1.Text != "")
sql = "Selecte * from employs_Infos Where name like'%" + TextBox1.Text + "%'";
OleDbCommand Comm = new OleDbCommand(sql, Conn);
OleDbDataReader DR = Comm.ExecuteReader();
DG.DataSource = DR;
DG.DataBind();
Conn.Close();
}
}
大家帮我看看哪错了 怎么.net提示说 “用户代码为处理”
还有我的.net中没有DataGrid控件!
我就把代码直接写上了
<asp:DataGrid ID="DG" runat="server">
</asp:DataGrid>
帮我看看哪处错了阿!
谢谢回复!!!
using System.Data;
using System.Configuration;
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 _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{ }
protected void Button1_Click(object sender, EventArgs e)
{
OleDbConnection Conn = new OleDbConnection();
Conn.ConnectionString ="Provider=Microsoft.Jet.OLEDB.4.0;"+
"Data Source="+Server.MapPath("access.mdb");
Conn.Open();
string sql = "select * from employs_Infos";
if (TextBox1.Text != "")
sql = "Selecte * from employs_Infos Where name like'%" + TextBox1.Text + "%'";
OleDbCommand Comm = new OleDbCommand(sql, Conn);
OleDbDataReader DR = Comm.ExecuteReader();
DG.DataSource = DR;
DG.DataBind();
Conn.Close();
}
}
大家帮我看看哪错了 怎么.net提示说 “用户代码为处理”
还有我的.net中没有DataGrid控件!
我就把代码直接写上了
<asp:DataGrid ID="DG" runat="server">
</asp:DataGrid>
帮我看看哪处错了阿!
谢谢回复!!!
可以通过:
工具箱上点右键选择“选择项",在弹的界面中找到DataGrid,确定,这样的你工具箱上就有了DataGrid了;还有,你的代码:OleDbConnection ,OleDbCommand,OleDbDataReader需要using System.Data.OleDb
是不是也该改成下面的呀。
sql = "Selecte * from employs_Infos Where name like '%" + TextBox1.Text + "%'";