初学者请教。三层 读取数据DataRow读取数据
----------------------DAL--------------------------
public static DataRow GetProductRow(int ProductID)
{
StringBuilder sb = new StringBuilder();
sb.Append("select * from Product where Product_ID=").Append(ProductID);
return SqlHelper.ExecuteDataRow(DBConnection.Conn.ConnectionString, CommandType.Text, sb.ToString());
}
----------------------BLL--------------------------
public DataRow GetProductRow(int ProductID)
{
return DAL.ProductDAL.GetProductRow(ProductID);
}
----------------------后台绑定到Textox--------------------------
int productId = 5;
DataRow dr = new DataRow();
dr=new BLL.ProductBLL().GetProductRow(productId);
sproduct_Name.Text = dr["product_Name"].ToString();
scost_Price.Text=dr["cost_Price"].ToString();
不是这样绑定数据的吗? 为啥报错呢?