public static string getData1Field(NpgsqlCommand ocmd)
{
string strHasil = "";
try
{
clsConnection xconn = new clsConnection();
xconn.Open();
DataTable dt = new DataTable();
ocmd.Connection = xconn.Conn;
ocmd.CommandType = CommandType.Text;
NpgsqlDataAdapter da = new NpgsqlDataAdapter(ocmd);
da.Fill(dt);
if (dt.Rows.Count > 0)
{
strHasil = dt.Rows[0].ItemArray.GetValue(0).ToString();
}
xconn.Close();
}
catch (Exception e)
{
MessageBox.Show(e.ToString());
}
return(strHasil);
}
public static void xsetupdatedatabase(string strSql)
{
try
{
clsRegKey oReg = new clsRegKey();
oReg.RegistryPathCurrentUser = clsGlobal.s_FullRegKey;
using (clsConnection oConn = new clsConnection())
{
oConn.Open();
NpgsqlCommand ocmd = new NpgsqlCommand();
ocmd = new NpgsqlCommand();
ocmd.Connection = oConn.Conn;
ocmd.CommandText = strSql;
ocmd.ExecuteNonQuery();
oConn.Close();
}
}
catch (Exception ex)
{
//throw
}
}