.net达梦数据库 dbHelp

public class DMDBhelp
{

/// <summary>
/// 获得数据库链接
/// </summary>
/// <returns></returns>
public static DmConnection GetConn()
{
string strconn = "server=111111111:5236;UserId=11111;PWD=111111111";
DmConnection conn = new DmConnection(strconn);
conn.Open();
return conn;
}

 

/// <summary>
/// 修改数据
/// </summary>
public static void Update(String sql)
{
DmConnection conn = GetConn();
try
{

string strCmd = sql;
DmCommand cmd = new DmCommand(strCmd, conn);
int effect = cmd.ExecuteNonQuery();

}
catch (System.Exception ew)
{
Tools.WriteMsg("达梦数据库操作失败，同步失败:" + ew.Message);
}
conn.Close();
}

 

/// <summary>
///用DataAdapter 查询数据，返回DataSet
/// </summary>
public static DataTable getDatatab(String sql)
{
DataTable tab = new DataTable();
try
{
DmConnection conn = GetConn();
string strCmd = sql;
DmDataAdapter da = new DmDataAdapter(strCmd, conn);
da.Fill(tab);
}
catch (System.Exception ew)
{
Tools.WriteMsg("达梦数据库操作失败，同步失败:" + ew.Message);
}

return tab;
}
}