I want to read the values of the 8 neighboring cells in an image as shown on the attached file. For example, the green cell is the home cell and it has 8 neighbors (cells from 1 to 8 as seen on the attached image). It will read all 8 neighboring cells then it will move one cell to right (now pixel 4 will be home pixel). Again it will read its neighboring cell values and then it will move to next pixel etc. It will continue till to the end (the last cell or pixel of the image).
I have just found that if a DataGridView image column's size (height & width - in pixels) is smaller than the image's original size (in my case all images are exactly 180 x 180 pixels) at the time the cell is populated then the image is automatically being converted to a lower resolution I assume to fit the image completely within the size of the cell). How can I stop the automatic scaling of the image?
The image below show the same file displayed twice, both at 60x60 pixels ('Thumbnail' column) and a blowup of the image (PictureBox populated via the CellMouseEnter event) to it's right. You'll notice the resolution of the first blowup is far less the the second. so, what made the difference in the resolution of the blowups is? In the second blowup's case I'd first stretched the image column's width to ~180 pixels and set the row height to match (via the ColumnWidthChanged event) then populated the DataGridView then stretched the image column to 60 pixels (its minimum).
I am trying to test certain cell values to see if they contain subtrings of a certain format at the END of the cell sting value.E.G.I have cells with the values...
324f5 346-ssth 4565-Q1-09 dsfsd46
[code].....
I want to run a macro that searches through the cells and tests to see if they have a substring sitting at the end of the value that is in the format "-Q[number]-[number][number]" OR "-[3 LETTER MONTH ABBREVIATION][number]-[number][number]" OR "-[3 LETTER MONTH ABBREVIATION][number][number]-[number][number]"and then if the test is true, the cell color is changed to RED.So if I ran the macro on the example I gave above, it would turn the cells with the following values red:
4565-Q1-09 454354-FEB2-09 546-5-MAR03-09
I can do all the VB side of things but I don't know Regex but know it would help. I'm in a bit of a rush to finish this job for work because I finish working here in 2 days and need to get it done before I leave!
I have a dictionary object (let's call it _do) I am using to cache some values for use in a multi-threaded program. I have a single controlling parent thread, with a timer function _doTimer() which can kick off child threads with a new instance of class MyThreadObject in each. My parent thread has _do as a property and with each time _doTimer() gets called, it may or may not repopulate _do depending on cacheflag settings. I pass a reference to _do to each instance of MyThreadObject and those threads at some point read the values of _do but DO NOT write to it.
What I want is to ensure that the child threads do not try and read _do whilst the parent thread is writing to it. Same thing but very slightly different -> I also don't want the parent thread to write to _do whilst the child threads are reading from it. However there is no problem with 1 child thread reading the values of _do at the same time as another child thread is reading the values - so ideally I do not want each child thread to completely lock out read access, only locking out Write access.. The code is roughly like this:
i am importing data from Excel workbook having around 30 sheets in each book. Application works fine but after uploading few books it gives error continuously Exception from HRESULT: 0x800AC472 i used thread.sleep(1000) for each workbook into folder remove that? if these due to hyperlinks in some sheet, is any way to disable hyperlinks through code in vb.net
I'm reading a cell value from a Datagridview, and this works fine in other projects, but not here?
HTML Dim OldGUID() As String = Nothing Dim X as Integer = -1 For X = 0 To Me.DGView.RowCount - 1 If Me.DGView.Rows(X).Cells(0).Value.ToString IsNot String.Empty Then OldGUID(X) = Me.DGView.Rows(X).Cells(0).Value End If Next
It fails on the line: OldGUID(X) = Me.DGView.Rows(X).Cells(0).Value with: NullReferenceException was unhandled - Object reference not set to an instance of an object. The Cell has a string value and during debug I see the value, but it fails anyway.
I've managed to work out how to read EXCEL cells via static values. Ideally I would like my application to check the third column of the EXCEL sheet and if there are no entries on a given row, it should display the coresponding row of colums 1 and 2...for example if (C,3) contains no entry then get values of (A,3) and (B,3)...then mark (C,3) as pending by writing a value to (C,3). Here is my code at the moment
I have a datagridview getting its information from an XML file, I was wondering if you have the one cell selected, how you get the other values of the cells in the same row?[code]...
I am trying to read a 16bit binary file (tif image) and pixel values of the image ranges from 1200 to 4500. I tried to use BinaryReader using ReadUInt16 but I get EndOfStreamException Unhandled error. ReadByte method works fine with an 8bit tif file. I do not know how to read a 16bit image file using binaryReader. Shouldn't I use ReadUInt16 since values of pixels range from 1200 to 4500?
product number | product name | dosage | description | price | remaining box(es) 0023 amoxicillin 50mg none 50 50
i am having problem in my buy button. how can i manipulate the value in the remaining box(es). for example, i select the item named amoxicillin, and i entered 5 on my textbox. when i press the buy button the value in remaining box(es) will be 45.
I am trying to retrieve cell values from a datagridview.I am trying to use the DataGridView.Item().Value property to pull each cell value into a temp variable to it can be added up, but for some reason it is not accepting any variables that I use to count the rows, only integer values.Here is an example of the code I am using.
Dim tempVariable as Decimal Dim i as Integer Dim Total as Decimal
[code]....
For some reason it does not like the variable i, and only wants integer values.
I have an image column in a dgv. I set the value from My.Resources.XXX.How can I compare the value of the cells with an image in the resource? dgv.rows(0).cells(0).value=My.Resources.S_DEFECT don't seems to work. I tried it with object.equals, but no success.
I'm trying to populate a ComboBox with all column headers I have in my Excel -file... Dim Polku = fdlg.FileName Dim XL_App As New Excel.Application Dim XL_WB As Excel.Workbook = XL_App.Workbooks.Open(Polku) Dim XL_WS1 As Excel.Worksheet = XL_WB.Worksheets(1) with ComboBox1 [Code] .....
All I get are 10 values that are: System.__ComObject
Even though I should get in the dropdown list: No: Title Dept. Item Spec. Size.
I have a project due tonight and suddenly 2 of my datagridviews are acting funky while the others are fine.
I have 2 tables in an sqlce db. the first is books(id, title, copyright) and the next is publisher(id, name, bookid). I'm writing a vb.net frontend to access the data.
I have data bound datagridviews for both tables. Both have their respective ID columns hidden. The publisher dgv uses a combobox cell style to display the book title in the bookid column. So far so good.
I have suddenly run into a problem where if I have clicked in a cell on the books dgv and then click a cell on another row, the title changes to the id value. The publisher dgv also updates to show the id instead of the title.
It sounds to me like there may be a problem with the booktableadapter or bookbindingsource, but I don't know where to start looking for it. I have a 3rd dgv referencing an unrelated table, and it has no problems. The code for both the working and problematic dgvs are the same (only the control names are different).
The above code is inserting first row of datagrid cell value, but I want to insert all the datagrid cell values. How to modify my code for getting all the datagrid cell value.
I programmatically edit my datagridview cell values. I use the vertical scrollbar to find the row I want to edit, select the row then click an edit button that takes me to another form where changes to the record are made. I then click a button which saves the changes and returns me to the datagridview form. No problems here.
When I return to the grid, the records are displayed with the first record at the top of the grid. That is, the vertical scroll bar has repositioned itself to the very top.
Is it possible for the datagridview to "remember" the position of the vertical scroll bar so that when I am returned to the grid, the rows displayed are the same as when I left?
This is bugging me. I have a "main" form named frmMain with a DataGridView object named objDataGrid.When a user double clicks on a row or clicks another button, I hide the main form, open a new form and want to reference the values in the row selected by the user but I keep getting an error when I try to access some, but not all, of the datagridview's properties.
I want to programatically add a background image to individual cells in a datagridview for easy identification, prefirably in the right bottom corner of the cell.
I want to make a certain column of my datagridview red based on values from 2 other columns. I have a "HI" column, a "LOW" column and a "Result" Column which are all strings. Now I want to make the result column red if it's values is less than the "LOW" columns value or if it's value is greater than the "HI" columns value. I tried the following code but something is wrong because cells that shouldn't be red are red:
Private Sub dgvTests_CellFormatting(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewCellFormattingEventArgs) Handles dgvTests.CellFormatting If dgvTests.Columns(e.ColumnIndex).Name.Equals("Result") Then Dim RowValue As DataRow = TestTable.Rows(dgvTests.CurrentRow.Index) [Code] .....
I have made a little bit of code which forces a naturally diverging iteration loop to converge to the value I need, excellent, but it currently is controlled by a button which I click to execute it. What I want to do is to automatically run the module when one of the input parameters changes, to find the new equilibrium value. Forgive me if this is really simple stuff, but I just can't figure out how to do it.
I have a MySQL database which acts as a source for a datagridview, is there anyway I can set colors to the rows based on values in a cell? So that if the value in a row in the field "Priority" is "yes" then the row is red?
I want to display image next to the text in each row in a datagridview. I have searched the net in the past 1 hour, but no big success. I know, that I must override the cellpaint event, but how?
I'm aware that the tooltip object can contain an image. I am unable to make an image popup when the mouse hovers over a datagridview cell, since it is not possible to attach a tooltip object to a cell ( myTip.SetToolTip(gridCell, "Hello") generates a compile error)
Im working with a DataGridView with an imported CSV file where the values are delimited with (,).. The grid works perfectly fine. My ultimate goal is to hide the grid out of view from the user and access the data in the grid based on the coordinates of the grid specified i.e (The cell in column 5, row 6 contains the value "Taco") and I want to save that value to a variable...Eventually I want to loop through all the values of a column and save them to individual variables to be later used. So far, this is what I have...
Dim sReader As New StreamReader("book1.csv") Dim Record() As String For x As Integer = 0 To 17[code]....
Presently, that will only display the data in column 0, row 0 in those labels...
Note: 17 in the for loop is the amount of columns in the data i provided.. that number will never change.
I�ve tried two different ways to open the file. The first one, is storing in a variable of type string,
Dim srTrad As New System.IO.StreamReader(fichToOpen, System.Text.Encoding.ASCII, True) sLine = srTrad.ReadLine()
so what I get is �2C0A0B453238�. Then I try to put them in pairs and reading as a HEX value, but I can�t. The only thing I get is the hex value of �2�, �C�, and so on. This is not what I�m looking for.
The second way is storing the values in a variable of type Byte:
Dim srByte As New IO.FileStream(fichToOpen, FileMode.Open, FileAccess.Read) Dim br As New IO.BinaryReader(srByte) Dim data As Byte() = br.ReadBytes(CInt(numBytes))
The result here, is pretty the same as before. For the pair �0A� what I get is either (30,41) or (48,65) (hex values or Dec). What I need isn�t to convert a char to its Hex value (I saw several examples for this on this forum). What I need is to know that 0A means 10 (0A is a hex value itself)