关于数据库连接(datagrid,listview)

数据库连接主要就是oracle,sql,access数据库的连接,

最近oracle数据库的连接也成功了,但是在数据显示,主要想用datagrid,listview把数据显示出来,并做相应的修改方面还欠缺.不过也是一个学习的过程,一直在找这方面的资料和做测试 

Access 连接:

using System.Data.OleDb ;

 OleDbConnection dbconn=new OleDbConnection (@"Provider=Microsoft.Jet.OLEDB.4.0;Data source=e:/test.mdb");
   dbconn.Open ();
      OleDbDataAdapter myAdapter=new OleDbDataAdapter ("select student_id,name,sex,birthday from  student",dbconn);
   OleDbCommandBuilder myBuilder=new OleDbCommandBuilder (myAdapter);
   DataSet myDataSet=new DataSet ();
   myAdapter.Fill (myDataSet,"student");
   dataGrid1.DataSource =myDataSet.Tables ["student"];
   dbconn.Close ();

通过这段简单的代码就能所要查询的数据在dataGrid中显示出来了

oracle 连接:

using Oracle.DataAccess .Client ;

/ be sure to replace OTNSRVR with your host's name
   string oradb = "Data Source=(DESCRIPTION="              // C#
    + "(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=zhulin1)(PORT=1521)))"
    + "(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orazl)));"
    + "User Id=ems_user;Password=emssme;";

   OracleConnection conn = new OracleConnection(oradb);
   try
   {
    conn.Open();

    OracleCommand cmd = new OracleCommand();
    cmd.Connection = conn;
    // Lab 1 select string
    //    cmd.CommandText = "select dname from dept where deptno = 10";
    // Lab 2 select string
    //    cmd.CommandText = "select deptno, dname, loc from dept where deptno = " + textBox1.Text;
    // Lab 3 select string
    //add

    //OracleCommandBuilder builder=new OracleCommandBuilder ();
    cmd.CommandText = "select trade_mode,ems_no,du_mark from ems_dcr_head where rownum<10";

 
    cmd.CommandType = CommandType.Text;
       
    OracleDataReader dr = cmd.ExecuteReader();

    // Labs 1 and 2 data retrieval
    //    dr.Read();
    //
    // Lab 1 assign data to label
    //    label1.Text = dr.GetString(0); // .NET native type
    //    label1.Text = dr.GetOracleString(0).ToString(); // Oracle native type
    // Lab 2 assign data to label
    //    label1.Text = dr.GetString(1); // .NET native type
    //    label1.Text = dr.GetOracleString(1).ToString(); // Oracle native type

    // Lab 3 data retrieval
    while (dr.Read())
    {
     
     listBox1.Items.Add(dr.GetString (0)+"   The " + dr.GetString(1) +
      " department is in " + dr.GetString(2));
    }
   }
   catch (OracleException ex) // catches only Oracle errors
   {
    switch (ex.Number)
    {
     case 1:
      MessageBox.Show("Error attempting to insert duplicate data.");
      break;
     case 12545:
      MessageBox.Show("The database is unavailable.");
      break;
     default:
      MessageBox.Show("Database error: " + ex.Message.ToString());
      break;
    }
   }
   catch (Exception ex) // catches any error
   {
    MessageBox.Show(ex.Message.ToString());
   }
   finally
   {
    conn.Dispose(); // C#
   }

这段代码是拷贝oracle网站帮助上的,在我的回复里也有相关网址.

通过这段代码可以让数据在listbox中显示出来,在datagrid中显示还有一定的问题.哪位高手在这方面知道多一点

的也不妨把东西写出来共享一下.

**************************************

查了一些资料,这一段代码也应该可以,可是老是出现问题

string oradb = "Data Source=(DESCRIPTION="              // C#
    + "(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=zhulin1)(PORT=1521)))"
    + "(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orazl)));"
    + "User Id=ems_user;Password=emssme;";
   OracleConnection conn = new OracleConnection(oradb);
   conn.Open ();

   OracleDataAdapter thisAdapter=new OracleDataAdapter("select trade_mode,ems_no,du_mark from ems_dcr_head where rownum<10",conn);
            OracleCommandBuilder thisBuilder=new OracleCommandBuilder(thisAdapter);
   DataSet thisDataSet=new DataSet ();

   thisAdapter.Fill (thisDataSet,"ems_dcr_head");
   //Console.WriteLine ("you{0}",thisDataSet.Tables["ems_dcr_head"].Rows[2]["ems_no"]);
   conn.Close ();

这些问题只能以后慢慢解决了.sql数据库和这个代码查不多,连接字符串不一样而已

祝大家:周末愉快!明天可以睡个懒觉了