Question

手动绑定GridView数据源

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

private void BindData()
{
string ConStr="data source=xhjj;user=gl;password=gl;";
OracleConnection MyCon = new OracleConnection(ConStr);
string QueryStr = "SELECT customerid,CompanyName,ContactName,Address FROM customers"; OracleDataAdapter Da = new OracleDataAdapter(QueryStr, MyCon);
DataSet Ds = new DataSet();
Da.Fill(Ds, "Customers");
GridView1.DataSource = Ds.Tables[0];
GridView1.DataKeyNames = new string[] { "customerid" };
GridView1.DataBind();
}
运行了，没出错，但显示空白（我的数据库有数据），不知什么原因，求教！
感谢qinsncn的回复，但调试过，不成功，仍然没有数据显示。

Answer 1

private void BindData()
{
string ConStr="data source=xhjj;user=gl;password=gl;";
OracleConnection MyCon = new OracleConnection(ConStr);
string QueryStr = "SELECT customerid,CompanyName,ContactName,Address FROM customers";
OracleDataAdapter Da = new OracleDataAdapter(QueryStr, MyCon);
DataSet Ds = new DataSet();
Da.Fill(Ds, "Customers");
GridView1.DataSource = Ds.Tables["Customers"].DefaultView; //修改这句
GridView1.DataKeyNames = new string[] { "customerid" };
GridView1.DataBind();
}

Answer 2

OracleConnection MyCon = new OracleConnection(ConStr);
//加一句
MyCon.Open();
string QueryStr = "SELECT customerid,CompanyName,ContactName,Address FROM customers"; OracleDataAdapter Da = new OracleDataAdapter(QueryStr, MyCon);