蜗牛—C#程设之增删改查

查询数据库数据的数量

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

namespace shiyan
{
    class Program
    {
        static void Main(string[] args)
        {
            //Data Source指的是服务器名  Initial Catalog指的是数据库名 
            //如果Integrated Security为false需要指定ID和密码；否则将使用当前的Windows账户凭据进行身份验证
            string strCon = @"Data Source = .\SQLEXPRESS;  
                            Initial Catalog = TestDB;
                            Integrated Security = True;";
            SqlConnection sqlCon = new SqlConnection(strCon);   //执行连接
            try
            {
                sqlCon.Open();                                              //打开连接
                string sqlStr = @"select count(*) from JBQK";
                SqlCommand sqlCmd = new SqlCommand(sqlStr, sqlCon);
                int count = Convert.ToInt32(sqlCmd.ExecuteScalar());
                Console.WriteLine("基本情况数据表中俄记录共有{0}条。",count);
            }
            catch (Exception e)
            {
                Console.WriteLine("数据库连接失败");
                
            }
            sqlCon.Close();                                     //关闭连接
            Console.WriteLine("数据库关闭成功");
            Console.Read();
        }
    }
}

向数据库插入一条记录

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

namespace shiyan
{
    class Program
    {
        static void Main(string[] args)
        {
            //Data Source指的是服务器名  Initial Catalog指的是数据库名 
            //如果Integrated Security为false需要指定ID和密码；否则将使用当前的Windows账户凭据进行身份验证
            string strCon = @"Data Source = .\SQLEXPRESS;  
                            Initial Catalog = TestDB;
                            Integrated Security = True;";
            SqlConnection sqlCon = new SqlConnection(strCon);   //执行连接
            try
            {
                sqlCon.Open();                                              //打开连接
                string sqlStr = @"insert into JBQK(No,Name,XB,Grade,JG)"+
                    "values('20112253','张晓明','nan','1204','重庆市')";
                SqlCommand sqlCmd = new SqlCommand(sqlStr, sqlCon);
                sqlCmd.ExecuteNonQuery();
                Console.WriteLine("基本情况插入成功。");
            }
            catch (Exception e)
            {
                Console.WriteLine(e+"数据库连接失败");
                
            }
            sqlCon.Close();                                     //关闭连接
            Console.WriteLine("数据库关闭成功");
            Console.Read();
        }
    }
}

修改一条数据

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

namespace shiyan
{
    class Program
    {
        static void Main(string[] args)
        {
            //Data Source指的是服务器名  Initial Catalog指的是数据库名 
            //如果Integrated Security为false需要指定ID和密码；否则将使用当前的Windows账户凭据进行身份验证
            string strCon = @"Data Source = .\SQLEXPRESS;  
                            Initial Catalog = TestDB;
                            Integrated Security = True;";
            SqlConnection sqlCon = new SqlConnection(strCon);   //执行连接
            try
            {
                sqlCon.Open();                                              //打开连接
                string sqlStr = @"Update JBQK set JG='烟台市' where No='20112253'";
                SqlCommand sqlCmd = new SqlCommand(sqlStr, sqlCon);
                sqlCmd.ExecuteNonQuery();
                Console.WriteLine("基本情况修改成功。");
            }
            catch (Exception e)
            {
                Console.WriteLine(e+"数据库连接失败");
                
            }
            sqlCon.Close();                                     //关闭连接
            Console.WriteLine("数据库关闭成功");
            Console.Read();
        }
    }
}

删除一条数据

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

namespace shiyan
{
    class Program
    {
        static void Main(string[] args)
        {
            //Data Source指的是服务器名  Initial Catalog指的是数据库名 
            //如果Integrated Security为false需要指定ID和密码；否则将使用当前的Windows账户凭据进行身份验证
            string strCon = @"Data Source = .\SQLEXPRESS;  
                            Initial Catalog = TestDB;
                            Integrated Security = True;";
            SqlConnection sqlCon = new SqlConnection(strCon);   //执行连接
            try
            {
                sqlCon.Open();                                              //打开连接
                string sqlStr = @"delete from JBQK where No='20112253'";
                SqlCommand sqlCmd = new SqlCommand(sqlStr, sqlCon);
                sqlCmd.ExecuteNonQuery();
                Console.WriteLine("基本情况删除成功。");
            }
            catch (Exception e)
            {
                Console.WriteLine(e+"数据库连接失败");
                
            }
            sqlCon.Close();                                     //关闭连接
            Console.WriteLine("数据库关闭成功");
            Console.Read();
        }
    }
}