c#对MSSQL一些简单的操作

 

以下的所有操作都是针对MSSQL2000，Northwin库中Region表的操作！

 

//############开始#####################

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

namespace ConsoleApplication1
{
    class Program
    {
        SqlConnection conn;
        SqlCommand cmd;
        SqlDataReader rs;
        /// <summary>
        /// 一般的读取
        /// </summary>
        public void ReadRS() {
            conn = new SqlConnection("server=.;database=Northwind;Integrated Security=SSPI");
            conn.Open();
            cmd = new SqlCommand("select * from Region", conn);
            rs = cmd.ExecuteReader();

            while(rs.Read()){
                Console.WriteLine("ID：{0} 方向：{1}", rs["RegionID"].ToString(), rs[1].ToString());
            }
            rs.Close();
            cmd.Dispose();
            conn.Close();
        }
        /// <summary>
        /// 插入记录
        /// </summary>
        public void Insert() {
            try
            {
                conn = new SqlConnection("server=.;database=Northwind;Integrated Security=SSPI");
                conn.Open();
                cmd = new SqlCommand("Insert into Region values (5,'中国')", conn);
                cmd.ExecuteNonQuery();
                Console.WriteLine("插入成功！");
            }
            catch(Exception e)
            {
                Console.WriteLine(e.Message);
            }
            finally {
                conn.Close();
            }
 
        }
        /// <summary>
        /// 修改记录
        /// </summary>
        public void Update() {
            try
            {
                conn = new SqlConnection("server=.;database=Northwind;Integrated Security=SSPI");
                conn.Open();
                cmd = new SqlCommand("Update Region set RegionDescription='china' where RegionID=5", conn);
                cmd.ExecuteNonQuery();
                Console.WriteLine("修改成功！");
            }
            catch (Exception e)
            {
                Console.WriteLine(e.Message);
            }
            finally
            {
                conn.Close();
            }
        }
        public void Del() {
            try
            {
                conn = new SqlConnection("server=.;database=Northwind;Integrated Security=SSPI");
                conn.Open();
                cmd = new SqlCommand("Delete Region where RegionID=5", conn);
                cmd.ExecuteNonQuery();
                Console.WriteLine("删除成功！");
            }
            catch (Exception e)
            {
                Console.WriteLine(e.Message);
            }
            finally
            {
                conn.Close();
            }
        }
        /// <summary>
        ///
        /// </summary>
        /// <param name="args"></param>
        static void Main(string[] args)
        {
            Program p = new Program();
            p.ReadRS();
            //p.Insert();
            //p.Update();
            //p.Del();
        }
    }
}
//#####结束##########