User Interface Choice For Managing An "orders" Table?
Mar 17, 2011
I want to "manage" a table of "orders." Orders is a typical table with a foreign key pointing to a customer, and a one-to-many relationship with a "details" table. To manage orders means to enter new orders, add details to orders, record payments, print a list of orders, cancel orders, mark orders shipped, print one order, etc., etc. These tasks can be divided into tasks that affect single orders (cancel an order) and tasks that affect multiple orders (print a list of orders).That task division led me to this user interface: present a form/window that displays by default a list of orders, and provide a button that switches the view from list mode to single-order mode. Each mode then provides the buttons for its tasks.
I have a scenario at hand which has some design discussion going on. To break it down in simple words, think about a hierarchy as such Company -----> Customer ------> Orders (ignore the details of how the orders have products etc) if I was to expose an API to work with this, what would be a better design.
a) Dim comp As New Company comp.GetInfo(123) Dim cust As New Customer cust.Name= "CustomerName" comp.Add( cust)
b) Dim custhand As Customerhandler Dim cust As New Customer cust.Name= "CustomerName" custhand.AddCustomer(cust,123) ''123 is CompanyID
I have some custom user controls in my .net winforms program that do not display correctly when the user has selected larger text size. This setting:
My controls look like this: Instead of like this:
The bill to area and ship to area are both custom controls. I don't know if this is contributing to the problem but I do have code in each to scale the phone/fax areas to stretch nicely, like this code from the bill to control,
Private Sub panFaxPhone_Resize(sender As Object, e As System.EventArgs) Handles panFaxPhone.Resize panFax.Width = (panFaxPhone.Width / 2) - 1 panPhone.Width = (panFaxPhone.Width / 2) - 1 panFax.Left = panFaxPhone.Width - panFax.Width End Sub
How can I get my controls to size correctly while still respecting the users choice for larger text (I don't want to just set the AutoScaleMode to None)? After playing with this for a long time it seems to be a problem with anchors in the child controls. See this below image, the inner black box is the control with its border turned on, the text boxes (like name) are anchored left and right and should stretch to fill the control, but don't.
I've got 6 hours left to finish a uni project. It's a basic database driven e-commerce site. I have a home page, a products page, an orders page, an order confirm page, a shopping cart page and a view current orders page. The site uses an Access database with three tables. A Customer table, with all of the customer details, (FirstName, LastName, EmailAdd, CardNo, CardEx, SortCode, DeliveryAdd, Postcode) A Products table, with all the product information, (ProductID, ProductName, Price, ProductType, Images, ProductDescription). And an Orders table which contains CustomerID and ProductID. I'm trying to create an INSERT statement on the orders page so that when the customer inserts their details and presses the submit button the customers table will have a new record inserted. I also want this to create an entry in the orders table and redirect the client to the order confirm page which will display the details of the order. Here is my code which runs when the submit button is clicked on the order form. EDIT I've fixed the error with the missing apostrophe. Attempting to insert using two sql commands as I've been told that access databases can't handle two at once. Still getting an error though.
Protected Sub btnAddRecord_Click(ByVal sender As Object, ByVal e As System.EventArgs) Dim strFirstName As String
I am working on an invoicing program that based on the Northwind database.I am pulling information from a 'view' for the orders form.How do i program the customer ID field to populate with the corresponding invoiceID (already done through the view) AND when i drop down the customerID box to list all possible customers from the customers table.I have the SQL for the operation I believe the problem is that the field is bound to the orders Orders Qry 'View'.How can i accomplish both of these tasks within the same dropdown?
I am developing a Windows Forms Based Application using dbo.database and Visual Basic: I populate some Orders in DataGridView1 using LINQ 2 SQL from "tbl_Orders" where OrderStatus is "Pending". I change OrderStatus Column Type to "CheckBox" in DataGridView, Now I want that when I select some records (Orders) by checking respective checkboxes and click on "btn_UpdateStatus" Button, program pick OrderID's of only selected orders and update OrderStatus of Only selected Records (Orders) from "Pending" to "Completed" in Database Table "tbl_Orders" and DataGridView1 should be Refreshed. [code]
sample_form.rtf (1.48MB). Number of downloads: 36. I have a working form to give specific choices to the user and retrieve the user's choice. (See code below and attached image in WordPad file.) I know I can use a global ("Public") variable to pass the text of the three choices from the calling form to the called form, but is there a way to pass these from one form to the other exclusively? Of course, my main objective is to have as little memory being used as possible. I would like to make the form in my example (frmDialogChoice) a generic form that can display any set of three choices.
code within calling form: Dim intSwitchToMake As Integer Dim insFrmDialogChoice As New frmDialogChoice insFrmDialogChoice.ShowDialog()
No doubt a simple question, but I'm a beginner (I learnt GW BritingASIC in 3 months long ago - but after 6 months grappling with vb 2008 I am still bewidered).
I have written a program that asks the user at run time to choose 1 of 40 buttons. These are themselves defined at run time. Whichever button is chosen the same algoritm will run (using different data). Question: To save writing the same Button_Click routine 40 times, what code should I write - and where in the program - to detect which of the 40 the user has chosen?
I need my program to let the user choose a text file by browsing the computer then the file path of the file needs to be set as the New StreamReader path so that the computer can open the file.
I have four drop down lists here and I've assigned the datasource and displaymemberproperties so they are populated by a table. When I run the program and select a choice, all four of them get updated with the new choice.
I am trying to show or hide tabpages as per user choice. If user selects gender male then form for male in a tabpage "male" should be displayed and if user selects female then similar next form should be displayed in next tab "female" I tried using
tabControl1.TabPages.Remove(...) and tabControl1.TabPages.Add(...)
It adds and removes the tabpages but doing so will loose my controls on tabpages too... i can't see them back.
I have designed this app with 5 pictureboxes. Each picturebox shows an image of a variation of a particular chord. Now, when a user types in (let's say) Cmajor (and it auto completes) how do I get the 5 pictureboxes to show the 5 different Voicing (Variations) of the Cmajor Chord?
How can I edit the time on my form. I have a one tabpage Schedule on which I want to set time according to user's choice. (I know how to display current time). If current time is 5.50.55 PM then user can set anything for eg. 6.45.12 AM according to he want to schedule.
I try to create a form that managing the access level of user management system.The model I use is the following :I create a connection to database I create a DataAdapter to transfer the data from the database I create a Dataset to hold my data My form consists of the following :A ListBox that list all the access level namesThree text boxes: the first for the record ID The second for the access level name And the third for the discription of the access level Five check boxes:One for writing rights One for the deleting rights One for the Updating rights One for Printing rights And one for Special area access rightsSo what i do is the following :I create a connection string I create a new connection to my database server I create the DataAdapter I initializing the DataAdapter command such as SelectCommand, DeleteCommand, e.t.c.I fill my DataSet with the data DataAdapter get from DataBase I binding my controls to DataSet I setting the DataSource property of the ListBox to my DataSet I setting the DisplayMember to the ACCL_NAME column of the DataTable inside the DataSet I setting the ValueMember to ACCL_ID column of the DataTable inside the DataSetUntil this time all are fine ! ! !The question is :When i try to add a new row to dataset by using the following code i have a problem :
Dim newRow As DataRow = Dataset.Tables("TableName").NewRow newRow("COLUMN_NAME") = Binded Control Value DataSet.Tables("TableName").Rows.Add(newRow)
I'm working on a design project where I have to use a Graphical User Interface that contains a drag and drop form. It consists of having a window dropped on a wall. Both of them are images to scale. I would like to know what kind of code I would have to use to show the x and y coordinates of one of the points of my window when dragged so when I drop it, I'm dropping in it on the desired coordinate of the wall.
designing a Windows based computer program that will allow a user to enter some number (n) and a choice of a count up or count down for that many numbers. So for example, the user enters 5 as their number and selects the count down option, the message box displayed would contain the message: "Here are your numbers: 5,4,3,2,1,0"
how to create a client/server... But I couldn't... I don't want anything fancy. Just want the client to send the server 4 numbers, depending on the user's choice; after that, the server would turn off the pc, restart it, etc. It all depends on the number received. Is there a rather "simple" way to do it? If it's not to much trouble you could use Atheist's example. (Btw I don't understand the code and, yes, I've checked on [URL])
I have an interface class (IUser) which is the interface of class User. Now, i want to put these into an IList but am confused as to how i should declare the IList:Dim userList As IList(Of IUser) = New List(Of IUser) Dim userList As IList(Of User) = New List(Of User) Dim userList As IList(Of IUser) = New List(Of User) Dim userList As IList(Of User) = New List(Of IUser) when instantiating should you always use its implementation; and when using it as a type use its interface?
And when im creating a new user should i use: Dim myUser as IUser = new User?
I would like to know how to filter out system tables and only return user tables .when i run the code it displays lists of system tables with user tables list in combobox.I have just gotten into vb.net and have tried few ways to do this but dont understand well enough.
I'm learning how to use visual basic and come from a background in Java. In Java I use the swing class to build my interface and code all of it. Is there a way to do this with visual basic, or is the designer the only way to create an interface?
I want input from user and when he click on view report button report should come in report viewer. May be my design is not good but my aspect is to design a user interface so that user should able to pass parameter in all the ways and get desired report.
Drop downlist Radio Button Check box and other countrols Gaurav
I'm making a VB.net program via a text file and I'm compiling it using vbc.exe via command line. I'm trying to get just a simple program to run in the background of my computer. Problem is, it displays the annoying console window. How do I get nothing to show? No form, no console?
I want to create a table as displayed in the image in VB.net. How do i do it ?? I tried LISTVIEW with Gridlines, but it has both horizontal and vertical lines, but in the image there is only Vertical lines.
How can I customize the user interface in Visual Basic .NET and is there stuff you cant do in Vb.net that you can in higherj level languages usch as Java and C and C++?
i want the user interface to be kinda similar to the jQuery UI. This means themed buttons and windows(preferabely the ones form jQuery UI) Also, i'm looking for nice sliding and morphing windows.
I am using Visual Basic 2005 for an Operator Interface in an industrial setting. Where should I be looking to help make my Operator Interface even more eye pleasing and practical?