>/***************************************************** > * Get the customer dataset >******************************************************/ > >string sSelectCommand = "select * from Customers where CustomerKey = 1"; > >SqlDataAdapter oDataAdapter = new SqlDataAdapter(sSelectCommand, oConnection); >DSCustomer oDataSet = new DSCustomer(); >oDataAdapter.Fill(oDataSet, "DSCustomer"); > >/***************************************************** > * Or Create an empty customer dataset >******************************************************/ >//DSCustomer oDataSet = new DSCustomer(); > >// Add a blank row >oDataSet.Tables[0].Rows.Add(); > > >// Get a reference to the table >DataTable oTable = oDataSet.Tables[0]; > >// Get the number of rows >int iRowCount = oTable.Rows.Count - 1; > >// Get a reference to the last row >DataRow oRow = oTable.Rows[iRowCount]; > >// Edit the column values >oRow["CustomerName"] = "Someone Else"; >oRow["CreditLimit"] = 15; > >// Save the changes >oDataSet.AcceptChanges(); >