ADO.Net:向程序传递查询字符串

页面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();

}