C＃将文本框值设置为来自Azure表存储的表查询

debugcn 发表于 Dev

瑞安·史蒂文·阿兹（Ryan Steven Artz）

因此，我可以毫无问题地访问我的azure表，因为console.writeline会显示我要提取的数据。我需要做的是查询我的azure表存储，然后将结果吐出到文本框中。我的代码如下：

               //start of code
               CloudStorageAccount storageAccount =
               CloudStorageAccount.Parse("DefaultEndpointsProtocol=https;AccountName=telephony;AccountKey=RandomKeyhere);
        CloudTableClient tableClient = storageAccount.CreateCloudTableClient();
        CloudTable table = tableClient.GetTableReference("TelephonyIssueLog");
        await table.CreateIfNotExistsAsync();

        //This is the code I'm having troubles with.
        TableQuery<IssueEntity> query = new TableQuery<IssueEntity>().Where(TableQuery.GenerateFilterCondition("PartitionKey", QueryComparisons.Equal, "Issues"));
        textBox1.Text = table.ExecuteQuery(query).ToString();

陈小龙

我的最终目标是将Azure表存储与Microsoft Chart Tools一起使用以导入从Azure表存储接收的数据。

我假设您要将Microsoft Chart控件添加到Windows窗体或Web应用程序。如果我误会了，请告诉我您提到的Microsoft图表工具是什么。

这是一个Windows Forms应用程序，可让您更好地了解如何将查询的数据放入基本图表中。

DemoForm.cs

private void btnLoad_Click(object sender, EventArgs e)
{
    GenerateChart(this.DemoChart, LoadData());
}

/// <summary>
/// Load data from Azure Table
/// </summary>
/// <returns></returns>
private IList<MetricEntity> LoadData()
{
    CloudStorageAccount storageAccount = CloudStorageAccount.Parse(
    CloudConfigurationManager.GetSetting("BruceChenStorageConnectionString"));
    CloudTableClient tableClient = storageAccount.CreateCloudTableClient();
    CloudTable cloudTable = tableClient.GetTableReference("TelephonyIssueLog");
    cloudTable.CreateIfNotExists();
    TableQuery<MetricEntity> query = new TableQuery<MetricEntity>()
        .Where(TableQuery.GenerateFilterCondition("PartitionKey", QueryComparisons.Equal, "Issues"));
    return cloudTable.ExecuteQuery(query).ToList();
}

/// <summary>
/// Generate the column chart with the specified data source
/// </summary>
/// <param name="chart"></param>
/// <param name="dataItems"></param>
private void GenerateChart(Chart chart, IEnumerable<MetricEntity> dataItems)
{
    chart.Series.Clear();
    chart.Titles.Add(
        new Title("Demo Chart for loading data from Azure Table"));
    List<string> xValues = new List<string>() { "MetricA", "MetricB", "MetricC" };
    foreach (var item in dataItems)
    {
        Series series = new Series() { Name = item.UserName };
        series.ChartType = SeriesChartType.Column;
        series.Points.DataBindXY(xValues, new List<int>() {
          item.MetricA,
          item.MetricB,
          item.MetricC});
        chart.Series.Add(series);
    }
}

MetricEntity.cs

public class MetricEntity : TableEntity
{
    public MetricEntity(string partitionKey, string rowKey)
    {
        this.PartitionKey = partitionKey;
        this.RowKey = rowKey;
    }
    public MetricEntity() { }
    public int MetricA { get; set; }
    public int MetricB { get; set; }
    public int MetricC { get; set; }
    public string UserName { get; set; }
}

Azure表存储中的数据结构