62,025
社区成员
发帖
与我相关
我的任务
分享
protected void show()
{
if(Request["m_id"]==null)
reurn;
string m_id = Request["m_id"].ToString();
SqlConnection con = new SqlConnection(connectionstring);
con.Open();
string selectmessage = "select * from message where m_id='" + m_id + "'";
SqlCommand cmd = new SqlCommand(selectmessage, con);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
this.Tbname.Text = dr["m_name"]==null?"":dr["m_name"].ToString();
this.Tbsubject.Text = dr["m_subject"]==null?"":dr["m_subject"].ToString();
this.Tbcontent.Text = dr["m_content"]==null?"":dr["m_content"].ToString();
this.TBreplay.Text = dr["m_replay"]==null?"":dr["m_replay"].ToString();
}
private string connectionstring = ConfigurationManager.ConnectionStrings["connection"].ConnectionString;//连接字符串
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)//如果是第一次访问这个页面
{
show();
}
}
protected void show()
{
string m_id = Request["m_id"].ToString();//获取参数,可能是这里的问题,URL中没有参数。
SqlConnection con = new SqlConnection(connectionstring);
con.Open();//打开数据库连接
string selectmessage = "select * from message where m_id='" + m_id + "'";
SqlCommand cmd = new SqlCommand(selectmessage, con);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())//从数据库中逐行读取数据
{
this.Tbname.Text = dr["m_name"].ToString();
this.Tbsubject.Text = dr["m_subject"].ToString();
this.Tbcontent.Text = dr["m_content"].ToString();
this.TBreplay.Text = dr["m_replay"].ToString();
}
dr.Close();//关闭datareader
con.Close();//关闭数据库连接
}
string m_id !=null? Request["m_id"].ToString():"测试下";