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

資源簡介

微軟官方的sqlhelper類,包含訪問sqlserver和access的類,可以編譯作為類庫引用,也可以直接以代碼形式加入項目,對于直接使用ADO.net訪問數據庫的小型項目來說,非常適用,大大減少了訪問數據庫的代碼量。內含中文注釋PDF。 評論可以返你一個積分哦。

資源截圖

代碼片段和文件信息

using?System;
using?System.IO;
using?System.Data;
using?System.xml;
using?System.Data.Odbc;
using?System.Collections;

namespace?Microsoft.ApplicationBlocks.Data
{

????///?
????///?The?OdbcHelper?class?is?intended?to?encapsulate?high?performance?scalable?best?practices?for?
????///?common?uses?of?OdbcClient.
????///?

????public?class?OdbcHelper
????{
????????#region?private?utility?methods?&?constructors

????????//Since?this?class?provides?only?static?methods?make?the?default?constructor?private?to?prevent?
????????//instances?from?being?created?with?“new?OdbcHelper()“.
????????private?OdbcHelper()?{?}

????????///?
????????///?This?method?is?used?to?attach?array?of?OdbcParameters?to?a?OdbcCommand.
????????///?
????????///?This?method?will?assign?a?value?of?DbNull?to?any?parameter?with?a?direction?of
????????///?InputOutput?and?a?value?of?null.??
????????///?
????????///?This?behavior?will?prevent?default?values?from?being?used?but
????????///?this?will?be?the?less?common?case?than?an?intended?pure?output?parameter?(derived?as?InputOutput)
????????///?where?the?user?provided?no?input?value.
????????///?

????????///?The?command?to?which?the?parameters?will?be?added
????????///?an?array?of?OdbcParameters?tho?be?added?to?command
????????private?static?void?AttachParameters(OdbcCommand?command?OdbcParameter[]?commandParameters)
????????{
????????????foreach?(OdbcParameter?p?in?commandParameters)
????????????{
????????????????//check?for?derived?output?value?with?no?value?assigned
????????????????if?((p.Direction?==?ParameterDirection.InputOutput)?&&?(p.Value?==?null))
????????????????{
????????????????????p.Value?=?DBNull.Value;
????????????????}

????????????????command.Parameters.Add(p);
????????????}
????????}

????????///?
????????///?This?method?assigns?an?array?of?values?to?an?array?of?OdbcParameters.
????????///?

????????///?array?of?OdbcParameters?to?be?assigned?values
????????///?array?of?objects?holding?the?values?to?be?assigned
????????private?static?void?AssignParameterValues(OdbcParameter[]?commandParameters?object[]?parameterValues)
????????{
????????????if?((commandParameters?==?null)?||?(parameterValues?==?null))
????????????{
????????????????//do?nothing?if?we?get?no?data
????????????????return;
????????????}

????????????//?we?must?have?the?same?number?of?values?as?we?pave?parameters?to?put?them?in
????????????if?(commandParameters.Length?!=?parameterValues.Length)
????????????{
????????????????throw?new?ArgumentException(“Parameter?count?does?not?match?Parameter?Value?count.“);
????????????}

????????????//iterate?through?the?OdbcParameters?assigning?the?values?from?the?corresponding?position?in?the?
????????????//value?array
????????????for?(int?i?=?0?j

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

?????文件??????81675??2009-07-25?13:48??SqlHelper\OdbcHelper.cs

?????文件??????82269??2009-07-25?17:15??SqlHelper\OleDbHelper.cs

?????文件??????72637??2002-04-08?10:38??SqlHelper\SQLHelper.cs

?????文件??????61833??2013-11-20?13:28??SqlHelper\SqlHelperCE.cs

?????文件???????9755??2011-02-10?11:26??SqlHelper\SqlHelperParameterCache.cs

?????文件???????3342??2009-11-07?13:01??SqlHelper\xmlHelper.cs

?????文件?????558802??2013-11-19?22:17??SqlHelper\微軟SqlHelper類中文注釋和使用方法.pdf

?????目錄??????????0??2013-11-20?13:28??SqlHelper

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

???????????????870313????????????????????8


評論

共有 條評論