What is the equivalent of a RecordSet

eldercise · Apr 28, 2012

I have just begun to understand using DataSets for output, but I am still really unsure as to how to update records. I used to do something like: sql = "SELECT * FROM table1 WHERE ID = something;" RS.open RS("field1") = info1 RS("field2") = info2 RS.Update RS.close But I haven't seen much of that yet. IBuySpy uses Store Procedures exclusively and I haven't seen much else. ThanksThere is no real equivalent to a recordset. There are some very important problems with recordsets, they need to be connected to the database and they hog resources in both the server and client. They work pretty well with 1 user but they kill upgreadeability. Microsof has gone all out to redesign this model with a disconnected model. You now connect to the database, get all of your data into a a DataSet and close the connection. You can now use the DataSet to access and modify the data till you are happy with it, then update the dataset which will connect to the database and update itself. It is actually an amazing model with very good posibilities. To your question lets write some code (in this case copy paste from the howtos that come with the framework) //Setting up variables String InsertCmdString; InsertCmdString = "Insert into Region (RegionID, RegionDescription) VALUES (100, 'Description')"; SqlConnection mySqlConnection = new SqlConnection("server=(local)\VSdotNET;uid=QSUser;pwd=QSPassword; database=northwind"); //ok to do the work mySqlConnection.Open(); SqlCommand mySqlCommand = new SqlCommand(InsertCmdString, myConnection); mySqlCommand.ExecuteNonQuery(); //this actually goes to the database myConnection.Close() //don't forget to close this But wait! after all that boring talk about DataSets in the begining I give you an example that has nothing to do with them? well yes. The Connection and Command objects are central to understanding ADO.NET. You can still do stuff the old way. Lets take a look at how this would work with a DataSet: String SelectCmdString = "select * from todo"; mySqlConnection.Open(); SqlCommand mySqlCommand = new SqlCommand(SelectCmdString , mySqlConnection); //Heres Johnny! DataSet myDataSet = new DataSet(); SqlDataAdapter mySqlDataAdapter = new SqlDataAdapter(mySqlCommand); mySqlDataAdapter.Fill(myDataSet); mySqlConnection.Close(); And now you have a disconected DataSet that you can play with. You can look at the data, modify it convert it to/from xml etc. when you are done DataSet.AcceptChanges() automagically connects itself back up to the database, updates itself and closes the connection. Of course there is much more you can do with DataSets, read up! happy programming asb

What is the equivalent of a RecordSet

eldercise

New Member