C#對(duì)于sql server數(shù)據(jù)庫(kù)的簡(jiǎn)單操作

1.在用windows模式登陸sql server 數(shù)據(jù)庫(kù) 簡(jiǎn)歷一個(gè)student的數(shù)據(jù)庫(kù)，然后新建查詢：

create table student( id     int  auto_increment  PRimary key, name char(10) not null, sex    char(10) not null, age   char(10) not null,   )

2.在vs中新建一個(gè)項(xiàng)目，輸入一下代碼：

using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Threading.Tasks;using System.Data;using System.Data.SqlClient;namespace Consoleapplication1{    class Program    {        static void Main(string[] args)        {            string connSting;            connSting = "server=localhost;database=student;Integrated Security=True ";            SqlConnection sConn = new SqlConnection(connSting);            try            {                sConn.Open();            }            catch (Exception ex)            {                Console.WriteLine("鏈接錯(cuò)誤:" + ex.Message);            }            string sqlMessage=null;            sqlMessage = "select * from student";            SqlCommand sCmd = new SqlCommand(sqlMessage, sConn);            SqlDataReader sdr = null;            try            {                sdr = sCmd.ExecuteReader();                            Console.WriteLine(" 姓名   性別   年齡 ");                while (sdr.Read())                {                    Console.WriteLine(sdr["name"] +""+ sdr["sex"]+"" + sdr["age"]);                }                sConn.Close();            }            catch (Exception ex)            {                Console.WriteLine(ex.Message);            }            Console.ReadLine();        }    }}

3.運(yùn)行結(jié)果將會(huì)顯示數(shù)據(jù)庫(kù)中的數(shù)據(jù)