Every day, it is very tired, but it is not what you have done. Maybe because you are too women, you won't reject others! It is very busy, and the day before yesterday, I have to help him write a summary, and the soft grinding is hard. I promise it. Maybe this is nothing, can I do this? Since I promised, I can only do this little thing in this way! Ugh. Just borrow this place to summarize: the work is over one year, the work and practice of this year makes me learn a lot of knowledge and greatly improves personal abilities. In life, I just ended my society, I deeply realized the hardships and opportunities of society, no matter what the problem, I can't dispel my positive attitude and strong confidence in life. In the work, my job is biased toward hardware, the theoretical knowledge learned in the university is now supported, and many places that don't understand at the time will also be able to run. The first job I did is the system integration. From a beginner who is stunned to hardware, I can install the skilled work. I use only one and a half months; then it is a network architecture and configuration, I can skilled assembly. Various routers, switches, firewalls, and simple configurations; at the same time, I also have a deeper understanding of the operating system, you can skilled the installation of Microsoft's version of the operating system, and can also install the Linux operating system independently. After the skilled use of the operating system, I started to set up the server, and can independently set up Windows IIS web servers and several simple mail servers. Although my work is hard, my favorite is software programming, under unremitting efforts, I can not only skilled using the ASP website development, but also use VC, Delphi, VB, etc. Simple program development ... Learn ... in business ...
data processing
First, two ways to connect data sources: common way: Namespace: system.data; system.data.oledb Used Categories: OLEDBConnection; OLEDBCOMMAND; OLEDBDataReader Pedes: Microsoft Access / Microsoft SQL Server / Oracle / DB2, etc.: Open Microsoft Access Database Connection: <% Improt Namespace = "System.Data"%> <% Import Namespace = "System.Data.OLEDB"%> "省 本 省 省 省 省 省 本 本 省 省 省 省;; 省; 省 省 省 省; 省; 省 省 省 省 省 省 省 省;;; OLEDBCONNECTION ("provider = microsoft.jet.Oledb.4.0; data source = c: /autb.mdb") MyConnection.Open ()%> Microsoft SQL Server mode: Namespace: system.data; system.data.sqlclient Used Class: SqlConnection; SqlCommand; SqlDataReader facing data source: Microsoft SQL Server Example: Open a SQL Server Database: <% Improt Namespace = "System.Data"%> <% Import Namespace = "System.Data.sqlclient"% %%%%%%%%.DATA.SQLCLIENT "% > 'After the Bank is omitted; <% DIM MyConnection As SqlConnectionmyConnection = New SqlConnection ("Server = localhost; database = pub; uid = sa") MyConnection.Open ()%> Compare: Although the second method has certain The advantage, but it does not have versatility. Microsoft can always reserve certain technologies in some places. Second, the general process of inserting data: mycommand = New SqlCommand ( "Insert testtable (coll) values ( 'hello')", myConnection) mycommand.ExecuteNonQuery () Note: If the operator access the database, using the inser is a need to Write: INSERT INTO TESTTABLE (COLL) VALUES ('Hello'), this INTO is not omitted. If you contain single quotes in the inserted statement, you need to use two single quotes to replace.
Update: mycommand = new sqlcommand ("Update Authors Set Lastname = 'Smith'" ", MyConnection) MyCommand.executenonQuery ()
