我正在努力使我的dataGrid viev查询结果。与数据库的连接很好。这是我的代码示例:
using (OracleConnection conn = new OracleConnection())
{
conn.ConnectionString = "properConnectionString"
conn.Open();
OracleCommand cmd = new OracleCommand();
cmd.Connection = conn;
cmd.CommandText = "select * FROM WORKERS";
cmd.CommandType = CommandType.Text;
OracleDataReader dr = cmd.ExecuteReader();
using (OracleDataAdapter orclDataAdapter = new OracleDataAdapter(cmd))
{
DataTable dt = new DataTable();
orclDataAdapter.Fill(dt);
dataGridView1.DataSource = dt;
}
}
假设您对 Oracle 数据库的调用实际上返回数据,则网格视图上缺少 databind 语句。 添加这个:
dataGridView1.DataBind();
将其放在dataGridView1.DataSource = dt;
行代码之后。