OBOUT - ASP.NET Grid - Serialize Tutorial

ASP.NET Grid - Serialize Tutorial

The ASP.NET Grid has the option to serialize its data. If a postback occurs, the data will be loaded from the viewstate.
This way, the database will be accessed only once and the performance will be increased.

How this works

To enable the grid serialization, just set Serialize to true.
For small grids (with less than 1000 records) this is the best option to use.
The grid will load faster this way. After the data is retrieved from the database
there will be no more traffic between the web server and the database server.

Important

For grids with more than 1000 records we suggest you to set Serialize to false.
Because the serialized data will be huge, the size of the page will increase and
it will load slower. In this case, it's faster to access the database more times.

Examples

Serialize="true"

VB.NET

void Page_load(object sender, EventArgs e)
{
    if (!Page.IsPostBack)
    {
      DataSet ds = new DataSet();
      // load data from a database

      grid1.DataSource = ds;
      grid1.DataBind();
    }
}

Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs)

    If Page.IsPostBack = False
      Dim ds = new DataSet()
      ' load data from a database

      grid1.DataSource = ds
      grid1.DataBind()
    End If

End Sub

ASP.NET
<obout:Grid id="grid1" runat="server" Serialize="true"></obout:Grid>

Serialize="false"

VB.NET

void Page_load(object sender, EventArgs e)
{ 
    DataSet ds = new DataSet();
    // load data from a database

    grid1.DataSource = ds;
    grid1.DataBind();
}

Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs)
 
    Dim ds = new DataSet()
    ' load data from a database

    grid1.DataSource = ds
    grid1.DataBind()
End Sub