資源簡介
ado.net連接SQL數據庫
代碼片段和文件信息
using?System;
using?System.Collections;
using?System.Collections.Generic;
using?System.Web;
using?System.Web.UI;
using?System.Web.UI.WebControls;
using?System.Configuration;
using?System.Data;
using?System.Data.SqlClient;
public?partial?class?_Default?:?System.Web.UI.Page
{
????protected?void?Page_Load(object?sender?EventArgs?e)
????{
????????updateData();
????}
????private?void?updateData()
????{
????????string?Con?=?ConfigurationManager.ConnectionStrings[“itNews“].ConnectionString;
????????SqlConnection?Myconn?=?new?SqlConnection(Con);
????????Myconn.Open();
????????string?SQLStr?=?“update?tUser?set?myPass=‘1111‘“;
????????SqlCommand?cmd?=?new?SqlCommand(SQLStr?Myconn);
????????cmd.ExecuteNonQuery();
????}
????public?void?UpdateDataWithProcNoParameter(
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件???????4170??2015-12-07?05:51??連接數據庫\App_Code\MyAdoCS.cs
?????文件????????947??2015-12-07?15:43??連接數據庫\Default.aspx
?????文件???????4616??2015-12-07?16:51??連接數據庫\Default.aspx.cs
?????文件????????815??2015-12-07?14:36??連接數據庫\Web.config
?????文件???????1306??2015-12-07?05:09??連接數據庫\Web.Debug.config
?????目錄??????????0??2015-12-07?06:01??連接數據庫\App_Code
?????目錄??????????0??2015-12-07?16:51??連接數據庫
-----------?---------??----------?-----??----
????????????????11854????????????????????7
- 上一篇:打卡系統
- 下一篇:asp+access 電影網站源碼
評論
共有 條評論