Hiding/sizing columns in data grid -
I have a data grid that is bound to a relationship of two tables in a dataset. The common field in the relationship is classId. When I view the data in the data grid I do not want to see the classId field but if I do not include the field in my select statement I get an error when I try to form the relationship. Is there anyway to hide a field/column in a data grid? ALong this line of questions, can the width of the data grid columns be dynamically set to fit the data in each column.
I can include code samples if needed.
Hiding/sizing columns in data grid -
I have a data grid that is bound to a relationship of two tables in a dataset. The common field in the relationship is classId. When I view the data in the data grid I do not want to see the classId field but if I do not include the field in my select statement I get an error when I
Hiding columns within a Data Grid -
Does anyone know how to hide columns within a Data Grid? I have a Data Grid who's DataMember is a Relationship between two tables in a Dataset. I have some fields on the Grid that I'd like to hide. How would I do this. I read something about DataGridTableStyles, but couldn't get it
Column sizing with MSHFlexGrid bound to a shaped RS -
I'm having problems sizing columns with a MSHFlexGrid bound to a shaped recordset. The shaped RS is built and bound to the grid with code. The problem appears when I try to hide (.colwidth = 1) the columns needed to build the shaped RS but don't want to display in the grid. The columns
hiding columns from a form's data grid -
Can someone show me how to exclude columns from a DataTable shown by binding it to a form's data grid?
I can create a DataTable using a SQL statement to get data from an ACCESS database. But, while I want to use all the columns in the DataTable in associated analyses, I want to exclu
Hiding rows/columns in Flex Grid -
We hide rows and columns in flex grids by setting the COLWIDTH or ROWHEIGHT to 0.
This has some odd display behavior. You can almost see the "hidden" rows - they make the "dividing line" between the rows less dark.
Has anyone else used a different technique f
sizing of columns in a grid -
How do you have vb automatically size a msflexgrid to the longest field in the record extracted from the database?
does anyone know?
Help with flexgrid row and column sizing -
Dear all,
I am new using flexgrid. I want to be able to resize the columns and rows in flexgrid by code. How can I do it?
Secondly, I want to use bitmap images in the grid cells. How do I address a cell in the flexgrid and put a picture into it. It was easier when I used MS Grid
Hiding ListView Columns...Using API -
Is this possible?
Basically I have a standard ListView, but the users now want to show/hide certain columns at run time. If this is possible, then great, if not, i will have to use another grid, that is able to hide it's columns...
Woka
[2005] Adding values to hidden columns in a DGV -
I have a DataGridView that is bound to a dataset. There are 5 columns in the dataset, however, only 1 is visible in the Grid. The grid is an editable grid. My dilema is, each time I add a value in the grid for the visible column, I need to add data to the other 4 hidden columns (I just
Datagrid when presses the keyup -
I would like to ask some few questions, about the Datagrid when presses the keyup key in the keyboard. Here's my code when pressing the keyup key.
Private Sub DataGrid_User_KeyUp(KeyCode As Integer, Shift As Integer)
If KeyCode = vbKeyUp Then
If DataGrid_User.R
grid controls -
Howdy all, so I am chugging along with my first real VB app, and now I am looking for a way to set number of columns in a grid, display the column title, and those columns' widths at design time, and then dump data into those columns queried out of a database, which can scroll up and d
Using Datagrids -
Hello all,
I am trying to use a datagrid with my VB form, however, I want the user to only be able to edit certain columns in the data grid. So basically I want some columns to be locked and others to be unlocked to updates... is this possible to do????
Also, I am trying to have the
[2005] Printing the contents of a grid -
if i have a grid on a form that has got a load of information contained in different columns, is it possible that when a button is clicked it prints out the data that is in the grid in the columns?
i am only using the express edition of vs 2005
Sizing columns ListView -
Hello,
I use a Listview control to display information. I preset the column width but the info varies that much that I want to change the column width at run-time based on length of the text that goes into it. I will size it the the largest text in the list at that moment.
Is the
[ RESOLVED ]Save from GRID -
Hi GLAD to see this forum back to business...
and now let me come back to the point. I have a table with 3 columns and I want to display all data in a GRID but I do not want a DATA BOUND GRID. I got that working fine.
Now the trouble is I can't figure out how to save all the cont
Change data in Data Grid -
Hello Friends,
I am developing one application in which I want to display data in data grid from one table. Now I want to add one column in which I want to enter data and as per entered data I want to update values in other columns. Plz can u help me how to do that using Data Grid?
how to add new cell in the Dta Grid control. -
I am using Data grid control and in this grid i want to add 12 columns but it is using only 2 columns and giving the error subscript out of range.
Freeze a column in ultra grid while scrolling -
Hi,
I want my first three columns in ultra grid to be freezed when the grid scrolls horizontally. ie when i scroll my grid, the first three columns will not be hidden. Only the rest of the columns should scroll. If any body has some idea about it, Please help me.
Thanks in advanc
List Box Columns -
I am using a list box to allow users to make multiple selections (checkboxes) but I also want to list other columns of data for each selection. Is there a way to create multiple columns of data for each checkbox that displays in the listbox? Or allow a user to edit data - like you coul
SQL and VB -
I am fairly new to VB and SQL....I am wanting to sort data in a data grid (bound to ADO control) by various columns ( i.e. like in MS Access....Rt. Click on column)
First is it possible to set up the Data Grid to do this and how?
If now how can I use SQL to Sort the columns?
T
Sizing a datagrid at run-time -
Hi all,
can anyone tell me how to size the columns in a datagrid at run time??? I am populating the grid using a query and cannot use the retieve fields facility.
Cheers!
How to set max column data in MSFlexGrid -
I have a MSFlexGrid that is bind to a recordset
Set grdProgressViewer.DataSource = rsGrid
There are 3 questions:
Let say the grid has 24 columns and the recordset will return 19 fields/columns.
Question 1:
Some reason everytime I rebind the grid, an extra column appears on t
DataGridView Column index -
I have a datagridview with two columns
Grid.Columns(0).Name ' Employee
Grid.Columns(1).Name ' Title
Now, I allow the user to move the columns. So when the user moves the title column before the Employee Column I expect the Column index to be:
Grid.Columns(0).Name '
Selecting the "Fixed Row", in a MSFlexGrid -
I'm using a FlexGrid in an application.
The flex grid has 4 columns, 4 rows, and 1 Fixed Row.
I use the fixed row as a header row, which contains text descriptions for each of the 4 columns.
When the program is running and I click on the Header Row, in ANY of the 4 columns, an
Data Grid control with data entry in one column -
Does anyone know how I can display a grid with several columns populated by data from a dataset and then allow data entry via the grid for random fields (some will not be allowed to be overwritten)
Datagrid and databinding to textbox -
Dear all,
I am getting stuck in the implementation of Data display/maintain in a windows form. The UI likes that: one datagrid, a couple of textboxs and comboxes, and couple of buttons of 'add', 'delete','update','confirm','cancel'. The datagrid only display few of the all the fiel
Re-sizing grids -
There are many fancy re-sizing OCXs and Grids on the market. I'm up to my a$$ in elastic controls and grids.
Where/what is a resizing control that will resize a grid (either the standard Microsoft MSFlexGrid, or a high priced custom control)?
Where can I find samples/examples/de
APEX True Data Grid 6.0 -
Does anyone know if I can display one of my columns on the true data grid to appear as a checkbox. One of my fields in the database in a yes-no field and I would like to display it in the grid as checked or unchecked. If not, do you know a way I can do this while displaying the rest
How to format a Data grid Column and use CheckBox -
Hi,
I am using VB 6 and create a data grid columns that listed below. I do not know how to format a data grid column and use Checkbox. Can you show me what is the right code for it? I would like the first column to be CheckBox in the Data Grid and it is a Boolean field
My Code:
Getting limited data from the db into the datagrid -
i have a grid in which i am getting all the columns from the db. I want to get only those columns into the grid which i specify.
how can i do that....
Need Grid that Emulates Excel Data Filter -
Hi guys I am looking for a prebuilt tool that provides the following functionality:
Choose Server, Database, Table
From this the tool
Populates a data grid with all columns in the underlying table.
Header for every column with Combobox populated with Distinct values from the o
Hiding rows on conditional format -
Hi all - I'm new to the forums, and somewhat new to VBA [Office 2003, SP2].
I've got a project with a couple thousand rows of data and max capacity of columns filled. The first ten columns are "placeholders" for a 1, 2, 3, etc.. to go into, for "selection" pur
Hiding Columns in an MSFlexgrid -
Can someone please tell me is there a function for hiding columns in an MSFlexGrid?
Example
.ColumnHide(2) ?
Thanks
Grid selection -
Im using an ado data control for my database...
Which grid should i use for, showing just some columns of my table.
And how do i configure the grid.
thanks in advance
Vb Grid ... -
Does VB.NET have any grid control which is better than VB6 Grid control(s). I mean is there a built-in control that can simulate the Excel like grid ? Can you have different type of columns in them, Checkboxes, Comboboxes, Date columns, Time columns etc etc. There is a control called F
vb.net grid -
Does VB.NET have any grid control which is better than VB6 Grid control(s). I mean is there a built-in control that can simulate the Excel like grid ? Can you have different type of columns in them, Checkboxes, Comboboxes, Date columns, Time columns etc etc. There is a control called F
sizing columns -
How do you size the columns in a datagrid? Seems like it should be something simple, like in the properties, but I don't see anything there...
Critical problem in Grid View[2005] -
Hi everybody,
I wanted to do something like this using Grid View , i.e. There are 4 columns 1st is Date, Model, Color, Party,Quantity , I want provide the total of quantity in grid but I dont know how do i do that how do I get the last row of the grid and the last row of the column. P
DBGrid hide columns........ -
I have a DBGrid with Columns that I require, however I change the RecordSource to the DBGrid on several occasions this is to save hiding three diferent DBGrids.
As you can Imagine there are unused columns showing in the dbgrid which means you have to scrole to see parts of the data.
Data Grid problem! -
Here´s the problem...
Im using an ado data control for my database.
i´m using some textbox to see information of some columns of my table.
But i also want a grid that shows just two columns,(id number and name) not all the table...
How can i do that!!