1、【在web.config文件中配置】

2、【連接字符串】

private static readonly string StrCon = ConfigurationManager.ConnectionStrings["sqlConnection"].ToString();

3、【查詢數據方法】

///

/// 查詢數據

///

/// 查詢語句

/// 參數

///

public static DataTable QueryData(string sqlStr,params SqlParameter [] parameter) {

try

{

using (SqlConnection conn = new SqlConnection())

{

conn.Open();

SqlCommand cmd = new SqlCommand(sqlStr, conn);

DataSet dt = new DataSet();

SqlDataAdapter adapter = new SqlDataAdapter();

cmd.Parameters.AddRange(parameter);

adapter.SelectCommand = cmd;

adapter.Fill(dt);

conn.Close();

return dt.Tables[0];

}

}

catch (Exception ex)

{

throw new ApplicationException("查詢數據異常"+ex.Message);

}

}

4、【更新數據方法】

///

/// 更新數據

///

/// 更新語句

/// 參數

///

public static bool UpdateData(string sqlStr, params SqlParameter[] parameter) {

try

{

using (SqlConnection conn = new SqlConnection())

{

conn.Open();

SqlCommand cmd = new SqlCommand(sqlStr,conn);

cmd.Parameters.AddRange(parameter);

var row=cmd.ExecuteNonQuery();

conn.Close();

if (row>0)

{

return true;

}

return false;

}

}

catch (Exception ex)

{

throw new ApplicationException("更新數據異常"+ex.Message) ;

}

}

5、【刪除數據方法】

///

/// 刪除數據

///

/// 刪除語句

/// 參數

///

public static bool DeleteData(string sqlStr,params SqlParameter[] parameter) {

try

{

using (SqlConnection conn=new SqlConnection())

{

conn.Open();

SqlCommand cmd = new SqlCommand(sqlStr,conn);

cmd.Parameters.AddRange(parameter);

var row = cmd.ExecuteNonQuery();

conn.Close();

if (row>0)

{

return true;

}

return false;

}

}

catch (Exception ex)

{

throw new ApplicationException("刪除數據異常"+ex.Message);

}

}

6、【添加數據方法】

///

/// 刪除數據

///

/// 刪除語句

/// 參數

///

public static bool AddData(string sqlStr,params SqlParameter[] parameter) {

try

{

using (SqlConnection conn = new SqlConnection())

{

conn.Open();

SqlCommand cmd = new SqlCommand(sqlStr,conn);

cmd.Parameters.AddRange(parameter);

var row = cmd.ExecuteNonQuery();

conn.Close();

if (row>0)

{

return true;

}

return false;

}

}

catch (Exception ex)

{

throw new ApplicationException("添加數據異常"+ex.Message);

}

}

7、寫個方法調用【查詢數據方法】，其他三個方法調用與此類似

public DataTable GetInfo(string id) {

var sqlStr = "select * from Student where id=@id";

DataTable table = SqlHelper.QueryData(sqlStr, new System.Data.SqlClient.SqlParameter[] { new System.Data.SqlClient.SqlParameter("@id",id) });

return table;

}