I try to select the last row like this:
Dim lastRow As Integer = DGV.RowCount
MsgBox(lastRow)
DGV.Rows(lastRow).Selected = True
The messagebox returns the correct number, but when it comes to select that row it says:Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index
But if I assign it a row, example: DGV.Rows(5).Selected = True
Is there a way to make a column unselectable? I can make the column read-only but it would be easier if it was unselectable so the user won't be confused trying to enter data into a read only cell. So if I clicked on a cell in that column or moved into that cell in that column it would jump to the next column, or not focus on the cell at all.
View 4 RepliesI Have a problem with selecting a row in a datagridview. I want the user to press on the data rowheader of the data gridview of a particular row and then that rows first item are put in a string. But the problem is that if i Select an item another item is still selected. So If I press the mouse button on the row header the previous item is still selected and then the wrong data is in the string. Here is the code under the event of the datagridview mouse click:
Private Sub dataGridView1_MouseDown(ByVal sender As Object, ByVal e As MouseEventArgs) Handles DataGridView1.MouseDown
Dim hit As DataGridView.HitTestInfo = DataGridView1.HitTest(e.X, e.Y)
Dim index As Integer
[code]....
I have a datagridview that is bound to a dataview. I use a textbox to sort the list of data in the datagridview. Once the list is sorted I want to click on a row to populate the textboxes in order to update the data. Problem is once I sort the data I click on say row 3 and it pulls up the orginal data before the data was sorted in the datagrid view. For instance:
Before Sort:
1. betsy
2. james
3. john
After sort:
1. john
2. james
3. betsy
If I double click row 1 it will pull betsy info into my textboxes instead of john. I currently refresh my datagridview after every letter is entered into my textbox. I also reload my dataview and rebind the dataview with the datagridview.
Currently I am using this code to fill my datagrid.
Dim da As New SqlDataAdapter("Select id, name, type, add1 from [company_details]", con)
Try
If Pdetails.Visible = True Then
con.Open()
Dim ds As New DataTable
[Code] .....
I have a bound datagridview containing 4 columns. All I want to do is click on a row and then assign the value for each column to other controls (in this case textboxes). My problem is, I'm not sure which Event to use. I don't know how many events I've tried the code below in several different events but none of them are working.[code]
View 5 RepliesI have a strange problem with a DataGridView I'm using which is bound to a table in VB.net
I've added a checkbox column to allow a user to tick a bunch of rows that I can then loop through and save off to a different table. All the checkboxes are enabled by default. So it's really a case of unchecking the rows which aren't required.
However, the DataGridView re-enables any checkbox that I click after I click on a checkbox in another row. So in effect, only one row can be unchecked at a time.
EDIT: I forgot to mention this is a Windows form, not an ASP.net application.
I have a DataGridView that is being populated. What I'm trying to accomplish is when I select like 3 rows I click a button and it gives me the "row numbers" for those three rows.
View 3 RepliesI have this datagridview on form1. It can select the items that be selected. But the problem is I want to select all the items. Here is the code that the datagridview can select one by one:
Dim i As Integer
Dim ds As DataTable = CType(DataGridView1.DataSource, DataTable)
Form1.TextBox1.Text = ""
[code].....
how can i select full and first row of datagridview in vb.net on form_Load
View 2 RepliesWith the two lists (t1s and t2s), I want to display t1s in a DataGridView, and in one column show the T2 property as a comboBox column, which dropdown will show the t2s list such that a new list instance can be selected. T2 has a Name property that should be used for displaying it in the comboBoxColumn.
I'm able to display the dropdown, but remaining a few problems:
1. How to display the correct comboBox "selection" on "load"?
2. How to change the T2 child object instance when combobox selection is made?
3. This is a really basic problem, which suddenly happened and I just couldn't understand what I have changed; The code marked BLUE now just shows empty cells.. While the AutoGenerated columns do show values.. Shouldn't those "manual" columns work?
[Code]...
NB: I'm using Visual Basic.NET?My form has 2 DataGridView controls. One of these is bound to a DataSet, the other isn't visible - at least not until the user selects a uniqueidentifier cell in the 1st grid.When the user makes this selection, the 2nd grid will become visible and display the row from another with the same id as the one selected in the 1st grid.So, basically, I want to dynamically display data in one grid based on user selection in another grid.My code looks like this so far...
Private Sub RulesGrid_CellClick(ByVal sender As System.Object, ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles RulesGrid.CellClick
Try
FlagsGrid.Visible = True
[code]....
I have created a bound DataGridView and then added an unbound checkbox (name=select) for selecting multiple rows. The problem I'm having is the row doesn't actually get selected when I set .selected to true which I'm doing in the CellValueChanged event. When I trace it the code is properly executed but the row is not highlighted when the checkbox is checked and consequently not selected in the grid.There is no mouse or keyboard and the input device is a USB button panel which we built.
Public Sub dataGridView1_CellValueChanged(ByVal sender As Object, ByVal e As DataGridViewCellEventArgs) Handles DGV_Categories.CellValueChanged
If DGV_Categories.Columns(e.ColumnIndex).Name = "Select" Then
[code]....
I have a datagridview and some code that will seek out the appropriate row and select it programmatic.
For intIndex As Integer = 0 To ofrmMasterList.dgvMasterList.Rows.Count - 1
If ofrmMasterList.dgvMasterList.Rows(intIndex).Cells(0).Value = strMasterID Then
ofrmMasterList.dgvMasterList.Rows(intIndex).Selected = True
[Code].....
The above code works like a charm, except that my selecting of the right row does not fire the datagridview 'selectionchanged' event like it would normally do if I just clicked on it manually.
what I need to do to get the grid to fire off this event after selecting a row with code instead of a mouse click?
I have a datagridview with data in it, i have set it so you can only select the row and one at a time.However, i need to get the data from one of the cells in the selected row, i have tried this
View 2 RepliesI've been looking everywhere for an answer to a simple question, but i'm having issues, so i thought i'd join and post here. I'm having issues with a simple concept. I load information from a SQL database, and i want to add a 'Passport' link URL relating to column cells called 'name'. It basically selects the name, and inserts it into the link fields to be opened. But i cant find a way to work it. I thought i could do it with something like:
[Code]...
I want to select records from a access table using sql in vb.net 2010 based on what a user types....
My statement is: comm = New OleDbCommand("SELECT * FROM Recipes WHERE RecipeName= '" & TB1.Text & "')", con)
this only selects records where the full word is the only word in the record set.
I want to type say "Vodka" in the search box and then it must return all the records where "Vodka" is ANY part of the record name: ie: "vodka" or "Vodka" (any case letter) or "Blue Vodka" etc.
I am trying to select records from a table using the following command
SQLStr = ("SELECT ItemCode, PriceSold, WhenSold, WhoSold from SoldItems where WhenSold = '" & DateTimePicker1.Value & "'")
I get the error message
[code].....
Using Excel 2007 and VB 2010...I'm trying to have my program select a specific worksheet from a workbook yet my program keeps opening whatever sheet was active at the time of the file being saved last. Here is my code for that
xlWorkbook = xlApp.Workbooks.Open("MyWorkbook.xlsx")
xlWorkSheet = CType(xlWorkbook.Worksheets("My Worksheet"), Excel.Worksheet)
I have an application written in VB.net for batch print jobs. As part of the application, the user selects two printer trays to use to print the batch to (one plain paper the other coloured for coversheets and batch seperators) I had this working until we upgraded our systems from Windows XP with Office 2000 to Windows 7 and Office 2010. Now the selected trays are not being recognised and an error is thrown.
I've looked at similar posts on here and other forums but they seam to concentrate on using some word default trays (wdPrinterDefaultBin etc) however I need to be able to let the user pick whatever tray they wish to use. I don't want to have to go through every printer in the building and map the trays to the word values either as I don't want to rewrite the app everytime we've a new printer.
Here is the code:
sub PopulatePrinterTray (byref Printer as String)
'gets printer trays for selected printer and then populates some comboboxes
Dim pkSource As Printing.PaperSource
Dim printDoc As New Printing.PrintDocument
[code]....
I have tried the following:tabsmain.SelectedTab = tabNew
and tabsmain.SelectedTab = tabsmain.TabPages.Item("tabnew")
As per articles found through Google.
These don't seem to work though.
how do I go about selecting a time of day in a form??
I have tried using a datetimepicker but it just selects a date and it displays the static time (current time).
I'm am trying to determine the total number of fields under a particular heading given that the other Heading's total number of fields are > or < than the heading in question. The query, shown first in the attached code, works well if there is one column in one database table, however it does not work well when there are a number of columns with a different number of fields respectively. The CategoriesID encompasses the entire tables contents.I devised a function to determine the total number of fields within a particular column and then attempted to incorporate this, without success, into the second query, shown in the code.
Private Sub GetRandomHeadingFields()
Dim varNumberHigh As Integer
varNumberHigh = TotalNumberofHeadingFields()
[code]....
Can I select all buttons in my form on mouse hover event in few lines only?I want to add hover sound effect on all buttons when hovered.
View 2 RepliesI have a datagridview populated from a CSV file in vb.net. I have 2 datepickers, 1 button. see the attached images. Image1->before filtering
[Code]...
I have two datagridview's both are databound. First one shows items for sale and the second stores all the items that were sold. I am trying too transfer selected rows from one to the other but no matter what I keep getting told "Rows cannot be programmatically added to the DataGridView's rows collection when the control is data-bound."
View 2 RepliesI have a datagridview extracted from a csv file. It displays duplicate rows. How can I delete those duplicate rows from the datagridview? replies would be precious.
[Code]...
I've made an add button and I want it to add another row to the DGV and fill it with data from a database query.
Me.DataSet.App.Rows.Add() - this does add a new empty rowCode for filling the DGV with a query:Try Me.English_AppTableAdapter.FillBy1(Me.PunchDataSet.English_App) Catch ex As System.Exception
[Code]...
I used MSFlexGrid in VB6, now I've gone from little in VB10 and use Datagridview .... I want to read the contents of a single cell in a particular column and row selected with the mouse...
View 1 RepliesI have a unbound datagridview. I want to find the minimum and maximum value in a column in a datagridview, how can I do this?
I also would like the "address", or row number of these values,