UC知道ASp.net 夸页面传值 Leble能接手到，但是用于SQL查询语句时老是获取异常
来源：百度知道 编辑：UC知道 时间：2024/06/07 03:02:19
.aspx
public partial class a : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!this.IsPostBack)
{
SqlConnection con = DB.createCon();
con.Open();
SqlDataAdapter sda = new SqlDataAdapter("select * from tb_Class", con);
DataSet ds = new DataSet();
sda.Fill(ds, "Class");
this.DataList1.DataSource = ds.Tables["Class"];
this.DataList1.DataKeyField = "ClassID";
this.DataList1.DataBind();
}
}
protected void DataList1_ItemCommand(object source, DataListCommandEventArgs e)
{
Response.Redirect("b.aspx?ClassID=" + DataList1.DataKeys[e.Item.ItemIndex].ToString());
}
}
b.aspx
public partial class b : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!this.IsPostBack)
{
string C = Request.Query
public partial class a : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!this.IsPostBack)
{
SqlConnection con = DB.createCon();
con.Open();
SqlDataAdapter sda = new SqlDataAdapter("select * from tb_Class", con);
DataSet ds = new DataSet();
sda.Fill(ds, "Class");
this.DataList1.DataSource = ds.Tables["Class"];
this.DataList1.DataKeyField = "ClassID";
this.DataList1.DataBind();
}
}
protected void DataList1_ItemCommand(object source, DataListCommandEventArgs e)
{
Response.Redirect("b.aspx?ClassID=" + DataList1.DataKeys[e.Item.ItemIndex].ToString());
}
}
b.aspx
public partial class b : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!this.IsPostBack)
{
string C = Request.Query
SqlDataAdapter sdr = new SqlDataAdapter("select * from tb_GoodsInfo where ClassID='" + C + '"', con);
这句错了
加号后边多了个单引号
SQL语句后少了个双引号
有关.net的问题，这里都有很详细的讲解，你可以参考一下，方法有很多
参考资料:http://www.baidu.com/s?wd=%B1%B1%B7%E7%CD%F8&rsv_bp=0&rsv_spt=3&inputT=422
SqlDataAdapter sdr = new SqlDataAdapter("select * from tb_GoodsInfo where ClassID='" + C + "'", con);
最后的分号写错了