DB/Reporting - Simple DB Steps - Building Two Forms With One To Many Relation
Aug 4, 2009
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.
View 6 Replies
ADVERTISEMENT
Jun 10, 2011
Is there anyone can post a simple code using vb,that start building a simple games ?
View 2 Replies
Apr 21, 2010
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?
View 2 Replies
Oct 9, 2008
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)
View 10 Replies
Apr 23, 2009
I am building a simple form wicht allows the user to update the data on it.I use this
Imports System
Imports System.Data
Imports System.Data.OleDb[code].....
View 8 Replies
Oct 2, 2009
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.
View 3 Replies
Oct 19, 2010
I am trying to follow an example. I'm getting the following errors:
1. PartNum is not a member of 'Vantage2.OMSDataContext.
2. Name 'Where' is not declared.
3. Method arguments must be enclosed in parenthesis.
4. Name 'p' is not declared.
5. Comma, ')', or a valid expression continuation expected.
For reference, the link is here: [URL]
I have followed with my code as follows...
Class Window1
Private db As New OMSDataContext
Private View As BindingListCollectionView
Private Sub Window1_Loaded(ByVal sender As Object, ByVal e As System.Windows.RoutedEventArgs) Handles Me.Loaded
[Code] .....
View 1 Replies
May 6, 2012
I'm using vb.net express with access 2010.Everything is working fine except for a simple query:SQL: SELECT * FROM Customers WHERE Name Like 'Ale*'Which returns all the names starting with Ale. Now in my .NET code I wrote this:cmd = New OleDbCommand("SELECT * FROM Customers WHERE Name Like " & Chr(39) & Name.Text & Chr(39), connection)Now when I start the app and in my textbox "name" I write Ale* I have the following expression:SQL: SELECT * FROM Customers WHERE Name Like 'Ale*'But when it executes from .NET (dr = cmd.ExecuteReader) it doesn't find ANYTHING.
View 11 Replies
Apr 2, 2008
I am trying to query a SQL db and send the results to a notepad or wordpad doc. I have the VB code wrapping the statement and it works fine but I have to put the results to a doc so the user can preview and/or print.
View 3 Replies
Jul 22, 2010
I know this sounds simple to the majority of the database gurus out there but I am finding it difficult to find anything related.I am using Visual Studio 2008 VB.net winforms application.I have a form which contains a datagridview. what I want to do by push of a button is set the field "OnHand" either to default or 0. The 'either or' is really for you guys. Which ever one works the best in terms of reducing code or functionality is obviouls prefered.Once the 'OnHand' Fields in every record has changed then I would like to save all the data back to the database'This is more than likely very simple I just cannot find anything that discusses this kind of thing.
View 1 Replies
Aug 5, 2009
I've tried different approaches to query a simple xml and compare one of it's values but none of them worked well.
Consider the following XML structure:
<?xml version="1.0" encoding="iso-8859-1" ?>
- <Shops>
- <Shop>
<text>Northampton</text>
<value>NN</value>
<currentdate>050809</currentdate>
<labelcounter>1</labelcounter>
[Code] .....
I have the shop name in a drop down list which is ShopsDDL and it's set to autopostback. What I want to achieve is:
On postback, check for a xml node where node's text = shopDDL shopname
And retrieve also this node's currentdate and label counter.
Rhen, if the node currentday = today then increment labelcounter by 1
Else set labelcounter = 1 and currentday= today
My problem is the XML query, I can do all the logic as soon as I manage to retrieve data from the XML.
View 1 Replies
May 8, 2010
I am developing an application that takes user input into text boxes or list boxes or check boxes. I have 4 forms with questions of different categories. I want to form a paragraph string with some literal string text and add in the text from text boxes, selected item from list boxes and, either, add literal text string or add nothing to the string based on check box condition.dim strScopeParagraph as string
View 10 Replies
Jan 8, 2011
I'm having troubles while building a bar chart with graphics. What happens is that I create the bar chart correctly and it looks perfect, but when I click outside the picturebox or just change the window, the bar chart disappear completely, leaving the picturebox empty.
View 10 Replies
Aug 11, 2010
What actually is required to consider something installed on a machine. What happens in the background? I know VB offers an installer but Im trying to build my own from scratch. What do I need to do to accomplish this?
View 13 Replies
Jan 17, 2010
I'm building a form with just a combo box in it that contains a list of other forms that I made. I want to program the combo box so that if a user opens it and clicks on "Web Browser", that form with the combo box will close and the web browser that I made will open. Another example is that if a user selects "Media Player" from that combo box, the form with the combo box will close and the media player that I made will open. How would I program the combo box to do this?
View 3 Replies
Apr 20, 2010
I wanted to create a simple application which has 2 forms.the first one contains a combobox which has the list of names of reports.now i select this report and click on next which takes me to the 2nd form.there i have to enter 4 values(or parameters)like the date from and date to and other 2 values...using these 5 values i want to retrieve the respective reports from the archive folder based on these parameters...i just know how to select and move to the second form from the first..how do i achieve my goal of retrieving the pdf files.i want the result in a table form which will have column names of the parameters i pass and the last column with the report pdfs.
View 6 Replies
Jun 16, 2011
I am new in programming, I am trying to develop a simple calculator but I am unable to connect the addition, subtraction and equal sign buttons.[code]
View 1 Replies
May 14, 2009
Recently, someone asked me to code a program for them in Visual Stuido. What they need is a program that allows them to enter names, and each name has to pick a option (i was thinking that the user would select a radio button) and each option could only be selected a limited number of times.
View 8 Replies
Apr 6, 2010
I have absolutely zero coding experience and my background is non-IT. I'm however trying toy friend who also shares the same non-coding skillset as mine her automate some of her work but building a simple form that takes a bunch of input (drop down, check boxes, radio buttons, rich text boxes etc) and outputs it to the a word or rtf file. Is this possible?
View 14 Replies
Jun 25, 2009
I'm new to VB.NET, and have set myself a little challege to learn VB.NET, I was wondering if you you guys new any really good tutorials on how to create a effective MDI Text Editor?, Ive been able to create a simple text editor, however the next step is to use the MDI to be able to have mulitple windows within one form
View 5 Replies
Mar 6, 2011
I should start a project where several clients are included. There is a wcf web service controler that after a call from an specific client about a certain question it will retrive data from a server in London and then it will pass it back to the corresponding client in a different country e.g.
Clients and service are far away. the only way of transportation is through HTTP and intenet connection. Service should be able to callback also so i guess it will be dualHttpBinding.
View 2 Replies
Nov 18, 2011
I'm setting up a simple app that has 2 variables, one from a combobox and one from a textbox.Putting all my code directly in the button1_click sub works just fine, however, I wanted to add a marquee progress bar so I tried to implement a backgroundworker.
[code]...
and call it with Me.Invoke(New SetComboBoxTextDelegate(AddressOf SetComboBoxText), ComboBox1.Text)but it still throws the Cross-thread operation invalid error.
View 10 Replies
Mar 27, 2012
I am currently debugging throught a lengthy piece of code that behaves differently if the batch loaded is created from one way or another. I have tried going through it and it seems each step is the same, so my question is, Is there a tool that will record each line of code that is hit while debugging? so instead of writing everything down and risk missing something i could just run the program use beyond compare to compare the results of both runs.
View 1 Replies
Feb 17, 2009
I have created a table with the following fields
loan_id (PK)
loan_date
loan_return_date
loan_user (FK)
i have set the loan_id column to increment in steps of 1, but when i add a column in visual studio 2008 express it auto increments in minus steps -1 -2 -3. it increments in positive numbers?
View 5 Replies
Jul 15, 2009
I have just downloaded VB Express 2008 with the intention of teaching myself how to use it from scratch. Previous programming experience limited to Lotus / Quattro Pro old style macros. Preference would be to work through a good hard copy DIY manual starting from the basics.
View 18 Replies
Feb 13, 2010
What is the code for making steps in dgv? For example I have a button, every time that I press the button I want to make a step in dgv row
View 2 Replies
Mar 25, 2011
I am ready to deploy my vb.net project to my client computer.In my development computer I have crystal report 9, sql server express and .net frame work 3.5 installed.My Client computer hasn't got anything installed there.I am trying to making msi installer so that it will be easy for my client to install.I created the new solutions -> setup type project, added the project on it and build it.it successfully created the msi installer but it doesn't installs the sql server express and crystal report.How do i make the installer with crystal report and sql server and also with db
View 1 Replies
Dec 5, 2011
i am creating a ticket ordering system, there is 5 - 10 step for public user to choose what they want. These steps is dynamic, can some one advice me what is the best way to store data during steps, so that i can have a back button to return to previous step or retrieve data from step when compiler at last?
View 1 Replies
Sep 21, 2008
What I mean is that when I make queries on a Parent Form. Child forms can also retrieves the datatable /datarows from its parent form.
View 3 Replies
Mar 19, 2011
I would like to know what are the basic steps involved in setting up your application to able to read data from another application. Then take that data and modify it and send it back to the application. The data being read will have over 100 fields.... what is the most efficent way to store them? Put them in a class object?
View 1 Replies
