Here is the code:
con = connect()
con.Open()
'transaction begins here-------
trans = con.BeginTransa ction()
Try
'Data is inserted into mastertable---------
cmd = New SqlClient.SqlCo mmand("INSERT INTO mastertable(mbn o,mbdate,mbamou nt,mbcperson) VALUES(" & counter_bill_no & ",'" & server_date & "'," & billvalue...
vsc33
Last Activity: Aug 4 '17, 08:44 AM
Joined: Feb 8 '08
Location:
-
Database not getting updated
My vb.net application runs on a sql server 2000 and it is about making bills in a fast running gift counter with 5 to 6 client and server is placed at a distance of 200 meters. The store sells maximum of 50-60 gifts. The user does all the transaction through clicks.
Two tables are involved for making a transaction. One is mastertable and detailtable.
In the mastertable my application is inserting the total of the bill,... -
How to bind two sql with commit in vb.net
My application runs on a network of 15 to 16 clients on a SQL Server 2000. Some of the modules perform transaction, i.e. they run more than one sql. I have tied the different sql statemels under the following procedure:
con.Open()
trans = con.BeginTransa ction()
Try
'First Sql
cmd = New SqlClient.SqlCo mmand("INSERT INTO table1(col1, cl2, col3, col4) "VALUES('"... -
Thanks Nathan for your reply.
Well we are validating the text box for integer.
And the mystery behind is that from that particular text box around 1000 entries are stored everyday in sql server over network. Out of these 1000 entries on an average only 5 to 7 entries are there where the data gets lost. And only for one particular field. Rest all the datas are stored correctly.Leave a comment:
-
not storing correct value in sql server from a vb.net application
Hello,
I have a vb.net application that runs on a server. There are five client PC's that are connected to the server and all the data is saved on the server from my vb.net application.
To add a record, two sql runs under Commit transaction. One runs an insert statement while the other updates a record.
However, I have noticed a error. The update statement has lot of other fields which are stored correctly,...
No activity results to display
Leave a comment: