c#学习笔记
一、c#连接Mysql数据库
c#连接mysql数据库要使用 第三方插件,也就是xxxx.dll 插件,网上可以下载到,但是官网上下载好像很麻烦,其他网站上的插件我个人是不想使用的。在这里,我是用的另一种方法。
原料: VS2013, xampp(mysql)
方法:打开VS,打开项目之后,选择工具 ——> NuGet程序包管理器 -->程序包管理器控制台,当在VS底部,也就是平时出现console的地方出现这个就说明是对的
此时,只要在PM> 后面输入Install-Package MySql.Data 就可以了,然后就等VS自己现在引用就好了。当然,从网上下载插件自己添加引用也是没问题的。最后结果是这样就可以了。
引用里面MySql.Data 说明成功。
二、c# WPF 里对数据库数据进行操作。
完成上述步骤,之后 需要在头文件里添加引用
然后就可以操作了,贴段代码给自己看
using MySql.Data.MySqlClient; using System; using System.Collections.Generic; using System.Data; 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.Shapes; namespace elisha { /// <summary> /// Show.xaml 的交互逻辑 /// </summary> public partial class Show : Window { public Show() { InitializeComponent(); readincome(); readcost(); } private static MySqlConnection myConnection = new MySqlConnection("server=localhost;user id=root;password=;database=elisha");
// 连接数据库,database为所需要使用的数据库名称 public void readincome() { DataTable dt1 = new DataTable();//使用datatable读取数据 dt1.Columns.Add("name0", System.Type.GetType("System.String")); dt1.Columns.Add("money0", System.Type.GetType("System.String")); dt1.Columns.Add("date0", System.Type.GetType("System.String")); dt1.Columns.Add("other0", System.Type.GetType("System.String")); string query = "select * from income "; MySqlCommand myCommand = new MySqlCommand(query, myConnection); try { myConnection.Open(); myCommand.ExecuteNonQuery(); } catch (MySqlException e) { myConnection.Close(); } MySqlDataReader myDataReader = myCommand.ExecuteReader(); while (myDataReader.Read() == true) { DataRow dr1 = dt1.NewRow(); dr1["name0"] = myDataReader["name"]; dr1["money0"] = myDataReader["money"].ToString(); dr1["date0"] = myDataReader["date"].ToString().Split(' ')[0]; dr1["other0"] = myDataReader["other"]; dt1.Rows.Add(dr1); } income.ItemsSource = dt1.DefaultView; myConnection.Close(); } public void readcost() { DataTable dt2 = new DataTable(); dt2.Columns.Add("name1", System.Type.GetType("System.String")); dt2.Columns.Add("money1", System.Type.GetType("System.String")); dt2.Columns.Add("date1", System.Type.GetType("System.String")); dt2.Columns.Add("other1", System.Type.GetType("System.String")); string query = "select * from cost "; MySqlCommand myCommand = new MySqlCommand(query, myConnection); try { myConnection.Open(); myCommand.ExecuteNonQuery(); } catch (MySqlException e) { myConnection.Close(); } MySqlDataReader myDataReader = myCommand.ExecuteReader(); while (myDataReader.Read() == true) { DataRow dr2 = dt2.NewRow(); dr2["name1"] = myDataReader["name"]; dr2["money1"] = myDataReader["money"].ToString(); dr2["date1"] = myDataReader["date"].ToString().Split(' ')[0]; dr2["other1"] = myDataReader["other"]; dt2.Rows.Add(dr2); } cost.ItemsSource = dt2.DefaultView; myConnection.Close(); } private void Button_Click(object sender, RoutedEventArgs e) { Window w = new Add(); w.Show(); Close(); } private void Button_Click_1(object sender, RoutedEventArgs e) { Window w1 = new Analyse(); w1.Show(); Close(); } private void Button_Click_2(object sender, RoutedEventArgs e) { Window w = new sta(); w.Show(); Close(); } } }
在贴段xmal的代码,使用listview来展示数据。
<Window x:Class="elisha.Show" xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation" xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml" Title="Show" Height="500" Width="800"> <Grid> <TextBlock HorizontalAlignment="Left" Margin="57,10,0,0" TextWrapping="Wrap" Text="Income" VerticalAlignment="Top" Height="30" Width="73" FontSize="20"/> <TextBlock HorizontalAlignment="Left" Margin="57,209,0,0" TextWrapping="Wrap" Text="Cost" VerticalAlignment="Top" Height="30" Width="73" FontSize="20"/> <ListView x:Name="income" HorizontalAlignment="Left" Height="155" Margin="42,45,0,0" VerticalAlignment="Top" Width="705"> <ListView.View> <GridView> <GridViewColumn Header="name" DisplayMemberBinding="{Binding Path=name0}" Width="150" ></GridViewColumn> <GridViewColumn Header="money" DisplayMemberBinding="{Binding Path=money0}" Width="150"></GridViewColumn> <GridViewColumn Header="date" DisplayMemberBinding="{Binding Path=date0}" Width="150"></GridViewColumn> <GridViewColumn Header="others" DisplayMemberBinding="{Binding Path=other0}" Width="250"></GridViewColumn> </GridView> </ListView.View> </ListView> <ListView x:Name="cost" HorizontalAlignment="Left" Height="175" Margin="42,244,0,0" VerticalAlignment="Top" Width="705"> <ListView.View> <GridView> <GridViewColumn Header="name" DisplayMemberBinding="{Binding Path=name1}" Width="150" ></GridViewColumn> <GridViewColumn Header="money" DisplayMemberBinding="{Binding Path=money1}" Width="150"></GridViewColumn> <GridViewColumn Header="date" DisplayMemberBinding="{Binding Path=date1}" Width="150"></GridViewColumn> <GridViewColumn Header="others" DisplayMemberBinding="{Binding Path=other1}" Width="250"></GridViewColumn> </GridView> </ListView.View> </ListView> <Button Content="Statistics" HorizontalAlignment="Left" Margin="84,440,0,0" VerticalAlignment="Top" Width="75" Click="Button_Click_2"/> <Button Content="Analyse" HorizontalAlignment="Left" Margin="345,440,0,0" VerticalAlignment="Top" Width="75" Click="Button_Click_1"/> <Button Content="Add" HorizontalAlignment="Left" Margin="598,440,0,0" VerticalAlignment="Top" Width="75" Click="Button_Click"/> </Grid> </Window>
起初,学习这些是为了当初的作业,但是现在有要用到这些,想回忆却回忆不全,又要重新从网上搜集资料,所以这次决定把这些贴出来,目的是为了以后用的方便,如果能对其他人有所帮助的话,也是不错的。