控制台实现数据库的增删改查

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data.SqlClient;
using System.Configuration;
using winformlogin;

namespace datareader
{
    class Program
    {
        static void Main(string[] args)
        {
            string bankStr = DBHelper.connStr;
            using (SqlConnection con = new SqlConnection(bankStr))
            {
                //string sql = "insert into Grade values(@GradeName)";
                //string sql = "update Grade set GradeName=@GradeName where GradeName='s8'";
                string sql = "delete from Grade where GradeName=@GradeName";
                SqlCommand cmd = new SqlCommand(sql,con);
                cmd.Parameters.AddWithValue("@GradeName",Console.ReadLine());
                con.Open();
                int n = cmd.ExecuteNonQuery();
                if (n != 1)
                {
                    Console.WriteLine("error");
                }
            }
            Console.ReadKey();
        }
    }
}

至于select:

用datareader。

posted on 2015-03-18 15:05  飞哥Penfield  阅读(252)  评论(0编辑  收藏  举报

导航