I'm connected to an access database using VB 2008.. there is information already located in the tables. But what I am looking to do, is find the "SUM" of all the data in a certain column.
View 35 Repliesi need to do a macro. this is what my excel looks like
1 2 3 4
seq1 name name seq2
abcde vv1 abcdddd
abcxy vv2 abcdlmn
[code]....
I've tried to use the DMAX Function in my VB windows application to find the highest value in a column in one of my tables, however it doesn't seem to work. After doing some research, I think that the function is only relevant to VBA, although I could be wrong.
'show me the maximum HCCID - DMAX
'Dim HCCNUM As Int32
'HCCNUM = DMAX("[HCCID]", "tblHCC")
How to find the maximum value in a column in one of the tables in my database?
We have a DataGridView with 3 columns: InvoicedOn, PaidOn and Amount
On the MouseDown event is this line of code which needs to be fixed:
MsgBox(DataGridViewPayments.Item("Amount", DataGridViewPayments.CurrentRow.Index), "")
We are trying to find out what the value in the Amount column of the curent row.
We also get this error message:
Conversion from string "" to type 'Integer' is not valid.
how to fix the MsgBox so it will show the value?
Using VB.NET i want find a specific string that occurs in column B of an Excelsheet and copy that entire row and paste it in a new worksheet. This string occurs a couple of times in this B column.I know how to open up an excel sheet in VB but I'm having difficulties searching for the string and then copying that entire row and do it multiple times (loop until the end of the column)
View 4 RepliesIn WPF, I have a Uniform Grid and would like to be able to find the row and column based on the index of a child element.
I know there is a mathematical way of doing this and would rather not use a normal Grid.
If it helps, I can get the total number of rows and columns by using:
Math.Sqrt([*uniformgrid*].Children.Count)
I wonder if it is possible to find a specific row and specific columns in data base file (Access) . You see , I am using a DataGridView control to show only SOME of the columns (fields) of a table from an Access file . For example , lets say that in the DataGridView control I only show the following fields :Field1 , Field2 and Field3 .Now , when the user selects an entry in the DataGridView control , I want to insert the text from Field4 into a text box on the form .
The problem , however , is that I don't know how to get the specific row in the data base file and also I don't know how to get the text in column (field) Field4 of that row .One thing that might be important is that the index of the row in the data base file is not necessarily the same with the index of the current row in the DataGridView control . This is because in the DataGridView control the rows are order by the contents in the ID Field .ol .
Are there any good free alternatives to DevExpress data grids (WinForms)?I am looking for WinForms Data Grid and Data Editor Controls.
View 1 RepliesI am going crazy trying to figure this one out. I have been told many times that you can get the data of a column in a listview in this manner: YourListView.SelectedItems(0).SubItems(1).text This does not work. I have a ListView called EmployeeListView that is correctly populated by my database. There are three columns: (0) is First name, (1) is Last name and (2) is Employee ID. I can see the information in the ListView when I run the program. What I need to do is to pull out the Employee ID and put that into a variable called EmpID.
[Code]...
I've been searching and searching, but I haven't been able to find a halfway-decent way of adding multiple columns of data into a WPF VB.NET ListView. The data I'm adding is not from a datasource. [code]...
View 1 RepliesI have this test form where I'm testing the idea, but ran into a snag. Now the main idea is to load all the data from a dataset into the one column of the datagridview. This works perfectly as shown in the image. Now there is something that I want to happen, but just can't get it right. when on the DataGridViewComboBox Column I also want to be able to type in my own data if the one I want is not available in the combobox.
Also if there are 50 values in my combobox and 2 of them are:
jacky, jacson
When I type jac, I want the combobox to only give me the options starting with "jac"
Here is the code that I'm currently using:
Dim dt As DataTable
Dim dsNewDataset As New DataSet()
Dim i = 0, intSetArray As Integer = 0
Public Function JT_PullDataWithCOLUMNS1(ByVal Cols As String, ByVal TableName As String) As DataTable
[Code] .....
I'm somewhat of a novice at VB.I have a DataGrid that I am manually populating from a SQL query-based dataset (see code below). Question: How do a capture the value of a specific column of the selected row (mouse click in the row) to use as a variable in other parts of the overall solution?Also, how do I add cell padding around the contents of the data grid cells?
[Code]...
This is my programs complete code, the only problem is i want to fix the amount of decimal places that show up in my gridview. The problem is if i do this on the asp side the location of the column gets thrown off and the column is duplicated. I figured if i just remade the table on the asp side it would work only problem is if i remove the sql for that particular column the asp side column cannot get data.
Imports System.Data.Sql
Imports System.Data.SqlClient
Imports System.Data
[Code]....
I am having a little trouble with the folowing code. I made it so that it searches column "U" in the excel spreadsheet and for bcode that is input into a text box. The code runs perfectly the first time it runs but if i try to search a second time it gives me this error " Exception from HRESULT: 0x800A01A8"
Here is the
Dim Shape As String
Dim bcode2 As String
Dim Size As String
[code]....
[wink]You'll notice i dim'd n as integer = 0...[/wink] hehe I need a bit of advice on how to find the largest number stored as data in an array. For example vote(0) = 6, and vote(3) = 12, and lets assume all the other vote(n) are less. How do I pick out the big one?
[Code]...
I am taking a VB2008 class and I have the entire program figured out except for one thing. I've checked our text I've scoured the internet and I've tried tons of things.
What this section of code does is access a data file, calculate the average from it... done.. that works, calculates the highest number in it... done that works... and calculate the lowest number from the file... nope... not working. I've tried tons of things and what i have in there now keeps giving me an output of 0, when it should be a 2.
Private Sub btnCalc_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnCalc.Click
'Calculates average, minimum, and maximum temperatures from data file
Dim month As String
[Code]....
Table Employees has data as follows
sno----name
1------Eric
2------Boris
3------Bill
Whien I enter "B" in text5 and run following codes then it show error message as IndexOutOfRangeException was unhandeledThere is no row at position 0I have two question
1) Why it does not select name begins with "B"
2) If it has no row then why it does not exit sub.
str = "select sno,name from employees "
str &= "where Name Like '" & (TextBox5.Text) & "%'"
cmd2 = New SqlClient.SqlCommand(str, con)
da2 = New SqlClient.SqlDataAdapter(cmd2)
[code].....
how to find the row position/index in a data table, using a value from another table. For example, I use the row position from Linkingtable1 to get my value for CustomerID, but i want to use the CustomerID to search the CustomerTable for its row position, in order to show the Customers Name in a text box, As currently when loading the textbox shows the customerID. I understand the code to get the names from the rows in the datatable, its just finding the row position of the customerID.
View 9 RepliesI have a binary file. If I look at it with a hex editor, the first values are:208, 207, 17, 224, 161, 177, 26, 225, 0, 0, 0, ... etc.It has a length of 330240 bytes I have tried to open it and read it into a string so I can manipulate it and write it back. No matter what I use, I either don't get the correct number of bytes or the values in the string are incorrect. The most common error results in the first values being: 63, 63, 17, 63, 63, 26, 0, 0, 0 .... etc.It is interesting that it appears that any value > 63 becomes 63.
I get the 2nd values by a simple loop:
For lnx = 0 To 99
Debug.Write(Asc(line.Substring(lnx, 1)))
Next
I have tried a whole number of ways to read in the file, including filestream, My.Computer.FileSystem.ReadAllText, File.io.readAllLines, etc.All either give me a string length of about 324000 (not sure why) or, if they do, don't have the correct values. Yes, I have tried various encoding options.
I need to find a string (sort of like: "D" & Chr(0) + "L" & Chr(0) + "S" & Chr(0)... ) so I can then replace that portion of the string with a new value, then write out the file.I use the ".indexOf" to find the data in the string.Why can't I load the file into a string? Or, do you know of an easy way to find some text (similar to above) in a file and then replace the next x number of bytes with a new value and close the file?
is there a method check the number of records in data reader? like the count of rows. ?
View 2 RepliesWhat i got is a checkedlistbox with a list of text files, iam trying to search thru the text file and add to a listbox, my code works, But from 2 Txt files its returning 2 found and each txt file has 5 lines with excat names.
[Code]....
I have a problem that I�m sure will not be hard to fix for anyone who has been using CR for some time.
To start I have created a program in VB2008 that uses a MS Access data file, I can connect to it with no problem and can also add data and amend data, so all seems to work perfectly. I have published it and it once again runs perfectly on another/s machines.I have now a requirement for a number of reports so have chosen CR for this purpose. I have connected the report to the database and that runs with no problems at all, that is until I try to run it on another machine, it seems not to be able to find the database and comes up with a database Login panel wanting me to log in with a password and Admin name.
I feel it's properly a problem with the path to the database but if I modify the path manually it still won't work.
G:DevelopmentDOT NET DevColony_4ImagesBattenhallAve_Plan.bmpand i want to find and return the value after the last '' for example in the string above i would want to return:BattenhallAve_Plan.bmp
View 5 RepliesI have FolderBrowserDialog1, how do I find the last latter of FolderBrowserDialog1.SelectedPath?
View 1 RepliesI am attempting to calculate a range of prime numbers determined by two user inputs (textboxes) I have the following code, but it displays nothing but zeros in the multiline textbox. I just need a bit of guidance here as to what is causing my code to show nothing but zeros.
Public Class PrimeNumbers
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim lowBound As Double
Dim upBound As Double
[code]....
I'm trying to work out a bit of a memory leak and was hoping someone can assist. The below program is running fine except for one thing. 1. The memory leak. When I run the program and watch task manager, I can see the memory usage of the program starts at roughly 14 meg. Over a period of hours, that increases pretty substantially. Eg. at 6am this morning, it was at 14 meg, and by 3pm it was at 36 meg.In a nutshell this program takes an incoming stream of data which looks like this.
MSG,3,51,350,461D3B,1427,2007/02/24,10:58:35.441,2007/02/24,11:03:35.829,,33975,,,53.82440,10.19830,,,0,0,0,0
MSG,3,51,673,44CE6D,1429,2007/02/24,10:58:35.098,2007/02/24,11:03:35.829,,39000,,,53.87798,9.88422,,,0,0,0,0
MSG,3,51,350,461D3B,1427,2007/02/24,10:58:35.848,2007/02/24,11:03:36.829,,33975,,,53.82353,10.19696,,,0,0,0,0
It basically parses the stream and places items into hash tables depending on the type of data. Eg. I have a hash table for latitude, one for longitude, one for altitude, etc.The key is always the hex code eg. in the first line above the key would be 461D3B.Essentially, as the data arrives in and is parsed and placed into hash tables depending on the type of data, I also have another hash table dedicated to keeping track of timeout times for that individual piece of data. The timer event fires and if the timeout is exceeded for that piece of data then it gets removed from all the hash tables.
I believe this is working. I've done heaps of debug output to the output window ensuring that items are being added to and removed from the hash tables successfully. Eg. ensuring that the hash table record count matches what I believe the number of active records should be.I'm at a loss what could be causing this memory leak though. I'm assuming i'm not disposing of an object properly, or not initializing/declaring it properly, but I can't work out what i'm doing wrong.One thing i'll mention though. The timer event occasionally comes up with a warning about the contents having changed during the For..Next loop. I don't think this will affect things though. As long as the hash table item count matches what it should be, I don't see that being an issue.
Imports nsoftware.IPWorks
Imports System.Data.SQLite
Public Class frmMain
[code]....
I am needing to locate a given set of numbers in a string, and have limited success, it is almost always finding the numbers that I want, but I need it to be more reliable.Below is a test program that I am using to test with and also 2 picures that may explain better that I can put into words.
[Code]...
I have a string. I need to check what characters it contains because certain invalid characters are causing my sql query not to work. In the query I select where SupplierName is equal to the string. I need to replace the invalid characters at database and vb level. But I need to know first what the characters are.
View 15 RepliesHow can I calculate the bounding rectangle of an ellipse using 4 points on the ellipse?
View 1 RepliesI got a situation where i have the first word only of a a child window and the rest of the name changes. I need to find this child window using findwindowex i think by not knowing the full name.
Searching the processes wont work since it is a child.