帮我看下 OleDbDataReader 哪出错了

[xxshuaingxx]

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 vi: System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
string idd = Request.QueryString["ID"];
//连接
string dbname = System.Web.HttpContext.Current.Server.MapPath("App_Data/dbdb.accdb");
string connStr = "PROVIDER=microsoft.ACE.oledb.12.0;Data Source=" + dbname;
OleDbConnection conn = new OleDbConnection(connStr);
conn.Open();
//控制
OleDbCommand cmd = new OleDbCommand();
cmd.Connection = conn;
cmd.CommandText = "select * from chanpin where idd=id";
//数据返回
OleDbDataReader mydata = cmd.ExecuteReader(); ------- 至少一个参数没有被指定值。
while (mydata.Read())
{
Label1.Text = mydata["cname"].ToString();
}
}
}

[我在深圳搬砖-Justin]

//这里错误
     cmd.CommandText = "select * from chanpin where idd=id"; 
  //修改为,idd是你前面request获取的
     cmd.CommandText = "select * from chanpin where 对应你表里面的ID ='"+idd+"'"; 

[wuyq11]

cmd.CommandText = "select * from chanpin where idd="+id;

cmd.CommandText = "select * from chanpin where idd='"+id+"'";

[红街咖啡]

string idd = Request.QueryString["ID"]; 
cmd.CommandText = "select * from chanpin where id='"+idd+"'"; 

[xxshuaingxx]

改了 说

标准表达式中数据类型不匹配。

[我在深圳搬砖-Justin]

[Quote=引用 4 楼 xxshuaingxx 的回复:]
改了  说 

标准表达式中数据类型不匹配。
[/Quote]
那应该是你的id是int类型的

//获取值的时候转换为int
int idd = int.Parse (Request.QueryString["ID"].ToString); 
//拼接SQL语句的时候 去掉引号
 cmd.CommandText = "select * from chanpin where 对应你表里面的ID ="+idd+";