Question

在asp.net中手动绑定GridView数据源后？GridView不显示数据？

private void Bind()
{
string sqlStr = "select * from Department";
SqlConnection MyCon = new SqlConnection(connectionString);
SqlDataAdapter sda = new SqlDataAdapter(sqlStr,MyCon);
DataTable dt = new DataTable();
sda.Fill(dt);
GridView_Department.DataSource = dt;
GridView_Department.DataBind();
}

protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Bind();
}
}

Answer 1

你用调试功能调试一下，看看dt里是不是有数据。。。

Answer 2

确认表中有数据

追问

有！

Answer 3

private void Bind()
{
string sqlStr = "select * from Department";
SqlConnection MyCon = new SqlConnection(connectionString);
MyCon.Open();
SqlDataAdapter sda = new SqlDataAdapter(sqlStr,MyCon);
DataTable dt = new DataTable();
sda.Fill(dt);
MyCon.close();
GridView_Department.DataSource = dt;
GridView_Department.DataBind();
}

Answer 4

开玩笑，都没见你MyCon.open();哪来的数据

追问

哥们，您是幽默呢？还是不懂装懂呢？开个玩笑！