Aspose.Cells要將數(shù)據(jù)庫綁定到一個(gè)工作表，應(yīng)遵循以下步驟：

• 訪問將被綁定的表
• 指定一個(gè)數(shù)據(jù)源（可以是一個(gè)DataSet，DataTable或DataView等）的工作表
• 創(chuàng)建列綁定到數(shù)據(jù)源
• 創(chuàng)建驗(yàn)證。在我們的實(shí)例中，我們將為ProductID列創(chuàng)建一個(gè)必要的驗(yàn)證
• 指定數(shù)字格式設(shè)置。在我們的實(shí)例中，我們將產(chǎn)品價(jià)格列的數(shù)字格式設(shè)置為Currency3
• 加載和填充數(shù)據(jù)集
• 實(shí)現(xiàn)綁定

實(shí)例代碼：

[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
 
最后，編譯并運(yùn)行此Web應(yīng)用程序的。 Web窗體加載后，你會(huì)看到從數(shù)據(jù)庫加載到工作表中的數(shù)據(jù)：