C#连接oracle数据库的问题[标签：HYPERLINK"http://wenwen.soso.com/z/Search.e?sp=Sc%23&ch=w.tag.yjj"\t"_blank"c#,HYPERLINK"http://wenwen.soso.com/z/Search.e?sp=Soracle&ch=w.tag.yjj"\t"_blank"oracle,HYPERLINK"http://wenwen.soso.com/z/Search.e?sp=S%E6%95%B0%E6%8D%AE%E5%BA%93&ch=w.tag.yjj"\t"_blank"数据库]usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Text;usingSystem.Windows.Forms;usingSystem.Data.OleDb;usingSystem.Data.OracleClient;namespaceabc{publicpartialclasslogin_win:Form{publiclogin_win(){InitializeComponent();}privatevoidlogin_button_Click(objectsender,EventArgse){stringconnString="DataSource=nes;UserID=nes;Password=nes";stringuser_name=user_textBox.Text;stringuser_password=pw_textBox.Text;OracleConnectionconn=newOracleConnection(connString);stringv_sql="select*fromneswherev_name='"+user_name+"'andv_password='"+user_password+"'";conn.Open();OracleCommandcmd=newOracleCommand();cmd.Connection=conn;cmd.CommandText=v_sql;try{if(cmd.ExecuteNonQuery()==0){MessageBox.Show("您的用户名或密码不正确！");}else{MessageBox.Show("欢迎使用！");}}catch{MessageBox.Show("数据库没链接上吗?");}finally{conn.Close();}}privatevoidcancel_button_Click(objectsender,EventArgse){Application.ExitThread();}C#连接oracle数据库操作2010-06-1614:231、导入引用System.Data.OracleClient.dll文件2、在头部usingSystem.Data.OracleClient;//通过DataSet来读取数据：//创建和数据库的连接OracleConnectionoraCon=newOracleConnection("userid=112;datasource=wmatech;password=112");//新建一个DataAdapter用于填充DataSetOracleDataAdapteroraDap=newOracleDataAdapter("select*fromactor",oraCon);//新建一个DataSetDataSetds=newDataSet();//填充DataSetoraDap.Fill(ds);//新建一个DataTableDataTable_table=ds.Tables[0];//查看表中数据的列数intcount=_table.Rows.Count;DataGrid1.DataSource=_table;DataGrid1.DataBind();//通过DataReader来读取数据：//创建和数据库的连接OracleConnectionoraCon=newOracleConnection("userid=112;datasource=wmatech;password=112");//新建一个对数据库操作的实例OracleCommandoraCmd=newOracleCommand("select*fromactor",oraCon);//打开数据库连接oraCon.Open();//DataReader提供一种从数据库