form3.cs

是个好用的!！！你愉快 的来用的哦．那可以是很好的哟立刻内好家伙棵开幕厂力量女爸爸 方法法环境２２饿的大公国各个是是常常方法

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;

namespace mySQLDataAdapter
{
    public partial class FormOrders : Form
    { 
        public string CustomerID = "";
        public FormOrders()
        {
            InitializeComponent();
        }
      
        private void FormOrders_Load(object sender, EventArgs e)
        {
            sqlConnection conn = new sqlconnection("data source=(local)"+"initial catalog=Northwind;"
                                                   +"integrated security=SSPI;"+"persist security info=False;"
                                                   +"workstation id=SUN;"+"packet size=4096");
            string sqlStatement = "SELECT * FROM Orders WHERE CustomerID=@ID" + "ORDER BY OrderID";
            sqlCommand sqlcmd = new sqlCommand(sqlStatement,conn);
            sqlcmd.Parameters.AddWithValue("@ID",CustomerID);
            conn.Open();
            sqlDataReader sdr = sqlcmd.ExecuteReader();
            int cols = sdr.FieldCount;
            lvOrders.BeginUpdate();
            for (int i = 0; i < cols; i++)
            {
                lvOrders.Columns.Add(sdr.GetName(i),100,HorizontalAlignment.Left);
            }
            string[] lvitem = new string[cols];
            object[] values=new object[cols];
            while (sdr.Read())
            {
                sdr.GetValues(values);
                for(int i=0;i<values.Length;i++)
                    lvitem[i]=values[i].ToString();
                ListViewItem lvi = new ListViewItem(lvitem);
                lvOrders.Items.Add(lvi);
            }
            lvOrders.EndUpdate();
            sdr.Close();
            conn.Close();
        }
    }
}