DataBinding:“System.Data.DataRowView”不包含名为“id”的属性。
asp.net运行之后出现这个错误,但是我的sql语句中有id这个字段,请大神看一下哪里不对,如果是缓存的问题,那具体应该怎么操作?
这是代码
public partial class Gshouli : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
string sql = "select id,FormatId as 订单编号,type as 货物类型,sname as 寄件人姓名,saddress as 寄件人地址,sphone as 寄件人电话,gname as 收件人姓名,gaddress as 收件人地址,gphone as 收件人电话,beizhu as 备注,wuliu as 物流,cheliang as 车辆,cangku as 仓库,zhuanxian as 专线 from test where cheliang is null";
SqlConnection con = db.createconnection();
con.Open();
SqlCommand com = new SqlCommand(sql, con);
DataSet ds = new DataSet();
SqlDataAdapter sda = new SqlDataAdapter(com);
sda.Fill(ds, "test");
con.Close();
this.gridv1.DataSource = ds;
this.gridv1.DataBind();
}
protected void gridv1_SelectedIndexChanged(object sender, EventArgs e)
{
GridViewRow row = gridv1.SelectedRow;
string strUserId = row.Cells[2].Text;
Label1.Text = strUserId;
}
protected void Button1_Click(object sender, EventArgs e)
{
SqlConnection con = db.createconnection();
string sql = "update test set cheliang = '" + this.ddlcar.SelectedValue + "', cangku = '" + this.ddlcangku.SelectedValue + "',zhuanxian = '" + ddlzhuanxian.SelectedValue + "' where FormatId ='" + Label1.Text + "'";
con.Open();
SqlCommand cmd = new SqlCommand(sql, con);
cmd.ExecuteNonQuery();
con.Close();
Response.Write("<script language=javascript>alert('该订单已生成!')</script>");
}
}