世俱杯 2025

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窗体加载后，你会看到从数据库加载到工作表中的数据：