WPF数据操作

最新推荐文章于 2023-05-25 06:16:14 发布

C979170768

最新推荐文章于 2023-05-25 06:16:14 发布

阅读量1.1k

点赞数

文章标签： wpf textbox datagrid button excel class

本文链接：https://blog.csdn.net/C979170768/article/details/7637619

版权

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
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 System.Data.SqlClient;
using System.Configuration;

namespace DataBaseOper
{
    /// <summary>
    /// MainWindow.xaml 的交互逻辑
    /// </summary>
    public partial class MainWindow : Window
    {
        public MainWindow()
        {
            InitializeComponent();
        }

        private void button1_Click_1(object sender, RoutedEventArgs e)
        {
            Disp("select * from T_Excel",CommandType.Text);
        }

        private void Disp(string sqlcmd,CommandType commandtype,params SqlParameter[] param)
        {
            using (SqlConnection con = new SqlConnection(@"server=.\sqlexpress;initial catalog=Mytest1;integrated security=true"))
            {
                using (SqlCommand cmd = new SqlCommand(sqlcmd, con))
                {
                    cmd.Parameters.AddRange(param);
                    cmd.CommandType = commandtype;
                    using (SqlDataAdapter sda = new SqlDataAdapter(cmd))
                    {
                        DataTable dt = new DataTable();
                        sda.Fill(dt);
                        dataGrid1.ItemsSource = dt.DefaultView;
                    }
                }
            }
        }

        private void button2_Click(object sender, RoutedEventArgs e)
        {
          // MessageBox.Show(dataGrid1.SelectedIndex.ToString());
           DataRowView row = dataGrid1.SelectedItem as DataRowView;
           if (row!=null)
           {
               SQLExecute("delete from T_Excel where id=@id",CommandType.Text,new SqlParameter("@id",row["id"].ToString()));
               Disp("select * from T_Excel",CommandType.Text);
               MessageBox.Show("删除成功!!!");
           }

}

        private void SQLExecute(string sqlcmd,CommandType commandtype, params SqlParameter[] param)
        {
            using (SqlConnection con = new SqlConnection(@"server=.\sqlexpress;initial catalog=Mytest1;integrated security=true"))
            {
                using (SqlCommand cmd = new SqlCommand(sqlcmd, con))
                {
                    cmd.Parameters.AddRange(param);
                    con.Open();
                    cmd.ExecuteNonQuery();
                }
            }

        }

        private void button3_Click(object sender, RoutedEventArgs e)
        {
            SQLExecute("insert T_Excel values(@class,@stuid,@name,@phone,@QQ)",
                CommandType.Text, new SqlParameter("@class", textBox1.Text),
                new SqlParameter("@stuid", textBox2.Text.Trim()),
                new SqlParameter("@name", textBox3.Text.Trim()),
                new SqlParameter("@phone", textBox4.Text.Trim()),
                new SqlParameter("@QQ", textBox5.Text.Trim())
                );

Disp("select * from T_Excel",CommandType.Text);
}

        private void button4_Click(object sender, RoutedEventArgs e)
        {
             DataRowView row = dataGrid1.SelectedItem as DataRowView;
             if (row != null)
             {
                 SQLExecute("update T_Excel set class=@class,stuid=@stuid,name=@name,phone=@phone,qq=@QQ where id=@id",
                    CommandType.Text, new SqlParameter("@class", textBox1.Text),
                    new SqlParameter("@stuid", textBox2.Text.Trim()),
                    new SqlParameter("@name", textBox3.Text.Trim()),
                    new SqlParameter("@phone", textBox4.Text.Trim()),
                    new SqlParameter("@QQ", textBox5.Text.Trim()),
                    new SqlParameter("@id",row["id"].ToString())
                    );
             }
             Disp("select * from T_Excel",CommandType.Text);
        }

        private void dataGrid1_SelectionChanged(object sender, SelectionChangedEventArgs e)
        {
             DataRowView row = dataGrid1.SelectedItem as DataRowView;
             if (row != null)
             {
                DataTable dt = ReturnDisp("select * from T_Excel where id=@id",CommandType.Text,new SqlParameter("@id",row["id"].ToString()));
                 textBox1.Text=dt.Rows[0][0].ToString();
                 textBox2.Text=dt.Rows[0][1].ToString();;
                 textBox3.Text=dt.Rows[0][2].ToString();;
                 textBox4.Text=dt.Rows[0][3].ToString();;
                 textBox5.Text=dt.Rows[0][4].ToString();;

             }
        }

        private DataTable ReturnDisp(string sqlcmd, CommandType commandtype, params SqlParameter[] param)
        {
            using (SqlConnection con = new SqlConnection(@"server=.\sqlexpress;initial catalog=Mytest1;integrated security=true"))
            {
                using (SqlCommand cmd = new SqlCommand(sqlcmd, con))
                {
                    cmd.Parameters.AddRange(param);
                    cmd.CommandType = commandtype;
                    using (SqlDataAdapter sda = new SqlDataAdapter(cmd))
                    {
                        DataTable dt = new DataTable();
                        sda.Fill(dt);
                        return dt;
                    }
                }
            }
        }
    }
}

C979170768

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
WPF数据操作

xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation" xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml" Title="MainWindow" Height="350" Width="525">
复制链接

扫一扫