C # Write database operations!

Source: Internet
Author: User

For some reason, the database software on which the software depends will change! If the opening and operation code of the database appear on each page, it will be quite troublesome to modify the code after the database software is changed. Therefore, writing database operation code into a class will not cause the above situation and reduce the amount of code. Source code
Using System;
Using System. Data;
Using System. Data. SqlClient;
Namespace news. common
{
/**
*-----------------
* Database connection/Operation
* Create
* Ryan_bin@126.com
*----------------
*/
Public class DBClass
{
/* ---- Global variable definition ------*/
Private SqlConnection conn;
Private SqlCommand comm;
Public SqlDataReader dr;
Public DataSet ds;
Public SqlDataAdapter dad;
Private string SQL;
Private string connStr;/* database connection string */
Private string errInfo = "";
/*----------------------*/

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.