http://dotnet.aspx.cc/ShowDetail.aspx?id=B12283DE-DB20-4322-ACCC-12724442808A
解决方案 »
- 请问下时间点选择控件是哪个啊,Winform
- 我用ribbon做工具栏,结果不知道碰到哪了,现在下面的缩进不上去
- C#网络编程———木马程序
- C# 打开程序、打开网页
- 怎么编译“default.aspx.cs”文件
- 这种功能如何实现?
- 问个关于程序占用内存和提高速度的问题!!!顺便送点分!!!!!!!
- Dataset操作问题!
- 求助:怎样才能当鼠标停在TreeView的菜单上时(包括子菜单),显示该菜单的内容,就像ToolTip提示一样??
- 老鸟们请帮我看下菜鸟的程序有什么错误,可以的话可以帮我改正一下
- 关于API调用的问题。具体内容见帖子。问题解决马上结帖。谢谢
- WinForm中打开文本文档的问题!
using System.Data;
using System.Data.OleDb;namespace ZZ.DAL
{
/// <summary>
/// AccessDbHelper 的摘要说明。
/// </summary>
public class AccessDbHelper
{
private static string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=GMS.mdb;Persist Security Info=False;";
/// <summary>
/// 获取单个值
/// </summary>
/// <param name="strSql"></param>
/// <returns></returns>
public static object ExecuteScalar(string strSql)
{
object o = null;
OleDbConnection myConn = new OleDbConnection(strConn);
OleDbCommand myComm = new OleDbCommand(strSql,myConn);
try
{
myConn.Open();
o = myComm.ExecuteScalar();
}
catch(Exception e)
{
}
finally
{
myConn.Close();
}
return o;
}
/// <summary>
/// 更新数据
/// </summary>
/// <param name="strSql"></param>
public static int ExecuteNonQuery(string strSql)
{
int count = -1;
OleDbConnection myConn = new OleDbConnection(strConn);
OleDbCommand myComm = new OleDbCommand(strSql,myConn);
try
{
myConn.Open();
count = myComm.ExecuteNonQuery();
}
catch(Exception e)
{
}
finally
{
myConn.Close();
}
return count;
}
/// <summary>
/// 获取数据读取器
/// </summary>
/// <param name="strSql"></param>
public static OleDbDataReader ExecuteReader(string strSql)
{
OleDbConnection myConn = new OleDbConnection(strConn);
OleDbCommand myComm = new OleDbCommand(strSql,myConn);
myConn.Open();
return myComm.ExecuteReader(CommandBehavior.CloseConnection);
}
/// <summary>
/// 获取数据集
/// </summary>
/// <param name="strSql"></param>
/// <returns></returns>
public static DataSet ExecuteDataSet(string strSql)
{
DataSet ds = new DataSet();
OleDbConnection myConn = new OleDbConnection(strConn);
try
{
OleDbCommand myComm = new OleDbCommand(strSql,myConn);
OleDbDataAdapter myAda = new OleDbDataAdapter(myComm);
myAda.Fill(ds,"TableName");
}
catch(Exception e)
{
ds = null;
}
finally
{
myConn.Close();
}
return ds;
}
}
}