public dsTstTest GetTstTest(string stWhereCommand)
{
dsTstTest ds_TstTest = new dsTstTest();
OracleDataAdapter daSQL = new OracleDataAdapter();
OracleConnection conn = new OracleConnection();
try
{
string getTNS = this._GetDb("TNS", "ORACLE");
conn.ConnectionString = getTNS;
OracleCommand stCMD = new OracleCommand(stWhereCommand, conn);
daSQL.SelectCommand = stCMD;
daSQL.Fill(ds_TstTest.TST_TEST);
return(ds_TstTest);
}
catch (Exception ex)
{
return(null);
}
finally
{
conn.Dispose();
conn.Close();
}
}
public string SetTstTest(dsTstTest qDaTaSet)
{
dsTstTestTableAdapters.TST_TESTTableAdapter da = new dsTstTestTableAdapters.TST_TESTTableAdapter();
string mConn = "";
try
{
mConn = this._GetDb("TNS", "ORACLE");
da.Connection.ConnectionString = mConn;
da.Update(qDaTaSet);
return("OK");
}
catch (Exception ex)
{
string getError = ex.Message.Substring(0, (ex.Message.Length - 1));
return(getError);
}
}
