I want to show data in a grid. I tried DataGridView but i have some extra requirements which aren't supported:
1. Rows should be able to group together (like in a TreeView)
2. I can put icons in the cells
3. I can add color to the cells (like in a RichTextBox)
Does anyone know about a FREE (or a low cost) control which support those requirements? Maybe DataGridView does support those functions and i just don't know..?
I need to know how to show my search item in a data grid? There is error in grid display part. [Code]
View 1 Repliesi m using these code for selecting data grid row [code]but , when no of row more then grid showing rows then grid not show selected row in grid screen, for showing selected row we have to use scroll bar, my problem is how to show selected row in grid automatically
View 2 RepliesI want to add prices together which is in cells in a grid view and show the total in a text box.
View 9 RepliesI am student of MCS and i am working on my final project i face some problems regarding to show cubes data in grid control in vb.net around with dimensions
View 1 RepliesI am importing a .csv file into a data set / data table and then into a data grid view. I need to show decimal position for whole number.
[Code]...
Is there a way to have the data grid view show the colum names as rows and then the data would be in the colums?
I know I can do it in asp. But cant figure out how to swap the 2 around for display purposes in VB.
how to show data in textbox when mouse click on any cell grid in vb.net with text file?
View 6 RepliesThis is a VB .NET application where we are showing the output of a SQL statement in a Datagrid view. using .NET 2005.We need to get the seperators of the headers on the grid control to be the same colors as the GridColor on the form. See the picture below:We've tried looking through all of the properties of the DataGridView control, and found some interesting things that looked promising such as the DataGridViewAdvancedHeaderStyle, and DataGridViewHeaderBorderStyle, but none of it seems to allow you to change the colors on it.Does anyone know how to do this without remaking the entire thing with a GDI+ control?
View 2 RepliesIs there a way to automatically put a Data Grid Row Column in a data Grid?[code]...
View 5 RepliesI have the below code that i am trying to have two datagrids with a grid splityter in the middle. The split seems to be working fine but the issue i am having is when I populate the datagrid it is growing in height and changing the splitter instead of leaving the height alone and adding scroll bars.
What simple thing am I overlooking?
<Grid x:Name="gdHistory" Grid.Column="0" Grid.Row="2" >
<Grid.RowDefinitions>
[code].....
I have a problem with importing an excel into a data grid.
Here is my code:
Try
Dim _Obj As New ExcelConnection.ExcelConnection
_Obj.ImportAttendence("c:Info_pc.xls", DataGrid1)
Catch ex As Exception
End Try
In the excel i have numers and text and "Service Pack", "Processor Speed" and "Numar procesoare(Number of processors)" and the values for these are numers. in the data grid when i import the excel those values doesn't appear, i receive the value "null".
[code].....
View 1 RepliesI have 1 datagridview and i want to transfer all records to another datagridview, how can i possibly do that. Newbie here. This is my code in transferring 1 record to another datagridview to another one.
[Code]...
I have a request to show a grid similar to a calendar showing on columns the day and on row months.
Something like this
Month |Sun|Mon|Tue|Wed|Thu|Fri|Sat|Sun|Mon|Tue|Wed|Thu|Fri|Sat|Sun|Mon|Tue|Wed|...|Thu|
January | 1| 2| 3| 4| 5| 6| 7| 8| 9| 10| 11|...................| 31|
Febrary | | | | 1| 2| 3| 4| 5| 6| 7|...........................| 29|
...
December| 30| 31| | | | | 1| 2| 3| 4|............................
Is there a way to do this, considering that The Start day of the year must be the real day name, not a constant and this must be generated dynamically
Private Sub GenerateCalendar(ByVal year As Integer)
Dim colsCount As Integer = 3
If Bisiesto(año) Then
[code]....
In designer i had a button with errorprovider.The button show 3 extra properties at button's property grid in design time.Error on ErrorProvider1
IconAlignmnent on
IconPadding on
But how can i show this 3 extra properties in propertygrid at run time?
Private Sub Form_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Dim propertyGrid1 As New PropertyGrid()
propertyGrid1.CommandsVisibleIfAvailable = True[code].....
How to apply for loop on grid view and to check the empty cell value then show a message...
Dim cnt As New DataSet1.LibraryDataTable
For i As Integer = 0 To cnt.Rows.Count - 1
For j As Integer = 0 To 5
If GridView1.Rows(i).Cells(j).Text = Nothing Then
GoTo e
ElseIf GridView1.Rows(i).Cells(j).ID Then
GoTo a
End If
Next
Next
e:
lblmsg.Text = "he is not return a book"
a:
lblmsg.Text = "he is return all book"
how to cambine 2 data grid view into 1 data grid view
View 2 RepliesI just want to display data in a DataGridView (from SQL - already made the connection) based on what is selected in a ComboBox (data that is also coming from SQL). The 2 are separete on the form. I am using VB 2010.
This doesn't work for me:
objCommand2.CommandText = "SELECT ProductID, Name, Color, Size, ListPrice FROM SalesLT.Product WHERE ProductCategoryID = " & cbCategory.SelectedValue
[code].....
The control comes up blank??Imports System.Data Imports System.Data.OleDb Public Class Form1
[Code]...
I'm trying to create a simple Data Grid that will automatically save changes. So far I have a data grid connected to a MS Access 2007 Database that reads the data. I can create new fields in the Data Grid, but I need to program to save the data automatically to the database on update (or on close).
View 6 RepliesI have an excel file that I would like to load into my form and display there.
View 1 Replieshow to display data in grid view using code that you can edit, update and delete the data...do i need to have a stored proc in this?
View 4 RepliesAre there any good free alternatives to DevExpress data grids (WinForms)?I am looking for WinForms Data Grid and Data Editor Controls.
View 1 RepliesData binding should be an extremely simple thing to manage but I can't find a SIMPLE solution to the following problem.
I have two forms
Form1 contains a 4x4 MSFlexGrid (unfortunately an unmanaged COM object but I can merge cells, which I can't do with a managed Datagrid)
Form2 contains other controls which change the data in the Flexgrid.
I connect the two with a Public 4x4 array. Form2 changes the data in this array. I can update the grid data by reading the array. But how do I bind the Grid to the array so that it auto-updates - which is the whole point of binding isn't it?
I am trying to pass a different template to a Telerik Grid, depending on if the add button or the edit button is pressed (on creation: a few field to fill. on existing: add button : some extra fields to fill, edit button : most field are read-only, new field to fill).
Dim myGrid = Html.Telerik().Grid(Of SomeModel) _
.Name("myGrid")
If Model.Action = AddNewData Then
myGrid.Editable(Sub(editing) _
[code]....
I have no idea on how to do the if "gridBoutonPushed = Add" then part.
I have a datagridview which have 5 columns. The name of the columns are T,C,F,S,H. [cod]e...
So i want to display this data in datagried view. I must display the number beside T to T column, the number beside C to C column and so on. It should only display number in the respective column. It should not display the T,C and so on. [code]...
i have a form which search data in specific date and show result in the datagridview, what i want is that when delete button is clicked all datas that in the datagridview will be deleted sameway in the database
View 3 Repliescan data reader be used as a data source for a grid control?
View 5 RepliesHow do you refresh a datagridview in code to show to show new data in the DB?
View 3 Replies