C#教程之WinForm之窗体应用程序

当前位置:

首页 > Python基础教程 >

C#教程之WinForm之窗体应用程序

基本简单数据库操作（增删改查）

 1 using System;
 2 using System.Collections.Generic;
 3 using System.Windows.Forms;
 4 
 5 namespace DataBaseOperation
 6 {
 7     static class Program
 8     {
 9         /// <summary>
10         /// 应用程序的主入口点。
11         /// </summary>
12         [STAThread]
13         static void Main()
14         {
15             Application.EnableVisualStyles();
16             Application.SetCompatibleTextRenderingDefault(false);
17             Application.Run(new frmMain());
18         }
19     }
20 }

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

namespace DataBaseOperation
{
   public partial class frmMain : Form
   {
       public frmMain()
       {
           InitializeComponent();
       }

       private void btnSelect_Click(object sender, EventArgs e)
       {
           frmSelect fs = new frmSelect();
           fs.ShowDialog();
       }

       private void btnInsert_Click(object sender, EventArgs e)
       {
           frmInsert fi = new frmInsert();
           fi.ShowDialog();
       }

       private void btnUpdate_Click(object sender, EventArgs e)
       {
           frmUpdate fu = new frmUpdate();
           fu.ShowDialog();
       }

       private void btnDelete_Click(object sender, EventArgs e)
       {
           frmDelete fd = new frmDelete();
           fd.ShowDialog();
       }

       private void frmMain_Load(object sender, EventArgs e)
       {
           
           this.Left = Screen.PrimaryScreen.WorkingArea.Width - this.Width;
           this.Top = Screen.PrimaryScreen.WorkingArea.Height - this.Height;
       }
   }
}
			

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

namespace DataBaseOperation
{
   public partial class frmDelete : Form
   {
       public frmDelete()
       {
           InitializeComponent();
       }

       SqlDataAdapter sda;//
       DataSet ds = new DataSet();//

       private void frmDelete_Load(object sender, EventArgs e)
       {
          //窗体加载时查询表中全部信息

          //1.
           string sql = "select sid,sname,ssex,saddress,semail from students";

          //2.
           sda = new SqlDataAdapter(sql, DBHelper.connection);
           
           int result = sda.Fill(ds);

           if (result > 0)
           {
               this.dataGridView1.DataSource = ds.Tables[0];
           }
           else
           {
               MessageBox.Show("表中无信息");
           }
          
       }

       private void 删除选中行ToolStripMenuItem_Click(object sender, EventArgs e)
       {
           if (this.dataGridView1.SelectedRows.Count > 0)
           {
               //1.
               string id = this.dataGridView1.SelectedRows[0].Cells["sid"].Value.ToString();

               //2.
               string sql = string.Format("delete from students where sid={0}", id);

               //3.

               try
               {
                   SqlCommand command = new SqlCommand(sql, DBHelper.connection);
                   DBHelper.connection.Open();
                   int result = command.ExecuteNonQuery();
                   if (result > 0)
                   {
                       MessageBox.Show("成功删除该行信息！");
                   }
                   else
                   {
                       MessageBox.Show("操作失败！");
                   }
               }
               catch (Exception ex)
               {

                   MessageBox.Show(ex.Message);
               }
               finally
               {
                   DBHelper.connection.Close();
               }
           }
           else
           {
               MessageBox.Show("请选中要删除的行");
           }

           //刷新控件中信息行
           this.dataGridView1.Rows.Remove(this.dataGridView1.SelectedRows[0]);
       }

       private void btnSearchAll_Click(object sender, EventArgs e)
       {
           //1.清空ds中的表信息
           ds.Tables.Clear();

           //2.
           int result = sda.Fill(ds);
           if (result > 0)
           {
               this.dataGridView1.DataSource = ds.Tables[0];
           }
           else
           {
               MessageBox.Show("表中无信息");
           }
       }

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

       private void dataGridView1_MouseDoubleClick(object sender, MouseEventArgs e)
       {

       }

       private void contextMenuStrip1_Opening(object sender, CancelEventArgs e)
       {

       }
   }
}
			

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

namespace DataBaseOperation
{
   public partial class frmInsert : Form
   {
       public frmInsert()
       {
           InitializeComponent();
       }

       private void btnReset_Click(object sender, EventArgs e)
       {
           this.txtName.Text = "";
           this.txtAddress.Text = "";
           this.txtEmail.Text = "";
           this.radMan.Checked = true;
           this.txtName.Focus();
       }

