mysql+C#实战一：向数据库里面写入数据

来源：互联网发布：栅格矢量化算法编辑：程序博客网时间：2024/06/05 10:03

首先，得打开数据库工作站；

然后从文件中添加数据接口dll，再写入C#语句

using System;using System.Collections.Generic;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;using System.Data;using MySql.Data;//这两个是数据库的链接库，要现在引用里面添加；using MySql.Data.MySqlClient;namespace WpfApplication1{    /// <summary>    /// MainWindow.xaml 的交互逻辑    /// </summary>    public partial class MainWindow : Window    {                public MainWindow()        {            InitializeComponent();//注意这里的初始化控件一定要加，给空间做初始化，否则会出异常；            //选中本地主机，用户id和密码；选中调用数据库的名称；            string constr="server=localhost;User Id=root;password=1234;Database=student";            //连接数据库            MySqlConnection mycon=new MySqlConnection(constr);            mycon.Open();            //输入数据命令；            MySqlCommand mycmd = new MySqlCommand("insert into postgraduate(username) values('E')",mycon);                     txt.Text = "nihao";            if (mycmd.ExecuteNonQuery()>0)            {                                Console.WriteLine("nihao");                            }                        Console.ReadLine();            mycon.Close();//注销连接；        }    }}

注意下面的x:name，还有上面的初始化控件一定要有；

<Window x:Class="WpfApplication1.MainWindow"        xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"        xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"        Title="MainWindow" Height="350" Width="525">    <Grid>        <Grid.ColumnDefinitions>            <ColumnDefinition Width="6*"/>            <ColumnDefinition Width="31*"/>        </Grid.ColumnDefinitions>        <TextBox x:Name="txt" Grid.Column="1" HorizontalAlignment="Left" Height="23" Margin="84,124,0,0" TextWrapping="Wrap" Text="TextBox" VerticalAlignment="Top" Width="120"/>         </Grid></Window>

0 0