namespace login
{
    public partial class addstore : Form
    {
        SqlDataAdapter sqlDataAdapter1;
        //存取數(shù)據(jù)庫(kù)的主要類
        SqlCommand sqlCommand1;
        //SQL語(yǔ)句處理的類
        SqlConnection sqlConnection1;
        // 表示是否處于插入新記錄的狀態(tài)
        private bool bNewRecord = false;
        DataSet dataSet1;
       
        // 獲取所有客戶的ID
        private void GetCustomID()
        {
            SqlDataReader sdr;
            sqlConnection1.Open();	// 打開(kāi)連接
            sdr = sqlCommand1.ExecuteReader(CommandBehavior.CloseConnection);
            cbxID.Items.Clear();
            while (sdr.Read())
            {
                // 把客戶ID插入到組合框控件中
                cbxID.Items.Add(sdr.GetValue(0));
            }
            sdr.Close();			// 關(guān)閉SqlDataReader對(duì)象和數(shù)據(jù)庫(kù)連接
           cbxID.SelectedIndex = 0;
        }
        public addstore()
        {
            InitializeComponent();
            // Windows 安全登錄機(jī)制
            String sConnString = "Data Source=localhost;Initial Catalog=WZGL_20052070;Integrated Security=True";
            //SQL語(yǔ)句
            String sSQL = "SELECT * FROM outstore";
            //創(chuàng)建一個(gè)數(shù)據(jù)庫(kù)連接對(duì)象
            sqlConnection1 = new SqlConnection(sConnString);
            sqlCommand1 = new SqlCommand(sSQL, sqlConnection1);

            //創(chuàng)建一個(gè)SqlDataAdapter對(duì)象
            sqlDataAdapter1 = new SqlDataAdapter(sSQL, sqlConnection1);
            // 創(chuàng)建一個(gè)DataSet對(duì)象
            dataSet1 = new DataSet();
            sqlDataAdapter1.Fill(dataSet1, "admin");
            dataGridView1.DataSource = dataSet1.Tables["admin"];
            sqlCommand1.CommandText = "SELECT pName FROM room order by pName";
            GetCustomID();
        }