电脑
vs2008+SqlServer数据库
数据库连接好
using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Data.SqlClient;using System.Drawing;using System.Linq;using System.Text;using System.Windows.Forms;namespace login{ public partial class Form1 : Form { public Form1() { InitializeComponent(); } private void button1_Click(object sender, EventArgs e) { SqlConnection conn = new SqlConnection('Data Source=.;Initial Catalog=user1;Integrated Security=True'); try { conn.Open(); // 打开数据库连接 //cmd.Connection = conn; //cmd.CommandText = 'delete from usermessage'; //cmd.ExecuteNonQuery(); // string str = 'insert into usermessage(num,name,tel) values('10091', '张三','3332')'; string str = 'insert into usermessage(num,name,tel) values('' + textBox1.Text + '','' + textBox2.Text + '','' + textBox3.Text + '')'; SqlCommand cmd = new SqlCommand(str, conn); cmd.ExecuteNonQuery(); string str1 = 'select * from usermessage where num=' + textBox1.Text + ''; SqlCommand cmd1 = new SqlCommand(str1, conn); SqlDataReader reader = cmd1.ExecuteReader(); if (reader.Read()) { MessageBox.Show('添加成功!', '提示'); textBox1.Text = ''; textBox2.Text = ''; textBox3.Text = ''; } reader.Close(); conn.Close(); } catch (Exception ex) { MessageBox.Show('错误信息:' + ex.Message, '出现错误'); } } private void button2_Click(object sender, EventArgs e) { SqlConnection conn = new SqlConnection('Data Source=.;Initial Catalog=user1;Integrated Security=True'); try { conn.Open(); string str1 = 'select * from usermessage where num=' + textBox1.Text + ''; SqlCommand cmd1 = new SqlCommand(str1, conn); SqlDataReader reader = cmd1.ExecuteReader(); if (reader.Read()) { reader.Close(); string str = 'delete from usermessage where num='' + textBox1.Text + '''; SqlCommand cmd = new SqlCommand(str, conn); cmd.ExecuteNonQuery(); MessageBox.Show('删除成功!', '提示'); textBox1.Text = ''; textBox2.Text = ''; textBox3.Text = ''; conn.Close(); } else { MessageBox.Show('用户不存在!', '提示'); textBox1.Text = ''; textBox2.Text = ''; textBox3.Text = ''; } } catch (Exception ex) { MessageBox.Show('错误信息:' + ex.Message, '出现错误'); } } private void button3_Click(object sender, EventArgs e) { SqlConnection conn = new SqlConnection('Data Source=.;Initial Catalog=user1;Integrated Security=True'); try { conn.Open(); // 打开数据库连接 string str1 = 'select * from usermessage where num=' + textBox1.Text + ''; SqlCommand cmd1 = new SqlCommand(str1, conn); SqlDataReader reader = cmd1.ExecuteReader(); if (reader.Read()) { String name = reader['name'].ToString(); String tel = reader['tel'].ToString(); textBox2.Text = name.Trim(); textBox3.Text = tel.Trim(); } else { MessageBox.Show('用户不存在!', '提示'); textBox1.Text = ''; } reader.Close(); conn.Close(); } catch (Exception ex) { MessageBox.Show('错误信息:' + ex.Message, '出现错误'); } } private void button4_Click(object sender, EventArgs e) { SqlConnection conn = new SqlConnection('Data Source=.;Initial Catalog=user1;Integrated Security=True'); try { int t=0; conn.Open(); if (t == 0) { string str = 'update usermessage set name='' + textBox2.Text + '', Tel='' + textBox3.Text + ''where num='' + textBox1.Text + '''; SqlCommand cmd = new SqlCommand(str, conn); cmd.ExecuteNonQuery(); t++; ; } if(t==1) { string str1 = 'select * from usermessage where num=' + textBox1.Text + ''; SqlCommand cmd1 = new SqlCommand(str1, conn); SqlDataReader reader = cmd1.ExecuteReader(); if (reader.Read()) { String name = reader['name'].ToString(); String tel = reader['tel'].ToString(); textBox2.Text = name.Trim(); textBox3.Text = tel.Trim(); reader.Close(); t=0; MessageBox.Show('修改成功!', '提示'); textBox1.Text = ''; textBox2.Text = ''; textBox3.Text = ''; } else { MessageBox.Show('用户不存在!', '提示'); textBox1.Text = ''; textBox2.Text = ''; textBox3.Text = ''; } } } catch (Exception ex) { MessageBox.Show('错误信息:' + ex.Message, '出现错误'); } } private void button5_Click(object sender, EventArgs e) { textBox1.Text = ''; textBox2.Text = ''; textBox3.Text = ''; } private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e) { } private void button6_Click(object sender, EventArgs e) { try { DataGridView dataGridView1 = new DataGridView(); string strsql = 'select * from usermessage';//查询语句。 SqlConnection conn = new SqlConnection('Data Source=.;Initial Catalog=user1;Integrated Security=True'); SqlCommand cmd = new SqlCommand(strsql, conn); SqlDataAdapter da = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); da.Fill(ds); this.dataGridView1.DataSource = ds.Tables[0]; this.dataGridView1.Columns[0].HeaderText = '序号'; this.dataGridView1.Columns[1].HeaderText = '编码'; this.dataGridView1.Columns[2].HeaderText = '姓名'; this.dataGridView1.Columns[3].HeaderText = '电话'; this.dataGridView1.Columns[0].Width = 110; //设置该列宽度 this.dataGridView1.Columns[1].Width = 110; this.dataGridView1.Columns[2].Width = 110; this.dataGridView1.Columns[3].Width = 110; int coun = this.dataGridView1.RowCount; for (int i = 0; i < coun - 1; i++) { this.dataGridView1.Rows[i].Cells[0].Value = i + 1; this.dataGridView1.Rows[i].Cells['id'].Value = i + 1; } //默认按顺序每列DataGridView依次从ds中对应赋值 this.dataGridView1.Columns[0].DataPropertyName = ds.Tables[0].Columns[0].ToString(); } catch (Exception ex) { MessageBox.Show('错误信息:' + ex.Message, '出现错误'); } } private void Form1_Load(object sender, EventArgs e) { DataGridView dataGridView1 = new DataGridView(); string strsql = 'select * from usermessage'; SqlConnection conn = new SqlConnection('Data Source=.;Initial Catalog=user1;Integrated Security=True'); SqlCommand cmd = new SqlCommand(strsql, conn); SqlDataAdapter da = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); da.Fill(ds); this.dataGridView1.DataSource = ds.Tables[0]; this.dataGridView1.Columns[0].HeaderText = '序号'; this.dataGridView1.Columns[1].HeaderText = '编码'; this.dataGridView1.Columns[2].HeaderText = '姓名'; this.dataGridView1.Columns[3].HeaderText = '电话'; this.dataGridView1.Columns[0].Width = 110; //设置该列宽度 this.dataGridView1.Columns[1].Width = 110; this.dataGridView1.Columns[2].Width = 110; this.dataGridView1.Columns[3].Width = 110; int coun = this.dataGridView1.RowCount; for (int i = 0; i < coun - 1; i++) { this.dataGridView1.Rows[i].Cells[0].Value = i + 1; this.dataGridView1.Rows[i].Cells['id'].Value = i + 1; } //默认按顺序每列DataGridView依次从ds中对应赋值 this.dataGridView1.Columns[0].DataPropertyName = ds.Tables[0].Columns[0].ToString(); } }}
这是结果!!!!!!!!!!!!
多多运行 多多研究