C#在winform中实现数据增删改查等功能

3.代码仅供参考：

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 Data
{
 public partial class Form1 : Form
 {
  
  public Form1()
  {
   InitializeComponent();   
  }     
    
  DataSet ds = new DataSet();
  DataTable dt = new DataTable();

  private void TextBoxNull()
  {
   textBox1.Text = "";
   textBox2.Text = "";
   textBox3.Text = "";
   textBox4.Text = "";
  }
  private void 用户ToolStripMenuItem_Click(object sender, EventArgs e)
  {
   TextBoxNull();
   ds = SqlDesigner.ExecuteDataSet("select * from dtuser");   
   dt = ds.Tables[0];
   dataGridView1.DataSource = dt;
   labelshow();
  }

  private void 角色ToolStripMenuItem_Click(object sender, EventArgs e)
  {
   TextBoxNull();
   ds = SqlDesigner.ExecuteDataSet("select *from dtrole");
   dt = ds.Tables[0];
   dataGridView1.DataSource = dt;
   label4.Text = "None";
   textBox4.Text = "None";
   labelshow();
  }

  private void 对象ToolStripMenuItem_Click(object sender, EventArgs e)
  {
   TextBoxNull();
   ds = SqlDesigner.ExecuteDataSet("select * from dtfunction");
   dt = ds.Tables[0];
   dataGridView1.DataSource = dt;
   labelshow();
  }

  private void 帮助ToolStripMenuItem_Click(object sender, EventArgs e)
  {
   TextBoxNull();
   ds = SqlDesigner.ExecuteDataSet("select * from help");
   dt = ds.Tables[0];
   dataGridView1.DataSource = dt;
   dataGridView1.Columns[1].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
  }
  //双击dataGridView1
  private void dataGridView1_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
  {
   string index = dataGridView1.CurrentRow.Cells[0].Value.ToString();
   if (label1.Text == "uid")
   {
    ds = SqlDesigner.ExecuteDataSet("select *from dtuser where uid='" + index + "'");
    dt = ds.Tables[0];
    DataRow row = dt.Rows[0];
    textBox1.Text = row["uid"].ToString();
    textBox2.Text = row["uname"].ToString();
    textBox3.Text = row["pwd"].ToString();
    textBox4.Text = row["uflag"].ToString();
   }
   if (label1.Text == "rid")
   {
    ds = SqlDesigner.ExecuteDataSet("select *from dtrole where rid='" + index + "'");
    dt = ds.Tables[0];
    DataRow row = dt.Rows[0];
    textBox1.Text = row["rid"].ToString();
    textBox2.Text = row["rname"].ToString();
    textBox3.Text = row["flag"].ToString();
    textBox4.Text = "None";
   }
   if (label1.Text == "fid")
   {
    ds = SqlDesigner.ExecuteDataSet("select *from dtfunction where fid='" + index + "'");
    dt = ds.Tables[0];
    DataRow row = dt.Rows[0];
    textBox1.Text = row["fid"].ToString();
    textBox2.Text = row["fname"].ToString();
    textBox3.Text = row["flag"].ToString();
    textBox4.Text = row["uflag"].ToString();
   }
  }
  private void labelshow() 
  {
   label1.Text = dataGridView1.Columns[0].HeaderText;
   label2.Text = dataGridView1.Columns[1].HeaderText;
   label3.Text = dataGridView1.Columns[2].HeaderText;
   try
   {
    label4.Text = dataGridView1.Columns[3].HeaderText;
   }
   catch (Exception)
   {

    label4.Text = "None";
   }               
  }    
  private void btn_add_Click(object sender, EventArgs e)
  {   
   int i = 0;
   if (label1.Text=="uid")
   {
    string str = SqlDesigner.GetMD5(textBox3.Text.Trim());    
    i = SqlDesigner.ExecuteNoQuery("insert into dtuser(uid,uname,pwd,uflag)values('" + textBox1.Text + "','" + textBox2.Text + "','" + str + "','" + textBox4.Text + "')");
   }
   else if (label1.Text == "rid")
   {    
    i = SqlDesigner.ExecuteNoQuery("insert into dtrole(rid,rname,flag)values('" + textBox1.Text + "','" + textBox2.Text + "','" + textBox3.Text + "')");
   }
   else
   {
    try
    {
     i = SqlDesigner.ExecuteNoQuery("insert into dtfunction(fid,rid,uid,uflag)values('" + textBox1.Text + "','" + textBox2.Text + "','" + textBox3.Text + "','" + textBox4.Text + "')");
    }
    catch (Exception)
    {
     MessageBox.Show("添加失败");
    }
    
   }
   
   if (i > 0)
   {
    MessageBox.Show("添加成功");
   }
   else
   {
    MessageBox.Show("添加失败");
   }          
  }
  
  private void btn_del_Click(object sender, EventArgs e)
  {
   int i = 0;
   string currentIndex = dataGridView1.CurrentRow.Cells[0].Value.ToString();
   if (label1.Text=="uid")
   {
    i = SqlDesigner.ExecuteNoQuery("delete from dtuser where uid='" + currentIndex + "'");
   }
   else if (label1.Text=="fid")
   {
    i = SqlDesigner.ExecuteNoQuery("delete from dtfunction where fid='" + currentIndex + "'");
   }
   else
   {
    i = SqlDesigner.ExecuteNoQuery("delete from dtrole where rid='" + currentIndex + "'");
   }
   if (i > 0)
   {
    MessageBox.Show("删除成功");
   }
   else
   {
    MessageBox.Show("删除失败");
   }
  }

  private void btn_update_Click(object sender, EventArgs e)
  {
   int i = 0;
   if (label1.Text == "rid")
   {
    i = SqlDesigner.ExecuteNoQuery("update dtrole set rname='" + textBox2.Text + "',flag='" + textBox3.Text + "'where rid='" + textBox1.Text + "'");
   }
   if (label1.Text == "uid")
   {
    i = SqlDesigner.ExecuteNoQuery("update dtuser set uname='" + textBox2.Text + "',pwd='" + textBox3.Text + "',uflag='" + textBox4.Text + "'where uid='" + textBox1.Text + "'");
   }
   if (label1.Text=="fid")
   {
    i = SqlDesigner.ExecuteNoQuery("update dtfunction set rid='" + textBox2.Text + "',uid='" + textBox3.Text + "',uflag='" + textBox4.Text + "'where fid='" + textBox1.Text + "'");
   }
   if (i > 0)
   {
    MessageBox.Show("Succeed！");
   }
   else
   {
    MessageBox.Show("Failed！");
   }
  } 

  
 }
}
								 
 2/3   首页 上一页 1 2 3 下一页 尾页