Click here to Skip to main content
12,403,784 members (70,748 online)
Click here to Skip to main content
Add your own
alternative version

Stats

173.7K views
7.5K downloads
65 bookmarked
Posted

Enhanced DataGrid control

, 24 Jun 2003
Rate this:
Please Sign up or sign in to vote.
Extends DataGrid Functionalities

Sample Image - GridEx.jpg

Introduction

This is an enhanced DataGrid that built in with Auto Search, Auto Column Sizing and Row Select features. In addition, it supports multiple Tablestyles binding to single DataTable. New events such as CurrentRowChanged and OnHeaderClick also have been included.

Background

This component was created out of frustration with default datagrid controls. After searching around from web but could not find a Free datagrid control with the features that suit my needs. I decided to create one by myself. This is my first .NET component, feel free to give me feedbacks or comments so that I can learn something and improve my .NET skill. I hope this component is useful to those of you who are as frustrated as me.

GridEx

Property Description
AutoSearch Enable or disable auto search function in datagrid.
AutoSize Enable or disable column auto sizing in datagrid.
RowSelect Enable or disable row select in datagrid.
CurrentStyeIndex Gets or sets a value indicating current TableStyle. Default value is -1.
UseGridParentStyle Gets or sets a value indicating whether TableStyles should follow the grid style.

Method Description
OnHeaderClick Raises HeaderClicked event.
OnCurrentRowChanged Raises CurrentRowChanged event.

Event Description
CurrentRowChanged Occurs when current row has changed.
HeaderClicked Occurs when grid header is clicked.

How to use AutoSearch in GridEx

Set AutoSearch property to true during design time or use the following code during runtime:-

...
this.gridEx1.AutoSearch = true;

During runtime, simple click on the header column that you want to perform search and then type in search value and GridEx will perform incremental search for you. You may use [Backspace] to delete char or [Escape] to clear search value. If you search on DateTime column type, a datetime input box will appear.

Creating Multiple TableStyles

Create styles using datagrid TableStyles Editor. Set the style's MappingName to TableName of DataTable if you want GridEX to load this style first. If none of the styles has MappingName assigned, default style will be used.

Changing TableStyles at Runtime

To change style at runtime, set CurrentStyleIndex to a valid TableStye index.

...
this.gridEx1.CurrentStyleIndex = 1;

Setting CurrentStyleIndex to -1 will tell GridEx to use default style.

Limitation

AutoSearch only supports DataTable and DataView datasource. AutoSearch will be turned off automatically if you assign a DataSet to datagrid DataSource property.

Contact

I can be reached at cheetuan_choong@jabil.com

License

This article has no explicit license attached to it but may contain usage terms in the article text or the download files themselves. If in doubt please contact the author via the discussion board below.

A list of licenses authors might use can be found here

Share

About the Author

cctuan
Web Developer
Malaysia Malaysia
No Biography provided

You may also be interested in...

Comments and Discussions

 
GeneralCalender Cells Pin
sashdude1-Oct-08 7:39
membersashdude1-Oct-08 7:39 
GeneralColumnName with a space Pin
KC5HHQ12-Jan-07 3:52
memberKC5HHQ12-Jan-07 3:52 
GeneralDisable a column in datagrid Pin
Ndichuw Samuel21-Jun-06 1:05
memberNdichuw Samuel21-Jun-06 1:05 
GeneralRe: Disable a column in datagrid Pin
KC5HHQ12-Jan-07 3:51
memberKC5HHQ12-Jan-07 3:51 
GeneralRe: Disable a column in datagrid Pin
altaf sami4-Apr-08 19:15
memberaltaf sami4-Apr-08 19:15 
QuestionHow i retrive data from Cell [modified] Pin
sachinjr14-Jun-06 0:40
membersachinjr14-Jun-06 0:40 
AnswerRe: How i retrive data from Cell Pin
danish_bear20-Jun-06 9:32
memberdanish_bear20-Jun-06 9:32 
GeneralRe: How i retrive data from Cell Pin
KC5HHQ12-Jan-07 3:54
memberKC5HHQ12-Jan-07 3:54 
AnswerRe: How i retrive data from Cell Pin
altaf sami4-Apr-08 19:19
memberaltaf sami4-Apr-08 19:19 
GeneralAutosize only works with DataSets, DataTables, and DataViews but not with DataRelations Pin
Josef Meile8-May-06 9:37
memberJosef Meile8-May-06 9:37 
GeneralAutosearch Pin
u999nik6-Nov-03 11:15
memberu999nik6-Nov-03 11:15 
GeneralQuerying the database Pin
sayyedabdulrahim6-Sep-03 5:35
membersayyedabdulrahim6-Sep-03 5:35 
GeneralWhy "ReadOnly" Pin
scampbell15-Sep-03 17:17
memberscampbell15-Sep-03 17:17 
GeneralProblem with AutoSize Pin
ikos18-Jul-03 5:47
memberikos18-Jul-03 5:47 
GeneralAnnouncement !!! Pin
cctuan25-Jun-03 15:12
membercctuan25-Jun-03 15:12 
GeneralError running demo project Pin
Drew Stainton25-Jun-03 7:43
memberDrew Stainton25-Jun-03 7:43 
GeneralRe: Error running demo project Pin
Michael Choong25-Jun-03 14:32
memberMichael Choong25-Jun-03 14:32 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

| Advertise | Privacy | Terms of Use | Mobile
Web01 | 2.8.160721.1 | Last Updated 25 Jun 2003
Article Copyright 2003 by cctuan
Everything else Copyright © CodeProject, 1999-2016
Layout: fixed | fluid