c#操作mysql 执行语句_C#连接ACCESS数据库，执行SQL语句解决办法

2009-06-20 14:05 純→白銫.NET

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Data.SqlClient;

using System.Configuration;

using System.Data;

#region 数据层

namespace DATA

{

#region 数据库查询操作类

///

/// 数据库连接、操作类

///

public class ToDber

{

#region 数据库连接以及数据读取等私有变量和用于关闭连接的方法

///

/// 数据库连接对象

///

private static SqlConnection con = null;

///

/// DataReader对象

///

private static SqlDataReader sdr = null;

///

/// 关闭数据库连接

///

private static void CloseConAndSdr()

{

if (sdr != null) { sdr.Close(); }

if (con != null) { con.Close(); }

}

#endregion

#region 数据库操作公共方法，提供数据库查询返回等操作

///

/// 数据库连接方法

///

///

private static void GetConn()

{

// string conStr = ConfigurationSettings.AppSettings["GetConnStr"].ToString();

con = new SqlConnection("server=;database=;uid=;pwd=");

con.Open();

}

///

/// 查询SQL语句返回DataReader对象

///

///

///

public static SqlDataReader GetDataReader(string sqlStr)

{

CloseConAndSdr();

GetConn();

SqlCommand cmd = new SqlCommand(sqlStr, con);

sdr = cmd.ExecuteReader();

return sdr;

}

///

/// 查询SQL语句返回DataAdapter对象

///

///

///

public static SqlDataAdapter GetDataAdapter(string sqlStr)

{

CloseConAndSdr();

GetConn();

SqlDataAdapter sda = new SqlDataAdapter(sqlStr, con);

return sda;

}

///

/// 查询SQL语句返回SqlCommand对象的ExecuteNonQuery()

///

///

///

public static int GetExecuteNonQuery(string sqlStr)

{

CloseConAndSdr();

GetConn();

SqlCommand cmd = new SqlCommand(sqlStr,con);

return cmd.ExecuteNonQuery();

}

///

/// 查询SQL语句返回DataSet对象

///

///

///

public static DataSet GetDataSet(string sqlStr)

{

CloseConAndSdr();

GetConn();

SqlDataAdapter sdr = new SqlDataAdapter(sqlStr, con);

DataSet ds = new DataSet();

sdr.Fill(ds);

return ds;

}

#endregion

}

#endregion

}

#endregion

第1楼