static void Main()
{
DataTable myTable = DataSetFiller.FillDataset(dataFilePath).Tables[0];
myTable.PrimaryKey = new DataColumn[] { myTable.Columns["CustomerID"] };
myTable.AcceptChanges();
DataRow janeRow = myTable.Rows.Find("5");
janeRow["LastName"] = "QueenOfJungle";
// myTable.AcceptChanges(); // Если принять изменения, то измененных строк уже не будет
// посмотреть измененные данные (до сохранения - AcceptChanges())
DataRow[] drs = myTable.Select("", "", DataViewRowState.ModifiedOriginal);
if (drs != null)
{
foreach (DataRow dr in drs)
{
ShowDataRow(dr);
}
}
}
static void Main(string[] args)
{
DataTable myTable = DataSetFiller.FillDataset(dataFilePath).Tables[0];
DataRow[] drs = myTable.Select("LastName Like '%OfJungle'", "FirstName ASC");
if (drs != null)
{
foreach (DataRow dr in drs)
{
ShowDataRow(dr);
}
}
}
static void Main()
{
DataTable myTable = DataSetFiller.FillDataset(dataFilePath).Tables[0];
DataRow[] drs = myTable.Select("FirstName Like 'Jo%'");
if (drs != null)
{
foreach (DataRow dr in drs)
{
ShowDataRow(dr);
}
}
}
static void Main(string[] args)
{
DataTable myTable = DataSetFiller.FillDataset(dataFilePath).Tables[0];
myTable.PrimaryKey = new DataColumn[] { myTable.Columns["CustomerID"] };
myTable.AcceptChanges();
DataRow janeRow = myTable.Rows.Find("5");
janeRow["LastName"] = "QueenOfJungle";
DataRow[] drs = myTable.Select("", "", DataViewRowState.ModifiedOriginal);
if (drs != null)
{
foreach (DataRow dr in drs)
{
ShowDataRow(dr);
}
}
}
static void Main(string[] args)
{
// Base DataTable
DataTable myTable = DataSetFiller.FillDataset(dataFilePath).Tables[0];
// Set Primary Key
myTable.PrimaryKey = new DataColumn[] { myTable.Columns["CustomerID"] };
DataRow dr = myTable.Rows.Find("2");
if (dr != null)
{
Console.WriteLine("Find a row using a base DataSet");
ShowDataRow(dr);
}
// Strongly typed DataSet
CustProd.CustomersDataTable myStrongDataTable = DataSetFiller.FillStrongDataSet(dataFilePath).Customers;
CustProd.CustomersRow cr = myStrongDataTable.FindByCustomerID(2);
if (cr != null)
{
Console.WriteLine("Find a row using a strongly typed DataSet");
Console.WriteLine(cr.CustomerID + " " + cr.FirstName + " " + cr.LastName);
}
}
