Aspose.Cells要將數據庫綁定到一個工作表，應遵循以下步驟：

• 訪問將被綁定的表
• 指定一個數據源（可以是一個DataSet，DataTable或DataView等）的工作表
• 創建列綁定到數據源
• 創建驗證。在我們的實例中，我們將為ProductID列創建一個必要的驗證
• 指定數字格式設置。在我們的實例中，我們將產品價格列的數字格式設置為Currency3
• 加載和填充數據集
• 實現綁定

實例代碼：

[C#]

 //Implementing Page_Load event handler
private void Page_Load(object sender, System.EventArgs e)
{
    //Checking if there is not any PostBack
    if (!IsPostBack)
    {
        //Accessing a desired worksheet
         WebWorksheet sheet = GridWeb1.WebWorksheets[0];

        //Specifying Data Source for the worksheet
         sheet.DataSource = dataSet11;

        //Specifying Products tables as the DataMember
         sheet.DataMember = "Products";

        //Creating data bound columns automatically
         sheet.CreateAutoGenratedColumns();

        //Creating REQUIRED validation for ProductID column
        Validation v = new Validation();
        v.IsRequired = true;
         sheet.BindColumns[0].Validation = v;

        //Setting Number Format of ProductPrice column to Currency3
         sheet.BindColumns[2].NumberType = NumberType.Currency3;

        try
        {
            //Filling DataSet
            oleDbDataAdapter1.Fill(dataSet11);
        }
        finally
        {
            //Closing database connection
            oleDbConnection1.Close();
        }

        //Binding worksheet with DataSet
        sheet.DataBind();
    }
}
 

[VB.NET]

 'Implementing Page_Load event handler
Private Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles MyBase.Load
    'Checking if there is not any PostBack
    If Not IsPostBack Then
        'Accessing a desired worksheet
         Dim sheet As WebWorksheet = GridWeb1.WebWorksheets(0)

        'Specifying Data Source for the worksheet
         sheet.DataSource = dataSet11

        'Specifying Products tables as the DataMember
         sheet.DataMember = "Products"

        'Creating data bound columns automatically
         sheet.CreateAutoGenratedColumns()

        'Creating REQUIRED validation for ProductID column
        Dim v As Validation = New Validation()
        v.IsRequired = True
         sheet.BindColumns(0).Validation = v

        'Setting Number Format of ProductPrice column to Currency3
         sheet.BindColumns(2).NumberType = NumberType.Currency3

        Try
            'Filling DataSet
            oleDbDataAdapter1.Fill(dataSet11)
        Finally
            'Closing database connection
            oleDbConnection1.Close()
         End Try

        'Binding worksheet with DataSet
        sheet.DataBind()
    End If
End Sub
 
最后，編譯并運行此Web應用程序的。 Web窗體加載后，你會看到從數據庫加載到工作表中的數據：