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