当前位置: 首页>>代码示例>>C#>>正文


C# DataView.Table属性代码示例

本文整理汇总了C#中System.Data.DataView.Table属性的典型用法代码示例。如果您正苦于以下问题:C# DataView.Table属性的具体用法?C# DataView.Table怎么用?C# DataView.Table使用的例子?那么恭喜您, 这里精选的属性代码示例或许可以为您提供帮助。您也可以进一步了解该属性所在System.Data.DataView的用法示例。


在下文中一共展示了DataView.Table属性的2个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。

示例1: DemonstrateDataViewTable

private static void DemonstrateDataViewTable()
{
    DataTable table = new DataTable();

    // add columns
    DataColumn column = table.Columns.Add("ProductID",
        typeof(int)	);
    column.AutoIncrement = true;
    column = table.Columns.Add("ProductName", 
        typeof(string));

    // populate DataTable.
    for(int id=1; id<=5; id++)
    {
        table.Rows.Add(
            new object[]{ id, string.Format("product{0}", id) });
    }

    DataView view = new DataView(table);

    PrintTable(view.Table, "DataTable");
}

private static void PrintTable(DataTable table, string label)
{
    // This function prints values in the table or DataView.
    Console.WriteLine("\n" + label);
    foreach(DataRow row in table.Rows)
    {
        foreach(DataColumn column in table.Columns)
        {
            Console.Write("\table{0}", row[column]);
        }
        Console.WriteLine();
    }
}
开发者ID:.NET开发者,项目名称:System.Data,代码行数:36,代码来源:DataView.Table

示例2: Main

//引入命名空间
using System;
using System.Data;
using System.Data.SqlClient;

class FindingDataRowViews
{
  public static void Main()
  {
    SqlConnection mySqlConnection =new SqlConnection("server=(local)\\SQLEXPRESS;database=MyDatabase;Integrated Security=SSPI;");
    SqlCommand mySqlCommand = mySqlConnection.CreateCommand();
    mySqlCommand.CommandText =
      "SELECT ID, FirstName, LastName " +
      "FROM Employee";
    SqlDataAdapter mySqlDataAdapter = new SqlDataAdapter();
    mySqlDataAdapter.SelectCommand = mySqlCommand;
    DataSet myDataSet = new DataSet();
    mySqlConnection.Open();
    mySqlDataAdapter.Fill(myDataSet, "Employee");
    mySqlConnection.Close();
    DataTable employeeDT = myDataSet.Tables["Employee"];

    string filterExpression = "ID = 9";
    string sortExpression = "ID";
    DataViewRowState rowStateFilter = DataViewRowState.OriginalRows;

    DataView employeeDV = new DataView();
    employeeDV.Table = employeeDT;
    employeeDV.RowFilter = filterExpression;
    employeeDV.Sort = sortExpression;
    employeeDV.RowStateFilter = rowStateFilter;

    foreach (DataRowView myDataRowView in employeeDV)
    {
      for (int count = 0; count < employeeDV.Table.Columns.Count; count++)
      {
        Console.WriteLine(myDataRowView[count]);
      }
      Console.WriteLine("");
    }

    int index = employeeDV.Find("8");
    Console.WriteLine("8 found at index " + index + "\n");

    DataRowView[] employeeDRVs = employeeDV.FindRows("8");
    foreach (DataRowView myDataRowView in employeeDRVs)
    {
      for (int count = 0; count < employeeDV.Table.Columns.Count; count++)
      {
        Console.WriteLine(myDataRowView[count]);
      }
      Console.WriteLine("");
    }
  }
}
开发者ID:C#程序员,项目名称:System.Data,代码行数:55,代码来源:DataView.Table


注:本文中的System.Data.DataView.Table属性示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。