Right Approach For Objects That Belong To Categories
Feb 3, 2010
I want to know what's the right way to work with objects that belong to a category.I'm building an applications with the following layers:Base data access Data access Business logic + Factories Presentation.I want to pass only objects to the presentation layer and back.I have objects (Employees), that belong to a certain category (EmployeeCat). I was wondering if I should have just an EmployeeCatID property in my Employee class/object, or an EmployeeCat property that contains a complete category object.If I want to fill a GridView with a list of employee objects as datasource, and I used just an ID in my Employee objects, then I will have some work at the presentation level to display the category names, so I think. On the other hand, if the list of employees contains plain category objects... I'm not sure what will happen.
I am working on a inventory application and I have a question, I have created a table for each of the main categories that I will be using, now if I wanted to add sub categories would I create another table for the sub directory and set the type as a child for its corresponding category or would it be easier to keep the main categories and just add another column in each table for "sub category" so it uses the same table but I can just filter it out easier?
If it is a better option for creating parent and child tables, how would I go about listing them in a hierarchical treeview to show parent and child sub-categories in them.
In my propertygrid having 3 categories..By default these categories displayed on Alphabetical order..But i don't want like this..
Suppose my 3 categories are appearance,Layout,Dynamic Events.. Now it is displaying appearance, Dynamic Events, Layout,
But i want like this appearance,Layout,Dynamic Events..
How can i arrange.. This is the code i will implemented..
<Category("Appearance")> <Description("Indicates how the text should be aligned for the control")> _ Public Property Alignment() As System.Windows.Forms.HorizontalAlignment Get
I want to have a control listing all subcategories from a database table. What control should I use. then I want to have a treeview with Categories, and be able to drag and drop sub categories onto the Categories. VS 2008
I can not use Inheritance Picker Dialog windows. Choosing Project in menu bar and then Add New Item, there is Templates frame only and Inherited Form is missing. Categories frame, which should be located on the left side, is missing as well. So i could not choose Windows Forms from Categories Frame on the left and Inherited Form from Templates on the right. Is it possible that Express Edition does not support Inheritance?
Here's the program. there are five categories say a, b, c, d, e, each in a textbox (color blue). There will be a command button say "choose". If i click the choose button, it will randomly choose one category and that corresponding textbox example "a" will change color(color yellow). Then if I want to click the choose button again, the selected category "a" from the first selection will change to gray, then a new category will be randomly chosen without "a" in the list and again will change to color yellow. and so on. So I can click the choose button five times, exhausting the five categories without repeating the category that was already selected.
I have a project that works with a database. It groups al my films per category. I use this code to group everything by category. The categories are chosen in the combobox cboCateogorie.
category Private Sub cboCategorie_SelectedIndexChanged_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cboCategorie.SelectedIndexChanged If Not cboCategorie.SelectedValue Is Nothing Then
[code]....
what I want is the opposite off what I do when I select a category in a combobox. Now I actually select a film and this film also has an ID, namely DvdID and with that I want that the combobox shows the category where the film belongs to.
I have a routine in a custom class that is assigning values to an object based on data from a table row. However, several tables may be used to update these values and only have some of the fields in common. Therefore, I want to check each field value to make sure it exists before I attempt to access it's value to assign to my object. However, I am getting the error "Column x Does Not Belong To Table."
'error occurs on first line If Not memberRow.Item("nickname") Is Nothing Then returnval.NickName = Trim(memberRow.Item("nickname").ToString) End If
I got some simple sql statement to see a record but I get an error - column does not belong to table...
Here's my
Dim mydataset As New DataSet mystring = "select max(NoteRef) as max_NoteRef from notes" Dim adapter As New SqlDataAdapter(mystring, nwindconn) adapter.Fill(mydataset, "notes") Label1.Text = mydataset.Tables(0).Rows(0).Item("NoteRef")
The problem seems to be that the codes below are events and cannot be called directly. I want to know how I can properly use the RaiseEvent statement while still keeping these where they belong, smack in the middle of the rest of my huge code:
I have data codes in the format abcd123, abcd345,... present in the table Info of database.I want to drop abcd from code and display remaining code in a combobox of datagridview.
Code:
Dim dsCodeList As New DataSet Dim dtCodeList As New DataTable
[code]....
It is giving error at first statement inside for loop saying Column Code Does not belong to Table Info.If i write simple query without use of right function and use dtCodeList.Rows(i).Item("Code").substring() to ignore first 5 characters, it works well.
I have an ASP.Net form where I use a DropDownList control to display data retrieved from a table. However setting the SelectedValue of the DropDownList to a value not existing in the dropdown list does not trigger an exception.
I have a form to set reminders on it. When I write a 1 reminder, everything works well. But when I write 2 reminders in same time, it comes this message.(Column 'Reminder_Time' does not belong to table Reminder.)
Dim i As Integer TextBox3.Text = DateTime.Now.ToShortDateString() TextBox4.Text = System.DateTime.Now.ToShortTimeString[code]......
I want to get a list of all users and groups that belong to a specific department (entered by the user) from Active Directory using VB.Net and DirectoryServices.
OK, I have this loop I want to perform which involves the serial port. Not to get too specific I'm actually sending data to an external device within a loop The loop involves a Start number, increments by a Step and ends when it gets to Stop This repeats until I click a STOP button.
I understand that there are several ways of Inserting, Updating and Deleting records in a database such as DataAdapters, DataSets, TableAdapters, SqlCommandBuilders, Parameterized SqlCommands, StoredProcedures, etc, etc,etc. According to David Sceppa Sprocs are the most preferred. Ok, I go with him on this one (who am I to challenge him anyway?).
My question is, apart from Sprocs, which of these options is the BEST for a large commercial database application and why, taking performance into account? What are the benefits and drawbacks of each option?
I am writing a program to assist Paramedic students in learning the Drugs that they have to know in order to pass their classes. I have created an Access database to hold all the information on these drugs, but not every student that will use this program will need to learn all the drugs contained within this database.
Right now I have 43 drugs in the database and still growing.
What I want to do is to present to the student the drugs and have them say "Y" or "N" as to whether its on their required list to learn. That way they only work on the ones that they need to.
I've two BGW with similar coding but different approach, My second BGW shows me "NOT RESPONDING" whenever i try move/click/focus to form while the BGW is running.
To write a effecient Active Directory library to ease the work of technicals who are responsible to create access models into the domain controller's Active Directory. This library must allow the following:Basic operations: Add, Modify, Delete, List entries;An entry may either be an organizational unit, group or user (no further need required as of now);I thought about having a class which would represent the domain with which we want to work with.
public class Domain { public Domain(string root) { Root = root;
I have a database with three tables: stock orders order_details
Stock and Orders are self explanatory. Order_details is a lookup table, holding basically just the orderID, stockID and quantity for each item in the order. That's not very friendly for the user however, so what I want to show is a DataGridView with some elements from order_details, and some from stock, i.e.: Part_Code, Item_Name, Description, Quantity, Price
I can create a database view for this easily enough, and bind it to a datagridview. It shows existing items in the order fine, but the problem is the view doesn't update when I add new elements to order_details in the dataset. It appears that it's bound to the main database, and so won't update until I save the record. That also has the problem that it's now much harder to update the database. A simple datagridview bound to order_details would make it easy for the user to enter quantities and for me to save the record, this one now needs a custom update statement.
In summary: - I want to show data from two tables - I want the datagridview editable (well, the quantity column anyway) - I want the datagridview to update when I add entries in the dataset What is the best/easiest way to do this? Is my current approach of a view in the database and custom update statements sensible? How can I get the datagridview to refresh whenever there's a change to the local dataset?
I recently started a project and needed to do some integration with LDAP via DirectoryServices. I've done this in other apps so I went into one of them to see how I did it -- why reinvent the wheel right? Well, while this wheel works, it was developed years ago and kinda smells (it's wooden, firmly attached to the previous vehicle, hard to repair and produces a potentially bumpy ride).So I thought to myself, this is the perfect time to refactor this puppy and make it more portable, reusable, reliable, easier to configure etc. Now that's fine and dandy, but then I started feeling a tad overwhelmed regarding to where to start. Should it be a separate library? How should it be configured? Should it use IoC? DI?
So my [admittedly subjective] question is this -- given a relatively small, but quite useful class like the one below, what is a good approach to refactoring it? What questions do you ask and how do you decide what to implement or not implement? Where do you draw the line regarding configuration flexibility? [Note: Please don't bash this code too much okay? It was written a long time ago and has functioned perfectly well baked into an in house application.]
Public Shared Function AuthenticateUser(ByVal id As String, ByVal password As String) As Boolean Dim path As String = GetUserPath(id)
I'm working on a system where there can be 2 level of users "Admin" or "Researcher".We have the requirement to allow the researcher to change fields for a record a record, but they want the original values to stay in the record and have an admin "accept" or "approve" the changes before the real record gets updated.Has anyone run into this scenario before? I'm trying to think of the best way to do this.
I'm currently working on a system that requires monthly, quarterly and annual reports. I have no problem in generating/retrieving the data, my problem is the presentation. What is the best way to do it? I need the report to be:
