I have several forms that have a DataGridView object in them. I recently discovered the AllowUserToOrderColumns attribute. I set it to true and I can reorder the columns at will. The problem is that the order for these columns is lost once the form is closed. Ok, how do you save the order for these columns and then restore them to the form once it has been reopened?
View 4 RepliesSometimes I select a value in my Combobox by hand, and sometimes the value to show is chosen elsewhere in my program logic. I want to carry out a certain action only when I have chosen a value by hand, and not when the value is changed by the program. For this reason I use the DropDownClosed event (and not, for example, SelectedValueChanged or SelectedIndexChanged). This works fine, but if I set AutoCompleteMode of my Combobox to Suggest, selecting a value from the suggested list doesn't fire the DropDownClosed event (perhaps logical, as the actual drop down list doesn't actually open).
View 2 RepliesI have a databound Datagridview. The DGV is bound to a datatable of a strongly typed DataSet created using the wizard. Is there any way to re order the columns before displaying them eg: the Columns are displayed in the DGV in this other Col4, Col6, Col3, Col1,Col5, Col2
But I want to it to show as Col1, Col2, col3, Col4, Col5, Col6?
I realise that the display order followed the Column order in the database table and by extension, the datatable. I have re-arranged the columns in the Database but the Datatable still retains the old order.
How do i change the column order of a datagridview in code.
View 1 RepliesI have a DataGridView bound to a list of business objects:
Dim template As New IncidentTemplate
Dim temps As List(Of IncidentTemplate) = template.LoadAll
Dim bs As New BindingSource
[code].....
I am using a modal form with a datagridview in order to populate textboxes on a parent form. The datagridview is bound to an anonymous type resulting from a linq query, which varies depending on the textbox control whose keypress event is called. I always want to display a key value in column 0 of the datagridview (along with a variable number of additional columns), and then use that key value once the user selects a row.
However, when setting an anonymous type from a linq query as the datasource for a datagridview control, the columns are indexed alphabetically rather than in the sequence selected in the query. This requires setting the displayindex as a workaround, and then keeping track of which column contains my key value. I read elsewhere that this was something fixed in VS2008 SP1, but I still encounter the behavior.
I'm retooling an app, and condensing my queries down to one, but to do so, I would like to move the columns for better presentation. I am reporting on errors for particlular equipment, and the user may want to get equipment by errors or errors by equipment. Is there any way to change column order?
View 5 RepliesI have an unbound datagridview that has 2 columns. Both columns contain numeric data only and will only go to 55 in count. How do you sort a Datagridview Column in collating sequence? I basically want to sort from 55 down to 1 and 1 to 55 in their respective numerical order.
View 3 RepliesI have a DGV.It has some columns.The columns are in the correct order e.g. 1,2,3,4 at design time.When I start debugging and then come back to VS, the order of the columns have changed and I have to put them back in the correct order everytime.After some testing I have realised it only occurs if
1) I make a change on the form that holds the DGV
2)Leave the form open in VS while I play the application ie. debug.
I have a datagridview which has mixed values in one column. Is there a way to add a control into the Value cell depending on the row? For example, for Name and Age row, it will be a regulator textbox but for the Products row, I want to be able to add a combobox.
View 2 RepliesI have a datagridview with 3 columns. The second column is a combobox which I want to bind with a dataset. How do I go about setting the column index for it as I am doing something like this.
Dim ComboCol As New DataGridViewComboBoxColumn
ComboCol.DataSource = SDS.Tables(0)
ComboCol.ValueMember = "Specie"[code].....
How to set values to a predefined combobox column in datagridview i.e., I want to set some values to this column other than binding
View 1 RepliesI have a databound DataGridView, and I'd like to keep one column in front, with a slightly smaller width than the default. The grid's AutoSizeColumnsMode property is set to Fill so that the columns fill out the entire grid. This makes the first column equally large as all others, which is why I need to set its width manually. The smaller column is the first one with the checkboxes. I have two grids that I need to do this with, and for some reason it works just fine with the first grid, but gives a null reference error on the second grid...
Here's the code for the first grid (working fine):
vb.net
Public Sub UpdateTodoGrid()
' Load todo items
todoGrid.DataSource = _TodoManager.LoadAll()
' Set backcolor
For Each row As DataGridViewRow In todoGrid.Rows
[Code] .....
As you can see, the code is exactly the same (except for not setting the BackColor of each row and not using the ReadOnly property*). When I run this code, it gives me a null reference error ("Object reference not set to an instance of an object.") on the line where I set the column's Width. Obviously 'col' is not Nothing (otherwise it would have errored before that line), and there's nothing else there that could be Nothing... I assume that something happens internally in the grid when you set the width of a column, and that there is a null reference there, but obviously I have no control over that.
The grid's are absolutely the same, as the second grid is just a 'copy' (meaning I copy/pasted it in the designer) of the first. So all their properties are equal. I thought maybe the ReadOnly properties were the problem, but I tried putting them in in the same way and the issue did not go away... The first grid is not ReadOnly (because the checkboxes need to be editable), but all rows except the first are, while the second grid is completely ReadOnly.
I have a DataGridView which contains a hidden column. On the BindNavigator SaveItem_Click event i need to populate the hidden column cell with the current date. I tried using the DefaultValuesNeeded event but it did not work out.
View 4 RepliesThis is something that has been bugging me for a while as it is easily fixed but not desirable.I have a DataGridView that has 5 columns. The first is called ID.In vb.net the following line gives an error "Object reference not set to an instance of an object": dgvJobs.Columns("ID").Visible = False ' ERROR dgvJobs.Columns(0).Visible = False ' OK
Obviously using the name is much better than a hard coded value to reference the column but wondering if there is anything i can do to get this to work correctly?The datagridview datasource is BindingSource control with the datasource being a dataset.
[Code]...
i am working on a college project in visual basic 2010. in my program, i noticed at the last minute that i needed to add a "main" window. in this main window, i want to have all my other forms opened by buttons (i know how to do that part of it).
the problem i keep having is the window with the options to save the information pops up, not the main window. is there a way to easily fix this? maybe a snippet of code, because the only way i can think of is to scrap the project, start over from scratch adding my main window first, then the others.
Is there an easy way to set the tab order for controls on a form in Visual Basic 2010 Express? I saw some references to a "View / Tab Order" menu item, but I don't see anything like this in the View menu when I am designing a form.
View 5 Repliesi am in need of some help getting my code working correctly like i am needing it to. Below is my code that when the user click on the textbox, it pops up a keyboard where they can click on any letter and it will type that letter into the textbox. Problem being is i can not seem to get the name of the text box to return so that it knows where to send the letters to.
[Code]...
How to control UAC manifest in XP.How to add manifest file in XP and build an application step by step.
View 1 RepliesI am currently dealing with a problem of saving an arraylist for a Client List for a company. This is what i have:I need to save the settings of the clients, so that when the program is closed and opened back, it will have the same list of people with the same information. I also need it to save the data as it is deleted from the list.
View 4 RepliesI'd like to have something like:
[Code]...
I just got this really cool 9" monitor (USB attached) which I will be using for dialogs in my vb application. Can someone tell me why this code displays on both machines? if I change screen=AllScreens(1) to (2) the form is only shown on the primary but I want to show it on the very cool USB screen.
[Code]....
I have a web browser with thumbnails on the homepage of recently viewed sites. I can't figure out how to save the images without saving them to a files. I want to save them to either resource files or a setting file;but i can't find a setting type that supports images!
View 6 RepliesHow to add a checkbox column at first column of datagridview including column header?After adding, how to code to "check all" or "uncheck all"?
View 27 RepliesHere is the code:
<%@ Page Language="VB" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<script runat="server">
[Code]...
I have this strange phenomena in which I load an Excel file. The Excel file consists of data arrange in columns having a column header. Once some computation is performed and another file is loaded into the datagrid, the column order of the new file changes .i.e the column header is changes its position from its original Excel file.
View 2 RepliesI have the following code to get the column names from my Microsoft Access database.THE PROBLEM is that the stupid thing orders it alphabetically for me. How do I get it to put the columns in order the way they are in the database?[code]I've also tried a different approach with a string array and for loop to "make it" go to the beginning, but proves my point that its stupid enough to order it for me.
View 3 RepliesSame thing I am trying to do in the linq order by. It's not working.I have column that is defined in the data base as string (Varchar) and I need to cast/convert it to integer before I need to sort it.What should be my linq statement?
View 1 Repliesi want prevent user order column.i have a datagridview , it has allowuserordercolumns properties and it is set to false. But i didnt see so. i still order column.how can i prevent user ordering column.
View 6 RepliesI know this is a VB.Net messageboard, but it can work with in all languages. Is there a quick way to complete a line (sample code):
//Setting variables set 1
a = e;
b = f;
c = g;
d = h;
.....
//Saving changes set 2
e = a;
f = b;
g = c;
h = d;
without having to type everything out...A technique using EXCEL or Notepad....Find and Replace. This would save a lot of time coding and becomes pain in the butt when you working with many variables.