本文整理汇总了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();
}
}
示例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("");
}
}
}