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); } }