No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
Re:
This code to save, Edit and delete data in VB.Net using SQLServer as backend. this code is continuance from my previous post "Show Data in DataGrid with VB.Net 2003 and SQLServer 2000". so i didn't write code how to connect SQLServer 2000 with VB.Net 2003 cause this already in there. … |
|
Re:
i open a child form from within a parent form Private Sub TextBox1_KeyPress(ByVal sender As System.Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles TextBox1.KeyPress Dim custmast As New CustomerMaster custmast.MdiParent = Me.MdiParent custmast.Show() End Sub now the form customer master has values within a listview. when i doubleclick on a value within … |
|
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 … |
|
Re:
Hi. I'm using Visual Studio 2005 so I didn't know where to put this topic. This is my problem. I made a qucik search program so when I browse for a text file, it adds that text file to a listbox1. And then when you search result will be placed … |
|
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 |
|
Re:
hi daniweb members I am using visual basic 2008. i have a listview and a datagridview which have both 3 columns like ProductCode,ProductName & ProductPrice. Now i want to pass listview values to datagridview in the same sequence. I want that when i double click on any row in the … |
|
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 … |
|
|