ASP NET动态网站开发基础教程习题答案(5)

在Default.aspx.cs文件中的代码如下：

public partial class _Default : System.Web.UI.Page {

protected void Page_Load(object sender, EventArgs e) { }

protected void Button1_Click(object sender, EventArgs e) {

Service1.Service ws = new Service1.Service(); TextBox3.Text = ws.add(Convert.ToInt32(TextBox1.Text), Convert.ToInt32(TextBox2.Text)).ToString(); } }

3、在Service.cs文件中加入如下代码： [WebMethod]

public bool GetBook(out DataSet ds) {

String sqlconn = \.NET3.5动态网站开发基础教程\\\\代码\\\\chap10Ex\\\\ServiceEx\\\\App_Data\\\\BookStore.mdb;\OleDbConnection myConnection = new OleDbConnection(sqlconn); myConnection.Open();

OleDbDataAdapter myCommand = new OleDbDataAdapter(\ds = new DataSet(); myCommand.Fill(ds); return true; }

在该网站中添加一个名为DisplayBook.aspx的文件，在该文件中加入一个GridView控件，然后在DisplayBook.aspx.cs的Page_Load函数中加入如下代码： protected void Page_Load(object sender, EventArgs e) {

ServiceEx.Service svr = new ServiceEx.Service(); DataSet ds = new DataSet(); if(svr.GetBook(out ds)) {

GridView1.DataSource = ds; GridView1.DataBind(); } }

Chap11参考答案 一．填空题

1. 2. Name LoginUrl Protection TimeOut

3. Session_Start Session Session.Abandon Session.End 4. Glabal.asax HttpApplication Application_Start Application_EndRequest Application_End 二、选择题

1. ABCD 2.BCD 3.D 4. AD

Application_BeginRequest

三、上机实习题

1.Web.config里面连接信息的内容为：

Default.aspx.cs的内容为：

public partial class _Default : System.Web.UI.Page {

protected void Page_Load(object sender, EventArgs e) {

Configuration rootWebConfig = WebConfigurationManager.OpenWebConfiguration(\ConnectionStringSettings connString;

if (0 < rootWebConfig.ConnectionStrings.ConnectionStrings.Count) {

connString = rootWebConfig.ConnectionStrings.ConnectionStrings[1]; if (connString.ConnectionString != \{

OleDbConnection myConnection = new OleDbConnection(connString.ConnectionString); myConnection.Open();

OleDbDataAdapter myCommand = new OleDbDataAdapter(\DataSet ds = new DataSet(); myCommand.Fill(ds);

GridView1.DataSource = new DataView(ds.Tables[0]); GridView1.DataBind(); }

} } }

2. ChooseAuthor.aspx.cs的代码为：

public partial class ChooseAuthor : System.Web.UI.Page {

protected void Page_Load(object sender, EventArgs e) {

Label1.Text = Application[\}

protected void Button1_Click(object sender, EventArgs e) {

Session[\

Response.Redirect(\} }

DisplayWorks.aspx.cs的代码为：

public partial class DisplayWorks : System.Web.UI.Page {

protected void Page_Load(object sender, EventArgs e) {

Configuration rootWebConfig = WebConfigurationManager.OpenWebConfiguration(\//声明ConnectionStringSettings对象 ConnectionStringSettings connString;

//如果连接字符串大于０则继续查找连接信息，否则返回Nothing if (0 < rootWebConfig.ConnectionStrings.ConnectionStrings.Count) {

Label1.Text = Session[\

connString = rootWebConfig.ConnectionStrings.ConnectionStrings[1]; //得到连接信息

if (connString.ConnectionString != \{

SqlConnection myConnection = new SqlConnection(connString.ConnectionString); myConnection.Open();

string strSel = \作者 = '\SqlDataAdapter myCommand = new SqlDataAdapter(strSel, myConnection); DataSet ds = new DataSet(); myCommand.Fill(ds);

GridView1.DataSource = new DataView(ds.Tables[0]); GridView1.DataBind(); } }