// Get an object by Object ID. public static c_object GetObject(int ObjectID) { c_object oObject = new c_object(); // Configure database connection elements. OleDbDataAdapter da = new OleDbDataAdapter(); OleDbConnection connection = new OleDbConnection(); connection.ConnectionString = database.getConnectionString(); DataSet ds = new DataSet("object"); try { connection.Open(); // Create query. string strSQL = string.Empty; strSQL += " select [ObjectID], [VNUM], [ShortDesc], [ObjectType] "; strSQL += " from [Object] "; strSQL += " where ObjectID = " + ObjectID + " "; da = new OleDbDataAdapter(strSQL, connection); da.Fill(ds); if (ds.Tables[0].Rows.Count > 0) { oObject.objectID = (int)ds.Tables[0].Rows[0]["ObjectID"]; oObject.objVNUM = (int)ds.Tables[0].Rows[0]["VNUM"]; oObject.ShortDesc = (string)ds.Tables[0].Rows[0]["ShortDesc"]; oObject.objType = (string)ds.Tables[0].Rows[0]["ObjectType"]; } } catch (Exception ex) { string strError = ex.Message; } connection.Close(); connection.Dispose(); return(oObject); }
// Get an object by Object ID. public static c_object GetObject(int ObjectID) { c_object oObject = new c_object(); // Configure database connection elements. OleDbDataAdapter da = new OleDbDataAdapter(); OleDbConnection connection = new OleDbConnection(); connection.ConnectionString = database.getConnectionString(); DataSet ds = new DataSet("object"); try { connection.Open(); // Create query. string strSQL = string.Empty; strSQL += " select [ObjectID], [VNUM], [ShortDesc], [ObjectType] "; strSQL += " from [Object] "; strSQL += " where ObjectID = " + ObjectID + " "; da = new OleDbDataAdapter(strSQL, connection); da.Fill(ds); if (ds.Tables[0].Rows.Count > 0) { oObject.objectID = (int)ds.Tables[0].Rows[0]["ObjectID"]; oObject.objVNUM = (int)ds.Tables[0].Rows[0]["VNUM"]; oObject.ShortDesc = (string)ds.Tables[0].Rows[0]["ShortDesc"]; oObject.objType = (string)ds.Tables[0].Rows[0]["ObjectType"]; } } catch (Exception ex) { string strError = ex.Message; } connection.Close(); connection.Dispose(); return oObject; }