- Upvotes Received
- 0
- Posts with Upvotes
- 0
- Upvoting Members
- 0
- Downvotes Received
- 1
- Posts with Downvotes
- 1
- Downvoting Members
- 1
me in KSA
- Interests
- VB.net
- PC Specs
- Intel Core 2 due
13 Posted Topics
HI! I CREATING A "POS" APPLICATION FOR MY SHOP I WANT TO KNOW THAT HOW TO PRINT OUT DATAGRIDVIEW DATA Like This: -  to this :  | |
Hi! I want to know, how to delete empty or blank row in DataGridView in Vb.net.......... "When i click Button the all empty or blank row in DataGridView will be remove......" LIKE this : " Before Button Clicked "  " After Button Clicked "  | |
Hi! i want ADD empty row in DataGridView............Like This ! When user enter Number in textbox and click button then Add empty rows(as per user input number in textbox) in DataGridView.......... for example :- if user entered "5" in textbox and click button then "5" empty rows will be … | |
Please Help me ! I want to make SCREEN LOCK program(softwar) for my pc! i want when SCREEN LOCK program start, then unable to close by user but i am unable to do this. when i press alt + f4, it's working great but when i press alt + f1, … | |
PLEASE HELP !!!! I MAKEING A PROGRAM FOR MY SHOP........... BUT I DON'T NO HOW TO SAVE MY ALL SALES INVOICE MS ACCESS THANK YOU IN ADVANCE | |
OpenConn() For Each li As Windows.Forms.ListViewItem In ListView1.Items With OleDa .UpdateCommand = New OleDb.OleDbCommand() .UpdateCommand.CommandText = "UPDATE [Inventry] SET [CODE] = @CODE , [ITEM] = @ITEM , [QTY] = val(QTY) - @QTY , [SPRICE] = @SPRICE , [PPRICE] = @PPRICE WHERE (CODE = ?)" .UpdateCommand.Connection = Con .UpdateCommand.Parameters.Add("@CODE", OleDb.OleDbType.VarWChar, 50, … | |
OpenConn() Dim li As Integer Dim qqttyy As Integer = Val(ListView1.Items(li.Index).SubItems(3).Text) Dim codee As String = ListView1.Items(li.Index).SubItems(1).Text OleDa.UpdateCommand.CommandText = "UPDATE Inventry SET QTY = QTY -'" & qqttyy & "'WHERE CODE ='" & codee & "'" OleDa.UpdateCommand.ExecuteNonQuery() CloseConn() | |
OpenConn() Dim qqttyy As Integer = Val(ListView1.SelectedItems(0).SubItems(3).Text) Dim codee As String = ListView1.SelectedItems(0).SubItems(1).Text OleDa.UpdateCommand.CommandText = "UPDATE Inventry SET QTY = QTY -'" & qqttyy & "'WHERE CODE ='" & codee & "'" OleDa.UpdateCommand.ExecuteNonQuery() CloseConn() | |
Hello! I am makeing inventry program for my SHOP, When Button1 clicked, listview all items will UPDATE, listview coloum 3(QUANTITY) will SUBTRACT from ms access quantity. Please help me. Private Sub Button9_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button9.Click Try Call OpenConnection() OleDa.UpdateCommand.Parameters.Add("UPDATE [Inventry] SET [QTY] = [QTY] … | |
HELLO. IF I CLICKED BUTTON "SAVE" MS ACCESS ITEM WILL BE UPDATE FROM LISTVIEW. | |
| |
Private Sub cmddelete_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmddelete.Click If Not acsconn.State = ConnectionState.Open Then acsconn.Open() End If 'sql statements strSQL = "DELECT * FROM Table1 ([Item Code], [Item], [Sale Price], [Purchase Price]) values ('" _ & txtid.Text & "','" _ & txtname.Text & "','" _ & … | |
Re: i does'nt understand....................please help me .......... i want to make a program, that can search item from list view, and what ever word or letter in textbox that will search in listview............PLEASE HELP ME!!!!! I AM USING VISUAL BASIC 2010 THANKING YOU IN ADVANCE |
The End.