c#操作sql server2008 的界面

最新推荐文章于 2025-02-11 01:35:00 发布

sunshine-宏翊

最新推荐文章于 2025-02-11 01:35:00 发布

阅读量892

点赞数

CC 4.0 BY-SA版权

分类专栏：学习文章标签： sql 数据库 c# 界面

本文链接：https://blog.youkuaiyun.com/sun_boy_01/article/details/62037071

学习专栏收录该内容

4 篇文章

订阅专栏

本文介绍了如何使用C#进行数据库的基本操作，包括查询、修改和按条件查询表等内容。文章通过实例展示了如何利用DataGridView控件展示数据，以及如何通过ComboBox进行表的选择，并实现了根据不同条件进行数据查询的功能。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

先是查询整张表，用到combobox选择查询哪张表，最后用DataGridView显示

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


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


        private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {
            
        }


        private void Form1_Load(object sender, EventArgs e)
        {
     
            this.dataGridView1.RowHeadersVisible = false;
            this.dataGridView1.AllowUserToAddRows = false;
            this.dataGridView1.ReadOnly = true;
            this.dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
           // this.comboBox1.SelectedIndex =0;
            string sql = "select * from student";
            DataTable table = SqlManage.TableSelect(sql);
            this.dataGridView1.DataSource = table;
            comboBox1.Items.Add("学生表");
            comboBox1.Items.Add("教师表");




        }


        private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
        {
            string sql = "";
            switch (this.comboBox1.SelectedIndex)
            { 
                case 0:
                    sql = "select id as 学生号,name as 姓名,sage as 年龄 from student";
                    break;
                case 1:
                    sql = "select t_id as 教师号,t_name as 姓名,T_age as 年龄 from teacher";
                    break;
                default:
                    break;
            }


            DataTable table = SqlManage.TableSelect(sql);
            this.dataGridView1.DataSource = table;
        }


      
    }
}

然后是修改表格，这个比较简单，用到textbox和button

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

namespace WindowsFormsApplication2
{
    public partial class Form2 : Form
    {
        public Form2()
        {
            InitializeComponent();
        }

        private void button4_Click(object sender, EventArgs e)
        {
            this.Close();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            string sql = string.Format("insert into teacher values('{0}','{1}','{2}')",
                            this.textBox1.Text, this.textBox2.Text, this.textBox3.Text);
            SqlManage.TableChange(sql);
            
        }

        private void button2_Click(object sender, EventArgs e)
        {
            string sql = string.Format("update teacher set ('{0}',''{1}'','{2}')",
                            this.textBox1.Text, this.textBox2.Text, this.textBox3.Text);
            SqlManage.TableChange(sql);
        }

        private void button3_Click(object sender, EventArgs e)
        {
            string sql = string.Format("delete from teacher where t_id='{0}'",
                            this.textBox1.Text);
            SqlManage.TableChange(sql);
        }

        private void Form2_Load(object sender, EventArgs e)
        {

        }

       
    }
}

按条件查询表格，这个是核心，用到radiobutt，combobox,，button， DataGridView

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

namespace WindowsFormsApplication2
{
    public partial class Form3 : Form
    {
        public Form3()
        {
            InitializeComponent();
        }

        private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {

        }

        private void Form3_Load(object sender, EventArgs e)
        {
            this.comboBox1.Enabled = false;
            this.comboBox2.Enabled = false;
            this.comboBox3.Enabled = false;
            this.comboBox4.Enabled = false;
            //初始化教师编号
            string sql = "select t_id from teacher";
            DataTable table = SqlManage.TableSelect(sql);
            string t_id;
            foreach (DataRow row in table.Rows)
            {
                t_id = row["t_id"].ToString();
                this.comboBox1.Items.Add(t_id);
            }
            if (table.Rows.Count > 0)
            {
                this.comboBox1.SelectedIndex = 0;
            }

            //初始化教师姓名
            string sql_name = "select t_name from teacher";
            table.Clear();
            table = SqlManage.TableSelect(sql_name);
            string t_name;

            foreach (DataRow row in table.Rows)
            {
                t_name= row["t_name"].ToString();
                this.comboBox2.Items.Add(t_name);
            }
            if (table.Rows.Count > 0)
            {
                this.comboBox2.SelectedIndex = 0;
            }

            //初始化学生
            string sql_id = "select id from student";
            table.Clear();
            table = SqlManage.TableSelect(sql_id);
            string s_id;

            foreach (DataRow row in table.Rows)
            {
                s_id = row["id"].ToString();
                this.comboBox3.Items.Add(s_id);
            }
            if (table.Rows.Count > 0)
            {
                this.comboBox3.SelectedIndex = 0;
            }

            //初始化学生
            string sql_sname = "select name from student";
            table.Clear();
            table = SqlManage.TableSelect(sql_sname);
            string t_sname;

            foreach (DataRow row in table.Rows)
            {
                t_sname = row["name"].ToString();
                this.comboBox4.Items.Add(t_sname);
            }
            if (table.Rows.Count > 0)
            {
                this.comboBox4.SelectedIndex = 0;
            }
        }

        private void button2_Click(object sender, EventArgs e)
        {
            this.Close();

        }

        private void button1_Click(object sender, EventArgs e)
        {
            string sql = "";
            if (this.radioButton1.Checked)
            {
                sql = string.Format("select t_id as 教师编号,t_name as 教师姓名,t_age as 年龄 from teacher where t_id = '{0}'",
                    this.comboBox1.Text);
            }
            else if (this.radioButton2.Checked)
            {
                sql = string.Format("select t_id as 教师编号,t_name as 教师姓名,t_age as 年龄 from teacher where t_name = '{0}'",
                    this.comboBox2.Text);
            }
            else if (this.radioButton3.Checked)
            {
                sql = string.Format("select id as 学生编号,name as 学生姓名,sage as 年龄 from student where id = '{0}'",
                    this.comboBox3.Text);
            }

            else if (this.radioButton4.Checked)
            {
                sql = string.Format("select id as 学生编号,name as 学生姓名,sage as 年龄 from student where name = '{0}'",
                    this.comboBox4.Text);
            }


            DataTable table = SqlManage.TableSelect(sql);
            if (table.Rows.Count > 0)
            {
                this.dataGridView1.DataSource = table;
            }
            else
            {
                MessageBox.Show("没有相关内容");
            }
        }

        private void radioButton1_CheckedChanged(object sender, EventArgs e)
        {
            if (this.radioButton1.Checked)
            {
                this.comboBox1.Enabled = true;
            }
            else
            {
                this.comboBox1.Enabled = false;
            }
        }

        private void radioButton2_CheckedChanged(object sender, EventArgs e)
        {
            if (this.radioButton2.Checked)
            {
                this.comboBox2.Enabled = true;
            }
            else
            {
                this.comboBox2.Enabled = false;
            }
        }

        private void radioButton3_CheckedChanged(object sender, EventArgs e)
        {
            if (this.radioButton3.Checked)
            {
                this.comboBox3.Enabled = true;
            }
            else
            {
                this.comboBox3.Enabled = false;
            }
        }

        private void radioButton4_CheckedChanged(object sender, EventArgs e)
        {
            if (this.radioButton4.Checked)
            {
                this.comboBox4.Enabled = true;
            }
            else
            {
                this.comboBox4.Enabled = false;
            }
        }

        
    }
}