手把手教你学vfp sql的cs系统.docVIP

手把手教你学vfp+sql2000的cs系统 First, basic preparation Install SQL personal version + SP4; Install VFP9 + SP1 + sinify. (see whether he likes to hanhua or not) You will do a bit of a stand-alone project. Second, prepare to implement Start the SQL enterprise manager, select the current server, create a new database, name the cj, and build a table under the library, fields The field name type width Number C six Name C 8 Post C 10 c-10 Phone C 11 Set the number to the primary key, save, and name the staff table; Build an ODBC, point the staff table. (where ODBC is located: the start - Settings - control panel - the administration tool - data source ODBC) Add. Select SQL, complete. Enter the desired name, description, the server, and the next step Enter the user ID and password. Next. Change the database, next. To complete. Test the data source. At this point, the preparations have been completed. Third, the implementation process Create a new project, name yourself. Create a new program to connect to the server and download the data from the server to the client. (because the tables are relatively small, you can download them all, and if the table is large, its better to have a selective download of the records you need to use.) Heres how to do this: Define a connection string nhandle and use the user name password to connect to the corresponding database to test if the connection is successful. If successful, the download table to the local temporary table (like the view? Dont understand, when it is first table), named gh, if you dont succeed, then suggest the connection fails, and prompt connection no again. After the connection has been successful and downloaded the table, set the corresponding update to the table and server table. (this setting can be another form, and when you do this, try another.) Procedure is as follows: Public nhandle define connection string names The connection type is SQL server, the server is cjc1010, the user name is sa, the password is aa, a