Click here to Skip to main content
Click here to Skip to main content
Go to top

XYDataGrid

, 25 Mar 2007
Rate this:
Please Sign up or sign in to vote.
XYDataGrid is a web datagrid control which helps developers put fixed headers and columns.

Screenshot - Datagrid1.jpg

Introduction

XYDataGrid is a web datagrid control which helps developers to put fixed headers and fixed columns. A very common business need is fixed headers and fixed columns for a datagrid component. However, it is not so easy for a web development team to add these functionalities to an existing datagrid control.

XYDatagrid offers you these methods to add and remove fixed columns and headers easily.

Using the code

Please add the code below after you add XYDataGrid as a reference to your project.

Dim constr As String
Dim dt As New System.Data.DataTable
Dim sql As String

constr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _ 
         "c:\XYDataGridTestData.mdb;User Id=admin;Password=;"

Dim cn As New OleDbConnection(constr)

cn.Open()
sql = "Select * from XYDataGridTestTable"

Dim cmd As New OleDbCommand(sql, cn)
Dim da As New OleDbDataAdapter(cmd)

da.Fill(dt)
XYDataGrid1.DataSource = dt
XYDataGrid1.DataBind()

Another interesting code snippet is the code which should be added to the design side:

<form id="form1" runat="server">
<div>
<DIV style="Z-INDEX: 101; LEFT: 0px; OVERFLOW: auto; WIDTH: 400px; 
              POSITION: relative; TOP: 46px; HEIGHT: 200px">
    <cc1:XYDataGrid ID="XYDataGrid1" runat="server" 
      style="border-width:1px;border-style:None;" 
      FixHeader="True" FixColumn="2">
    </cc1:XYDataGrid> 
</DIV>
</div>
</form>

After you set the properties as below, the datagrid is ready to work.

Screenshot - datagrid6.jpg

Here are some pictures of the XYDataGrid:

Screenshot - Datagrid1.jpg

Picture 1 - Ready to scroll down and right.

Screenshot - Datagrid2.jpg

Picture 2 - After first scroll right, the department column slides to the left. ID and Name are fixed.

Screenshot - Datagrid3.jpg

Picture 3 - After birthday column slided to left.

Screenshot - Datagrid4.jpg

Picture 4 - After scroll down, the first row scrolls up.

Screenshot - Datagrid5.jpg

Picture 5 - After scroll down, the first row scrolls up.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Share

About the Author

Yildirim Kocdag
Architect
Turkey Turkey
Phd. Yildirim Kocdag is a Computer Engineer.
 
Programming Languages
Android, Objective-c, c#, vb.net, asp.net, javascript, TSQL.
 
Computer Science
DataMining, Compilers, Expert Systems, Digital Image Processing, AI and Extreme Programming.
 
ykocdag@yahoo.com
 
http://www.linkedin.com/profile/view?id=223886830
Follow on   LinkedIn

Comments and Discussions

 
QuestionBug? PinmemberCoach_8128-Jul-08 16:29 
Questionvb 2 c# PinmemberOmidH30-May-07 1:46 
AnswerRe: vb 2 c# PinmemberYildirim Kocdag30-May-07 2:40 
GeneralRe: vb 2 c# PinmemberOmidH30-May-07 18:00 
GeneralThanks Pinmembervolkan.ozcelik5-Apr-07 23:15 
GeneralRe: Thanks PinmemberYildirim Kocdag6-Apr-07 1:26 
GeneralEmbedded CSS PinmemberDeclan Bright26-Mar-07 3:42 
GeneralRe: Embedded CSS PinmemberYildirim Kocdag26-Mar-07 4:53 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    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 | Mobile
Web01 | 2.8.140916.1 | Last Updated 26 Mar 2007
Article Copyright 2007 by Yildirim Kocdag
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid