Create A Customer Data Form
Nov 20, 2011
I working on a program that I am trying to create a customer data form.Along with the form I have their vehicles related to that record.Now I have setup a dataset in the form.I am pulling data from the database, however when I enter a new record on the customer part the customerID is in the running order, everything seems to be working on in this table.But when I create a vehicle for this customer I have a running vehicle id.Example: I have in the database 4 customers.IDs 1,2,3,4 customer 1 has vehicle ID1,2.customer 5 has a car there 1st car but the database gives is a ID of 3.I want this customer to ID 1 for car one.My problem might be because it was set in the database as Unique Identifier.Maybe I should make the license plate the unique identifier.
View 4 Replies
ADVERTISEMENT
Mar 15, 2012
I have a customer and booking data sets on my form. customer id is a foreign key in booking table .but when i click delete button. it gives me an error: The DELETE statement conflicted with the REFERENCE constraint "FK_Booking_Customer". The conflict occurred in database "photoshoot", table "dbo.Booking", column 'Cust_id'. The statement has been terminated. Its a one to many relation between customer and booking. one customer can make many bookings each booking will belong to only 1 customer.
View 1 Replies
Oct 4, 2011
I have the following problem: I select a customer from a dropdownlist and then the gridview should load all items of all orders of that customer. I have the following query:
Dim allorders = From ord In db.Orders
Where ord.CustomerID = Convert.ToInt32(CustomerDropDownList.SelectedValue)
[CODE]..............
I also tried to modify the query as follows:
Dim orderitems = From oi In db.OrderItems
Where oi.OrderNumber = (From From ord In db.Orders
[CODE]...........
But this does not work. I just started using LINQ.
View 5 Replies
Oct 5, 2011
A registeration sys using a Microsoft acres database I have a table named customer info to store customer details when registering and I need coding that will add the following to my table customer I'd , firstname, lastname , phonenumber and user also has to make selection between radio buttons male or female.
View 2 Replies
Jan 5, 2010
I am trying to autocomplete customer surnames direct from the Customer Datatable, using the code below which I got from another thread, but nothing is happening.
[Code]...
View 6 Replies
Jan 23, 2011
I am sure some of you have seen this project before. I need to create an application that queries customer name (first and last) and there addresses. I need more than that but once I figure what i am doing wrong with that, I should be able to figure out the rest on my own. I am using VS 2010. I can not figure out the proper syntax for String.Format. I can only get it to display the first and last names of the customers.This is the code I have so far:Public Class Form1
[Code]...
View 2 Replies
May 31, 2010
I am attempting to create a program which saves customer information for a business e.g first name, last name, address etc. but i am having trouble coding the save , new, print, next/previous record buttons.
Would someone be able to link me to a tutorial which explains how to do these?
View 3 Replies
Jan 19, 2012
I need to create an application for a kiosk where a customer could select pictures from a camera, select and edit the pictures, then submit them for order. Are there any really strong image editor controls I could use or you can recommend?
View 10 Replies
Nov 2, 2009
In my sales order i use one combo that is CUSTOMER, actually it display all the data of CUSTOMER database.
at run time in SALES ORDER i saw that the CUSTOMERis not available in that combo then i want to add new customer there which save in my CUSTOMER data base WITH OUT LOSSING WHT EVER I INSERT IN SALES ORDER.
View 1 Replies
Oct 30, 2011
For some reason my code is not adding customer to the session. I am new to ASP.NET does anyone have any input as to why this is happening and maybe able to give some code example.
Below it the code.
Imports System.Data
Partial Class _Default
Inherits System.Web.UI.Page
[Code]....
View 1 Replies
Jan 26, 2011
I've done some research into this using the MSD website; I have found that my applicaiton saves the Customer Details to the Customer File, but only as (spaces). No data is present in the file.
I'm creating an application that saves Customer data to a file. Once the Data is saved into the file, how would i then get it from the file into a ListView?
[Code]...
View 3 Replies
Jun 10, 2011
This is the error when i try to execute my code "Procedure or function 'Get Customer data' expects parameter '@Name', which was not supplied."
objCommand.CommandType = CommandType.StoredProcedure
objCommand.CommandText = "GetCustomerData"
Dim ObjParam1 As New SqlParameter("@Name", SqlDbType.VarChar, 2000)
[Code].....
In debugging, i c the value in ObjParam1.value that I'm passing.
View 2 Replies
Oct 22, 2010
I have used VB (versions 2 - 6) through many years; however, I am crash-course training myself into the VB2008 / VB2010 world kicking a screaming. I would like suggestions as to what SQL database access method should I focus more on in my learning process without making me feel that I'm a million years behind. I know I have WinForms where I can create a datasourse and drag / drop fields or tables on a form to create a grid (not really what I'm looking for).
My trouble isn't so much designing the form but in how I access the database. Theres XML, LINQ to SQL, ADO.NET, and many other methods. Not only do I need to grasp these methods quickly but I also need to know what type of projects I should create. What I mean is...I was thinking that I would design a WinForm app; however, I see that there are WPF apps and others to chose from. This is getting deep. I know it depends on the project that I'm working on. My plans are to write an app based off of either an SQL Express 2008 or SQL Server 2008 database. This first app will be standalone for now but may later become multi-user. I know I'm far behind on my learning curve coming from VB6. I have read a bit on VB2005 / 2008 / 2010. I own
both VB2008 and VB2010. I use VB2008 at work. I know ADO.NET is still alive but by what I read online, it's a dying method and is only kept for backward compatibility. XML and LINQ to SQL and other methods are all pretty new to me.
View 1 Replies
Oct 13, 2010
Currently we are using a VB script macro created in word to create some fairly simple forms based off of data entered on a data entry form. I am very new to VB, and I have been able to create many applications using forms, but I have absolutely no history creating reports. I have been reading up on the reports, and it looks like they are designed to use with data sources like tables. I merely want to take either data from the entry form, or from data derived internaly from processing the user entered data and populate a defined report "form". I have been searching, but there is so much on printing reports, that I feel overwhelmed. I am not looking for the exact answer as much as a link or place to look for a sample for what I want to do.
View 2 Replies
Sep 16, 2009
To create a data access form
View 3 Replies
Jul 2, 2010
Using this tutorial How Do I: Create a One-to-Many Data Entry Form? as a reference Suppose I have a parameter query called FillByStatus in my "Customer" DataTable and I want to fill the CustomerTableAdapter On Form_Load using this query. So I can do that by using the following
Private Sub Form2_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) _
Handles MyBase.Load
Me.OrdersTableAdapter.Fill(Me.CustomerOrdersDataSet.Orders)
Me.CustomerTableAdapter.FillByStatus(Me.CustomerOrdersDataSet.Customer, "Active")
End Sub However, when I do that my related DataGridView (orders) is empty, how do I make it so that doesn't happen?
View 1 Replies
Mar 10, 2009
I am designing a form that will create a template of data that will later be loaded into another form.From a menu command "Create New Template" I will need to ask how many Fields will be needed for the new template in an input box. If the user would input say 10, then I need to generate 10 labels, 10 text boxes, & 10 combo boxes. Each group (label, Text Box & Combo Box) on its own row on the form.I also want create the data mapping for each of them at this time.Once I have achieved this then I will add a form that will lookup the template name, and row count given from the above form via the database and load the required rows of items for further data entry.
Since I will have a MAX row limit I thought about designing a form using a Table Layout panel with 25 Rows and 5 columns then doing some sort of .visible true/false for the layout panel row after the user input of row/field quantities.Another question is resizing the form around only the visible rows.
View 4 Replies
Nov 17, 2009
for example if we have add a product to that data grid and then we have add another product, i want that another product places at under the 1st product in that data grid and if we add the same product then just the quantity have increase.. TQ so much.. and the field in that top column data grid is..
NoProduct NameProduct Quantity Price SubTotalPrice
View 2 Replies
Dec 8, 2010
For my project i want to i want to export form data to a new database so that i can send it by attaching it to email.
what i want that on click of a button
1) create .mdb file at c:est*.mdb, with the name = "textbox1.text"
2) create table, name = "demo" with column "id" and "job No"
and then i can use insert command to fill the data in the table and email it to client.
View 4 Replies
Mar 5, 2010
logic to build this kind of data entry form using grid controls in vb .net.
View 3 Replies
Oct 3, 2009
I want to create a local data store for a login form and but I dont want to use MS access or SQL so what should I use? I thought about using induivual files like config files except they get kinda dificult after a while so then I thought about using XML which may work but I have found no really useful tutorials on this, if someone has a good tutorial?[code...]
View 4 Replies
Feb 17, 2012
I have a bunch of Excel files full of research data. Everything is strait forward: rows of research categories and columns of research parameters. I want to create a simple search form that allows opening any of the spread sheets that contains the type of data that I specify. For example, I would choose a parameter
[Code]...
View 5 Replies
Nov 28, 2010
I want to create a class is it where I can do...
[code]...
How do I do this? Do i create a class and create a instance of CarData? but how do I add Color and Year etc to it?
View 3 Replies
Aug 4, 2010
Hello I want to create a windows form application program that can create games something like Gamemaker or Klik & Play (butt less advanced) with D&D "Drag and Drop" events and actions.
View 7 Replies
Apr 17, 2009
I have produced an application which works with datasets but I now wish to provide the user the ability to add and admend records within the database.But i wish to do this in a seperate form.My current dataset instanciates classes onLoad.Should i try passing the Dataset to the new form class? although I have the problem where by when i pass the dataset to the form class using code below i get this problem:[code]Should i just create a create a new connection to the database and produce a new dataset for this form? or is there a better way to do this?
View 2 Replies
Jun 2, 2011
[code]A customer can not exceed a debt load of 36% of their gross monthly income including house rent or a mortgage.[code]I basically know how to code this. I get the information from the user (income, rent, and other monthly payments) and then ask if they have good, ok, or bad credit (this will be the percentage part) and I know mostly what to do, but the hardest part is the actuall coding part, basically the calculations part, im always confused on what to do, my example shows basically what to do and I know how to get the users info, but how to program the calculations, is where im also stuck at My example is (the money for the income, rent, and other monthly payments the user entered already)
1. If there monthly Income is:$2,000.00
2. Monthly Home Rent/Mortgage:$500.00
3. Other Monthly Payments (alimony, child support, student loans):$100.00
4. Then there allowable Monthly Car Payment:( 36% of 2,000 (income) = 720)( now I subtract debts 720 - 500 (rent) - 100 (other) = 120) :$120.00
5. Display Maximum Car Value (interest rate based on credit):Present Value Function (16% per year (this is where I check one of the boxes for the credit, which in this case its an ok credit), 6 years (I have to keep it at 6 years), 120 (this is the allowable monthly car payment) per month)So basically PV((0.16 / 12), (6 * 12), 120) : $5532.03.
View 5 Replies
Jun 4, 2011
im using a datagridview, and it is connected to ms access. every time i have an input same in the column where primary key is I already got an error. can you guys how to show a messagebox if the Customer Contact number is already in use? here is my code.
[Code]...
View 1 Replies
Jun 28, 2009
It's a basic Access 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've managed to get the orders page to work, this leads to the order confirmation page which displays the details the customer just placed.Here is what I have in the order confirmation page load event so far. Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs)
[code]...
This returns this error "Syntax error in FROM clause." I'm guessing my SQL code is wrong. I noticed when I placed the order in the order page it added an entry in the Access database where the generated CustomerID was 12 on the customers table and 4 in the orders table. Shouldn't these numbers be the same when they are generated?
View 2 Replies
Apr 14, 2011
So, I want to implement my own binary serialization. I'm looking for some examples to head me in the right direction.
View 2 Replies
May 4, 2012
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've managed to get the orders page to work, this leads to the order confirmation page which displays the details the customer just placed.[code]This returns this error "Syntax error in FROM clause." I'm guessing my SQL code is wrong.I noticed when I placed the order in the order page it added an entry in the Access database where the generated CustomerID was 12 on the customers table and 4 in the orders table.
View 2 Replies
