using?System;
using?System.Collections.Generic;
using?System.Linq;
using?System.Text;
using?System.Configuration;
using?System.Data.SqlClient;
using?System.Data;

namespace?StudentMgr
{
????public?static?class??SqlHelper
????{
????????public?static?readonly?string?connstr?=
????????????ConfigurationManager.ConnectionStrings[“connstr“].ConnectionString;

????????public?static?SqlConnection?OpenConnection（）
????????{
????????????SqlConnection?conn?=?new?SqlConnection（connstr）;
????????????conn.Open（）;
????????????return?conn;
????????}

????????public?static?int?ExecuteNonQuery（string?cmdText
????????????params?SqlParameter[]?parameters）
????????{
????????????using?（SqlConnection?conn?=?new?SqlConnection（connstr））
????????????{
????????????????conn.Open（）;
??????

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件???????3197??2014-04-18?11:41??SqlHelper.cs

-----------?---------??----------?-----??----

?????????????????3197????????????????????1