查询语句写不出来
代码如下
using System;
using System.Data.SqlClient;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
public partial class spots : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
string sid = Request.QueryString["id"].ToString();
try
{
ArrayList al = new ArrayList();
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
conn.Open();
SqlCommand Mycmd = new SqlCommand("select * from spots where id=@id", conn);
Mycmd.Parameters.Add("@id", System.Data.SqlDbType.Int);
Mycmd.Parameters["@id"].Value = int.Parse(sid);
SqlDataReader dr = Mycmd.ExecuteReader();
string sarea = dr["area"].ToString();
this.Label1.Text = sarea.ToString();
conn.Close();
}
catch (Exception ex)
{
this.Label1.Text = "出现错误的原因是:" + ex.Message.ToString();
}
}
}
id是int类型的.........
就是查不出数据来