.net数据库连接实例代码

 

才学.NET数据库连接方面不久,在网上下载了部分代码,然后自己经过测试调试,写了以下的一段例程,仅

供象我一样的菜鸟学习了解.

该段代码实现了数据库操作的几个基本功能:插入,删除,显示等操作.

本人动手测试成功,利用了SQL Server2000中的pubs数据库中的stores表.

由于时间关系,没有写成完全可以利用的代码, 您可以自己修改使其更加完善.

dataOperator.cs:

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace MyFirstTestPro.dataconn
{
    class dataOperator
    {
        //数据库连接字符串
        private string sqlConnectionCommand = "Data Source=(local);Initial Catalog=pubs;User ID=sa;Pwd=admin";
        private string dataTableName = "stores";

        private string sqlSelectCommand = "select * from stores where stor_id='6380'";
        private string sqlDeleteCommand = "delete from stores where stor_id='1234'";

        private string id="";
        private string stor="";

        public void useSqlReader()
        {
            SqlConnection sqlConnection = new SqlConnection(sqlConnectionCommand);
            SqlCommand sqlCommand = new SqlCommand();
            sqlCommand.CommandType = System.Data.CommandType.Text;
            sqlCommand.Connection = sqlConnection;
            sqlCommand.CommandText = sqlSelectCommand;

            sqlConnection.Open();
            SqlDataReader sqlDataReader = sqlCommand.ExecuteReader();

            while (sqlDataReader.Read())
            {
                id =Convert.ToString(sqlDataReader["stor_id"]);  //int keywordid=(int)sqlDataReader["title_id"];
                stor =Convert.ToString(sqlDataReader["stor_name"]);  //string titlename=(string)sqlDataReader["title"];

            }

            sqlDataReader.Close();
            sqlCommand.Dispose();
            sqlConnection.Close();
        }

        public string getID()
        {
            return id;
        }

        public string getTitle()
        {
            return stor;
        }

        public void useDeleteDataSet()
        {
            SqlConnection sqlConnection = new SqlConnection(sqlConnectionCommand);
            SqlCommand sqlCommand = new SqlCommand();
            sqlCommand.CommandType = CommandType.Text;
            sqlCommand.Connection = sqlConnection;
            sqlCommand.CommandText = sqlDeleteCommand;
            sqlConnection.Open();

            int i= sqlCommand.ExecuteNonQuery();
            sqlCommand.Dispose();
            sqlConnection.Close();
       
        }
        public void UseAddDataSet(string storid, string storname)
        {
            SqlConnection sqlConnection = new SqlConnection(sqlConnectionCommand);
            SqlCommand sqlCommand = new SqlCommand();
            sqlCommand.CommandType = System.Data.CommandType.Text;
            sqlCommand.Connection = sqlConnection;
            sqlCommand.CommandText = sqlSelectCommand;

            sqlConnection.Open();
            SqlDataAdapter sqlDataAdapter = new SqlDataAdapter();
            sqlDataAdapter.SelectCommand = sqlCommand;
            DataSet dataSet = new DataSet();
            //sqlCommandBuilder is for update the dataset to database
            SqlCommandBuilder sqlCommandBuilder = new SqlCommandBuilder(sqlDataAdapter);
            sqlDataAdapter.Fill(dataSet, dataTableName);

            //Do something to dataset then you can update it to Database.Here I just add a row
            DataRow row = dataSet.Tables[0].NewRow();
            row[0] = storid;
            row[1] = storname;
            dataSet.Tables[0].Rows.Add(row);

            sqlDataAdapter.Update(dataSet, dataTableName);

            sqlCommand.Dispose();
            sqlDataAdapter.Dispose();
            sqlConnection.Close();
        }
    }
}