数据库操作
来源:互联网 发布:主人网络 编辑:程序博客网 时间:2024/05/17 09:01
using System;
using System.Data ;
using System.Data .OleDb ;
using System.Data .SqlClient ;
namespace MyProject
{
/// <summary>
/// GetData 的摘要说明。
/// </summary>
public abstract class DataControl
{
public static string conStr=XmlControl.GetStrNode (@"XmlData/SysInfor.xml","dataPath",0);
}
public class OleDbDataControl:DataControl
{
#region 获取DataReder
public static OleDbDataReader GetReader(string sql)
{
OleDbConnection con=new OleDbConnection( conStr );
OleDbCommand cmd=new OleDbCommand(sql,con);
OleDbDataReader dr=null;
try
{
con.Open();
dr=cmd.ExecuteReader();
return dr;
}
catch (Exception ex)
{
dr.Close ();
con.Dispose();
cmd.Dispose();
throw new Exception(ex.ToString());
}
}
#endregion
#region 获取DataSet
public static DataSet GetDataSet(string sql,string tablename)
{
DataSet ds= new DataSet();
OleDbConnection con=new OleDbConnection(conStr);
OleDbDataAdapter da=new OleDbDataAdapter(sql,con);
try
{
da.Fill(ds,tablename);
return ds;
}
catch (Exception ex)
{
throw new Exception(ex.ToString());
}
finally
{
con.Close();
con.Dispose();
da.Dispose();
}
}
#endregion
#region 执行Updata Insert Delete操作
public static void uid(string sql)
{
OleDbConnection con=new OleDbConnection(conStr);
OleDbCommand cmd=new OleDbCommand(sql,con);
try
{
con.Open ();
cmd.ExecuteNonQuery ();
}
catch (Exception ex)
{
throw new Exception(ex.ToString());
}
finally
{
con.Close();
con.Dispose();
cmd.Dispose();
}
}
#endregion
#region 获得单个数据
public static string GetOneDate( string sql )
{
OleDbConnection con=new OleDbConnection(conStr);
OleDbCommand cmd=new OleDbCommand(sql,con);
try
{
con.Open ();
return cmd.ExecuteScalar ().ToString ();
}
catch (Exception ex)
{
throw new Exception(ex.ToString());
}
finally
{
con.Close();
con.Dispose();
cmd.Dispose();
}
}
#endregion
}
public class SqlDataControl:DataControl
{
#region 获取DataReder
public static SqlDataReader GetReader(string sql)
{
SqlConnection con=new SqlConnection( conStr );
SqlCommand cmd=new SqlCommand(sql,con);
SqlDataReader dr=null;
try
{
con.Open();
dr=cmd.ExecuteReader();
return dr;
}
catch (Exception ex)
{
dr.Close ();
con.Dispose();
cmd.Dispose();
throw new Exception(ex.ToString());
}
}
#endregion
#region 获取DataSet
public static DataSet GetDataSet(string sql,string tablename)
{
DataSet ds= new DataSet();
SqlConnection con=new SqlConnection(conStr);
SqlDataAdapter da=new SqlDataAdapter(sql,con);
try
{
da.Fill(ds,tablename);
return ds;
}
catch (Exception ex)
{
throw new Exception(ex.ToString());
}
finally
{
con.Close();
con.Dispose();
da.Dispose();
}
}
#endregion
#region 执行Updata Insert Delete操作
public static void uid(string sql)
{
SqlConnection con=new SqlConnection(conStr);
SqlCommand cmd=new SqlCommand(sql,con);
try
{
con.Open ();
cmd.ExecuteNonQuery ();
}
catch (Exception ex)
{
throw new Exception(ex.ToString());
}
finally
{
con.Close();
con.Dispose();
cmd.Dispose();
}
}
#endregion
#region 获得单个数据
public static string GetOneDate( string sql )
{
SqlConnection con=new SqlConnection(conStr);
SqlCommand cmd=new SqlCommand(sql,con);
try
{
con.Open ();
return cmd.ExecuteScalar ().ToString ();
}
catch (Exception ex)
{
throw new Exception(ex.ToString());
}
finally
{
con.Close();
con.Dispose();
cmd.Dispose();
}
}
#endregion
}
}
using System.Data ;
using System.Data .OleDb ;
using System.Data .SqlClient ;
namespace MyProject
{
/// <summary>
/// GetData 的摘要说明。
/// </summary>
public abstract class DataControl
{
public static string conStr=XmlControl.GetStrNode (@"XmlData/SysInfor.xml","dataPath",0);
}
public class OleDbDataControl:DataControl
{
#region 获取DataReder
public static OleDbDataReader GetReader(string sql)
{
OleDbConnection con=new OleDbConnection( conStr );
OleDbCommand cmd=new OleDbCommand(sql,con);
OleDbDataReader dr=null;
try
{
con.Open();
dr=cmd.ExecuteReader();
return dr;
}
catch (Exception ex)
{
dr.Close ();
con.Dispose();
cmd.Dispose();
throw new Exception(ex.ToString());
}
}
#endregion
#region 获取DataSet
public static DataSet GetDataSet(string sql,string tablename)
{
DataSet ds= new DataSet();
OleDbConnection con=new OleDbConnection(conStr);
OleDbDataAdapter da=new OleDbDataAdapter(sql,con);
try
{
da.Fill(ds,tablename);
return ds;
}
catch (Exception ex)
{
throw new Exception(ex.ToString());
}
finally
{
con.Close();
con.Dispose();
da.Dispose();
}
}
#endregion
#region 执行Updata Insert Delete操作
public static void uid(string sql)
{
OleDbConnection con=new OleDbConnection(conStr);
OleDbCommand cmd=new OleDbCommand(sql,con);
try
{
con.Open ();
cmd.ExecuteNonQuery ();
}
catch (Exception ex)
{
throw new Exception(ex.ToString());
}
finally
{
con.Close();
con.Dispose();
cmd.Dispose();
}
}
#endregion
#region 获得单个数据
public static string GetOneDate( string sql )
{
OleDbConnection con=new OleDbConnection(conStr);
OleDbCommand cmd=new OleDbCommand(sql,con);
try
{
con.Open ();
return cmd.ExecuteScalar ().ToString ();
}
catch (Exception ex)
{
throw new Exception(ex.ToString());
}
finally
{
con.Close();
con.Dispose();
cmd.Dispose();
}
}
#endregion
}
public class SqlDataControl:DataControl
{
#region 获取DataReder
public static SqlDataReader GetReader(string sql)
{
SqlConnection con=new SqlConnection( conStr );
SqlCommand cmd=new SqlCommand(sql,con);
SqlDataReader dr=null;
try
{
con.Open();
dr=cmd.ExecuteReader();
return dr;
}
catch (Exception ex)
{
dr.Close ();
con.Dispose();
cmd.Dispose();
throw new Exception(ex.ToString());
}
}
#endregion
#region 获取DataSet
public static DataSet GetDataSet(string sql,string tablename)
{
DataSet ds= new DataSet();
SqlConnection con=new SqlConnection(conStr);
SqlDataAdapter da=new SqlDataAdapter(sql,con);
try
{
da.Fill(ds,tablename);
return ds;
}
catch (Exception ex)
{
throw new Exception(ex.ToString());
}
finally
{
con.Close();
con.Dispose();
da.Dispose();
}
}
#endregion
#region 执行Updata Insert Delete操作
public static void uid(string sql)
{
SqlConnection con=new SqlConnection(conStr);
SqlCommand cmd=new SqlCommand(sql,con);
try
{
con.Open ();
cmd.ExecuteNonQuery ();
}
catch (Exception ex)
{
throw new Exception(ex.ToString());
}
finally
{
con.Close();
con.Dispose();
cmd.Dispose();
}
}
#endregion
#region 获得单个数据
public static string GetOneDate( string sql )
{
SqlConnection con=new SqlConnection(conStr);
SqlCommand cmd=new SqlCommand(sql,con);
try
{
con.Open ();
return cmd.ExecuteScalar ().ToString ();
}
catch (Exception ex)
{
throw new Exception(ex.ToString());
}
finally
{
con.Close();
con.Dispose();
cmd.Dispose();
}
}
#endregion
}
}
- 操作数据库
- 数据库操作
- 数据库操作
- 数据库操作
- 数据库操作
- 数据库操作
- 数据库操作
- 数据库操作
- 数据库操作
- 数据库操作
- 数据库操作
- 数据库操作
- 数据库操作
- 数据库操作
- 数据库操作
- 数据库操作
- 操作数据库
- 数据库操作
- 体验Opera手机浏览器
- Web----logout---- 注销页面设计
- 【转】从工作中总结的游戏场景设计思路浅谈(一)
- 常用js
- DataGridView 的 DataGridViewCheckBoxColumn使用简单说明
- 数据库操作
- 逻辑模拟和故障模拟
- stl remove的例子
- RSS 2.0 Specification
- UNIX Programming FAQ 中文版 v0.1.0
- 通过字符串变量动态打开窗体并动态调用其方法
- before Chirstmas eve
- 回家过年了
- 后续略过。准备正式进入ASM旅程