yucheng的部落格

C# 連線至 資料庫

using System.Data.SqlClient; //引用sql命名空間

private SqlConnection conn; //資料庫連接

private SqlCommand cmd; //增刪修

private SqlDataAdapter da; //查詢

private DataTable dt = new DataTable(); //虛擬表

pirvate string sql = ””; //存放資料庫語法

conn = new Sqlconnection (“Server = 127.0.0.1; Database = test; UID = sa; PWD =1234”);

//資料庫連線設定

conn.Open (); //開啟資料庫

da = new SqlDataAdapter (“Select * From test”, conn); //查詢

da.Fill (dt); //資料庫傳到虛擬表

dataGridView1.DataSource = dt; //實體表連接虛擬表

conn.Close (); //關閉資料庫連接

***查詢***

da = new SqlDataAdapter (“Select * From test”, conn);

da.Fill (dt);

dataGridView1.DataSource = dt; 

***新增***

sql = ”INSERT INTO test (column1, column2) VALUES (‘cell1’, ‘cell2’)”;

cmd = new SqlCommand (sql, conn);

cmd.ExecuteNonQuery ();

***修改***

sql = ”Update test SET column2 = ’cell2’ Where column1 = ’cell1’ ”;

cmd = new SqlCommand (sql, conn);

cmd.ExecuteNonQuery ();

***刪除***

sql = ”Delete From test Where column1 = ’ cell1’ ” ;

cmd = new SqlCommand (sql, conn);

cmd.ExecuteNonQuery ();