I am trying to create a database application that will keep records of all cash transactions. how to print a cash receipt to give it to the customer?
View 2 Repliesi have a simple application which can create/update/delete/search records using Access database. If i add a record, save it, then close the application and run it again and search for that record, it appears. However, when i write some code to my application, nothing to do with the search function, and i run the application the record is not found. For example i added a button to clear the textfields, and when i ran the application the records i have added earlier were not found.
View 1 RepliesMy assignment this week is to create a simple cash register. The kicker here is that I have to have an input box pop up to accept the data. I know I need to use a Do Loop here, but I' not sure what the proper condition should be. Hitting cancel on the input box or inputting nothing ought to terminate the loop.
Private Sub btnCheckout_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnCheckout.Click
Static decPrice As Decimal
Static intCount As Integer
Static decSub As Decimal
[code]....
I am trying to create an application that records screenshots every 50 milliseconds... And It works below:
Private Sub Timer1_Tick(sender As System.Object, e As System.EventArgs) Handles Timer1.Tick
Dim b As Bitmap = New Bitmap(Screen.PrimaryScreen.Bounds.Width, Screen.PrimaryScreen.Bounds.Height)
[Code]....
But after 30 seconds I see an ArgumentException on the second line...
Does anyone have a solution or an alternate method of capturing the screen like this?
I am using vb.net and ms access for developing windows applications. I want to know how to take the backup of database for after each and every transactions.
View 2 RepliesI got a big problem in using crystal report in vb.net 2005. im creating a sales and inventory system for softdrinks dealer. so i need to create a receipt for every cash or credit transaction of a client. but i dont have any idea how to use crystal report. how can i make a receipt on crystal report in vb.net 2005.
View 4 RepliesI need to export data to a text file either in VB or SQL and it has to be formmatted like this. The data is in a SQL Databse[code]...
View 7 RepliesI have to create buttons at rum time based on database records and implement their events.
View 5 RepliesI can retrieve records from my Database fine, but I'm having trouble updating records. I am getting a syntax error on [code] I get this error when I change the Last Name (Row 0, Column 1). [code]
View 4 Replieshow to get records into oracle database delete from db & update the records i have successfully connected my vb 2008 win form with oracle 10g.
View 1 RepliesI am trying to create an application that needs to have a database. I would like to know which one you recommend using. I have programmed in php using mysql but I do not think that is feasible for a windows application. I want something that does not have to install something else with my application.
View 32 RepliesWhat i am looking is how to create a layer between the application and database? I need to create an xml files where the application will fetches the data and updates the data into local cache. Later from the xml files the data has to be transferred to database. Here the application need to work even when the application is in offline and database is not been connected.
View 3 RepliesEvery time when application start check for change in structure..
View 1 RepliesWith VB.net, I'm coding a simple application to get more used to the new .Net format.
I'd like to save all the information to a 'new' database file. how to create a database on the fly, once that is done i'll be able to connect to it no problem, but actually creating the file is proving difficult to work/find out.
Also, with vb.net and the newly created custom file, how can it be made to automatically open that information with the program?
Is there a method in installation to associate the file type with the new program? How can i check when the program loads if a database file has been 'double-clicked' (rather than just running from the .exe of the program) and proceed to load the data?
EDIT1 - Extra InfoThe windows application has many different fields and content etc, then i need to save that to a file that could later be loaded by 'double clicking'. I assumed the easiest way would be to create a mini-database for each unique file
I'm Using Visual Studio 2005 and Mysql Database to create a windows application. The datagrid displays all the records. Since I don't know how to directly update from datagrid, thats why I have used textboxes for the respective datagrid fields. A load button is provided which on clicking puts the data on the respective textboxes. The data can be edited in the textbox. Problem is that I can't save this edited or modified data back into dattabase.
[Code]...
I want to create a very simple (to begin with) database driven application. The company I work for have very kindly said they will host any SQL database I create, they have a remote server that we all connect to for files etc.
So I want to be able to create an SQL database that they can host and have my colleagues and I install the application local on our machines.
[Code]...
I am trying to create an application that adds the contents of a till to a database. (Does this on two forms into two different sets of db columns) and can pull that back up at a later stage. At the moment, I'm stuck at the first section?
BODda.Update(BODds, "Data")
Is where I get an SQL error stating:Syntax error in INSERT INTO statement.I have not been able to find a way to insert via SQL?
i've got a free mysql database online hosted by 000webhost, i'm just wondering if i could connect to the mysql database, and if so what would the connectionstring be like? when i connect using php its something like this: new mysqli("mysql13.000webhost.com", "user", "password", "database1"), how do i translate this into a vb connection string, i can't decide what to put as the data source [code]if there's no way to connect, is there anyway for me to create an application that can store and access database online?
View 7 RepliesI trying to create an application using vb 2010.This application handles booking of airline customers. i am using ms access 2007 where i have created a table that stores customer information and another that stores and updates seats available in different flying classes. Am trying to develop an interactive application in visual basic 2010 where customers can book. i want to add this data to the database in real time and communicate to customers the seats available,prices and so forth. In otherwards the application communicates with database and updates accordingly. Firstly how do i connect to my database? I tried ADO.net but seems better equiped to work with sql server which i have no idea how to use. Is there a tool that can make my interaction with the access seamless
View 1 RepliesWe would like to create a client-server architecture application that the server can control all client computers connected to it (e.g shutdown) and we would like to put a security login and a desktop lockeron the clients. The process of the system is that when the clients starts, the desktop is locked and ofcourse the user can't access the desktop unless he/she logged-in. And when the scheduled time (e.g 1 hour) is done, the client computers where automatically shutdown like the Time Logger Softwares
View 2 Repliescreate a database application, which integrates search and sort, with the use of notepad.
View 5 RepliesI am trying to create an application where it stores images as well as data.
View 3 RepliesI am using VB 2008 Express and have created an application that connects to a SQL database to populate a datagrid.The application is working properly on my computer but will not on others 'remote connection permissions' error.After some googleing I found that the express version is crippled to only work on local machines that use a database.If I purchase Visual Studio 2008 Standard Edition, import and rebuild my application, will my application be able to run properly on other PC's?
View 7 RepliesBasically, the code checks if the amount being entered is check. If it is check, insert the check value into chckval. If it is cash insert the cash value into cashval. So far, it is half working. It inserts the check into the check fieldname and inserts 0 into cash fieldname. What is not working is inserting cash into cash fieldname if the money is cash. It inserts the cash into cash fieldname as it should but it also inserts the same amount into check fieldname. This is not good. If it is cash and it is inserted into cash fieldname, I want check value to be 0.
Here is the latest code.
For x = 1 To 5 Step 1
dedval = Gridview1.FindControl("ded" & CStr(x))
chckval = Gridview1.FindControl("chck" & CStr(x))
chcknumval = Gridview1.FindControl("chcknum" & CStr(x))
checkboxval = Gridview1.FindControl("chckBox" & CStr(x))
[Code] .....
I think there is some issue with the
IF chckval.Text <> "" And Not checkboxval.Checked Then
statement
I still have troubles understanding what the deal is with the whole String.Format("{0:C}" thing. How would I implement it into this code and how exactly does it work?
Public Class Form1
Private Sub computedeposit(byval dblrate As Decimal, ByVal dblfutureval As double, ByVal intyears As integer, byref dbldeposit as double)
dblrate = dblrate / 100
dbldeposit = dblfutureval / ((1 + dblrate) ^ intyears)
[code].....
I have a USB cash drawer that acts as a com port (lets assume com2)
any ideas on how I can open it? there is not really any documentation with it.
Usually when I need to create a DB with excel files(in order to get records that I need), I used following
HTML
Excelconnection = New OleDbConnection("provider=Microsoft.Jet.OLEDB.4.0; data source=" + mypath + "; Extended Properties='Excel 8.0;HDR=Yes;IMEX=1'")
Excelconnection.Open()[code]....
where mypath contains path of excel files.Now I have a file with no extension where structure is: each record is separated by space and row are more than 65535.I saw that with csv file I can solve this issue but I don't know if OLEDB connection to csv file works fine.I don't want to create several sheets.
I have installed SQL Server 2005 Express and VB 2008 Express.
For testing, I created a database with 1 table with 4 columns. I used SQL Server to add 2 records. I then created a new project with 2 forms. On one form, I put a DataGridView control. On the other, I used bound text boxes. Both had a ToolStrip. I made changes to the data through the forms. Both forms seemed to work properly, except when I looked at the data again using SQL Server, the data had not changed. Opening the forms again, the data had reverted to the original data.
I am using the code created by controls, so it should work. When I use the Database Explorer in VB, it shows the table and the data and I can make changes to that data. So why is my code not committing the transactions?[code]...
I am trying to use SqlTransaction object in my vb code for an application to insert vendor info.The code runs till inserting a transaction and then gives following exception:
"Execute requires the command to have a transaction object when the connection assigned to the command is in a pending local transaction. The Transaction property of the command has not been initialized."
[code]...
I am still working on a POS application in VB.Net 2003. What I need to do is check the state of the cash drawer. I want to make sure the drawer is closed before a cashier is allowed to move on to the next sale. The cash drawer I am using is a MMF ECD200 (not sure if this will make a difference). Here is the code I am using to open the drawer:
[Code]...