本文整理汇总了C#中AdoDataConnection类的典型用法代码示例。如果您正苦于以下问题：C#AdoDataConnection类的具体用法？C#AdoDataConnection怎么用？C#AdoDataConnection使用的例子？这里精选的类代码示例或许可以为您提供帮助。
示例1:Save
///
///Savesmeasurementbacktotheconfigurationdatabase
///
///
Databaseconnectionforquery.Willbecreatedfromconfigifthisvalueisnull.
///Measurementtobeinsertedorupdated
publicvoidSave(AdoDataConnectiondatabase,PowerMeasurementmeasurement)
{
varcreatedConnection=false;
try { createdConnection=CreateConnection(refdatabase);
if(measurement.SignalID==Guid.Empty) { database.ExecuteNonQuery("INSERTINTOMeasurement(DeviceID,PointTag,SignalTypeID,"+
"SignalReference,Adder,Multiplier,Description,Enabled,UpdatedBy,UpdatedOn,CreatedBy,CreatedOn)VALUES"+
"({0},{1},{2},{3},{4},{5},C# CodeClass类代码示例C# AdornerLayer类代码示例C# AppSettings类代码示例C# BulkMaterialType类代码示例,C# Antlr4类代码示例C# Byte4类代码示例C# DataSet类代码示例C# CategoryModel类代码示例,C# BundleCollection类代码示例C# Activity类代码示例TextBox设置焦点时候设置背景颜色为红色C#代码C# AccessHelper类代码示例,C# Campaign类代码示例C# CardEffect类代码示例C# Args类代码示例C# AppDomain类代码示例C# CanvasDevice类代码示例C# CacheType类代码示例C# ClassMap类代码示例C# AVPixelFormat类代码示例C# AABB类代码示例C# CodeBlock类代码示例C# Build类代码示例C# AccessToken类代码示例C# ByteReader类代码示例C# AIType类代码示例C# BundleInstaller类代码示例C# CT_Tbl类代码示例C# Category类代码示例C# ChunkedMemoryStream类代码示例C# CellInfo类代码示例C# Anchor类代码示例,C# Business.OrderIdParser类代码示例C# DataPage类代码示例C# CloudServiceProject类代码示例switch语句用法详解C#写日志方法（写到指定目录，没有自动创建）C# AccountInfo类代码示例C# DatabaseHelper类代码示例C#DES加密和解密代码C# CPPTargetPlatform类代码示例C# CCControlEvent类代码示例C# CONTROL_STATE类代码示例C# ClientType类代码示例C# AccessCondition类代码示例C# Analyzer类代码示例C# AList类代码示例C# CardColor类代码示例C# CvSize类代码示例C# CGBitmapContext类代码示例C# AST类代码示例C# CSsemi.CSemiExp类代码示例,/biancheng/C/556488.html)",ToNotNull(measurement.DeviceID),measurement.PointTag,
measurement.SignalTypeID,measurement.SignalReference,measurement.Adder,measurement.Multiplier,ToNotNull(measurement.Description),
database.Bool(measurement.Enabled),Thread.CurrentPrincipal.Identity.Name,database.UtcNow,Thread.CurrentPrincipal.Identity.Name,database.UtcNow);
measurement.SignalID=database.ExecuteScalar("SELECTSignalIDFROMMeasurementWHEREPointTag={0}",measurement.PointTag); } else { database.ExecuteNonQuery("UPDATEMeasurementSETDeviceID={0},PointTag={1},"+
"SignalTypeID={2},SignalReference={3},Adder={4},Multiplier={5},Description=C# CodeClass类代码示例C# AdornerLayer类代码示例C# AppSettings类代码示例C# BulkMaterialType类代码示例,"+
"Enabled=C# Antlr4类代码示例C# Byte4类代码示例C# DataSet类代码示例C# CategoryModel类代码示例,UpdatedBy=C# BundleCollection类代码示例C# Activity类代码示例TextBox设置焦点时候设置背景颜色为红色C#代码C# AccessHelper类代码示例,UpdatedOn=C# Campaign类代码示例C# CardEffect类代码示例C# Args类代码示例C# AppDomain类代码示例C# CanvasDevice类代码示例C# CacheType类代码示例C# ClassMap类代码示例C# AVPixelFormat类代码示例C# AABB类代码示例C# CodeBlock类代码示例C# Build类代码示例C# AccessToken类代码示例C# ByteReader类代码示例C# AIType类代码示例C# BundleInstaller类代码示例C# CT_Tbl类代码示例C# Category类代码示例C# ChunkedMemoryStream类代码示例C# CellInfo类代码示例C# Anchor类代码示例WHERESignalId=C# Business.OrderIdParser类代码示例C# DataPage类代码示例C# CloudServiceProject类代码示例switch语句用法详解C#写日志方法（写到指定目录，没有自动创建）C# AccountInfo类代码示例C# DatabaseHelper类代码示例C#DES加密和解密代码C# CPPTargetPlatform类代码示例C# CCControlEvent类代码示例C# CONTROL_STATE类代码示例C# ClientType类代码示例C# AccessCondition类代码示例C# Analyzer类代码示例C# AList类代码示例C# CardColor类代码示例C# CvSize类代码示例C# CGBitmapContext类代码示例C# AST类代码示例C# CSsemi.CSemiExp类代码示例",ToNotNull(measurement.DeviceID),measurement.PointTag, measurement.SignalTypeID,measurement.SignalReference,measurement.Adder,measurement.Multiplier,ToNotNull(measurement.Description),
database.Bool(measurement.Enabled),Thread.CurrentPrincipal.Identity.Name,database.UtcNow,measurement.SignalID); } } finally { if(createdConnection) database?.Dispose(); } }
原文链接：http://www.jxszl.com/biancheng/C/556488.html
