根据数据库字段生成存储过程和c#引用代码

一个高校学籍管理系统 源代码完成了以下功能： 1)能够从屏幕上读取一个学生的信息并将信息存入到数据文件中。 2)能够将指定的信息从文件中删除。 3)能够按编号、姓名对学生的信息进行检索并将检索结果显示在屏幕上。 4)可以统计全部学生的总成绩，及其在班上的排名。 5)能够统计各科的平均成绩及及格率。 6)要求有错误提示功能，例如性别只能输入男女，输入错误提示重新输入。 7)如果检索不到相应的信息应提示用户。-a source code management system to complete the following functions : 1) to read from the screen of a student information and information into the data file. 2) can be designated information deleted from the document. 3) to by number, name of student information retrieval and search results displayed on the screen. 4) Statistical all students can be a total score, and the class rankings. 5) Statistics Branch to the average scores and passing rates. 6) require a functional errors, such as sex between men and women can only import, import errors to re-enter. 7) If less than the corresponding retrieval of information should prompt the user.

VB操作SQL实例,快来下载吧,对初学者很有帮助的-VB operation SQL examples, Come download it, very helpful for beginners

通过本实验加深对SQL Server 2000环境下数据定义语言的理解，能够熟练地建立数据库，并通过SQL语句来建立一个新的SQL Server设备管理数据库，使用SQL的数据定义功能建立数据库中的各个基本表（共3个），并按要求对有关表进行修改。 每次操作后通过企业管理器查看有关对象的变化。创建和修改基本表、创建和取消索引。-Through better understanding of this experiment under SQL Server 2000 data definition language understanding, able to skillfully build up a database, and through the SQL statements to create a new SQL Server Device Manager database, use SQL data definition, function to establish a database of all the basic table (a total of three), as required on the table to edit. After each operation through the Enterprise Manager view information about the object changes. Create and modify the basic form, the creation and abolition of the index.

图书管理系统，用于管理图书室里的图书的信息。-Library management system for managing library book information.

本代码展示了使用DB_LIB库对SQL SERVER的连接和各种操作的实例。-display of the code DB_LIB the use of SQL Server connectivity and various operational examples.

This returns a string containing row sets in XML format. The method, GetXML, takes as parameters: DBService = SQL Server connection parameters, i.e. “Data Source=XXX Initial Catalog=YYY Integrated Security=SSPI ” ProcedureName = stored procedure, or query statement with parameter markers. Parameters = NULL for no query parameters or a variant containing either a scalar value or safe array of multiple query parameters. Make sure the client declares any parameter vector as an array of variants, i.e. in VB, Dim Params(1 to 3) as Variant … Scalar entries can be any type recognized by the STD_SWITCH macro defined in QueryHandler.cpp. Result = Output string that holds the resulting row set XML. DocumentElementName = optional specification of the XML root node name. Default value is “root”.-This returns a string containing row sets in XML format. The method, GetXML, takes as parameters: DBService = SQL Server connection parameters, i.e. “Data Source=XXX Initial Catalog=YYY In

数据库课程设计。题目是教学管理系统。开发环境采用java+sql server 2000。-Database curriculum design. The topic of teaching management system. Development environment using java+ sql server 2000.

SQL技术培训文档，SQL语句操作性能进行优化方面，很有技术参考价值。(SQL technical training documents, SQL statements, operating performance optimization, very technical reference value.)

一个封装好的访问SQL Server数据库的源代码，用VB.NET写的。-a good visit Packaging SQL Server database of source code, written with VB.NET.

An SQL Query parser which allow you to see the route of the SQL select command.