C# 對SqlServer資料庫增刪改查

標籤：[]   cmd   values   sys   條件   pwd   log   set   console   

http://www.worlduc.com/blog2012.aspx?bid=730767

用C#sqlserver實現增刪改查

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

namespace ConsoleApplication2
{
    class Program
    {
        static void Main(string[] args)
        {

            while (true)
            {
                SqlConnection con = new SqlConnection();
                con.ConnectionString = "server=505-03;database=ttt;user=sa;pwd=123";
                con.Open();
                SqlCommand cmd = new SqlCommand();
                cmd.Connection = con;
                string sql="";

                Console.WriteLine("增加請輸入1；刪除請輸入2；修改請輸入3；尋找請輸入4");
                int i = Convert.ToInt32(Console.ReadLine());
                string str = "";
                switch (i)
                {
                    case 1:
                        sql = "insert into ";
                        Console.WriteLine("請輸入你要修改的表");
                        str = Console.ReadLine();
                        sql += str + "(";
                        Console.WriteLine("請輸入你要修改的列名，用逗號隔開");
                        str = Console.ReadLine();
                        sql += str + ")";
                        Console.WriteLine("請輸入相應的資料，用逗號隔開");
                        str = Console.ReadLine();
                        sql += " values (" + str+")";
                        break;
                    case 2:
                        sql = "DELETE FROM ";
                        Console.WriteLine("請輸入表名");
                        str = Console.ReadLine();
                        sql += str;
                        Console.WriteLine("請輸入刪除的條件");
                        str = Console.ReadLine();
                        sql += " where " + str;
                        break;
                    case 3:
                        sql = "UPDATE ";
                        Console.WriteLine("請輸入表名");
                        str = Console.ReadLine();
                        sql += str + " set ";
                        Console.WriteLine("請輸入要修改的資料，如money=0,多個用逗號隔開");
                        str = Console.ReadLine();
                        sql += str;
                        Console.WriteLine("請輸入要修改的條件");
                        str = Console.ReadLine();
                        sql += " where " + str;
                        break;
                    case 4:
                        sql = "select ";
                        Console.WriteLine("請輸入你要查詢的列名，多個用逗號隔開");
                        str = Console.ReadLine();
                        sql += str;
                        Console.WriteLine("請輸入你要查詢的表名，多個用逗號隔開");
                        str = Console.ReadLine();
                        sql += " from " + str;
                        break;

                }
                cmd.CommandText = sql;
                cmd.CommandType = CommandType.Text;
                cmd.ExecuteNonQuery();
            }

        }
    }
}

C# 對SqlServer資料庫增刪改查