C#链接数据库代码

来源:百度知道 编辑:UC知道 时间:2024/09/28 10:24:49
链接sql和oracle,并且给出使用实例

using System.Data.SqlClient;

SqlConnection connection = new SqlConnection();
connection.ConnectionString = "your connection string";

connection.Open();

using System;
using System.Data;
using System.Xml;
using System.Data.OracleClient;
using System.Collections;

namespace Database.Data.OracleClient
{
public sealed class SqlHelper
{
#region private utility methods & constructors

private SqlHelper() { }

private static void AttachParameters(OracleCommand command, OracleParameter[] commandParameters)
{
foreach (OracleParameter p in commandParameters)
{
//check for derived output value with no value assigned
if ((p.Direction == ParameterDirection.InputOutput) && (p.Value == null))
{
p.Value = DBNull.Value;