Question

用三层架构,将查询数据显示在datagirdview上，运行结果为空的。。。读不出来数据

UI： private void table1_Load(object sender, EventArgs e)
{
DataSet ds = new userBll().SelectAll();
DataView dv = new DataView(new userBll().SelectAll().Tables[0]);

dataGridView1.DataSource = dv;
}
BLL： public DataSet SelectAll()
{
UserService sevrice = new UserService();
return sevrice.SelectAll();
}
DAL ： public DataSet SelectAll(){
string sql = "SELECT delivery.delivery_date as 单据日期,deliverygoods.goods_no as 货号,deliverydetail.colorid as 颜色,deliverygoods.quantity as 数量,deliverygoods.quantity*unitprice as 金额,deliverygoods.DeliveryGoodsID from delivery,deliverygoods,deliverydetail where delivery.deliveryid=deliverygoods.deliveryid and deliverygoods.deliverygoodsid=deliverydetail.deliverygoodsid order by delivery.delivery_date desc,deliverygoods.goods_no asc,deliverygoods.quantity desc";
string setting = ConfigurationManager.ConnectionStrings[@"Data Source=ADMIN-PC;Initial Catalog=regent;User ID=sa"].ToString();

SqlConnection conn = new SqlConnection(setting);
conn.Open();

SqlCommand cmd = new SqlCommand(sql, conn);
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
DataSet st = new DataSet();
adapter.Fill(st);
return st;
}
MODEL：
public class user
{

public string DeliveryDate { get; set; }
public string Goods_No { get; set; }
public string ColorID { get; set; }
public int Quantity { get; set; }
public double UnitPrice { get; set; }
}

Answer 1

private void table1_Load(object sender, EventArgs e)
{
DataSet ds = new userBll().SelectAll();
DataView dv = new DataView(new userBll().SelectAll().Tables[0]);

dataGridView1.DataSource = dv;
dataGridView1.DataBind();
}
少了dataGridView1.DataBind()数据绑定
如果还没数据，就打断点各层跟踪一下

追问

datagridview没有databind

datagridview没有databind

追答

winform啊，我以为是ASP.net呢，那你就在每个执行的方法前打个断点，跟一下！
或者先看下new userBll().SelectAll().Tables[0].Rows.Count 看是不是0

追问

不会打断呢，新手，能不能教一下，扣扣:1711945569

追答

你百度一下吧，我机器没VS，另外你的代码可以直接写成：
private void table1_Load(object sender, EventArgs e)
{
DataSet ds = new userBll().SelectAll();
if(ds.Tables[0].Rows.Count>0)
{
dataGridView1.DataSource = ds.Tables[0];
}
else
{
MessageBox.Show("没数据”);
}

}