C#数据库编程案例3

最新推荐文章于 2023-08-06 12:39:16 发布

life_+

最新推荐文章于 2023-08-06 12:39:16 发布

阅读量346

点赞数

分类专栏： WPF数据库编程

本文链接：https://blog.csdn.net/gj_user/article/details/53711686

版权

WPF数据库编程专栏收录该内容

3 篇文章 0 订阅

订阅专栏

一、窗体

<Window x:Class="SqlDemo2.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>
        <TextBox Name="txtName" HorizontalAlignment="Left" Height="34" Margin="187,54,0,0" TextWrapping="Wrap" Text="" VerticalAlignment="Top" Width="178"/>
        <TextBlock HorizontalAlignment="Left" Margin="124,113,0,0" TextWrapping="Wrap" Text="姓名：" VerticalAlignment="Top" Height="27"/>
        <TextBox Name="txtNo" HorizontalAlignment="Left" Height="36" Margin="187,104,0,0" TextWrapping="Wrap" Text="" VerticalAlignment="Top" Width="178"/>
        <TextBlock HorizontalAlignment="Left" Margin="124,64,0,0" TextWrapping="Wrap" Text="学号：" VerticalAlignment="Top" Height="37" RenderTransformOrigin="-0.425,0.988"/>
        <Button Content="插入信息1" Name="insert1" HorizontalAlignment="Left" Margin="124,246,0,0" VerticalAlignment="Top" Width="75" Click="Button_Click_6"/>
         <TextBox x:Name="txtScore" HorizontalAlignment="Left" Height="34" Margin="187,161,0,0" TextWrapping="Wrap" Text="" VerticalAlignment="Top" Width="178" RenderTransformOrigin="0.455,2.133"/>
        <TextBlock HorizontalAlignment="Left" Margin="124,175,0,0" TextWrapping="Wrap" Text="分数" VerticalAlignment="Top" Height="20"/>
        <Button Content="插入信息2" HorizontalAlignment="Left" Margin="268,246,0,0" VerticalAlignment="Top" Width="75" Click="Button_Click_1"/>
    </Grid>

</Window>

二、代码

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 SqlDemo2
{
    /// <summary>
    /// MainWindow.xaml 的交互逻辑
    /// </summary>
    public partial class MainWindow : Window
    {
        public MainWindow()
        {
            InitializeComponent();
        }

        private void Button_Click_6(object sender, RoutedEventArgs e)
        {
            string No = this.txtNo.Text;
            string Name = this.txtName.Text;
            int score= Convert.ToInt32(this.txtScore.Text);

            String conStr = "Data Source = localhost;Initial Catalog = studentDatabase;User Id = sa;Password = 123";
            SqlConnection con = new SqlConnection(conStr);
            con.Open();

            SqlCommand cmd = con.CreateCommand();
            cmd.CommandText = "insert into student (studentNo,studentName,score) values ('" + No + "','" + Name + "','" + score + "')";
            cmd.ExecuteNonQuery();
            MessageBox.Show("插入成功");

            con.Close();
        }

        private void Button_Click_1(object sender, RoutedEventArgs e)
        {
            string No = this.txtNo.Text;
            string Name = this.txtName.Text;
            int score = Convert.ToInt32(this.txtScore.Text);

            String conStr = "Data Source = localhost;Initial Catalog = studentDatabase;User Id = sa;Password = 123";
            SqlConnection con = new SqlConnection(conStr);
            con.Open();

             SqlCommand cmd = con.CreateCommand();
             cmd.CommandText = "insert into student (studentNo,studentName,score) values (@studentNo,@studentName,@score)";

             SqlParameter[] parameter = new SqlParameter[] {new SqlParameter("@studentNo",No),new SqlParameter("@studentName",Name),new SqlParameter("@score",score) };
             cmd.Parameters.AddRange(parameter);

             cmd.ExecuteNonQuery();
             MessageBox.Show("插入成功");
        }
    }
}