       private void btnInsert_Click(object sender, EventArgs e)
       {
           //1.获取控件中用户输入的学员信息
           string name = this.txtName.Text.Trim();
           string sex;
           if (this.radMan.Checked)
           {
               sex = "1";
           }
           else
           {
               sex = "0";
           }
           MessageBox.Show(sex);
           string address = this.txtAddress.Text.Trim();
           string email= this.txtEmail.Text.Trim();

           //2.
           string sql=string.Format("insert into students (sname,ssex,saddress,semail) values('{0}',{1},'{2}','{3}')",name,sex,address,email);

           //3.
           try
           {
               SqlCommand command = new SqlCommand(sql, DBHelper.connection);
               DBHelper.connection.Open();
               int result = command.ExecuteNonQuery();
               if (result > 0)
               {
                   MessageBox.Show("成功添加一条学员信息");
               }
               else
               {
                   MessageBox.Show("操作失败！");
               }
           }
           catch (Exception ex)
           {

               MessageBox.Show(ex.Message);
           }
           finally
           {
               DBHelper.connection.Close();
           }
       }
   }
}
			

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

namespace DataBaseOperation
{
   public partial class frmSelect : Form
   {
       public frmSelect()
       {
           InitializeComponent();
       }

       private void btnSearchName_Click(object sender, EventArgs e)
       {
           //根据学号查询学员姓名
           string id = this.txtNum1.Text.Trim();
           if (id != "")
           {
               string sql = string.Format("select sname from students where sid={0}", id);
               try
               {
                   SqlCommand command = new SqlCommand(sql, DBHelper.connection);
                   DBHelper.connection.Open();
                   object name = command.ExecuteScalar();
                   if (name != null)
                   {
                       this.lblName.Text = "此学员的姓名为：" + name.ToString();
                   }
                   else
                   {
                       MessageBox.Show("查无此人！");
                       this.lblName.Text = "";
                       this.txtNum1.Text = "";
                       this.txtNum1.Focus();
                   }


               }
               catch (Exception ex)
               {

                   MessageBox.Show(ex.Message);
               }
               finally
               {
                   DBHelper.connection.Close();
               }
           }
           else
           {
               MessageBox.Show("请输入学号！");
           }
       }

       private void btnSearchStudentInfo_Click(object sender, EventArgs e)
       {
           //根据学号查询学员信息
           string id = this.txtNum2.Text.Trim();
           if (id != "")
           {
               string sql = string.Format("select sname,ssex,saddress,semail from students where sid={0}", id);
               try
               {
                   SqlCommand command = new SqlCommand(sql, DBHelper.connection);
                   DBHelper.connection.Open();
                   SqlDataReader sdr = command.ExecuteReader();
                   if (sdr.Read())
                   {
                       this.txtName1.Text = sdr["sname"].ToString();
                       // MessageBox.Show("性别字段的值："+sdr["ssex"].ToString());
                       if (sdr["ssex"].ToString().ToLower() == "true")
                       {
                           this.radMan1.Checked = true;
                       }
                       else
                       {
                           this.radWoman1.Checked = true;
                       }
                       this.txtAddress.Text = sdr["saddress"].ToString();
                       this.txtEmail.Text = sdr["semail"].ToString();
                   }
                   else
                   {
                       MessageBox.Show("查无此人！");
                       this.txtNum2.Text = "";
                       this.txtNum2.Focus();
                       this.txtName1.Text = "";
                       this.radMan1.Checked = true;
                       this.txtAddress.Text = "";
                       this.txtEmail.Text = "";
                   }

                   sdr.Close();


               }
               catch (Exception ex)
               {

                   MessageBox.Show(ex.Message);
               }
               finally
               {
                   DBHelper.connection.Close();
               }
           }
           else
           {
               MessageBox.Show("请输入学号！");
           }
       }

       DataSet ds = new DataSet();//创建数据集对象
       SqlDataAdapter sda;//声明数据适配器

       private void btnSearchBySex1_Click(object sender, EventArgs e)
       {
           //清空数据集中表信息
           ds.Tables.Clear();

           //根据性别查询学员信息
           string sex;
           if (this.radMan2.Checked)
           {
               sex = this.radMan2.Tag.ToString();
           }
           else
           {
               sex = this.radWoman2.Tag.ToString();
           }
           MessageBox.Show("性别的值为：" + sex);

           string sql = string.Format("select sid,sname,ssex,saddress,semail from student where ssex={0}", sex);
           //创建数据适配器对象
           sda = new SqlDataAdapter(sql, DBHelper.connection);
           int result = sda.Fill(ds);
           if (result > 0)
           {
               this.dgvStudentInfo.DataSource = ds.Tables[0];
           }
           else
           {
               MessageBox.Show("无查询结果");
           }


       }

       private void btnSearchBySex2_Click(object sender, EventArgs e)
       {
           //清空数据集中表信息
           ds.Tables.Clear();

           //根据性别查询学员信息
           string sex;
           if (this.cboSex1.Text != "")
           {
               if (this.cboSex1.Text == "男")
               {
                   sex = "1";
               }
               else
               {
                   sex = "0";
               }
               MessageBox.Show("性别的值为：" + sex);
           }
           else
           {
               MessageBox.Show("请选择性别");
               return;
           }
           
180
      



  

   共2页: 
上一页
1
2
下一页

  

栏目列表