below is my code, i want to get a record base on a specif invoice number?
Imports System.Data.Sql
Imports System.Data.SqlClient
Public Class Invoice
Private Sub Invoice_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
[code]....
how do i make the invoice number increase as i make each new invoice. i want to save each invoice then as i make the next one i want the number to increase,then be able to save that one and so on...
View 1 RepliesI am searching for a best practice for Incremental Line Number generation i.e in an Invoice application. I am using VS2005, Sql2005 as a development environment. I need to create autoincremental line numbers for an invoice. I dont want to solve it in Database.
[Code]...
The issue is how do I best capture the invoice number of an tiff image?
I have a VB application in visual studio 2005 that scans invoices, creates .tiff's utilizing a standard image scanner.
I've tried the following...I thought I could save the image to text in an array and find the 6 digit number. Then, I tried to save the image to xml trying the same principal but I get a general error A generic error occurred in GDI+.
I need to know how to use a function to do the following: Create an invoice number using the last two letters of the last name and the first four digits of the zip code.
Example:
Name: John Doe
Zip: 11111
Invoice number becomes DO1111
I have a simple question that most could probably answer. I have a button that when it is clicked it transfers information from that form to a microsoft word doc. Now what I want to do is everytime that button is clicked it creates a number that is displayed on the word doc. So this is how it would go:
first click- it would show a number 1 on the invoice.
second click- it would show a number 2 on the invoice.
This would continue as long as the program is used.
have been trying to display on my data grip view but is not. i want a situation where by it will display on the datagrip view base on the invoice number, below are the code
Private Sub getLastID()
Dim oleDBDR As SqlDataReader
Dim oleDBCommand As New SqlCommand
[Code]....
I am trying to add a new record everytime i do my navigation gets all messed up I also need an update button... I would like so when i hit new record the record of will be(ex. If Im adding record number 30 it will say record 30 of 30, hit add new it will say record 31 of 31) my code is below.
'Class File
Module Class1
Public MasterConnection As New OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=db1.mdb;Persist Security Info=False;")
[code].....
"Create a class called Invoice that a hardware store might use to represent an invoice for an item sold at the store. An Invoice should include four pieces of information as instance variables--a part number (type String), a part description (type String), a quantity of the item being purchased (type Integer) and a price per item (Type Integer). Your class should have a constructor that initialize for each of the four instance variables. Provide a property for each instance variable. If the quantity is not positive it should be set to zero. If the price per item is not positive it should be set to zero."
I attached the code I have. obj is underlined and says "Argument not specified for parameter 'Invoice4' of the 'Public Sub New (Invoice1 As Object, Invoice2 As Object, Invoice3 As Object, Invoice4 As Object)' and so the program won't run. What am I doing wrong?
Public Class Form1
Private Sub TextBox1_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs)
Dim obj1 As New Invoice(Val(TextBox1.Text))
TextBox1.Text &= obj1.Invoice1 & vbNewLine
TextBox1.Text &= obj1.Invoice2 & vbNewLine
TextBox1.Text &= obj1.Invoice3 & vbNewLine
TextBox1.Text &= obj1.Invoice4 & vbNewLine
[CODE]...
how to my record connect with data base
View 3 RepliesI am handling many of the BindingNavigator tasks (MoveFirst, MoveNext, etc.)in code to ensure that I always ask the User to save his changes.
The one area I am have a problem is PositionItem. I would like to sense that the User has changed the Record Number in the BindingNavigatorPositionItem, handle my record Update, and move to the Record Number the User entered I have looked all over and have not found any way to do this.
Day Programmers how do i Update the record based on the Date & Time?? here's the code:
[Code]...
the problem is... it's updating but not on time... it's updating in advance... i just want to update it in the date & time that the record has and i'm thinking that it' may affect the other record's that not on time to update
how do i Update the record based on the Date & Time??
here's the code:
Private Sub Timer2_Tick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Timer2.Tick
lblTimeOfDay.Text = Format(TimeOfDay, "hh:mm:ss tt")
[Code]....
i just want to update it in the date & time that the record has and i'm thinking that it' may affect the other record's that not on time to update
I have a datagridview with 4 columns bound to a datasource. In the first column the user can only type numbers, in the 2nd, 3rd and 4th only letters (done with keypress and editingcontrolshowing).
Now I want that the user's input in the last two columns automatically gets converted to capital letters, regardless whether he is using Shift or has Caps Lock turned on.
[URL]
Private Sub DataGridView1_EditingControlShowing(ByVal sender As Object,
ByVal e As DataGridViewEditingControlShowingEventArgs) Handles DataGridView1.EditingControlShowing
[Code].....
My only problem is that when I double click a cell in the 3rd or 4th column (those where I want uppercase letters) and then one in the 2nd column, the text in the cell in the 2nd column is showed in uppercase letters too.
Note: It only shows the already present letters in uppercase. If I type extra letters they will get normal font (so lowercase if I don't use shift or caps lock, and uppercase if I do use shift or caps lock). If I don't type any letters and unselect the cell the text changes back to as it was before selecting.
If I double click another cell in the 2nd column (after i clicked one in the 3rd or 4th column and then one in the 2nd column), the present text stays the same, so it don't get showed in uppercase letters.
how it comes that only the first time that I double click a cell in the 2nd column after i clicked one in the 3rd or 4th column the present text gets converted to uppercase letters and, more important
Module Module1
Dim Bf, Bt, Lgt, Total, Pwr, Valu, Val2 As Integer
Dim InNum, Temp, OutNum As String
[code]....
I, will just explain a few areas of this to ease the process of understanding it:
1-The conversion Subs are to be used for values such as A7 in Hexadecimal
2-The Err Boolean will hopefully be used to link back to the top in the event of an error
3-Apollogies for the abreviated variable names, it simplifies things in my mind but winds my fellow students and teacher up no end.
This code is not fully functional yet, however I believe it should give an answer for my test value of 800 Base 10 to Base 8 (1440), however when the program runs in debug mode I can enter the three inputs but then it leaves two lines and gives an unresponsive flashing cursor.
I have been using this code for a long time now and it has always been accurate. I recently tried to convert a large string from one base to another and some weird stuff happens.
When I convert from base 36 to base 10, the result is accurate. When I convert the result back to base 36, it becomes inaccurate.
[Code]...
I was going to build a complex key value and wanted a "counter" like sequential value within it.Then I realized I could "shorten" the length if I used base 64 encoding.I saw something about converting byte arrays to base 64 - but that's not what I'm looking to do.So how to convert a number like 123456 to base 64.
View 24 RepliesAre there any built in base number conversion functions in .Net specifically decimal to hex?
View 7 RepliesI'm looking for a decimal to alphanumeric number base converter library in Visual Basic that does not use recursion. [url]...
which includes a demo app but discovered that it uses recursion. The problem with it using recursion became apparent when I attempted to integrate the library into my own Visual Studio Express 2010 Visual Basic project: I got a stack overflow exception.
Now I could consider increasing the size memory allocated for the stack but it might be hard to determine what this would be, given that the recursion depth might vary depending on the value to be converted.
I am getting following error when I am trying to use Convert.FromBase64String "The input is not a valid Base-64 string as it contains a non-base 64 character, more than two padding characters, or a non-white space character among the padding characters."
Dim payloadBytes = Convert.FromBase64String(payloadBase64)
Basically when my facebook registration form [URL]mphone field has a dash in it and encoded string is posted to other page and I am trying to decode it there which creates this error. Basically I am trying to extract data from Facebook Signed Request.
Recently I experiment with the binary file type. I have this structure[code]...
It works. And now, in the load event of the form I want to know, how many records (structures) are stored in the file.
Another question: how can I search and seek in the file (structure to structure, not byte to byte)?
How can i get the postion of the pointer or record number from a datagridview when a user clicks on a cell in the datagrid.?
View 4 RepliesSay I have a table called tblTest in MS Access with the primary key called field0 which is set to autonumber and a few other fields, say field1, field2 and field3. Say also, I inserted a new row using:
SqlO = "Insert into tblTest (field1, field2, field3) Values (value1, value2, value3)"
Dim cmdO As OleDbCommand = New OleDbCommand(sqlO, conn)
cmdO.ExecuteNonQuery()
[code]......
I have a data set with a table named IEA_Transaction_Test2.After executing the below codes to insert a record into the SQL server table IEA_Transaction_Test2, how do I get the identity value (auto number) of the record that just got inserted?
Me.Validate()
Me.IEA_Transaction_Test2BindingSource.EndEdit()
Me.IEA_Transaction_Test2TableAdapter.Update(Me.MyDataSet)
I have an Access table which has an auto-number primary key. When I add a new record to it I want to be able to get the value of this field.
The relevant code I have is:
dsNewRow.Item("FullName") = NewStudentFields(0)
dsNewRow.Item("FirstName") = NewStudentFields(1)
dsNewRow.Item("LastName") = NewStudentFields(2)
[Code]....
I want to be able to access the value of the primary key immediately after the Update (if that's possible without having to search the dataset for the new record - cumbersome!) or, even better, just before the Update, if that's possible.
I am writing a parsing method for a csv record and want to throw an exception if the number of fields in the record do not match the expected length
View 3 Repliesmy table name is "temp", and one of the field is item_id..how can i count how much item_id was added in this table...??is the code "SELECT item_id, COUNT(*) FROM temp GROUP BY item_id"it doesn't work.. i'm using OLEDB connection and can't use sql property
View 8 Repliesi know the record position or number of datatable and the same table is used as datasoure to grid. i want to find out the row number in the grid for current record in datatable. in case grid is not sorted it is easy but if grid is sorted then row number change in the grid.
View 3 RepliesI am attempting to create a program that opens a file and reads the contents to then display them in a set of four text boxes (e.g. id, firstName, lastName, avg.Salary). it stores the data in an array.
i have done all that i can do, however, i wish to display in a label something similar to this "5/10 (5th record of a total of 10)" meaning the 5th record in the array out of a total of 10 records. i have already done the code to display the total amount of items in the array, that part was simple, but i can't get my head around trying to code something that will display the record that i am currently viewing in the text boxes.
i have a "view previous record" and a "view next record" button that will go through to the next or previous record, in doing so will change the "5/10" records to the next appropriate number, e.g. "5/10" goes to "4/10" if the previous button is pressed (in doing so, obviously the records that are shown in the text boxes will change to the next or previous record)[code]...
I want to display the index number of the selected record in a listview box as it is clicked by the user. I can do it with multiselect set to false and the following call.
Private
Sub ListView1_SelectedIndexChanged(ByVal
sender As System.Object,
ByVal e
As System.EventArgs)
Handles ListView1.SelectedIndexChanged
[Code]...
This works fine except for one thing! after I click OK to the msgbox prompt, the record highlights normally and I click on the next record, and I get an Argument out of range exception error message, where I expected to just get another message with the next record number.