Home > Net >  Beginner c # using Mysql write a student management system form program
Beginner c # using Mysql write a student management system form program

Time:10-13

Primary school period chose.net classes, time because the teacher is not very detailed, class set is not reasonable, with the foundation of almost no object-oriented programming language requires writing a FORM program management system, database, and call for this small white pressure good big, face the upcoming final, physical review unfinished, how to choose? Liver program is nonsense, of course, (slanting, your students leave school notice), ahem, well, about the procedures in the reading station, every post, found that the difficulty is primarily a Mysql database in VS the call, so my question on the Mysql language, and how to configure, has spent the last two days time, basic mastered the Mysql build library, constructs the table, and the basic operation of base table and the user data, I went to the battle (may be curious about how make c #, February has actually have learn c + +, basic operation or a little),

First problem: online so many versions of Mysql, which is the next?
At first, this is also a hole, downloaded to a package of results later have to find a file download, did not find, but uninstall, then at some articles, originally just get MySQL DLL, may use MySQL classmates here to remind, don't go looking for a DLL, directly go to the website to download procedures, pay attention to see whether the zip, we do not want this, download the installer version, can be installed in accordance with the general flow point next, intermediate step need to set the root password, remember to yourself and see if the environment variable automatically after the installation is complete to add the path path, if not, please manually added, and then right click add reference in vs the resource manager, will MySQL. DLL file came in, and then you can use the relevant namespace,

Second question:
Learned in Mysqlcmd for database operation, but really a face of meng forced open vs, ha ha, I want to a beginner like me also is so, then don't panic, it is assumed that you've learned such structured language C, you already have basic programming thinking, then we start thinking about what I should do, what is needed to do this program framework, the framework details how to perfect, what are the specific contents, what are the features, functions of how to implement? Function is not function, in c # are all class, function is the method of (probably understanding does not reach the designated position), and tackling key problem: I want to realize the management system, it can check change operation to add or delete data, as it happens and MySQL corresponding operation, of course, incidentally, can achieve a sort order by) (look at the MySQL the select function, ok then we need to write a class, these functions are abstracted into a method, but, don't connect the database? Gnome male - ", nearly fell a pit,
So it is our general process, first connect to the database, and then use the string class to mysql statement string, call MySQLcmd method and then see where you are to display the data in the (datagridview),

Question 3: form beautification
The first wrote here, have a class?
  •  Tags:  
  • C#
  • Related