I didn't have to update my blog in a few days. The main reason is that there is too little online time. Today, I wrote the learning experience these days. These days, the contents of Connection / Command / DataReader are similar. There is the following experience: 1, connection. His use process is similar to the ASP, but the first to reference a namespace (this seems to be a rule of .NET). Then use the New OLEDBConnection (STRCONNECTION) to establish a connection. (Note: Because I am still not a lot of opportunities I am in touch with SQL, the key object I have programmed is Access. The future examples will be based on it). The last is open, close the connection, mainly to practice his usage Cooked, it is still very simple. 2. The use of Command is temporarily told me that it is also a good understanding. It is mainly necessary to memorize the methods and properties related to it. Commonly: command.executeReader () - This method generally cooperates with the DataSource method to be a definite data control together using Command.commandType - this is the way to execute, because I am now using SQL command, so general It is Text Command.comMandText - Get or sets the SQL statement or stored procedures to be executed on the data source. These comparison founders can be found in the VS.NET object. 3, DataReader because this object is generally used with the data control, I am using very shallow, not very well. General My Usage: DIM Objreader As OlddbdataReader = Objcommand.executeReader () DGCount.dataSource = Objreader Dgcount.database () ObjReader.close ()
