public static DataSet Example() { var connectionDetails = ConfigurationManager.ConnectionStrings ["MyDatabase"]; var providerName = connectionDetails.ProviderName; var connectionString = connectionDetails.ConnectionString; var dbFactory = DbProviderFactories.GetFactory(providerName); var adapter = dbFactory.CreateDataAdapter(); // Fill var myDataSet = new MyDataSet(); var myTable = new MyDataSet.MyTableDataTable(); adapter.Fill(myTable); foreach (MyDataSet.MyTableRow myTableRow in myTable) { var id = myTableRow.Id; var name = myTableRow.Name; var isMale = myTableRow.IsMale; } // insert MyDataSet.MyTableRow newRow = myTable.NewMyTableRow(); newRow.Name = "Bobby McFroggy"; newRow.Id = 1; newRow.IsMale = true; myTable.AddMyTableRow(newRow); myTable.AddMyTableRow(2, "James Pond", true); adapter.Update(myTable); return(myDataSet); }
public static DataSet Example () { var connectionDetails = ConfigurationManager.ConnectionStrings ["MyDatabase"]; var providerName = connectionDetails.ProviderName; var connectionString = connectionDetails.ConnectionString; var dbFactory = DbProviderFactories.GetFactory (providerName); var adapter = dbFactory.CreateDataAdapter (); // Fill var myDataSet = new MyDataSet (); var myTable = new MyDataSet.MyTableDataTable (); adapter.Fill (myTable); foreach (MyDataSet.MyTableRow myTableRow in myTable) { var id = myTableRow.Id; var name = myTableRow.Name; var isMale = myTableRow.IsMale; } // insert MyDataSet.MyTableRow newRow = myTable.NewMyTableRow (); newRow.Name = "Bobby McFroggy"; newRow.Id = 1; newRow.IsMale = true; myTable.AddMyTableRow (newRow); myTable.AddMyTableRow (2, "James Pond", true); adapter.Update (myTable); return myDataSet; }