WPF操作SQL SERVER 数据库实例讲解
using System; using System.Collections.Generic; using System.Data.SqlClient; using System.Linq; using System.Text; using System.Threading.Tasks; using System.Windows; using System.Windows.Controls; using System.Windows.Data; using System.Windows.Documents; using System.Windows.Input; using System.Windows.Media; using System.Windows.Media.Imaging; using System.Windows.Navigation; using System.Windows.Shapes; namespace demo_sql { /// /// MainWindow.xaml 的交互逻辑 /// public partial class MainWindow : Window { public MainWindow() { InitializeComponent(); WindowStartupLocation = WindowStartupLocation.CenterScreen; }
private void add_Click(object sender, RoutedEventArgs e) { string strconn = "server=(localdb)\\MSSQLLocalDB;database=studentdb;integrated security=true"; SqlConnection sqlconn = new SqlConnection(strconn); try { sqlconn.Open(); //MessageBox.Show("连接数据库成功"); string sqladd = "insert into student(name, password) values ('" +name.Text + "', '" + password.Text + "')"; SqlCommand sqlcmd = new SqlCommand(sqladd, sqlconn); sqlcmd.ExecuteNonQuery(); MessageBox.Show("插入成功"); } catch (Exception ex) { MessageBox.Show("数据库打开失败,详细信息:" + ex.ToString()); } finally { sqlconn.Close(); } } private void modify_Click(object sender, RoutedEventArgs e) { string strconn = "server=(localdb)\\MSSQLLocalDB;database=studentdb;integrated security=true"; SqlConnection sqlconn = new SqlConnection(strconn); try { sqlconn.Open(); string strmodify = "Update student set password='" + password.Text + "'" + " where name=" + "'" + name.Text + "'"; SqlCommand sqlcmd = new SqlCommand(strmodify, sqlconn); sqlcmd.ExecuteNonQuery(); MessageBox.Show("修改成功"); } catch (Exception ex) { MessageBox.Show("连接错误" + ex.Message); } finally { sqlconn.Close(); } } private void delete_Click(object sender, RoutedEventArgs e) { string strconn = "server=(localdb)\\MSSQLLocalDB;database=studentdb;integrated security=true"; SqlConnection sqlconn = new SqlConnection(strconn); try { sqlconn.Open(); string strdelete = "Delete from student where name='" + name.Text + "'"; SqlCommand sqlcmd = new SqlCommand(strdelete, sqlconn); sqlcmd.ExecuteNonQuery(); MessageBox.Show("删除成功"); } catch (Exception ex) { MessageBox.Show("连接错误"+ex.Message); } finally { sqlconn.Close(); } } private void search_Click(object sender, RoutedEventArgs e) { int flag = 1; string strconn = "server=(localdb)\\MSSQLLocalDB;database=studentdb;integrated security=true"; SqlConnection sqlconn = new SqlConnection(strconn); try { sqlconn.Open(); //MessageBox.Show("连接数据库成功"); string sqlsearch = "select * from student where name='" + name.Text + "'"; SqlCommand sqlcmd = new SqlCommand(sqlsearch, sqlconn); SqlDataReader reader = sqlcmd.ExecuteReader(); //读取数据 while (reader.Read()) { // 可以使用数据库中的字段名,也可以使用角标访问 if(reader["password"].ToString()==password.Text ) { flag = 0; break; } } if(flag == 1) MessageBox.Show("用户不存在"); else MessageBox.Show("存在用户"); } catch (Exception ex) { MessageBox.Show("数据库打开失败,详细信息:" + ex.ToString()); } finally { sqlconn.Close(); } } }
}