I have a DGV that is getting created on loadup, getting the results from a SP. So in this case, I have a DGV that is not bound to anything. It only get bound to a datasource at runtime.I have specific values that I'm looking for. See code
If e.Value.ToString = "HU-3" Then
e.CellStyle.BackColor = Color.Chartreuse
e.CellStyle.ForeColor = Color.White
I have a DGV that is getting created on loadup, getting the results from a SP. So in this case, I have a DGV that is not bound to anything. It only get bound to a datasource at runtime.I have specific values that I'm looking for.[code]
View 4 RepliesI am attempting to copy the value of the TimeStamp in cell A6 which has the NOW() formula into cell A5 Based on a change in Cell A4. The catch is I don't want it to update every time the sheet is recalculated due to updating links in other cells on the sheet. ONLY when Cell A4 Changes. What do I do?
View 2 RepliesI am writing a windows mobile application based on GPS technology. everything is ready but I need the function which is used to retrieve GPS location coordinates (latitude and longitude).I declared latitude and longitude, but now I need the function of GPS to put it inside a button I created, get longitude and latitude values and save them.
View 1 RepliesI want to get the user's approximate location (down to like a 1km radius) by their IP. Is this possible in VB Express 2008?
View 4 RepliesI have several DataGridView's that are located in several different containers. I want to display a small form in a precise location relative to the RowHeader when the user's mouse moves over the row header of the datagridview. How can I get the screen coordinates of the RowHeader? The code below does not display the form in the proper location. I want the top-left corner of the form to be displayed 15 points to the right of the Right property and 15 points below the Bottom property of the RowHeader.
[Code]...
i have a chart of images.. and i want to load individual images into picturebox from that chart..chart = big image, eg alphabet chart. (yes i am creating a game for my small nephew.. pictures and alphabet) now, i want to show different pieces of images into picture box. like the A box, b Box etc one option is to cut the chart into pieces, save each piece with different filename and load individual filename into picturebox.but i saw somewhere that we can use pixel location to load images into picturebox..as i recall it required two pixel location, 1 was upper left and other was lower right.. and passing that pixel locations would load the rectangular image between those pixel locations into picturebox?
View 9 RepliesI'm having some issues with the suppression of the typical javascript and other scripting errors that show in the webbrowser.I have three webbrowsers. The third webbrowser goes out and determines some action based upon location. The one thing I'm having trouble with is this example. It states that it should work but the errors keep on coming.I attached some of the code below. Am I doing something wrong?
[Code]...
I'm displaying a table in a Gridview. Some fields contain 0 and 1, but mean Yes and No. When displaying the table in a Gridview I would like to edit the 0's and 1's to show Yes or No.
<asp:BoundField HeaderText="Gearchiveerd?" InsertVisible="false" DataField="BestellingGearchiveerd" SortExpression="BestellingGearchiveerd">
<ItemStyle HorizontalAlign="Center" VerticalAlign="Middle" />
[code]....
I have a context menu which is shown over a DataGridView as follows below. The Context menu is shown if the mouse up occurs over the second column of the DataGridView. I also have a bunch of event handlers set up for each item in the context menu. I now want to pass the location of the cell in the datagridview to the event handlers.Do I have to pass the NewPoint() to a public variable and then translate that into a cell location within the event handler?
Private Sub DataGridView14_MouseUp(ByVal sender As Object, ByVal e As MouseEventArgs) Handles DataGridView14.MouseUp
Dim hitTestInfo As DataGridView.HitTestInfo
[code].....
I am just for learning purposes trying to develop a one player text based game.
I have a rich text box (GameWindow)
I have a text box (InputWindow)
I have a button (InputButton)
and a bunch of labels that aren't really important
I have two questions first is easy probably. How do i get InputWindow to respond to me hitting enter when text is in it?
[Code]...
But if i plan to have more that is only going to increase the size and code needed and im sure there is an easier way i just don't know how to do it.
Here is what I need to do: I need to be able to go through the cells in my first column and find any that have four digits (and only four digits). When a cell is found with a four digit number I need to be able to bold that entire row. How can I do this?
I'm in VS2007. This is a datagridview program. Data populates the tables from a database. The cells in the first column that contain the data can contain between four and 8 numeric digits. I only want to bold the rows that have cells in the first column that have four digits.
I have a datagrid that will get built at runtime. So i don't now how many columns I may have.I know I can do a column count, and get a list of the names. So don't think that will be a problem.What I'm trying to do is change only the CELL color, not the row, or the column, based on the value of the cell.Below is something I started with, but it clearly doesn't work.
' For Each row As DataGridViewRow In Me.QDGV.Rows
' ' Get the READY value from each row as we loop
' strExt = CStr(row.Cells.Item(4).Value)
[code]....
write a macro that removes the letters "TBD" from any cell it is in in a range of cells (J5:PJ421)n a different worksheet. This is probably very simple, but I am new to VBA and can't figure it out.
View 1 RepliesMy datagridview consists of Three columns.
1st column is Datagridviewcolumn
2nd column is datagridviewcheckboxcolumn
3st column is Datagridviewcolumn
so 3rd column i made as readonly.so i need to enable the 3rd column cell based on the checkbox check properry
so i am generating datagridview column dynamically and populating values in the datagridview dynamically.so my need is after populating the value if i check the check box the current row of the 3rd column cell has to be enabled. so how to do this. please show me some sample code if there any. please
I'm trying to get a value in a datagrid to highlight based on the value from a textbox, I can't seem to figure out why it's not working right.
Dim xdata As String = TextBox1.Text
Dim cell As DataGridViewCell
Dim cellVar As String
[Code]....
As I have no idea on how to retrieve access data at the specific location in the table, so I wrote VBA code t export the entire access database to a datagridview which is located in the form1. There's a column of datagridview contain complete address information of a image. I'm thinking a way to link image source (of form 2 or xaml file) to the the column so that the image will be displayed. is there any code to get cell value at the specific location in the table? In excel VBA, sheets("Sheetname").Cells(rownumber, columnnumber).value is used to get the cell value, but how about code for this case?
View 2 RepliesI have a DataGridView that has been dragged over from the DataSource Tab. All works good.I need to have the background color of some of the cells changed based on other columns in that same row. Such as, have the background color of a cell Red if the Status column (not shown) relates to 90 days overdue. The next row may be different.
View 6 RepliesI am having a loading problem, the problem is my formating code takes way to long to load.
What I have is a datagridview that is loaded by one table and I want to format the cells based on data from another table, the following code works, but it gets slower and slower as I add more records to the data.[code]...
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 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?
View 2 Replieshow I can change the back color of a row based on a cell value using CellFormating event. The cell visible property is set to false.
View 10 RepliesI have a SQL database, with some "status" strings. For every status I need to display a .bmp image .
I'm displaying the data from the database via DataGridView with LINQ. In order to display the DGV I have this code:
Me.MyTableAdapter.Fill(Me.TestdbDataSet.MyStatusList)
I was thinking to add another column named "Symbol" and based on the "Status" column to format the cells of the "Symbol" column to display an image.
I edited the DGV, and add a new image column.
I created a directory in my solution called "references" where I put all the .bmp files
I don't know how to do this. My first thought was to put an expression in the DataTable Properties, but I didn't manage to make that work. Another way is to format the cells in the "Symbol" column, and again I don't know how to do that. I tried with "Select Case ... Case ... End Select" with no success.
LE: Should I Insert the .bmp files into SQL database (varbinary(MAX)) If yes, how?
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 a tablix with alot of rows. I use =Fields!LedningLaengde.Value to set the value in the cell, that's on a row in the Tablix..The new thing, is that the font need to be red if =Fields!LedningLaengde.Value is equal to -1 how can this be done?
View 1 RepliesFirst off, apologies, I am probably diving in a bit too deep with this one. I am trying to find the current version of the drivers in my machine. I have a list of the GUIDs and friendly names by using the following code:
[Code]...
I want to create a button that opens a supplied word document in their standard word handler like office or openoffice. But how do you find the Location of the exe (Or its folder) and using it to open the Word Document.[code]...
View 3 RepliesWhen a MouseDown event occurs on a System.Windows.Forms.DataGridView I'm performing some action. But now I only want to perform said action if the MouseDown event occurs on any part of the Grid EXCEPT for the Headers (row or column).
View 5 Repliesi need to find the location of element by index
example i enter 5 numbers
1 2 3 4 5
search a number, i search 3 it should display the lindex location? for me to understand more about vb,,more on arrays..
How can I find the location of my application's executable in WPF (C# or VB.Net)?
I've used this code with windows forms:
Application.ExecutablePath.ToString();
But with WPF I received this error from Visual Studio:
System.Window.Application does not contain a definition for ExecutablePath.