mdb数据库名为123.mdb
表名为simple例如表结构如下id name
01 aaa
02 bbb窗体上添加textbox1和textbox2两个控件,在textbox1中输入查询条件(name)aaa,查出其id并显示在textbox2中这段代码怎么写,请给出代码实例(包括数据库连接\查询代码)!本人初学,望大家指教,谢谢,在先等!
表名为simple例如表结构如下id name
01 aaa
02 bbb窗体上添加textbox1和textbox2两个控件,在textbox1中输入查询条件(name)aaa,查出其id并显示在textbox2中这段代码怎么写,请给出代码实例(包括数据库连接\查询代码)!本人初学,望大家指教,谢谢,在先等!
在数据集中添加查询 ,select * from simple where name = @name;
返回一个DataTable ,然后textbox2.text = dt.Rows[0]["id"].toString();
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)
{
string name = tbUsername.Text.Trim();
OleDbConnection myCon = new OleDbConnection(ConfigurationManager.AppSettings["OleconnectionString"]);
OleDbCommand queryCmd = new OleDbCommand("select * from users where name='"+name+"'",myCon);
try
{
myCon.Open();
OleDbDataReader odr = queryCmd.ExecuteReader();
if (odr.Read())
{
if (odr["pwd"].ToString() == tbPwd.Text)
{
Session["name"] = tbUsername.Text.Trim();
//Server.Transfer("Option.aspx");
Response.Redirect("Option.aspx", true);
}
else
{
Response.Write("<script language=javascript>alert('用户名或密码错误')</script>");
}
}
else
{
Response.Write("<script language=javascript>alert('用户名或密码错误')</script>");
}
}
catch (Exception e1)
{
Response.Write("<script language=javascript>alert('数据库连接错误!')</script>");
Response.Write(e1.ToString());
}
finally
{
myCon.Close();
}
}
}参考下我写的登陆过程!
<appSettings>
<add key="OleconnectionString" value="Provider=Microsoft.Jet.OLEDB.4.0; Data Source=E:\C#\建材租赁系统\DataBase.mdb;User ID=Admin;Password=;"/>
</appSettings>
string strConnect ="PROVIDER=Microsoft.Jet.OLEDB.4.0;Jet OLEDB:Database Password=huangdonaldo;DATA Source=123.mdb";
OleDbConnection conConnection = new OleDbConnection ( strConnect ) ;
OleDbCommand cmd = new OleDbCommand(strCommand , conConnection );
conConnection.Open();
OleDbDataReader odr = cmd.ExecuteReader();
cmd.ExecuteReader();
textBox1.Text = odr["njbh"].ToString();
我是这样写的,但运行中提示cmd.ExecuteReader();至少一个参数没有被指定,怎么回事?是我代码写错了?
"select * from [aaa] where [name]='" + .text = "'";