public static ResponseDS GetBySelect(DataAccessServers db, string tablename, string cmdText)
{
var obj = new SQLDataAccess();
try {
var ds =
obj.GetDataSet(
tablename, cmdText, CommandType.Text, db, false);
ds.Tables[0].TableName = tablename;
return(new ResponseDS(ds));
} catch (Exception ex) {
return(new ResponseDS(ex.Message, ex.ToString()));
} finally { obj.Dispose(); }
}
public ResponseDS Get(DataAccessServers db, string tablename, int id)
{
var cmdtext = "SELECT * FROM " + tablename + " WHERE Id=" + id;
return(Common.GetBySelect(db, tablename, cmdtext));
}
