c#TabControl中集成加载多个窗体，通过选项卡切换窗体并绑定数据库数据源

木子后更是

于 2023-09-26 16:35:57 发布

阅读量464

点赞数

文章标签： c# 数据库开发语言

本文链接：https://blog.csdn.net/qq_43510923/article/details/133314957

版权

c#TabControl中集成加载多个窗体，通过选项卡切换窗体并绑定数据库数据源

using DXApplication5;
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;

namespace TabControlExample
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void checkBox1_click(object sender, EventArgs e)
        {
            CheckChanged(sender);
            if (checkBox1.Checked==true )
            {
                comboBox1.Visible = true;
                comboBox2.Visible = false;
                string sql = string.Format("select U_Name from SYS_Users");
                
                //控件名.DataSource=数据集.数据表
                //comboBox1.DataSource = DBHlelper.Query(sql).Tables[0].Rows[0]["U_Name"];
                comboBox1.DataSource = DBHlelper.Query(sql).Tables[0];
                comboBox1.DisplayMember = "U_Name";
                comboBox1.ValueMember = "U_Name";
                }
        }


        private void checkBox2_click(object sender, EventArgs e)
        {
            CheckChanged(sender);
            if (checkBox2.Checked == true)
            {
                comboBox1.Visible = false;
                comboBox2.Visible = true;
            }
        }


        private void  CheckChanged(object sender)
        {
          
            if ((sender as CheckBox).Checked==true) {
                foreach(Control chk in ( sender as CheckBox).Parent.Controls )
                {
                    if(chk != sender && chk.GetType().ToString() == "System.Windows.Forms.CheckBox")
                    {
                        ((CheckBox)chk).Checked = false;
                    }

                }
            }
        }

    }
}