xxxx18一60岁hd中国/日韩女同互慰一区二区/西西人体扒开双腿无遮挡/日韩欧美黄色一级片 - 色护士精品影院www

  • 大小: 4KB
    文件類型: .zip
    金幣: 2
    下載: 0 次
    發布日期: 2021-06-07
  • 語言: C#
  • 標簽: c#??sql??sql操作??

資源簡介

實現增刪改查功能,調用函數時候只要輸入表名和條件,省去大量代碼。 查詢多個數據默認是用dataset接收數據

資源截圖

代碼片段和文件信息

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


namespace?sqlcz
{
????class?sqlcz
????{
????????#region?變量

????????public?static?string?sql;
????????public?static?SqlConnection?conn?=?new?SqlConnection(“Server=.;Database=wyh;Integrated?Security=True“);
????????public?static?SqlCommand?com;
????????public?static?SqlDataAdapter?da;
????????#endregion


????????#region?獲取單個值

????????public?static?string?getValued(string?selected?string?table?string?wheretj)
????????{
????????????try
????????????{
????????????????conn.Open();
????????????????sql?=?“select?“?+?selected?+?“?from?“?+?table?+?“?where?“?+?wheretj;
????????????????com?=?conn.CreateCommand();
????????????????com.CommandText?=?sql;
????????????????string?result?=?com.ExecuteScalar().ToString();
????????????????conn.Close();
????????????????return?result;
????????????}
????????????catch?(Exception?e)
????????????{
????????????????return?“error“;
????????????}
????????}
????????#endregion


????????#region?刪除

????????public?static?bool?delete(string?table?string?wheretj)
????????{
????????????try
????????????{
????????????????conn.Open();
????????????????sql?=?“delete?“?+?table?+?“?where?“?+?wheretj;
????????????????com?=?conn.CreateCommand();
????????????????com.CommandText?=?sql;
????????????????com.ExecuteNonQuery();
????????????????conn.Close();
????????????????return?true;
????????????}
????????????catch(Exception?e)
????????????{
????????????????return?false;
????????????}
????????}
????????#endregion


????????#region?修改

????????public?static?bool?update(string?table?string?sertj?string?wheretj)
????????{
????????????try
????????????{
????????????????conn.Open();
????????????????sql?=?“update?“?+?table?+?“?set?“?+?sertj?+?“?where?“?+?wheretj;
????????????????com?=?conn.CreateCommand();
????????????????com.CommandText?=?sql;
????????????????object?result?=?com.ExecuteNonQuery();
????????????????conn.Close();
????????????????return?true;
????????????}
????????????catch?(Exception?e)
????????????{
????????????????return?false;
????????????}
????????}
????????#endregion


????????#region?插入

????????public?static?bool?insert(string?table?string?lie?string?values)
????????{
????????????try
????????????{
????????????????conn.Open();
????????????????sql?=?“insert?into?“?+?table?+?“(“?+?lie?+?“)“?+?“?values(?“?+?values?+?“)“;
????????????????com?=?conn.CreateCommand();
????????????????com.CommandText?=?sql;
????????????????object?result?=?com.ExecuteNonQuery();
????????????????conn.Close();
????????????????return?true;
????????????}
????????????catch?(Exception?e)
????????????{
????????????????return?false;
????????????}
????????}
????????public?static?bool?insert(string?table??string?values)
????????{
????????????try
????????????{
????????????????conn.Open();
????????????????sql?=?“inse

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2012-12-05?11:57??sql操作類庫\
?????文件????????4392??2012-12-05?11:54??sql操作類庫\sqlcz.cs
?????文件????????6144??2012-12-05?12:05??sql操作類庫\sqlcz.dll

評論

共有 條評論