static void WriteLineAllItemWithTableAdapter(SampleDatasetTableAdapters.ItemTableAdapter ta) { var msg = string.Join(Environment.NewLine, ta.GetData().Select(a => a.ID.ToString() + ":" + a.ItemName)); Console.WriteLine("------------------------------------"); Console.WriteLine(msg); Console.WriteLine("------------------------------------"); }
static void GetIdentityWithTableAdapter() { // TableAdapterの接続文字列は、Settingsのパーシャルクラスで設定済 using (var ta = new SampleDatasetTableAdapters.ItemTableAdapter()) { WriteLineAllItemWithTableAdapter(ta); // TableAdapterのRowUpdatedイベントハンドラの追加 ta.AddRowUpdatedEvent(); var ds = new SampleDataset(); var row = ds.Item.NewItemRow(); row.ItemName = "秋映"; ds.Item.AddItemRow(row); ta.Update(ds); // @@IDENTITYで取得した値を表示 Console.WriteLine("@@IDENTITY -> " + ds.Item.FirstOrDefault().ID.ToString() + ":" + ds.Item.FirstOrDefault().ItemName); WriteLineAllItemWithTableAdapter(ta); } }