首先,得打开数据库工作站;
然后从文件中添加数据接口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>