62,046
社区成员
发帖
与我相关
我的任务
分享
private void page_load(object sender, EventArgs e)
{
string Userid = Request.QueryString["userid"];
string filename = Request.QueryString["Filename"];
string ConnSql = System.Configuration.ConfigurationManager.AppSettings["SqlConnection"];
SqlConnection conn = new SqlConnection(ConnSql);
string sql = "select img2 from hls where userid='" + Userid + "'";
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
dr.Close();
string newimg2 = "test_a.jpg";
sql = "update hls set img2='" + newimg2 + "' where userid='" + Userid + "'";
cmd = new SqlCommand(sql, conn);
cmd.ExecuteNonQuery();
}
else
dr.Close();
}