花卉管理系统（数据库+源码）

【实例截图】

【核心代码】

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 FlowerManagerSys
{
    public partial class frmChaXun : Form
    {
        public frmChaXun()
        {
            InitializeComponent();
        }
        #region 窗体加载事件
        private void frmChaXun_Load(object sender, EventArgs e)
        {
            XianShiCha();//绑定显示
        }
        #endregion

        //创建数据库连接字符串
        string dizhi = "Data Source=.;Initial Catalog=FlowerManagerSys;Integrated Security=True";

        #region 显示查询 
        public void XianShiCha()
        {
            //创建数据库连接对象
            SqlConnection conn = new SqlConnection(dizhi);
            //处理异常
            try
            {
                #region sql语句

                string sql = string.Format(@"select   name, anothername, property, price, production from
                   Flower where  name  like  '%{0}%'",this.txtnaem.Text.Trim());

                #endregion
                //数据集
                DataSet ds = new DataSet();
                //数据适配器
                SqlDataAdapter dr = new SqlDataAdapter(sql,conn);
                //填充数据
                dr.Fill(ds,"Cha");
                //绑定数据源显示花卉信息
                this.dgvchaxun.DataSource = ds.Tables["Cha"];
                
            }
            catch (Exception ex)
            {
                //异常处理打印
                MessageBox.Show("显示异常" ex.Message);
            }
        }
        #endregion

        #region 关闭按钮 只关闭当前窗体
        private void btnguanbi_Click(object sender, EventArgs e)
        {
            this.Close();
        }
        #endregion

        #region 查询按钮
        private void btnchaun_Click(object sender, EventArgs e)
        {
            XianShiCha();
        }
        #endregion
    }
}