新建 Microsoft Word Document

C# wendang

using System;

using System.Collections.Generic;

using https://www.wendangku.net/doc/0a8656660.html,ponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Windows.Forms;

using System.Data.SqlClient;

using ADL;

namespace WindowsFormsApplication1

{

public partial class Form1 : Form

{

public Form1()

{

InitializeComponent();

}

private void Form1_Load(object sender, EventArgs e)

{

//SqlConnection con = new SqlConnection();

//con.ConnectionString = "server=rjxy1-1;database=ZFHC;uid=sa;pwd=sa";

//SqlCommand cmd = new SqlCommand("select * from manager", con);

//con.Open();

//SqlDataReader dr = cmd.ExecuteReader();

//while (dr.Read())

//{

// listBox1.Items.Add(dr[0].ToString() + "\t" + dr[1].ToString() + "\t" + dr[2].ToString());

//}

//con.Close();

//SqlConnection con = new SqlConnection();

//con.ConnectionString = "server=rjxy1-1;database=ZFHC;uid=sa;pwd=sa";

//SqlDataAdapter da = new SqlDataAdapter("select * from manager", con);

//DataSet ds = new DataSet();

//da.Fill(ds, "tables");

//for (int i = 0; i < ds.Tables["tables"].Rows.Count; i++)

//{

// listBox1.Items.Add(ds.Tables[0].Rows[i][0].ToString() + "\t" +

ds.Tables[0].Rows[i][1].ToString() + "\t" + ds.Tables[0].Rows[i][1].ToString());

//}

DataSet dt = DBhelper.Query("select * from manager");

if (dt != null)

{

this.dataGridView1.DataSource = dt.Tables[0];

//for (int i = 0; i < dt.Tables[0].Rows.Count; i++)

//{

// listBox1.Items.Add(dt.Tables[0].Rows[i][0].ToString() + "\t" + dt.Tables[0].Rows[i][1].ToString() + "\t" + dt.Tables[0].Rows[i][2].ToString());

//}

}

}

private void button1_Click(object sender, EventArgs e)

{

//con.ConnectionString = "server=rjxy1-1;database=ZFHC;uid=sa;pwd=sa";

try

{

string sql = string.Format("insert into manager(userName,passWord) values('{0}','{1}')", this.textBox1.Text, this.textBox2.Text);

if (DBhelper.NonQuery(sql) !=0)

MessageBox.Show("添加成功");

}

catch (SqlException err)

{

MessageBox.Show(err.Message, "添加失败");

}

}

private void button3_Click(object sender, EventArgs e)

{

//SqlConnection con = new SqlConnection();

//con.ConnectionString = "server=rjxy1-1;database=ZFHC;uid=sa;pwd=sa";

try

{

string sql = string.Format("delete from manager where userName='{0}'", this.textBox1.Text);

//SqlCommand cmd = new SqlCommand(sql,con);

//con.Open();

//cmd.ExecuteNonQuery();

//con.Close();

if (DBhelper.NonQuery(sql) != 0)

MessageBox.Show("删除成功");

}

catch (SqlException err)

{

MessageBox.Show(err.Message, "删除失败");

}

}

private void button2_Click(object sender, EventArgs e)

{

//listBox1.Items.Clear();

//SqlConnection con = new SqlConnection();

//con.ConnectionString = "server=rjxy1-1;database=ZFHC;uid=sa;pwd=sa";

//SqlCommand cmd = new SqlCommand("select * from manager", con);

//con.Open();

//SqlDataReader dr = cmd.ExecuteReader();

//while (dr.Read())

//{

// listBox1.Items.Add(dr[0].ToString() + "\t" + dr[1].ToString() + "\t" + dr[2].ToString());

//}

//con.Close();

//DataSet dt = DBhelper.Query("select * from manager");

//if (dt != null)

//{

// for (int i = 0; i < dt.Tables[0].Rows.Count; i++)

// {

// listBox1.Items.Add(dt.Tables[0].Rows[i][0].ToString() + "\t" + dt.Tables[0].Rows[i][1].ToString() + "\t" + dt.Tables[0].Rows[i][2].ToString());

// }

//}

DataSet dt = DBhelper.Query("select * from manager");

if (dt != null)

{

this.dataGridView1.DataSource = dt.Tables[0];

//for (int i = 0; i < dt.Tables[0].Rows.Count; i++)

//{

// listBox1.Items.Add(dt.Tables[0].Rows[i][0].ToString() + "\t" + dt.Tables[0].Rows[i][1].ToString() + "\t" + dt.Tables[0].Rows[i][2].ToString());

//}

}

}

private void button4_Click(object sender, EventArgs e)

{

//SqlConnection con = new SqlConnection();

//con.ConnectionString = "server=rjxy1-1;database=ZFHC;uid=sa;pwd=sa";

try

{

string sql = string.Format("update manager set passWord='{0}' where userName='{1}'", this.textBox2.Text, this.textBox1.Text);

// SqlCommand cmd = new SqlCommand(sql, con);

// con.Open();

// cmd.ExecuteNonQuery();

// con.Close();

//}

if (DBhelper.NonQuery(sql) != 0)

MessageBox.Show("更新成功");

}

catch (SqlException err)

{

MessageBox.Show(err.Message, "更新失败");

}

}

private void Enter(object sender, KeyEventArgs e)

{

try

{

string sql = string.Format("insert into manager(userName,passWord)

values('{0}','{1}')", this.textBox1.Text, this.textBox2.Text);

if (DBhelper.NonQuery(sql) != 0)

MessageBox.Show("添加成功");

}

catch (SqlException err)

{

MessageBox.Show(err.Message, "添加失败");

}

}

}

}