求助:c#查询oracle数据库中的表的字段内容并按列显示在listbox中
来源:百度知道 编辑:UC知道 时间:2024/06/15 09:44:42
具体实现时确实遇到问题了,也是正在学习中写的也不够精炼,麻烦高手贴一下代码 或者HI我,谢谢了
protected void Button1_Click(object sender, EventArgs e)
{
string Afieldname="";//得到列的名字
ListBox1.Items.Clear();
OleDbConnection conn=new OleDbConnection();
OleDbCommand dbc = new OleDbCommand("select distint "+Afieldname+" from theTable", conn);
OleDbDataReader dr = dbc.ExecuteReader();
while (dr.Read())
{
ListBox1.Items.Add(dr[0].ToString());
}
dr.Close();
dbc.Dispose();
conn.Close();
}
string strSelect="select distinct 字段名 from test ";//查询字符串
DataSet myset = new DataSet();//数据集
try
{
OracleConnection conn = new OracleConnection("数据库连接字符串");//连接对象
conn.Open();
OracleDataAdapter adapter = new OracleDataAdapter(strSelect, cd.conn);
adapter.Fill(myset);
ListBox1.DataSourc