Create An Application That Queries Customer Name?
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
ADVERTISEMENT
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
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
Apr 11, 2012
I am new to working with SQL databases (and databases in general) so I do not have a lot of experience with how queries work and how I can practice them. When I was first learning xml and XPath, I found XPath Visualizer incredibly helpful after someone on stack overflow mentioned it to me.Due to this, I am wondering if a similar tool exists for SQL databases?Basically a tool that will allow me to connect to a database,enter queries and see somehow what the results would be like.
I have looked online a bit, however I have found relatively few options in terms of any utility that would do what I want, and that looks reliable.I will ultimately be writing an application to interact with an SQL 2008 server in vb.net, however for now I am just experimenting so I will know what I am doing when I actually want to create my application.So far I have managed to connect to the database using an OLE DB connection, but I am now looking for a way to experiement with queries without just querying and figuring out a way to interpret the results in my program. Basically I want to be able to remove the programming aspect of things so I can experiment with queries without needing to question anything in my code that is unrelated to the specific query.
View 7 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
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
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
Nov 15, 2009
I have an application that connected to a database (SQL Server 2000) .Is there any way to send an information and Report made by Crystal reports by mail so customers can check it from his email?
View 4 Replies
Dec 4, 2009
Using parameterized queries with ms access 2003 integration. To search any data according to different criteria.
View 2 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 1, 2011
i have completed my application successfully and now i want to deploy it on the Customer End.How i can have to do this i have to install SQL Server 2005 on the Customers End and then have to create all the Tables and Views and Stored Procedures that SQL Server once again or is there anything else ???
if it is then its a big task coz i have about 12 tables and how i can get all the data stored in my Computer already of the Customer during testing...
View 7 Replies
Apr 7, 2011
I have a ClickOnce application that about 120 customers are using. This week, I found out two customers declined an update in January and were stuck on an old version. I discovered this by deleting an ASP script the old versions used on our server. The customers that aren't updating get a 404 and call to ask why.One customer clicked our install button again and got the latest version no problem. The other clicked our install button and gets an "Application validation did not succeed" error. The details of the error are SomeImage.gif "has a different computed hash than specified in manifest."I don't want to deploy a new version because that usually results in phone calls asking, "did you add what I asked for yet?"
I figure I should be able to uninstall the app completely and resintall with the one problem user. Nope. Error persists. How can I remove whatever the Windows uninstall process leaves behind that would cause this error to persist? I found the folder C:UsersUserAppDataLocalApps2.0 on the customer's Vista computer, and deleted it. We ran the installer again, and the error persisted after redownloading the app. I'm not 100% confident that this folder contained the whole program, though, but it is the only location on disk I could find that contained some resemblance of our app.
View 5 Replies
Jan 6, 2010
I am writing a message system on my server, the xml is something like this
<xml>
<entry>
<sender>[code]....
my problem now i guess is 2 fold, i wish to combine the first 3 queries into a single query and place in a list or a collection or is there a way to do this with a single query that will give me my desired result?
View 1 Replies
Jun 5, 2012
We created a VB.Net application which includes SSRS reports that runs on my development computer. Do you know of a step by step guide that steps us through deploying the reports on our customer's computer? We will be installing SQL Server 2012 Express Advanced on the target computer then configuring the reporting services then installing the application. The last part we need help with is to install the reports themselves on the target computer.
View 1 Replies
Jun 1, 2011
i have completed my application successfully and now i want to deploy it on the Customer End...How i can have to do this ??i have to install SQL Server 2005 on the Customers End and then have to create all the Tables and Views and Stored Procedures that SQL Server once again or is there anything else ???if it is then its a big task coz i have about 12 tables and how i can get all the data stored in my Computer already of the Customer during testing... ?
View 4 Replies
Jan 6, 2012
I have an application that works together with a SQL database. This database has more than 40 tables and my applican has to extract different situations from those tables.
I have predefined some queries for the situations that I know they need to be in the application.
The idea is that I need kind of a module in which an user can create his own situation based on the tables, views, functions and procedures that already exist in the database. Something like it is in SQL. There has to be a library or something which will read my sql database directly from my application and which allow the user to create his own queries and situations.
View 8 Replies
Dec 27, 2010
I have a problem related, not only to VB.net, but also Oracle.I have a simple application that runs queries from an Oracle db (Oracle 9i) and creates reports from it. I am using the official oracle.dataAccess component.I need a very simple report that returns a list of usernames. Something like "SELECT userName FROM users".(userName field is a VARCHAR2).Problem with this query:The top 50 rows are OK.All the remaining are strange characters.
[Code]...
View 4 Replies
Nov 17, 2010
I'm building an application that will be using several (7) SQL queries, I'm wondering whats the best way to approach this since I've never built an app with this many queries in it. These queries really won't change, just the start date and end date and I have query in my first form that finds out the next available date by checking a table. What I'm wondering is if it would be better to construct these queries in my application or if it would be better to use stored procedures on my sql server to do the same thing and not have the application carry the load of the queries.
View 1 Replies
Jan 8, 2011
I have developed a small ms-access based software with vb.net.
I've added auto-update capabilities to the software (mostly by using clickonce) to simplify the release of new features.
Every version of the software executes the update routine which may update also the existing database.Lately i've made few changes on the database structure adding few stored queries, so i want the autoupdate code to programmatically add these new queries to the existing database and make it perfectly up to date.
I haven't already found a solution to add stored queries to an ms-access database using odbc...I also tried to use the "CREATE PROC" sql statement but it does not seem to work with access databases, even if i create the query form the Microsoft Office Access front-end.I've found some examples that uses ADODB, but i'm using odbc to remain both x86 and x64 compliant.
View 2 Replies
Aug 6, 2009
I'm developing an application with Visual Studio 2008 (with visual basic), first of all, I'll give a brief of what I'm planning this module will do.
It's an accounting application, that I use to administrate some of my company's movemets. The application links directly with MS SQL server 2005, and sends queries to the database like: client name, employee Id, transacion type etc. Right now I'm developing a contracts module, wich is intended to be used with Microsoft Word 2007. We want the module to do the following: (It's a contract document; the document should get the variables from the application like contract type [that would change the template of contract used in microsoft word depending on the type], Client name, Salesman name, today's date, name of the company's representative)
1) After the data has been captured from the application (the application has a capture module that sends the info to the database), instantly send the capturer to microsoft Word, to a layout that has variable fields that should fill themselves with the database information ( I don't have a clue on how to do that )
2) The capturer should be able to change text in the contract layout and fix the variables info in case they were misstyped, adn when he/she saves the document; if there were any variables edited, they should get updated in the database; and the application should be saved with a name that has variables on its name ( 1)today's date in DDMMYY format, 2)First 2 letters of the client's name, 3)last 3 digits from tye contract number), save the file in a directory where all contracts are in .docx format (could use any frmat, it actually doesn't matters), and send the file location to the databse; to a table field named "file" wich only has the file's route.
3)From my application, when consulting the data, give the app access to the file directly; simply by getting the query form the database.
View 1 Replies
May 4, 2011
I am having some difficulty with an xPath expression. I am using an XML document to store queries / stored procedure names in an ASP application. I use a utility function to load the xmldocument (if it isn't previously loaded) and I am attempting to select the node set from the document that matches an Id element. [code] the node variable only returns the first element. I have verified the that the qry string that is used to SelectSingleNode IS the correct Id value (i.e. USER002) - however the node is getting loaded with the USER001 element. It is obviously the xPath expression that is messed up. What do I need to tweak on the xPath expression so that I can return the correct <Id> element and corresponding child <Sql> element.
View 2 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
Feb 26, 2010
How can I create a VB application in VS2008 without requiring the application be run on a computer with a .NET framework in place?
View 4 Replies
May 27, 2009
how to create a uninstall command for a Windows-based application in the Application Folder when creating a new setup project in visual studio 2008.
View 4 Replies
Dec 17, 2009
I understand this is possible but I am not sure where to start. I want to either buy or create an application that captures a resource from another application so that I can fire off another application. In other words, I want to start an application (which I did not write) that is database driven so the form has a number of text boxes. When someone keys something into that field I want to be able to validate the value, outside of the original application. For instance, if the program asks for a zipcode and it doesn't validate the zipcode, I'd like to trap for that and write something that would validate it. At this point I don't think I'd have to send anything back to the textbox/resource.
View 1 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
