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]...
I'm selecting a customer from a listbox of surnames...I need to address to display, and the date arrived back...Can't get anything to go into the textboxes, if dr.hasrows is showing up as none I think... not sure how to go about remedey"ing" it though...
Listbox
Private Sub ListBox1_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ListBox1.SelectedIndexChanged
Dim ConnectionString As String
[code]....
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.
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 Repliesi have 2 textbox for name and password and a buttonthere 2 table, one admin and one customerafter i enter the customer name and password , it verify whether empty or incorrect password , if correct it will go to the customer pagehowever if i enter admin name and password and after verify it should go to the admin pagei am only able to allow use one table for the login ? so how should i change the code below?
Protected Sub btnLogin_Click(sender As Object, e As EventArgs) Handles btnLogin.Click
If String.IsNullOrEmpty(txtName.Text) Or String.IsNullOrEmpty(txtPassword.Text) Then
Failure.Text = "Invalid User Name and Password. Try Again."
[code]....
How do I print out the message, "The customer has no reservation", when the computer cannot find the customerid table.
Private Sub cboSearchCustomer_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cboSearchCustomer.SelectedIndexChanged
Dim dt2 As New DataTable
Dim strFmt As String = "{0,13}{1,13}{2,13}{3,10}{4,13}"
[CODE]...
This is how it should look like when completed. What type of steps should I take to get here?
I created a RDCL in the designer. I would like the User to Determine what is shown in the Report. How can I change the query at runtime? (ex. changing the customer Name)
This is the query that I have in the properties:
SELECT [Date], Address, Customer, Orders
FROM Report_qry
WHERE (Customer= 'JohnDoe')
[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.
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]...
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?
So, I want to implement my own binary serialization. I'm looking for some examples to head me in the right direction.
View 2 RepliesI 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 Repliesi created a sales form and it is using currency also the project is working greatthe thing is when the form loads everything works great shows the decimal and dollar sign's for the first customer but when i click on the navigator for the next customer there is no decimal and dollar sign's how can i inherit the same controls to the next customer.
View 9 RepliesI'm currently in the middle of attempting to create a query that will be used so that the application user will be able to search the a customers id number. I'm completely new to adding queries using the query builder so I've become slightly stuck on trying to get this to work corrently.
I have a database which is set up and in this case the table is called 'cid' which defines the customers id column in the database, this is a primary key and the column has a data type 'AutoNumber'. I've become stuck as I'm not sure what I would have to put into the filter to make this query work.
how to view report particular Customer Name. in this code when i m type from date or To date report is showing all customer information but i need single customer info with name or Date this is my code.
[Code]...
[code]... i want to add CUSTOMER NAME in this code how to view each customer datewise
View 2 RepliesI'm trying to add 3 customers to an array that I can then display in 4 seperate text boxes on my form. First Name, Last Name, Account Number and Balance.
Public Class Customer
Private firstName As String
Private lastName As String
Private accountNo As Integer
[code]....
Error 2 Argument not specified for parameter 'account' of 'Public Sub New(first As String, last As String, account As Integer, balance As Decimal)'.
I have to calculate the maximum mortgage possible for a customer. If it is a single application, the customer can borrow up to three times their salary plus any savings and investments they may have.
If it is a joint application, the customer can borrow 3 times larger salary and 2 times the smallest, also borrowing against any savings and investments. In either case, the applicant is not allowed to borrow in excess of 90% of the purchase value of the property (including stamp duty and legal fees).
I have declared everything and done out the code, yet every time I calculate the max amount they can borrow, it comes up as 0. My code is below if anyone can spot problems.Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) _
[Code]...
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 RepliesI 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]...
I have an application that uses resource files (.resx) to switch the application between languages.These resource files are compiled at development time to create the dll'sHowever, there are many times when an application gets deployed onsite, and there are spelling mistakes, or general mistakes in the translated text.
View 1 RepliesIn 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.
I am able to loop through all the customers in db but unable to fetch the address of customer to disply to the using using vb .net?
View 2 RepliesI've done a customer register in a win form app. and I need to be able to search for a customer fast. If I have more than 100 customers I'd be spending all day to find the right customer by using the previous and next buttons, so I want to have a textbox and a search button. If I write for example just an "A", I want my program to show all customers beginning with an "A". If I write "AN" I want my program to show all customers beginning with "AN".
View 6 RepliesPrivate Sub lvList_DoubleClick(ByVal sender As Object, ByVal e As System.EventArgs) Handles lvList.DoubleClick
'Select Customer ID from lvList
frmEdit.txtCustomerId.text = lvList.Select("Customer ID").value
End Sub
my code for selecting the customer id from my listbox doesn't work..
i m doing a project using vb .net visual studio2005 . i need to develop a online chat application on my website for customer care supports. where i should start and which technology i should use for this web based application..
View 1 RepliesI m developing jewelry management software and i want to put SMS facility in my software for sending sms to customer
View 5 Repliesperviously i use ms access (.accdb) as my database, my sql connection is Dim connstr As String = "Provider=Microsoft.ACE.OLEDB.12.0;" & "Data Source = LibraryDatabase.accdb" now i have add a new customer.mdf with tables in my project, but what is the script for sql connection for (.mdf)?
View 1 RepliesI am making a booking system application for a sports club....In my sqlserver database I have two tables one is named as Memberships and the other is named as Bookings...Now what i want is to allow a new booking for only those customers who have a membership...In database i have joined both tables by cust_id attribute where Memberships table is parent and Bookings table is child....I want that when a new booking is tried then it should first check if the customer id is present in database or not..If it is present then the booking should be allow otherwise not...but my code either shows error first and then allows the booking Here is my code for this:
Dim i As Integer
Dim str2 As String ' defines string variable for taking select query
str2 = "select Memberships.cust_id, booking_date, booking_time, booking_duration, game, poolno, courtno, tableno from Bookings, Memberships where Memberships.cust_id = Bookings.cust_id"
[code]....
i have made a database using vb.net 2005 and SQL Server 2005, its completed now. how do i give to the customer in a full form, I mean as a professional software?
View 6 Replies
