ASP.NET(C#)串連資料庫和操作資料庫

標籤：

首先加入命名空間using System.Data.SqlClient;

1.查詢

SqlConnection conn = new SqlConnection();

conn.ConnectionString = "Data Source=(local);Initial Catalog=資料庫名;UserID=sa;Password=123456";

conn.Open();

string strsql=“select語句";

SqlCommand cmd = new SqlCommand(strsql, conn);

SqlDataReader sqlreader = cmd.ExecuteReader();

while (sqlreader.Read())

{

txtName.Text= sqlreader["列名"].ToString();

}

sqlreader.Close();

conn.Close();

2.插入、更新、刪除

SqlConnection conn = new SqlConnection();

conn.ConnectionString = "Data Source=(local);Initial Catalog=資料庫名;UserID=sa;Password=123456";

conn.Open();

strsql="update語句";// strsql="插入語句";//strsql="刪除語句";

SqlCommand sqlcmd2 = new SqlCommand(strsql, conn);

int iResult = sqlcmd2.ExecuteNonQuery();

conn.Close();

ASP.NET(C#)串連資料庫和操作資料庫