string aaa = Request.QueryString["id"];
//Response.Write(aaa);
string dbname;
dbname=Server.MapPath("lpan.mdb");
myConnection = new OleDbConnection( "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA Source=" + dbname );
myConnection.Open(); myCommand = new OleDbCommand( "select lpmc,qy FROM lpan where lpmc="+aaa+"", myConnection );
OleDbDataReader sr = myCommand.ExecuteReader();
while (sr.Read())
{
lpmc.Text = sr["lpmc"].ToString();
qy.Text = sr["qy"].ToString();
}
sr.Close();
myConnection.Close();
//Response.Write(aaa);
string dbname;
dbname=Server.MapPath("lpan.mdb");
myConnection = new OleDbConnection( "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA Source=" + dbname );
myConnection.Open(); myCommand = new OleDbCommand( "select lpmc,qy FROM lpan where lpmc="+aaa+"", myConnection );
OleDbDataReader sr = myCommand.ExecuteReader();
while (sr.Read())
{
lpmc.Text = sr["lpmc"].ToString();
qy.Text = sr["qy"].ToString();
}
sr.Close();
myConnection.Close();
解决方案 »
- SQL求两数差值最大的那一条数据
- IIS7.0 7.5版本出现的问题(未将对象引用到实例)
- 在web页面调用exe,上一帖未解决
- 求教,请帮忙看看是什么问题?
- 关于根据日期多表查询的问题(急,急,急,急,急,急,急,急)
- 一个ASP代码返回数据的问题
- 写完的web项目用IE却无法访问,也许是很菜的问题?
- 值赋不上去 document.getElementById("nameList").innerHTML = XmlHttp.responsetext;
- 微软打印模板的例子如何在网页上使用?哪位高人能告诉我?
- 如何在Asp.net(C#)中实现画图功能?
- 文本解析问题?谢谢
- SQL数据导出成EXCEL表!!
myCommand = new OleDbCommand( "select lpmc,qy FROM lpan where lpmc="+aaa+"", myConnection );
如果lpmc是数值型: myCommand = new OleDbCommand( "select lpmc,qy FROM lpan where lpmc="+aaa, myConnection );
如果lpmc是字符型:
myCommand = new OleDbCommand( "select lpmc,qy FROM lpan where lpmc='"+aaa+"'", myConnection );
lpmc.Text = sr["lpmc"].ToString();
qy.Text = sr["qy"].ToString();
的结果是LABEL 说明sr["lpmc"].ToString();是空的,但是数据库里确实是有这个字段的,为什么就没读到呢?