餐厅项目查询

 

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace 餐厅
{
    public partial class Form1 : Form
    {



        public Form1()
        {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            LoadDeskInfoByDelFlag(0);

        }

        private void LoadDeskInfoByDelFlag(int p)
        {
            //新建集合
            List<DeskInfo> list = new List<DeskInfo>();
            //数据库字符串
            string str = "Data Source=.;Initial Catalog=mysql;Integrated Security=True";
            //sql语句，flag为0的餐桌
            string sql = "select DeskId,DeskName,DeskNamePinYin,DeskNum from DeskInfo where DeskDelFlag = " + p;
            //string sql = "select * from DeskInfo";
            SqlConnection con = new SqlConnection(str);
            con.Open();
            SqlCommand cmd = new SqlCommand(sql, con);
            //cmd.reader为查询
            SqlDataReader reader = cmd.ExecuteReader();
            //判断是否读取了一行
            if (reader.HasRows)
            {
                //当读取的时候
                while (reader.Read())
                {
                    //实例化餐桌类，为每个属性赋值，值为数据库里的值，进行类型转换
                    DeskInfo dk = new DeskInfo();
                    dk.DeskId = Convert.ToInt32(reader["DeskId"]);
                    dk.DeskName = reader["DeskName"].ToString();
                    dk.DeskNamePinYin = reader["DeskNamePinYin"].ToString();
                    dk.DeskNum = reader["DeskNum"].ToString();
                    //把属性添加进list
                    list.Add(dk);
                }

            }
            //禁止自动生成列，没有delflag那一列了。
            dgv.AutoGenerateColumns = false;
            //绑定数据
            dgv.DataSource = list;

            //关闭数据库各项
            con.Dispose();
            cmd.Dispose();
            reader.Dispose();
        }
    }
}