LearnVBnet

Very HelpFull I Use to my Invoice Form, and can insert with a new form How can if my Invoice form have e. 3 row with productName, quantity, price, total And then I add new 2 record to my datagridview. If I click btnAdd there found Id then not save, …

~~~ vbnet Private Sub Listview_DoubleClick(ByVal sender As Object, ByVal e As System.EventArgs) Handles Listview.DoubleClick If Not Listview.SelectedItems.Count = 0 Then With LvList.SelectedItems(0) ParentForm.Textbox1.Text = Listview.SelectedItems.Item(0).Text End With End If ~~~

I can Insert table from Old_Table_Database to New_Table_Database with this code. [CODE] Dim cmd5 As New OleDbCommand Dim cmd6 As New OleDbCommand cmd6 = New OleDbCommand("select * from " & "Product ", OldConn) Dim dr6 As OleDbDataReader dr6 = cmd6.ExecuteReader For j As Integer = 0 To dr6.FieldCount - 1 …

[CODE] Dim NewConn As New OleDbConnection(strConn) NewConn.Open() Dim dlt1 As New OleDbCommand("DELETE * FROM Invoice ", NewConn) Dim dlt2 As New OleDbCommand("DELETE * FROM InvoiceDetail", NewConn) Dim dlt3 As New OleDbCommand("DELETE * FROM Receiver ", NewConn) Dim dlt4 As New OleDbCommand("DELETE * FROM ReceiverDetail", NewConn) dlt1.ExecuteNonQuery() dlt2.ExecuteNonQuery() dlt3.ExecuteNonQuery() dlt4.ExecuteNonQuery()[/CODE] How …

[CODE] New IO.StreamReader(winDir & "\system.ini")[/CODE] maybe I can make you some idea. I also open my database from the last open. I write my opened database when I open Last database, then when Load is the last opened. Sorry my english not good. you have inifile = system.ini You load …

Help me to format currency col(2) = 1.234.567 I have search any where can'not find answer [CODE] With Lv1 .Clear() .View = View.Details .FullRowSelect = True .GridLines = True .Columns.Add("Product Name", 250) .Columns.Add("Stock", 90, HorizontalAlignment.Right) .Columns.Add("Price", 90, HorizontalAlignment.Right) '.SubItems(2) = Format(Value, "#,##0.00") FillListView(Lv1, GetData(sSql)) End With[/CODE] tx

Load from database to datagridview [CODE]Call ConnectAccess() Dim da As OleDbDataAdapter = New OleDbDataAdapter("SELECT ProductName,Quantity,UnitPrice,Extention, InvNomer,ProductId, InvDetId " _ + " FROM InvoiceDetail where InvNomer ='" & pbInvNomer & "' ", mConn) Dim ds As DataSet = New DataSet() da.Fill(ds, "InvoiceDetail") DGV.DataSource = ds.DefaultViewManager DGV.DataSource = ds.Tables("InvoiceDetail") Me.DGV.Columns(0).HeaderText = "Product …

[code]Form Payment DGV.Columns.Add("FullName", "Customer") ' DGV.Columns.Add("InvNomer", "Invoice No.") DGV.Columns.Add("BalanceDue", "Total") DGV.Columns.Add("Paid", "Paid") Private Sub cmdPayList_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdPayList.Click ' where = " AND InvNomer NOT IN(" ' where = where & "'" & row(2).Value & "', " ' where = where & ")" PayList.show() …

I have Listview1 and listview2 After from listview1 focus to listview2 ex: row 20 keydown listview2 not go to row 21 but go to row 1, also keyUp not go to row 19 but go to row 1 any one can help, what to do Thanks

[QUOTE=codeorder;1474013]See if this helps. [CODE] Private Sub ListView1_DoubleClick(ByVal sender As Object, ByVal e As System.EventArgs) Handles ListView1.DoubleClick If Not ListView1.SelectedItems.Count = 0 Then '// check if item is selected. With ListView1.SelectedItems(0) Dim lvItem() As String = {.Text, .SubItems(1).Text, .SubItems(2).Text} '// get ListView selectedItem. DataGridView1.Rows.Add(lvItem) '// add it to DataGridView. End …

I Have Listview with All transaction with column InvoiceNo Date Customer Total Now I want to filter only month transation only month with combobox selection and one textbox year Me.cboMonth.Items.Add("1") Me.cboMonth.Items.Add("2") Me.cboMonth.Items.Add("3") ........... Me.cboDate.Items.Add("12") Me.cboDate.SelectedText = 1 my column date display mm/dd/yyyy How can I selection cboMonth to filter only …

Thanks alot for DaniWeb I'm newbie Daniweb very help to me thank