页面query.aspx可以根据传递的id参数在数据库中进行查询,如: http://gqa-eric-lv/aspnet/MyBBSQuery/query.aspx?id=26 程序中可以使用this.Request.QueryString["ID"]获取查询字符串ID的值,如下例:
SqlConnection coreDB=new SqlConnection(); coreDB.ConnectionString= "workstation id=\"GQA-ERIC-LV\";packet size=4096;integrated security=SSPI;" + "data source=\"gqa-eric-lv\";persist security info=False;initial catalog=CoreDB"; int QueryID=3; string idStr=TextBox2.Text.Trim(); QueryID=Convert.ToInt32(this.Request.QueryString["ID"]); if(QueryID<0||TextBox2.Text.Trim()!="")return; string mySelectQuery = "SELECT ID,Title,Content FROM myBBS where id="+QueryID;
SqlCommand myCommand = new SqlCommand(mySelectQuery,coreDB);
coreDB.Open(); SqlDataReader myReader = myCommand.ExecuteReader(); try { while (myReader.Read()) { TextBox1.Text=myReader["title"].ToString(); TextBox2.Text=myReader["ID"].ToString(); TextBox3.Text=myReader["content"].ToString(); } } finally { myReader.Close(); coreDB.Close(); }
|