)
{
MessageBox.Show(ex.Message);
}finally
{
conn.Close();
}
}
}
}
GridView_UserInfo.cs
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.OracleClient;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.Common;
using Oracle.DataAccess;
namespace Net3._5_oracleTest
{
public partial class GrideViews_UserInfo : Form
{
public GrideViews_UserInfo()
{
InitializeComponent();
}
private void GrideViews_UserInfo_Load(object sender, EventArgs e)
{
string sql1 = "SELECT * FROM infoofuser";
OracleConnection myconn = new OracleConnection(globals.connectionString);
OracleCommand mycmd = myconn.CreateCommand();
mycmd.CommandText = sql1;
myconn.Open();
OracleDataAdapter oraDA = new OracleDataAdapter(mycmd);
DataSet ds = new DataSet();
oraDA.Fill(ds);
myconn.Close();
DataTable dtbl = ds.Tables[0];
this.dataGridView1.DataSource = dtbl;
}
}
}
总结: 如果你的引用没有我说的两个,需要在项目里找引用,然后右键选择添加
这个是大家都知道的,oracle的各种错误让人烦恼不已,各种错误,幸好有百度,可以查询错在哪里,所以不要害怕困难,多总结.
|