韩顺平sqlhelper类php,自己编写sqlhelper类示例分享

自己编写SqlHelper&＃xff0c;大家参考使用吧

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

{

///

/// Window1.xaml 的交互逻辑

///

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(&＃39;张三&＃39;,55)",

new SqlParameter[0]);

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

}

private void btnDataSet_Click(object sender, RoutedEventArgs e)

{

DataSet ds&＃61; SqlHelper.ExecuteDataSet("select * from T_Student where hobbit&＃61;&＃39;&＃64;hobbit&＃39;",

new SqlParameter[]{new SqlParameter("&＃39;&＃64;hobbit&＃39;","哈哈哈")});

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

{

string name &＃61; (string)row["Name"];

MessageBox.Show(name);

}

}

}

}