I'm developing a data logging application using VB for the actual logging to a MySQL database. I'm reading a value from a device and then running an insert query every minute. This is great but if the value doesnt change all day then my records are going to all be the same. I'd like to try and calculate the percentage of change on the value and only run the insert query if the percentage of change is greater than, say 5%.
I am trying to calculate two columns in a DataGridView. The first column is the points column and the second column is the Rental_charge column. I would like one text box to display the total of points and the second text box to display the total Rental_charge.
Private Sub Rental_ItemDataGridView_CellEndEdit(ByVal sender As Object,
I would like a column in my datagridview to display todays date. Also to caluclate all the row charges of todays date and display them in a text box.[code]
I am attempting to fill a form with multiple rows from an access table based off of a parameterized query. My query works fine but I don't want to return one row at a time, I want to return all rows that match my query in multiple text boxes. I know that I can use a datagrid view to accomplish this, but I would prefer the look of a textboxes on a form. I have read through many books and searched the internet forums but think I may just not know what to search for as nothing has worked yet. Can anyone point me in the right direction. So far I have tried setting the text box value to the row().item(), creating a different dataset for each row, and even setting variables for the results of the query to then be passed to the text boxes. Since none of this work, I don't really have any starting code to post. If I could just get a starting point I could work from there, so don't feel the need to code anything for me, just set me in the right direction.
I have a small project i am doing for work to compare our website catalogue to our actual inventory in our financial software. To do this, i have exported the online catalogue as a delimited text file using "^" as the delimiter. I then want to go into our Accpac data a find out if all the items are still active, the current price and the stock on hand.
I am using a Strongly Typed Dataset as DAL. I want to return a single column from my table for that i wrote the code as
SELECT DISTINCT Floor FROM Room WHERE (Building = @Building)
But when i previewed the data, it shows me all the columns of the table with Null Value and the column with primary key has -1 value. This condition raise an Exception when i link this query to a ComboBox ..
I have two listview in a separate form, basically what i want to do is whenever I select a row in my first listview the items in that selected row will be copied in my second listview which is empty.
how to add information in to a listview with information from a dss. So far i have managed to get all the information from SQL and now im just in the process of populating the listview.
Im aware i could use a datasouce for this but i want to learn it this way
So heres my code
Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click Dim retrieve As New GlobalFunctions
[Code]...
It doesnt throw an error it finishes loading and then presents with me a listview with a vertical scroll bar but with an empty screen....i think i may have got things a bit muddled up
I have seven columns in a table Customer (custId, Date, AccountCode, Description, Quantity, Price, Amount)Also i have seven textboxes on the form from where data is transferred to the Listview. Listview has all seven columns from where data is to be transferred to the seven columns of Table Customer.I want that data should be transferred to all the seven columns of LIstview but Listview should display only last four columns and hide first three columns to display. In otherwords user may be able to see only the last four columns in Listview.
I have a listview that I populate with data from a recordset during runtime. After the code has executed and I view the listbox, my columns are missing. I am 100% shure the listview is populated with data. The listview view property is curremtly set on Details. If I however switch the view to anything else eg. view=list, I see the listview items in the listbox. I need to show the user all the columns.
I've setup a listview with two columns. Both have a fixed width which totals the width of the control (to fill the control fully and not display a horizontal bar)This works fine as long as the form does not change, anything such as a font change on the system will cause the list view to look off alignment.LV2.jpg shows it in the designer, LV.jpg shows the same listview with a different font.Is there an easy method to fix the position or auto size the last column to the edge of the control?
I'm developing Asset Management System, it will compute for straight line depreciation, my problem is how to calculate running total on each group that I've extracted from my database.Here's a snippet for my extraction of data
Private Sub cboAType_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cboAType.SelectedIndexChanged ListView1.Items.Clear() If Not cboAType.Text = "-" Then
I have a three column ListView.The first column has all the items in it, but if I save it to return later to put data in the other two columns it won't save the blank columns.The only way I can do it is to put a space or a character in those columns.[code]
I want to create a listview with 2 columns, on the first column, a series of names and on the second a series of filepaths. I want each name to be linked to a filepath and then when the user clicks on the name in the first column, the filepath can be used in another bit of code. How would I do this, never used listviews before.
I am currently using the following code to store all of the items from a listbox control in an array, and then build a string based on the array items, trimming the last two character of the string to remove the ", ". I am looking to do something similiar for my multicolumn listview control but am concerned about how to store the multiple subitems for each item in the array.
Dim myStr (listbox1.items.count) as String 'store all active medications information in an array & build a string For i As Integer = 0 To listbox1.Items.Count - 1
I seem to be having trouble finding out how to right align the text in listview columns. We have common listview control at my shop and I need to align it at run time. Currently dollar values are left aligned. Alignment. doesn't have right as an option.
I want to separate each text into their own Column in VB.net. How do I achieve this? Screenshot: Each entry is separated with "|" .
My Code: Private Sub MenuItem3_Click_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MenuItem3.Click Dim folder As String = Environment.GetFolderPath(Environment.SpecialFolder.Personal) Using sw As StreamWriter = File.AppendText("My Expenses.txt") sw.WriteLine(DateTimePicker.Text + Space(1) & "|" & Subject.Text + Space(4) & "|" & Category.Text + Space(5) & "|" & Amount.Text + Space(4) & "|" & Peyment.Text) sw.Close() End Using End Sub
I set the width for my ListView columns in the designer, in run time they always shrink back. I have no idea why, could anyone shed some light on this for me - possibly a solution to keeping them exactly the way I set them in designer ?