using?System;
using?System.Collections.Generic;
using?System.Linq;
using?System.Web;
using?System.Web.UI;
using?System.Web.UI.WebControls;
using?System.Data;
using?System.Data.SqlClient;
using?System.Configuration;

public?partial?class?_Default?:?System.Web.UI.Page
{
????string?sqlstr=ConfigurationManager.ConnectionStrings[“sqlstr“].ConnectionString;
????protected?void?Page_Load（object?sender?EventArgs?e）
????{
????????if?（!IsPostBack）
????????{
????????????GetData（）;
????????}
????????
????}
????private?void?GetData（）
????{
????????using?（SqlConnection?sqlcnn=new?SqlConnection（sqlstr））
????????{
????????????using?（SqlCommand?sqlcmm=sqlcnn.CreateCommand（））
????????????{
????????????????sqlcmm.CommandText?=?“select?*?from?Users“;
????????????????DataTable?dt?=?new?DataTable（）;
????????????????SqlDataAdapter?adapter?=?new?SqlDataAdapter（sqlcmm）;
????????????????adapter.Fill（dt）;
????????????????this.GridView1.DataSource?=?dt;
????????????????this.GridView1.DataBind（）;
????????????}
????????}
????}
????protected?void?btnAdd_Click（object?sender?EventArgs?e）
????{
????????using?（SqlConnection?sqlcnn=new?SqlConnection（sqlstr））
????????{
????????????using?（SqlCommand?sqlcmm=sqlcnn.CreateCommand（））
????????????{
????????????????sqlcmm.CommandText?=?“insert?into?users（userNameuserPassword）values（@userName@password）“;
????????????????sqlcmm.Parameters.AddWithValue（“@userName“this.txtName.Text）;
????????????????sqlcmm.Parameters.AddWithValue（“@password“this.txtPassword.Text）;
????????????????sqlcnn.Open（）;
????????????????int?i=?sqlcmm.ExecuteNonQuery（）;
????????????????if?（i?>?0）
????????????????{
????????????????????Response.Write（“ript>alert（‘添加成功！‘）ript>“）;
????????????????????GetData（）;
????????????????}
????????????????else
????????????????{

????????????????????Response.Write（“ript>alert（‘添加失敗！‘）ript>“）;
????????????????}
????????????}
????????}
????}//向數(shù)據(jù)庫(kù)添加數(shù)據(jù)

????protected?void?btnSeek_Click（object?sender?EventArgs?e）
????{
????????using?（SqlConnection?sqlcnn?=?new?SqlConnection（sqlstr））
????????{
????????????using?（SqlCommand?sqlcmm?=?sqlcnn.CreateCommand（））
????????????{
????????????????sqlcmm.CommandText?=?“select?*?from?users?where?username=@username“;
????????????????sqlcmm.Parameters.AddWithValue（“@userName“this.txtUser.Text）;
????????????????sqlcnn.Open（）;
????????????????SqlDataAdapter?adapter?=?new?SqlDataAdapter（sqlcmm）;
????????????????DataTable?dt?=?new?DataTable（）;
????????????????adapter.Fill（dt）;
????????????????this.GridView1.DataSource?=?dt;
????????????????this.GridView1.DataBind（）;
???????????????//?GetData（）;
????????????????
????????????}
????????}
????}//查詢數(shù)據(jù)
????protected?void?GridView1_RowDeleting（object?sender?GridViewDeleteEventArgs?e）
????{
???????
??????int?index?=?e.RowIndex;//獲取當(dāng)前行的索引
??????int?id=Convert.ToInt32（（this.GridView1.Rows[index].FindControl（“Label1“）?as?Label）.Text）;
??????using?（SqlConnection?sqlcn

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2012-04-15?19:19??GridView增刪改查\
?????目錄???????????0??2012-04-15?19:19??GridView增刪改查\數(shù)據(jù)庫(kù)\
?????文件?????3145728??2012-04-15?19:04??GridView增刪改查\數(shù)據(jù)庫(kù)\GridViewTest.mdf
?????文件?????1048576??2012-04-15?19:04??GridView增刪改查\數(shù)據(jù)庫(kù)\GridViewTest_log.ldf
?????目錄???????????0??2012-04-15?19:19??GridView增刪改查\源碼\
?????目錄???????????0??2012-04-15?17:05??GridView增刪改查\源碼\App_Data\
?????文件????????3948??2012-04-15?18:58??GridView增刪改查\源碼\Default.aspx
?????文件????????6143??2012-04-15?19:02??GridView增刪改查\源碼\Default.aspx.cs
?????文件?????????962??2012-04-15?17:05??GridView增刪改查\源碼\Global.asax
?????目錄???????????0??2012-04-15?19:19??GridView增刪改查\源碼\scripts\
?????文件??????239835??2010-05-04?06:45??GridView增刪改查\源碼\scripts\jquery-1.4.1-vsdoc.js
?????文件??????168792??2010-05-04?06:45??GridView增刪改查\源碼\scripts\jquery-1.4.1.js
?????文件???????71922??2010-05-04?06:45??GridView增刪改查\源碼\scripts\jquery-1.4.1.min.js
?????目錄???????????0??2012-04-15?19:19??GridView增刪改查\源碼\styles\
?????文件????????4258??2010-05-04?06:45??GridView增刪改查\源碼\styles\Site.css
?????文件????????1940??2012-04-15?17:19??GridView增刪改查\源碼\Web.config