XYDataGrid

• Download source code - 34.8 KB

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.

Here are some pictures of the XYDataGrid: