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 want to display data on the datagripview, this is my code but the error message am get is :"there is already an open DataReader associated with this Command which must be closed first."
Imports System.Data.Sql
Imports System.Data.SqlClient
Public Class Invoice
[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]...
I need to display a grade based on the number of points entered. store the min and grade in a 2d array here's my code that I have currently:
Dim strGrade(,) As String = {{"0", "F"},
{"300", "D"},
{"350", "C"},
[code]....
i want to display a certain section of my form based on the number selected by radio button.( scale 1 to 5) by default 1 is clicked . if they click 5 then the same portion will be repeated 5 times .i have the database table structure to support this . but how to code the radio button to do the same .
View 8 RepliesThe 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.
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]....
"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 do i count the number of rows that are affected when I updated a table, and display the number of affected rows in a message box ??
here is my code for updating the table ...
For Each row As DataGridViewRow In DataGridView1.Rows
req = row.Cells(Column1.Name).Value
If row.Cells("Column1").Value = True Then
[Code].....
is there a way to generate a random number and then display that number?
like for example i want to say "i got # - # pencils" or something like that
I am trying to run a nested loop; it should call a result from a MDB database. Which it does, when I run the single loop it goes thru all of the entries. But when I try to get a number to display twice it stops on the second entry. Having it display the number twice is just a test to make sure it does work, I am going to modify it after I can prove the loop works. The count on the Message Box is correct, but the number displayed is wrong?I want it to display each number twice and then move on to the next number. [code]
View 2 RepliesI've got a progressbar in my form that I want to increase the value of in increments based on number of files in a folder. I guess this is pretty basic, but this kind of programming is pretty new to me. So I've got these lines of code:
[Code]...
Given a week number, I need to get the date of the Monday of that week.For example, I have several strings that are stored in a file, such as
"WK 28 2010"
"WK 30 2010"
They could be any any valid week number.
The Monday on Week 28 of the year is 12 July 2010
The Monday on Week 30 of the year is 26 July 2010
Its these dates that I need.
I guess I could create a lookup table, but would prefer a more smarter approach so my software will be future compatible?
I have a ticketing application and I want to create a date based, sequential, ticket number.I'm leaning toward something based on Posix time as this generates a sufficiently large number and the likelihood of any two ticket numbers overlapping is slim to none (two people would have to just happen to hit the button at exactly the same time on two perfectly synchronized systems).Has anyone done anything like this or have any code snippets/ suggestions? At the moment, I'm just using a UNIX time converter someone posted elsewhere: [code] This works fine (although it's not POSIX time), but I wanted to see if anyone else had any feedback as well.
View 11 RepliesHow to locate a button based on the handphone number or any number? That means if I assign the button to coordinates 25, 14 and number 1 as the button name. So when i key in 1 in the text box, only that button will light up the rest wont. So that means the statement will be like:
if textbox1.text = "01" then
' button at 25,14 backcolor = black
end if
I have a dataview object that is being populated by database fields - so I can sort on these partulular columns by specifying the actual column names without any difficulty. However, I have been asked to add a few more columns to the dataview, and these columns will be calculated columns, not directly derived from an underlying database column.The users want to be able to sort on these new columns as well - even though there is no actual column name I can use to sort.
I have not been able to see where I can sort a dataview based on the actual column integer value used when the user clicks the appropriate heading to sort.
I had the following code to display crystal report based on the sql.
Code: Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click conKk.Open() Dim strReportPath As String = "C:Documents and SettingsChee MunDesktopFYPvbFYPCrystalReport1.rpt" MessageBox.Show(strReportPath) Dim mySelect As SqlCommand
[code]....
But the problem occured in objRpt.SetDataSource(mydsSong.Tables("Song")),it stated that no tables is found but my database is having this table.
I have a homework assignment to code an application that allows the Prof to display a grade based on the numnber of points he enter. The grading scale is : 0-299 -F; 300-349- D; 350-399- C; 400-449- B; 450-500- A. We are to store the minimum points in a 5 element one dimensional Integer array name intPonts and store the grades in a 5 element one dimensional String array name strGrades. The arrays should be parallel arrays. The procedure should search the intPoints array for the number of points entered by the user and then display the corresponding grade from the strGrades array.
I have stored the minimum points and grades in a one dimensional integer and string array respectively. I have coded the program, and when I put in random points, it gives me the letter grade. For example, if I put in 376 it will display a "C"; if I put in 200, it will display an "F". However, if I put in anything over 449, it will NOT display an "A", it just leaves the lbl blank. I am stumped on how to get the code to read pass 449 points.
here is my code:
' Name: Carver Project
' Purpose: Displays a grade based on the number of points the user enters
' Programmer: <Paul J. Williams> on <February 27, 2010>
[code]....
I have a UI that uses datagridviews / bindingsource / datatables of typed dataset for data entry. The dataset itself is serialized to a varbinary(max) in SQL. (i.e. no tableadapter, backend schema).I would like to limit the number of rows the user can enter into some of the grids (the data is used to fill PDF forms and I don't want them entering more rows than the forms can accomodate.).I have subclassed the datagridview, added a rowlimit property and tried to manipulate the AllUsertoAddRows property
Imports System.Windows.Forms
Public Class dgv
Inherits System.Windows.Forms.DataGridView[code]......
The behavior I see is that the messagebox comes up after leaving the max row even when the user is trying to leave the grid. I can lose the messagebox and deal with notification some other way but I thought someone else may have come up with something a little more sophisticated to handle simply causing attempting to add to many records to navigate out of the grid to the next UI control.
I am trying to look through a database and checked items in a checkedlistbox based on a Contact ID number. The error I'm receiving is this : Public member 'item' on type 'String' not found.
The error is on this line of
"If lstDebtState.Items.Item(x).item(0) = dt2.Rows(j).Item(0) Then"
<b>
Here is my
</b>
Try
con.Open()
[code]....
I have a form called FrmPracDetails, which has details of practices and each practice has a unique prac_no populated on the form in the text box called TxtPracNo. Now, I have another form called FrmPayHistory. This form has a datagrid called DgvPayHistory, which is loaded with all the payment history of all practices. It has also a field called prac_no and stores the unique prac_no.
What I want to do is, when a user is in FrmPracDetails, lets say prac_no 1115, then you open the FrmPayHistory. Only the payment history of that respective prac_no should be seen. Presently, it brings all the practices and their payment history. I have added a textbox (TextBox1) in the FrmPayHistory which links and displays the prac_no from FrmPracDetails with the following code:
Private Sub FrmPayHistory_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Me.TblPayHistoryTableAdapter.Fill(Me.TblPayHistory._TblPayHistory)
Me.TxtPracno.Text = FrmPracDetails.TxtPracNo.Text
End Sub
I have to display the available times in a dropdownlist called "DDL_avalTime" based on the date selected in a ASP calendar.
How the program works is that when a User clicks a date form the caldendar, it checks the SQL database. In this case the table that I'm retrieving it from is "trainerbookings" from the column "trainingDateTime". The data type for this column is datetime.[code]...
I have a DGV which is part of an inventory system. I have several columns but the ones i need to resolve are Quantity, Name and Plural Name. essentially if quantity is 1 i need to display the Name data if greater than one the plural data. Is this possible? would i need to resolve this earlier in the process (the data is extracted from an xml file using LINQ to bind it to a rowObject) or can i do this with the completed dataset, say by hiding the Name and Plural Name colums and creating a custom column? ideally i would like to keep the data untouched.
View 10 RepliesI need designing a Windows based computer program that will allow a user to enter some number (n) and a choice of a count up or count down for that many numbers. So for example, the user enters 5 as their number and selects the count down option, the message box displayed would contain the message: "Here are your numbers: 5,4,3,2,1,0"
View 7 RepliesIs it possible.we can reverse a digit in VB.NET(Graphics mode)not console based
View 2 RepliesHow do I dynamically display the 'Edit' on the hyperlink field based on the values on the rows, generated from the database. the gridview automatically generates rows.
View 1 RepliesI have a group of three radio buttons. Depending on which radio button is selected, I want to disaply one of three controls - a textbox, a dropdown list, or a button. How do I display controls based on the result of a selected radio button?
View 1 Replies