91av视频/亚洲h视频/操亚洲美女/外国一级黄色毛片 - 国产三级三级三级三级

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

資源簡(jiǎn)介

實(shí)現(xiàn)增刪改查功能，調(diào)用函數(shù)時(shí)候只要輸入表名和條件，省去大量代碼。 查詢多個(gè)數(shù)據(jù)默認(rèn)是用dataset接收數(shù)據(jù)

資源截圖

代碼片段和文件信息 

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?獲取單個(gè)值

????????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

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

評(píng)論

共有 條評(píng)論