//帮助类
public class SqlHelp
{
/// <summary>
/// 获得数据库链接
/// </summary>
/// <returns></returns>
public static DmConnection GetConnection()
{
string strconn = "server=localhost;User ID=SYSDBA;PWD=123456;Database=SYSDBA;port=5236;";
DmConnection conn = new DmConnection(strconn);
conn.Open();
return conn;
}
/// <summary>
/// 执行Sql语句
/// </summary>
/// <param name="sql"></param>
public static int ExecuteNonQuery(string sql)
{
DmConnection conn = GetConnection();
string strCmd = sql;
DmCommand cmd = new DmCommand(strCmd, conn);
int val = cmd.ExecuteNonQuery();
conn.Close();//关闭数据库链接
return val;
}
/// <summary>
///用DataAdapter 查询数据,返回DataTable
/// </summary>
public static DataTable QueryByDataAdapter(string sql)
{
DmConnection conn = GetConnection();
string strCmd = sql;
DmDataAdapter da = new DmDataAdapter(strCmd, conn);
DataTable dt = new DataTable();
da.Fill(dt);
return dt;
}
*国产数据库字段加“”*
/// <summary>
/// 查询数据列表
/// </summary>
/// <returns></returns>
public DataTable GetUserList()
{
string sql = string.Format("select * from SYSDBA.\"{0}\"", "t_user");
DataTable dt = SqlHelp.QueryByDataAdapter(sql);
return dt;
}
/// <summary>
/// 插入数据
/// </summary>
/// <returns></returns>
public int InsertUser()
{
string sql = string.Format("insert into SYSDBA.\"{0}\"(\"f_key\", \"f_name\", \"f_delete_flag\") VALUES ('{1}', '{2}', {3})", "t_user", "d56d35da-65ed-46ca-adb8-9b1ab8b01e6a", "bbbbbbb",0);
int num = Convert.ToInt32(SqlHelp.ExecuteNonQuery(sql));
return num;
}
/// <summary>
/// 更新数据
/// </summary>
/// <returns></returns>
public int UpdateUser()
{
string sql = string.Format("update SYSDBA.\"{0}\" set \"f_name\"='{1}' where \"f_key\"='{2}'", "t_user", "aaaaaa", "d56d35da-65ed-46ca-adb8-9b1ab8b01e6a");
int num = Convert.ToInt32(SqlHelp.ExecuteNonQuery(sql));
return num;
}
/// <summary>
/// 删除数据
/// </summary>
/// <returns></returns>
public int DeleteUser()
{
string sql = string.Format("delete from SYSDBA.\"{0}\" where \"f_key\"='{1}'", "t_user", "d56d35da-65ed-46ca-adb8-9b1ab8b01e6a");
int num = Convert.ToInt32(SqlHelp.ExecuteNonQuery(sql));
return num;
}
简单的增删改查 有兴趣的可以封装一下