自己编写SqlHelper

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;

 

namespace _05.自己编写SqlHelper

{

    /// <summary>

    /// Window1.xaml 的交互逻辑

    /// </summary>

    public partial class Window1 : Window

    {

        public Window1()

        {

            InitializeComponent();

        }

 

        //只用来执行查询结果比较少的sql

        private void btnds_Click(object sender, RoutedEventArgs e)

        {

            SqlHelper.ExecuteNonQurey("insert into T_Student(Name,Age) values('张三',55)",

                new SqlParameter[0]);

            MessageBox.Show("添加成功");

        }

 

        private void btnDataSet_Click(object sender, RoutedEventArgs e)

        {

            DataSet ds= SqlHelper.ExecuteDataSet("select * from T_Student where hobbit='@hobbit'",

                new SqlParameter[]{new SqlParameter("'@hobbit'","哈哈哈")});

            foreach(DataRow row in ds.Tables[0].Rows)

            {

                string name = (string)row["Name"];

                MessageBox.Show(name);

            }

        }

    }

}