using?System;
using?System.Collections.Generic;
using?System.Linq;
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?DataSetDemo?:?System.Web.UI.Page
{
????protected?void?Page_Load（object?sender?EventArgs?e）
????{

????}
????protected?void?btnSeek_Click（object?sender?EventArgs?e）
????{
????????//1.建立連接
????????//string?strConn?=“server=.;database=student;uid=sa;pwd=123456“;
????????string?strConn?=?ConfigurationManager.ConnectionStrings[“strConn“].ConnectionString;
????????SqlConnection?conn?=?new?SqlConnection（strConn）;
????????conn.Open（）;
????????//2.給出指令datadapter
????????string?sql?=?“select?*from?t_user“;
????????SqlDataAdapter?sda?=?new?SqlDataAdapter（sql?conn）;
????????DataSet?ds?=?new?DataSet（）;
????????sda.Fill（ds?“stuInfo“）;

????????//SqlCommand?cmd?=?new?SqlCommand（sql?conn）;
????????//SqlDataAdapter?sda2?=?new?SqlDataAdapter（）;
????????//sda2.SelectCommand?=?cmd;
????????//3.把數據讀取放入dataset里面

????????//4.斷開
????????conn.Close（）;
????????//5.把數據顯示在頁面上（從ds中讀取）
????????DataTable?dt?=?ds.Tables[“stuInfo“];
????????foreach?（DataRow?dr?in?dt.Rows）
????????{
????????????string?xh?=?dr[“xh“].ToString（）;
????????????string?username?=?dr[“username“].ToString（）;
????????????string?sex?=?getSex（dr[“sex“].ToString（））;
????????????string?birthday?=?dr[“birthday“].ToString（）;
????????????string?address?=?dr[“address“].ToString（）;
????????????Response.Write（“學號：“?+?xh?+?“ “?+?“姓名：“?+?username?+?“ “?+?“性別：“?+?sex?+?“ “?+?“出生日期：“?+?Convert.ToDateTime（dr[“birthday“]）.ToString（“yyyy年MM月dd日“）?+?“ “?+?“家庭地址：“?+?address）;
????????????Response.Write（“
“）;








????????}
????}
????private?string?getSex（object?sex）
????{

????????if?（Convert.ToBoolean（sex）?==?true）
????????????return?“男“;
????????else
????????????return?“女“;
????}


????protected?void?Button1_Click（object?sender?EventArgs?e）
????{
????????Response.Redirect（“http://localhost:801/Default.aspx“）;
????}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2018-04-30?15:47??web\
?????目錄???????????0??2018-04-30?15:47??web\aspnet_client\
?????目錄???????????0??2018-04-30?15:47??web\aspnet_client\system_web\
?????目錄???????????0??2018-04-30?15:47??web\aspnet_client\system_web\4_0_30319\
?????文件?????????618??2017-11-17?10:05??web\DataSetDemo.aspx
?????文件????????2233??2017-11-17?11:06??web\DataSetDemo.aspx.cs
?????文件?????????842??2017-11-17?10:04??web\Default.aspx
?????文件?????????280??2017-10-27?08:43??web\Default.aspx.cs
?????文件????????4446??2017-11-17?10:06??web\gridViewDemo.aspx
?????文件????????1111??2017-11-17?11:08??web\gridViewDemo.aspx.cs
?????文件????????2970??2017-11-03?10:15??web\userAdd.aspx
?????文件????????1906??2017-11-17?11:08??web\userAdd.aspx.cs
?????文件?????????490??2017-11-10?08:16??web\userDel.aspx
?????文件?????????420??2017-11-17?11:08??web\userDel.aspx.cs
?????文件????????2046??2017-11-03?10:13??web\userSelect.aspx
?????文件????????2712??2017-11-17?11:08??web\userSelect.aspx.cs
?????文件?????????496??2017-11-03?09:00??web\userUpdate.aspx
?????文件?????????423??2017-11-17?11:08??web\userUpdate.aspx.cs
?????文件?????????616??2017-11-17?08:29??web\Web.config