I am designing a system for our sales team to enter their sales expenses. I have designed an input form and need some advise on what exactly I should store in the expenses table VS lookup from the employee table.
First, the form has a text box where the user must enter their EmployeeID. Management asked for a text box VS a combo box because they do not want users looking at each others expenses. The form has a search feature where by after you enter your employee number, it will look for an existing expense ticket first before allowing you to create a new one. Anyway, here are some of the decisions I have to make.
When the user enters their employee number, I would like to display their employee name. The EmployeeID is saved in the Expense table but should I also store the name in the expsense table? If I do save it, it's duplication of data, if I do not, I have to look it up each time the record is loaded. But is there a point storing the name long term? Does this qualify as related data? If I was to perform some reporting, could this cause a problem if an employee changes their name etc.
The expense data is spread over 2 tables, the first for the header details including employeeID, expense date and Expense ID etc. The second table contains the expense lines information. Amount, customer, category etc. My next question is when the employee chooses an expense category, there is an associated general Ledger code with that category. Again, the expense category data is stored in a table. When the user chooses the expense category, should I store the categoryID or store the values associated with the ID (GLAcct, CategoryDescription etc.) Does this qualify as related data or should lookup values always be duplicated in the master table? It is possible that over time, the GL accounts associated with the Expense categories could change. So for accuracy purposes, should they be stored in the expense lines table?
in VS 2008, is there a way to design a ContextMenuStrip in a designer without a relation to a specific Form or UserControl class? For example,if you need the same ContextMenuStrip in Form1, Form2 and Form3, in which of them am I to design the ContextMenuStrip? Do I have to add a "pseudo-Form" to the project that contains my shared ContextMenuStrips and create only one instance of that Form, or is there another way? I consider this a programmatic hack, that's why my question is whether the IDE offers something better.
I want to make relationship between them Where In the F column of Table2 will sum the numbers in F column of table 3 according this condition ( show in the pic.)For the same data in columns(B,C,D) between two tables Example: Table 2 include in B,C,D data HH XX FF There are many data (HH XX FF) in tables3 in same columns(b,c,d) so it will sum the numbers in F column that in the same row with the data (HH xx FF), and insertded the results in the in table2 in F colmn in the same row with (HH XX FF)
With a 1-many relation. Ok, I have constructed the schema, and now I want to make the appropriate forms in which a user would scroll for a customer and then by pressing a button, a new form would appear showing all the orders that he has made.
I am interested in the way of building two forms that would have a one to many relation. That is basically what I would like to know. Also, Do you have any good book to suggest in order to create a real world app, in VB2008, Emphasizing in data-binding and connecting controls with underlying DB, one to many forms, searching etc.
Am using VB.net 2005, and I've created columns for the datagridview at design time. But when I run the code the fill method of the DataAdapter, the columns I created are not filled with data, but automatically generated columns appear. How can the columns I created at design time be filled with data?
In a program I am creating, i want to let the user add and remove fields on an entity, lets say "people". So I have a table named "People", with ID and Name columns. Now, I want to let the user choose "add field" in a webpage, define for instance "email" field, and then use "ALTER TABLE" from the codebehind to create the new field in the table. What I want to know is: is this recommended? It seems like a simple way to do this, but since I have never seen any other programs doing it like this (Using ALTER TABLE statements from codebehind in a live environment) - and since it changes the design of the DB -
Currently working on a web-service with Oracle10g as back-end. Here is my problem.
1. The table I need to populate has 100 columns. I have no control over the design of the table.
2. I wanted to use the "deriveparameters" method of OracleCommandBuilder, but found out that this is "costly" in terms of performance. What I initially planned to do was to derive the parameters from an open connection, close the connection, then maybe cache the parameters obtained but I don't know if this is possible.
I am unsure how big of a hit the performance will get if I continue using the "deriveparameters" method WITHOUT caching the parameters driven. The environment is as follows
-intranet -around 2000 users -users spread out in different parts of the country
I am not familiar where they will put the web pages of the application, the web service and the database. I don't know if they'll be putting it in different servers or on one server, but that's something we cannot control too, that's why I am looking for the best approach.
I just don't want to hard-code all that parameters and if, for instance, we need to change some properties/parameters, it will be a pain to maintain the code. It would be nice if someone here can point a way to automate the whole thing w/o the performance of the system taking a hit.
I've got a large and complex database system that is about to get even more complex, and I'm having trouble coming up with a reasonable way to model the new requirements so as to minimize the performance hit.For simplicity's sake, I'm going to use the example of certification exams, although it's not a perfect analogy for my system. So we have the following tables:
- Person - Certification - Exam - Certification_Exams (join table indicating which exams are required per cert) - Person_Exams (join table indicating which exams a person has taken)
Given that model, we can easily show that Certification A requires Exam 1, and Certification B requires Exam 2 and Exam 3.We can also determine whether a person is certified by checking Person_Exams to see if they have passed all exams required for the certification we're querying. (Note that we are not directly storing certifications for a person; these must be derived. That's one of the areas where the cert exam analogy doesn't quite match my real-life scenario, so please accept that there's a good business reason for it.In my world, the cert requirements are going to change frequently, so a person might get suddenly "un-certified.")Now enter the new requirement: We now need to be able to indicate that Certification A could be satisfied by either Exam 1 or Exam 4.And furthermore, Certification B always requires Exam 2 but also requires either Exam 3 or the combination of Exams 5, 6, and 7.I've come up with a couple different approaches so far, but the subsequent queries to be able to tell whether someone meets the criteria for a given certification are then incredibly complex.
I have created my webpage in asp.net in 1024*768 resolution, my problem was that when i change my monitor resolution then the controls in my webpage will be displayed in unmanaged manner .
How to arrange items in my webpage which support multiple resolution ...
Whatever the resolution of my monitor the controls in my webpage will display as it is as managed in 1024*768 reolution !
I seem to have reached a limit on the size of the form. I cannot make the form longer and I need to add more fields. Is there a limit on how many fields can be included in a form?
I have two dataset , each with with table . each datasets is connected to a separate dataadapter to get data from sql server database file (two different tables SQLtableOrders & SQLtableCustomerA))
datasetOrders.Tables("Orders") >>> the first column "orderID" is a primary unique key. Its structure is details below : OrderID----OrderName----OrderCost--------Date 1----------A---------------54------------11/11/2010
[Code].....
note that I had already made this by getting the data by SQL Statement "Select SQLtableOrders.* , SQLtableCustomerA.orderID FROM SQLtableOrders, SQLtableCustomerA WHERE SQLtableOrders.orderID = SQLtableCustomerA.orderID" It is really working fine , but the problem that it takes time to get data from the SQL server each time I disply orders. I already have the datasetOrders.Tables("Orders") data on the client PC , I need only to make the client PC extract which orders are assinged to a ceratin customers. I can do it by For... Next , but I guess it will take time , specially if "orders" data contains many data .
<HttpPost()> Function Edit(<Bind(Prefix:="Article")> ByVal Article As FormCollection, Optional ByVal DepartementID As Integer = 0, Optional ByVal LeverancierID As Integer = 0) As ActionResult ', ByVal ReferenceSupplierID As Integer ' Dim Art As Article = ArticleService.GetArticleById(Article.ArticleID) Dim _toUpdateArt As Article = ArticleService.GetArticleById(Article(0)) UpdateModel(_toUpdateArt, Article)
[Code]...
toUpdateArt.Departement = Nothing and _toUpdateArt.Supplier = Nothing is to remove the optional relationship.But it only works when i debug it and sometimes after several loops of the command, before the relation is actually removed and it's stored in the database.When there isn't a breakpoint on the "function", the Relationship will never be nulled.Does anyone has an explanation for this and how to fix this?
I am a newbie. I have been able to Add new entities where there is a One-To-Many Relation. I am having a problem (don't Know how to do it) adding a new Entity when the relation is using Many-To-Many. In my EDM I have:
I want to have a combo box with a list of names. When one of the names is selected, I want the phone number and email to be displayed below it in a text box (or something similar).
i have two tables ( employees and departments )i want to insert data in employees table via employees form .so how can i put the departments names in a combobox and when the user choose a specific one it will return a department number so i can pass it to the INSERT statement? i mean what is the exact SELECT statement to load the the information to the datatable do i need two SELECT statements or innerjoin or something else?
I have two tables populated in a dataset using sql data adapter.. i created relation by specifying two columns in each table.. added it in dataset and made datagridview to show related records.. but it shows only first record...
---code
Dim cons As New String("Data Source=xxxxSQLEXPRESS;Initial Catalog=emp;Integrated Security=True") Dim sql1 As New String("Select * from tab1") Dim sql2 As New String("Select * from tab2")
I searched codeplex and google. I have found so many such as tustena but unfortunately they are not domain driven based and in these solutions I could not find a good modelling documents or references. i am a newbie in CRM but I am sensetive to design it with solid object-oriented fundamentals. Any reference or open source solution especifically for CRM design and implementaion in .NET? Cheers
i am trying to get the angle of a line in relation to the x axis. The line is being drawn in a picturebox. So its the Upper right quadrant of the cartesian plane ... but its flipped over the x axis.im using this code
a=pt(1).x b=pt(1).y c=pt(2).x d=pt(2).y
z=math.atan2((c-a),(d-b))*(180/math.pi)
The issue is that the line im drawing is almost parallel to the x axis but its returning a value of roughly 90 degrees .It seems like it is giving me the angle in relation to the y axis, but not being super good at the math myself im not exactly sure what to change here.
i have a login form that contains a combo box and a text box and a button. the items of the como box are from the databse while the person selected can only log into the system if the password he enters on the textbox matches the password details in the database.(of the name selected)
my problem is, the second tab contains a couple of textboxes and combo boxes that need to be filled in. but i want the first combo box in the second tab to have drop down value of the name of the person that has logged in to fill in the form.
the person login in the first tab, his name should appera on the combo box in the second tab
I've made a ContextMenuStrip to use in my program to change the image in a picture box. However, it's used with multiple picture boxes which each need to have their own changed. What I want to do is make my command change only that picture box leaving the others as they were before. An example, if this were a plausible code.
Private Sub TestToolStripMenuItem_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles TestToolStripMenuItem.Click Self(aka the control that currently has the menu open).Image = My.Resources.Picture End Sub
I have this code working fine , it takes pictures of the correct size and correct file name , however , all the pictures it takes are in the top left corner of the screen , rather than where i have the form to. FYI the picture box in the middle has no picture in it , and is transparent , i want to save a bitmap of the contents of the picturebox ( a user defined size of the screen). The picture box and button are docked so that the form scales properly when being resized.
If I do the mousedown event in my picturebox, is there a way to calculate the mouse position in relation to the picturebox itself, or will I have to calculate it from the X/Y of the mouse and the X/Y of the picturebox? I can do the latter, just wondering if there's a command for the former.
i am new to vb2005 and i am developing a project of a restaurant in vb2005. i have two combo boxes of PRICE and SOFTDRINKS. there are 5 different soft drinks and there are five different prices of the softdrinks in the combo box of PRICE. my requirement is that when i select the soft drink in the combo box of SOFTDRINKS then automatically the price relevant to that soft drink should be selected in the combo box of PRICE.
How do I add relations for two colums between two tables? I tried below way but it does not work. Is there any other way?
Dim relCompanyEmp1 As DataRelation = ds.Relations.Add("relSectionEmp", ds.Tables("MST_COMPANY").Columns("COMPANY_ID"), ds.Tables("EMP_MASTER").Columns("COMPANY_ID")) Dim relCompanyEmp2 As DataRelation = ds.Relations.Add("relSectionEmp", ds.Tables("MST_COMPANY").Columns("LOCATION_ID"), ds.Tables("EMP_MASTER").Columns("LOCATION_ID"))
Not sure if I am using the correct term, but it's not child/parent since they aren't nested objects. In my application I've got a User, UserUserGroup, and UserGroup objects which are pretty standard, UserUserGroup is a linking object with corresponding IDs. I am using Linq-to-SQL so unforunately it doesn't used nested objects, but it still knows the relation.
I have created a strongly typed dataset in the VS 2005 Dataset Designer. There are two tables that relates to each other in a one to many relationship: Claim and ClaimDetail. The designer automatically creates a function GetClaimDetailRows which returns all ClaimDetailRows for a ClaimRow. Why is this Array's length always 0? Because ClaimDetail contains more than 40 Million rows, i did'nt fill it before i call GetClaimDetailRows but had configured it's selectcommand that it takes a parameter idData to fill only the related records. But that seems not to work because the ClaimDetail-Datatable is empty.
The automatically generated function in the ClaimRow-Class which returns all related ClaimDetailRows: Public Function GetClaimDetailRows() As ClaimDetailRow() If (Me.Table.ChildRelations("Claim_ClaimDetail") Is Nothing) Then Return New ClaimDetailRow(-1) {} Else Return CType(MyBase.GetChildRows(Me.Table.ChildRelations("Claim_ClaimDetail")),ClaimDetailRow()) End If End Function
When debugging I see that it jumps into the else block but returns 0 rows. Do I have to fill the Claimdetail-Datatable first(ClearBeforeFill=True) for each Claim? But then I don't need to use this function anymore. I now fill the Datatable(ClearBeforeFill=True)before i call the Child-function and it works. But I don't understand why it could not throw an exception(optionally) when I try to acess a child-relation without having that datatable being filled(at least with 0 rows). Instead of that it returns 0 rows what can be correct or incorrect and is difficult to detect.
the form backcolor is 14221235 , but when i set the customcolor in colordialog to equal the form backcolor, it sets it to 5046311 !!! what is the problem?the reason i am turning it into a string is because i will feed it into a string which has "32498239, 234234234, 23423234, 32234432432, 423324234"then i take this string and put it in customcolors like this. btw this piece of code works fine:
Dim numberStrings = My.Settings.mytext1.Split(","c).Select(Function(x) x.Trim()) ColorDialog1.CustomColors = numberStrings.Select(Function(x) CInt(x)).ToArray()
I am going to ask a dumb question. I want to update my tables (two). There is a one to many relation between them. I know how to update when only one table is update, but how do i update when there is many on the other side. My problem is that , if one of the records on the many should become redundant, how would i delete it in the update process. If only the content changes , it is not a problem, i know the data just gets written back to the tables, but if one of the child records is not delete, how would it work I need some clue on the SQL statement using OLEDB
If I use the following code to draw a rectange, do the values inserted into 'fromleft' & 'fromtop' set a co-ordinate from the top/left corner of the paper or from the top/left corner of the margins.
Dim R As Rectangle Dim across As Integer = 5 Dim down As Integer = 13
[Code]....
The reason I am asking this question is because I am trying to print labels so the position of the labels on the sheet are fixed. When the printer is set to papersize = letter the first label is in the correct position but when I change it to A4 the first label has moved 4mm to the right. With the margins set to 0 I still cant get it justified correctly. The printer is obviosly capable of printing 4mm from the left because it does so when set to 'letter'. Can't use letter because I need the extra length of A4 for the bottom row of labels.