Is there anyway to turn on/off selected cells on a dbgrid. I know you can change the background color but I want all cells to lose "focus" completely as I think they are interfering with the visible property of the rows when I try and hide certain rows.
View 12 RepliesI have DataGridView1 where there is numeric data present. I want the sum of selected cells of DataGridView1 in my TextBox1 just like MS-Excell. How can i do this?
View 6 RepliesI have a DataGridView with cells from a database file that contains data. Basically, I want to get the text from the selected cells in the DataGridView and display it in a textbox at the click of the button. The code for the button click event is:
Private Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim SelectedThings As String = DataGridView1.SelectedCells.ToString
TextBox1.Text = SelectedThings
End Sub
However in TextBox1 I get:
System.Windows.Forms.DataGridViewSelectedCellCollection
I'm thinking it isn't as simple as it seems. I'm a C developer just learning VB.NET.
VB 2010 form has 1 panel, 1 DGV in the panel, 1 TabControl with 3 tabs in the panel each tab has a DGV all 4 bound to the same DataSet through code.
I have a form that has multiple Datagridviews on it, 1 in the main portion of a panel and the other 3 in a tabcontrol. If I click on cell 0,4 of DGV1 cell 0,4 of DGV2 is also "hilighted" and the same goes in the reverse order. If I click on cell 1,4 in DGV 1, cell 0,1 is hilighted in DGV2 (basically it stays with the last selected col and what ever row for that DGV).
This isn't the functionality I'm really looking for here, when I single click or change cells on any of the DGV's I don't want any of the others doing anything.
As you can see there are 2 cells selected this was created by a single click in the 4th cell of Param0
Is this possible after binding a data source to it?
View 2 RepliesI would like to copy only the selected rows, but not all cells, only the ones I set in the sub, from one datagridview to another datagridview.
View 16 RepliesI've an excel sheet which is populated with thousands of rows of data, is there a way in vb.net I can pick out only selected cells/rows without having to go through every row?
View 2 RepliesI have a data grid view control which i populate using a random access file. What i want to do is when a user clicks on a cell, i want the data held in all the cells in the particular row to be used to populate some textboxes. i have searched everywhere and they all use sql databases.
View 2 Repliesi am having some problems running some code when there is a cell within my datagrid selected.is there some code i can use to deselect any cells that are selected within the datagrid?i have looked into this and tried, but nothing seems to do the right trick.
View 1 RepliesI have a DataGridView. I'd like the user to be able to select multiple cells using ctrl/shift. Then, as they type, I want the contents to update in all the selected cells. I'd prefer it if this happened as they type but I'd live with it updating the other selected cells when they leave the current cell.
I've tried hooking in to various events to to this but in each case there seems to be one problem or another that stops me doing it.
The following code records the row and column of a selected cell.
[code]...
.
If MonthDGV.Rows(selectedRowIndices(0)).Cells(selectedColumnIndices(2)).Style.BackColor = Color.White Then but that is no use. As there could numerous selected cells all over the place, how would I check the BackColor of all the selected cells.
How can i replace selected cells in a datagridview by using copy and paste or some other method. I want to highlight a Row or Column and then replace all the highlighted cells with one value
View 3 RepliesI am trying to change the font color of cell(s) that are selected by the user. So, the user highlights the cells, then presses a button to change the font color. I tried using datagridview1.selectedcells, but couldn't figure it out.
View 8 RepliesMy current code: Server: Imports System.IO Imports System.Text Imports System.Threading
[Code]...
I'm making a custom control suited for handling passwords. I have created a control that inherits from a text box and I have implemented a lot of things so far. But what i want to do now is create a system so that when a user types It will display his last character typed for a X amount of time. Is there a way to turn only selected characters into password characters and still be able to get the password text from the Text property ?
View 4 RepliesRight now I can add background music in my program by using this code
My.Computer.Audio.Play(My.Resources.Music_3, AudioPlayMode.Background)
I can also turn it off and change the music by using this code
My.Computer.Audio.Stop()
My.Computer.Audio.Play(My.Resources.Another_Music, AudioPlayMode.BackgroundLoop)
Is it possible to pause the music then if I resume the music it will just continue the flow? I mean if I pause the background music in 33 seconds and the music has 50 seconds and I resume it will just continue playing in 33,34,35 etc.. seconds?
I was wondering if their was a way to for me to turn off events and then turn them back on in my program or just queue them up until i am ready for them to be excuted. Kinda like how a OS turns on and off interupts. Is this one of those general programming no-nos?
View 1 RepliesMy main goal is to have an excel spreadsheet that automatically plots the overall success of my stock portfolio over time (% change over time). I've been able to incorporate stock data into my spreadsheet by linking it to the web, but the trouble is the spreadsheet will keep no history of what the previous stock values were, so I can't graph how things change over time. This sounds like it might be too complicated to be built in to excel, so I was wondering if anyone knew how to program this in Visual Basic. Maybe something like this.... If refresh then new cell plus new time stamp. Another possibility would be to have a whole bunch of cells that refresh only once but at longer and longer intervals, e.g.,
[Code]...
I have a DataTable and want to connect the cells of one of its columns to cells in some other DataTables.
For example:
DataTable1.Rows(0).Item(2) is connected to DataTable2.Rows(4).Item(6)
DataTable1.Rows(1).Item(2) is connected to DataTable4.Rows(2).Item(3)
DataTable1.Rows(2).Item(2) is connected to DataTable3.Rows(11).Item(4)
...
How can I do this?
I'm making a custom control suited for handling passwords. I have created a control that inherits from a text box and I have implemented a lot of things so far. But what i want to do now is create a system so that when a user types It will display his last character typed for a X amount of time.Is there a way to turn only selected characters into password characters and still be able to get the password text from the Text property ?
View 3 RepliesAs easily as possible? How to parse and create XML easily?
View 3 RepliesI want to take my dataset and convert it to an xml string.
View 2 RepliesI have code bellow. Why it doesn't work?
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
SendKeys.Send("{NUMLOCK}")
End Sub
I'm learning vb2008 from a book, and I just can NOT figure out how to turn on the "ViewerForm.vb [Design]" when it's not showing up as a tab.
View 6 RepliesI want to make a simple program with I can turn on/off litle USB LED.
Nothing special, just one small LED as you learnt in 8th grade.
I think the simpliest way to do this is "powering off" USB port. But how?
I'm using Visual Basic 2008 Express Edition.
How do I turn off a monitor using VB.NET code? OK, actually I found the C# solution. But I need the VB.NET solution. I have tried an online C# to VB.NET converter, but the converter is complaining that there are errors in it.How can the following C# code be translated to VB.NET?
[Code]...
my query is this: I want all of the characters that are of a membership level in a given area that is of admin or above.
This is what I have so far:
Dim L As List(Of Character) = (From C In MasterCharacterList.Characters.Values _
Where Me.Item(C.CharID).DreamLevel.ContainsValue( _
(From L In _Levels Where L.Value.Admin Or L.Value.BotMaster Select L.Value.MemberLevel).ToList.ForEach) Select C)
Me, in this case, is the members collection.
So far, I can't get the query to turn into a list (hence no .tolist at the end.) I know there's something wrong here, but I'm not sure what.
I would like to turn of this exception in the debug menu but I am not sure how or which one to uncheck or check.."ObjectDisposedException was unhandled"
View 6 RepliesI am making a small guessing game, and I have a numerical number box in the option forms which sets the max number that can be generated. Because of the way I get the variable it wont update that value correctly. To fix this, I have a label which, upon closing the form, is set to the number of the numerical number box, and the max value is gotten from that label. My question is this: How can I convert a string to an integer? I tried one way, but got (i think, i cant remember exactly) a "First class expectation error" and something to do with "vbexpress.dll" (again, not the exact name) This then caused my Laptop to lag up so much that i couldn't do anything, and had to force crash it. So again, my question is this: How can I convert a string to an integer?
View 3 RepliesI have an array of conditions with elements like "thunderstorm", "severe thunderstorm", etc. I want to loop through the elements and, for each element, check a registry key. Then, based on that registry key I want to either check or leave unchecked a checkbox called TornadoCheckBox, SevereThunderstormCheckBox, etc.
Here's what I've got so far:
Dim ConditionsArrayString() As String = {"Tornado", "Thunderstorm", "Severe Thunderstorm", "Hail", "Snow", "Heavy Snow"}
Dim CurrentConditionString As String
[Code]....