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 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);             }         }     } }