ADO.NET详细研究（四）－－实例演示DataReader基本操作

              // TODO: 在此处添加构造函数逻辑

              //

          }

         /// <summary>

         /// 获得所有联系人信息

         /// </summary>

         /// <returns>所有联系人信息</returns>

         public SqlDataReader getReader()

         {

              string sql = "select Fid,Fname,Fphone,Faddress from friend";

              SqlConnection conn = new SqlConnection(connStr);

              conn.Open();

              SqlCommand cmd = new SqlCommand(sql,conn);

              SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection);

              return reader;

         }

     }

}

我的目的很明显,我将调用getReader方法得到我须要的DataReader，因此在Form1里面的getInfo方法代码如下：

private void getInfo()

         {

              contractDB cdb = new contractDB();

              try

              {

                   SqlDataReader reader = cdb.getReader();

                   this.listView.Items.Clear();

                   while(reader.Read())

                   {

                       string[] subItems = new string[]

                       {

                            reader.GetInt32(0).ToString(),

                            reader.GetString(1),

                            reader.GetString(2),

                            reader.GetString(3)

                       };

                       this.listView.Items.Add(new ListViewItem(subItems));

                   }

                   reader.Close();

              }

              catch(Exception ex)

              {

                   MessageBox.Show(ex.ToString());

            &

上一页  [1] [2] [3] [4]  下一页

Copyright ＠ 2007-2012 敏韬网(敏而好学，文韬武略--MinTao.Net)（学习笔记） Inc All Rights Reserved.
闵涛 E_mail:admin@mintao.net(欢迎提供学习资源)

鄂公网安备 42011102001154号

站长：MinTao ICP备案号：鄂ICP备11006601号-18