Wordpress热门评论插件,seo排名优化方法,海阳玖网站建设,c2c跨境电商平台有哪些1、入行好几年了#xff0c;工作中使用数据库几率很小(传统行业)。借着十一假期回家机会#xff0c;学习下数据库。2、初次了解数据库相关知识#xff0c;如果本文有误#xff0c;还望告知。3、本文主要目的#xff0c;记录下wpf界面显示数据库信息#xff0c;且可进行删…1、入行好几年了工作中使用数据库几率很小(传统行业)。借着十一假期回家机会学习下数据库。2、初次了解数据库相关知识如果本文有误还望告知。3、本文主要目的记录下wpf界面显示数据库信息且可进行删除、修改、插入命令。并反馈数据到MySQL。做个记录以便以后工作中使用到时没个头绪。4、MySQL的基本讲解不再介绍安装过程什么的我也是按照网上教程一步一步进行的假定MySQL已安装成功且新建有数据库见下图:废话不多说直接上代码界面代码xaml后端代码cspublic partial class MainWindow : Window{//SQLBulkCopyRandom rd new Random();string sqlstr Data Source127.0.0.1;User IDroot;Passwordroot;DataBasetest;Charsetutf8;;MySql.Data.MySqlClient.MySqlConnection con;MySql.Data.MySqlClient.MySqlDataAdapter adapter;System.Data.DataSet ds;System.Data.DataTable dt;public MainWindow(){InitializeComponent();UpdateMySQLData();}private void DataGrid_LoadingRow(object sender, System.Windows.Controls.DataGridRowEventArgs e){e.Row.Header e.Row.GetIndex() 1;}private void UpdateMySQLData(){if (con null){con new MySql.Data.MySqlClient.MySqlConnection(sqlstr);con.Open();}if (adapter null){adapter new MySql.Data.MySqlClient.MySqlDataAdapter(select * from user, con);}if (ds null){ds new System.Data.DataSet();}ds.Clear();adapter.Fill(ds, user);if (dt null){dt ds.Tables[user];}DataGrid1.ItemsSource dt.DefaultView;}private void DeleteButton_Click(object sender, RoutedEventArgs e){int index DataGrid1.SelectedIndex;if (index -1) return;#if MySQLCommandstring DeleteSqlCommand string.Format(delete from user where id {0}, dt.Rows[index][id]);MySql.Data.MySqlClient.MySqlCommand cmd new MySql.Data.MySqlClient.MySqlCommand(DeleteSqlCommand, con);cmd.ExecuteNonQuery();UpdateMySQLData();#elsedt.Rows[index].Delete();//dt.Rows.RemoveAt(index);dt.Rows[index].Delete() dt.AcceptChanges()MySql.Data.MySqlClient.MySqlCommandBuilder builder new MySql.Data.MySqlClient.MySqlCommandBuilder(adapter);adapter.Update(dt);dt.AcceptChanges();#endif}private void UpdateButton_Click(object sender, RoutedEventArgs e){#if MySQLCommandint index DataGrid1.SelectedIndex;string UpdateSqlCommand string.Format(update user set id {0}, name {1}, phone {2}, email {3} where id {0},dt.Rows[index][id], dt.Rows[index][name], dt.Rows[index][phone], dt.Rows[index][email]);MySql.Data.MySqlClient.MySqlCommand cmd new MySql.Data.MySqlClient.MySqlCommand(UpdateSqlCommand, con);cmd.ExecuteNonQuery();UpdateMySQLData();#elseMySql.Data.MySqlClient.MySqlCommandBuilder builder new MySql.Data.MySqlClient.MySqlCommandBuilder(adapter);adapter.Update(dt);dt.AcceptChanges();#endif}private void InsertButton_Click(object sender, RoutedEventArgs e){#if MySQLCommandstring InsertSqlCommand string.Format(insert into user(id, name, phone,email) values({0},{1},{2},{3}), rd.Next(100), ZhangSan, 12332112345, zhangsanqq.com);MySql.Data.MySqlClient.MySqlCommand cmd new MySql.Data.MySqlClient.MySqlCommand(InsertSqlCommand, con);cmd.ExecuteNonQuery();string InsertSqlCommand2 string.Format(insert into user(id, name, phone,email) values({0},{1},{2},{3}), rd.Next(100), LiSi, 12332112345, lisiyahoo.com);MySql.Data.MySqlClient.MySqlCommand cmd2 new MySql.Data.MySqlClient.MySqlCommand(InsertSqlCommand2, con);cmd2.ExecuteNonQuery();UpdateMySQLData();#elseSystem.Data.DataRow dr dt.NewRow();dr[0] rd.Next(100);dr[1] ZhangSan;dr[2] 12332112345;dr[3] zhangsanqq.com;dt.Rows.Add(dr);System.Data.DataRow dr2 dt.NewRow();dr2[0] rd.Next(100);dr2[1] LiSi;dr2[2] 12332154321;dr2[3] lisiyahoo.com;dt.Rows.Add(dr2);MySql.Data.MySqlClient.MySqlCommandBuilder builder new MySql.Data.MySqlClient.MySqlCommandBuilder(adapter);adapter.Update(ds, user);dt.AcceptChanges();#endif}}软件打开界面