So I have a class that I use to filter the results of a datagridview in vb.net. And one of the things I want this class to do, is keep the column order, width, and visibility.
So what I do, is when my search class is instantiated, i create a copy of the columns in a hashtable, for later referencing.
Private dgv As DataGridView
Private dataSet As DataSet
Private bindingSource As New BindingSource
[Code].....
i am having trouble putting a value in a textbox. Each time a ticket is sold i put the total price in a textbox, each time a ticket is sold for the same concert it increases by adding its self to the total price. It works at the first sale, but after that it breaks down. here is the code
Private Function DisplayMoneyTaken() As Integer
Dim totalMoney As Integer
'open the database connection
[Code].....
I would like to restore MySQL database , but it does not restore anything ,
Shell("C:Program FilesMySQLMySQL Server 5.1inmysql.exe --user=root --password=123 --host=localhost --databases test < C:.sql")
I am using Sub to format datagridview but during Form_Load this error occur. There are rows in datasource and dg.row.count is > 0.
.Columns(0).Width = 50 <==== ERROR HERE
.Columns(1).Width = 150
.Columns(2).Width = 80
.Columns(0).HeaderText = "ID"
[code].....
Is there a simple way to restore the state of DataGridView1 to it's original Form_Load state?
View 3 RepliesDoes anyone know if you can index controls now in vb.net?You could do it in VB6 - where you would have 6 radio buttons and if you copied the 1st it would ask you did you want to index the control.So you would have optName(0), optName(1), optName(2).... optName(5)It was useful to do a select case on the controls or else do a For loop on them either.I can't see anyway to do this in vb.net now, is there a way to do it? Or a workaround for this?
View 5 RepliesI have a utiility that users can re-order DataGridView Columns in to their hearts content. I want them to be able to create a named list so they can have multiple Column Patterns to choose from.When I restore though the re-ordered Columns are not where I saved them.
View 1 RepliesI am working in VB 2008 and I have set up a datagridview to display rows of data which can then be selected. When I select the first row I get the error: Index was out of range. Must be non-negative and less than the size of the collection. When I select any other row the program executes as it should. From what I have learned so far is that the DataGridView has an index of -1 and that it counts the header row as part of the index which is the -1.When I select the first row through either DataGridView1_RowHeaderMouseClick or DataGridView1_CellContentClick the index is 0 for the first record. If the index is 0 I think it would fire off, but I have no idea what is happening behind the scenes. I can check the index, so when it is 0 and the code attempts to access the row, that is when I get the message.On an index number of 1 and up the code executes fine.So, is there a way to re-index the DataGridView, or is there a work around/fix for this issue?
View 2 Replies[url]..I'm trying to use the Restore.Abort function during an SMO restore process - What would be the best method?
[code]...
Using Visual Studios 2010.I have a project form.on this form is a tab page with 7 tabs on it. i also have a listbox and 6 buttons.i have the listbox datasource set to the bindingsource i'm using and the display member set to name, the 6 buttons filter that datasource based on what i want them to filter it by.... what i'm trying to do is have the buttons filter that data accordingly then select the filtered item onto a different tab... I DO NOT WANT TO USE DIFFERENT PAGES. SAME PAGE, DIFFERENT TABS. Sorry, not yelling just want to make that clear.so say when the page loads my listbox populates with all my projects. i click the button that says "wood" and the listbox filters all the projects under wood. i want to be able to select 1 item and have it fill the dataset on the tab that is labeled "wood projects"...
Same with if i select "metal". listbox filters all the projects under metal, i select 1 item and it fills the dataset under the tab labeled "metal projects"... and so on...now i got the listbox to populate and the buttons all work as far as filtering....but how do i go about doing the select part and having it fill the appropriate tab page?
In my program I allow to the user to change the columns Display index of a data gridI need to save the new Column Display index in a database so I can use it to display the columns in the order that the user want the next time he opens the form
View 1 RepliesI want to display the index number of the selected record in a listview box as it is clicked by the user. I can do it with multiselect set to false and the following call.
Private
Sub ListView1_SelectedIndexChanged(ByVal
sender As System.Object,
ByVal e
As System.EventArgs)
Handles ListView1.SelectedIndexChanged
[Code]...
This works fine except for one thing! after I click OK to the msgbox prompt, the record highlights normally and I click on the next record, and I get an Argument out of range exception error message, where I expected to just get another message with the next record number.
I have the following code:
indexOfSearchText = TextBox1.Find(item, start, TextBox1.TextLength, RichTextBoxFinds.WholeWord)
If indexOfSearchText <> -1 Then
startindex = indexOfSearchText
End If
But I want just the first result, if I have an example text:
then it searches twice "is", I just want the first "is".
I have an app where i have two list views
[Code]...
I clone the information to the empty listview2 from populated listview1 adding quantity via a numeric up/down. That works to a certain extent but problem is it adds another instance of the added item each time I press buy. I would like the items to appear in listview2 according to their index value in listview1. And when I press buy the app change only the quantity in column 2 if the item is already in listview2, if not just add the new item.
In vb.net using Data Reader while selecting an value in combobox should display an selected value record from the database into textbox.
View 4 RepliesI wrote a small VB6 program to monitor the status of a Shared Network Drive. In this case it's an external hard drive. The drive is used for backup. The program is invoked automatically when the computer is booted and runs minimized.
If the backup drive is not turned on or otherwise not functional then the program changes from minimized to a normal window and displays various statistics and a warning that the backup drive isn't working.
I want to make the warning much more prominent, like minimizing the program that happens to be running or displaying the warning window in front of the progrmam that happens to be running. I want something really noticaeble. The computers don't have speakers so I can't play an warning.wav .
I have a lot of files in my computer.Here is an example: C:Data3023e4rMarch_20113023e4r_03112011_062334.docC:Data3023e4rMarch_20113023e4r_03142011_092301.docUnder the folder March_2011 has a lot of doc files. The file name string 3023e4r is the serial number,03112011 - the date created,062334- time created.I'm planning to have a text box,where i could enter the serial number. then it will display the files under March_2011.I want the filename string to be displayed in datagridview column with their respective heading(SErial number,date, & time)
View 2 RepliesI can't manage to display unicode characters in VB.NET.I'm doing this in C#:
string myString = "u03A3"; //upper case sigma (sum)
But it doesn't work in VB and I can't find a way to make it work.
why i am unable to display datas from database.
If mConnection Is Nothing Then mConnection = New Odbc.OdbcConnection
' check if the connection is already open
If mConnection.State = ConnectionState.Open Then mConnection.Close()
[Code].....
I wrote the following program in vb.net. I am reading 2000 data points XY points from csv file into oledb connection and displaying it into the MS cHART but it is displaying only first 500 points...
Dim cn As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:;Extended Properties=""Text;HDR=No;FMT=Delimited""")
Dim da As New OleDbDataAdapter()
Dim ds As New DataSet()
[code]....
I'm unable to get the color to display in the colorLabel. I think the problem is in my selector expression. I tried "B", "##[B]##", "##B##"
Option Explicit On
Option Strict On
Option Infer Off
[Code].....
I have a DataGridView containing a large number of columns. I want the users to be able to select multiple columns and then select a menu item to hide the selected columns. For example a user might selected columns 5 through 10 and I want the program to hide those columns. I know how to hide columns, one at a time. I can get the count of selected columns but I have not figured out how to get the index to the left-most selected column. Trial and error is such a slow process.
Considering the huge number of options offered by the DataGridView tool, it would be nice if this forum had a special category for the DataGridView (common to VB and C#).
Finally I got the desired results but it took a lot of coding, looping through the selected cells to find the one with the lowest column index, then a second loop to count previously-hidden columns, then a third loop for hiding the selected columns, stepping past previously-hidden columns and declining to hide frozen columns.
Is there a way to force my application to ignore the index out of bounds error from the DataGridView? I have gone through from top to bottom and there is no reason why I should be receiving this error. No operations, rows, nor columns are affected by just continuing past the er
View 5 RepliesI have a datatable with 10 records linked to a datagridview. When I initially load the datagridview, row 0 in the datagridview = row 0 in the datatable - based purely on the order they load, and the datatable's default sort order. I then filter my datagridview and am left with 5 records. Is there a way of determining programatically, the actual datatable row number of a row displayed in a datagridview, considering that row 0 in the datagridview is now not necessarily row 0 in the datatable?
View 6 RepliesI am wondering in row in the datagridview, How can i show the row index in the row header?
View 1 RepliesI'm trying to set a background color for a row in my datagridview. Here is the code I'm using:
[Code]...
I have a column in a datagridview that is a combobox with 4 items in it. I can use this code to see the text value of the selected item:
View 2 Repliesvb
Dim CheckedRows = From dgv As DataGridViewRow In Me.DataGridView4.Rows _
Where dgv.Cells(0).Value = True _
Select New With {.a = dgv.Cells(1).Value, .b = dgv.Cells(2).Value}
my code above works fine but how to get the index of the row on which the checkbox is checked
If i try
ListView1.Sorting = SortOrder.None
ListView1.ListViewItemSorter = Nothing
ListView1.Items.Insert(0, "0")
ListView1.Items.Insert(1, "1")
ListView1.Items.Insert(0, "2")
ListView1.Items.Insert(1, "3")
If ListView1.View is SmallIcon , LargeIcon or Tile it dont work (Display 0 1 2 3). If it's in List it works (Display desired 2 3 0 1).
I am using VB.Net 2010, and when I run the following code, I get System.Data.DataViewManagerListItemTypeDescriptor displaying in the dropdownlist box
cmbProdType.DataSource = ds
cmbProdType.DisplayMember = "ProductType"
cmbProdType.ValueMember = "ProductCode"
When I hover over the datasource, I can see the correct records. But its not displaying in the dropdownlist control.