But that same .exe blows up with this when I run it on their server
See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.
************** Exception Text **************
[code].....
I 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 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 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 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 currently. 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.
View 7 RepliesI'm trying to figure out how to create a custom power plan in code. I've searched high and low and have come up with very little so far.
The first thing I ran into was WMI. After looking up some information, it seems that all of the WMI Power features are ReadOnly.
Then I looked into the registry. This might be a feasible option, but it's hard to say. It seems each Power Plan has a unique GUID associated with it. This isn't a huge issue, since I can create one like so:
VB.NET
Dim _GUID As Guid = Guid.NewGuid
With this method, the issue now lies in the subkeys. Each Power Plan looks like it also has a unique ID for each option in the power plan.
There are two issues with this. First, even though subkeys are the same for each powerplan on my PC, I'm not able to test others at this time. So I can't know for sure that they are the same. Secondly, I have no way of knowing which subkeys relate to which power options.
My only two other options would be an API or .NET methods.
That being said, does anyone know of any way to create a power plan or some info on it?
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 to use a northwind database to display customer and order information. Populate a combo box with the CompanyName sorted in alphabetic order. Display the customer information in bound labels and the order information in a grid. For customers, display id,name,title,phone. For orders display the order id order date required date and shipped date. how to connect the access database file to vb.
View 3 RepliesI have updated a VB 2008 Winform program and published it on a shared folder. The customer can no longer use it because, at launch time, it claimed for SQLServer.Diagnostic.STrace v 10.0.0.0, what it did not before. The only thing I can think at is that I have also recently installed VS 2010 on my PC. Does it change the way VS 2008 work ? How can I solve this issue on the customer PC ?
View 2 Repliesi'm tying to send email in my application directly by the smtp server but the server doesn't allow me to do that.The application its used by everyone in the company, so i set the smtp client UseDefaultCredentials to True, but the server replies with this when i try to send an email:[code].....If i set the credentials by hand, the server sends the email. So my problem is how to make this work to everyone? I don't want to have one public/friend var all time in the application with the credentials of the current user?
View 9 RepliesMulti-User Chat Program (Server & Client) with Main Server?
View 1 RepliesCase : I'm creating an application (desktop application) with VB.NET (actually windows form), and using SQL Server Express 2008 for its database.
[Code]...
I have developed a VB.NET program using a strongly typed dataset. This dataset has its connection to a SQL Server 2008 R2. The software should now be additionally used offline. The database should be exported to a *.sdf database. If no connection to the SQL server is produced, the software have to try to connect to the *.sdf database.I would like to achieve:
1. Export the data in the SQL Server 2008 R2 database to a local *.sdf file.
2. This *.sdf file has to work as an alternate connection string in the strongly typed dataset.
I have simple code that connects to Sql database... (well it doesn't)
VB
Dim objConn As New SqlConnection("Server=localhost;uid=***;pwd=***;database=***")
objConn.Open()
ERROR MESSAGE:A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)But looks like something is wrong with "localhost" thing. Any help? Where can I get name of (my) server?
We are currently using Access 97 as our database. This resides on the remote farm server (which is a Windows 2008 R2 server). We are using a front end vb6 exe which accesses the back end data.Occasionally we are getting corruption to our database and we have to make sure everyone exits the software to allow us to repair/compact it. There are 2 physical servers, each running 2 virtual machines. When the user logs onto the farm using RDP, they go to one of these 4 virtual machines.We are getting all kinds of corruption, some where # characters have been inserted into the top of one table, some where the indexes are corrupted, and some where access needs to repair the database.
View 1 Replies[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 RepliesWe recently upgraded our job server to Windows Server 2008. We have jobs we run manually in a folder (c:Custom Programs). Some programs are console programs others are have a gui. This one program has a gui.It also has a progress bar that shows the progress of the job when you click the go button. Of course it spawns a thread to do the processing. This thread creates a log file to write errors and other things too.
The problem is when the program goes to create the log file an access not authorized error is thrown. I checked the permission on the folder. All users are allowed to create/edit/append/execute. Pretty much everything except take ownership. Also, there's nothing that denies anything. So I see no reason why this isn't working. We can get this to work by using the run as administrator option when we first run the program. However, we don't view this as unacceptable solution. My only thought is the spawned thread isn't getting the same permission set as the program. Am I correct or does something think it's something else.
[Code]...
I'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]...
