日期:2014-05-18 浏览次数:21002 次
protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{
SqlConnection con = new SqlConnection();
con.ConnectionString = "server=(local);database=Meet;Integrated Security=SSPI";// 创建命令(SqlCommand)对象(cmd)
SqlCommand cmd = new SqlCommand();
cmd.Connection = con; // 指示命令发给哪个数据库
cmd.CommandType = CommandType.Text; // 指示是什么类型的命令
cmd.CommandText = "select * from [care] where NAME_user = '" + this.Label3.Text.ToString() + " ' and TITLE_meet = '" + this.titlelabel.Text.ToString() + " '";
con.Open();
SqlDataReader reader = cmd.ExecuteReader();
try
{
if (reader.Read())
{
reader.Close();
Response.Write(" <script>alert(' 您已关注过此会议 ') </script>");
}
else
{
reader.Close();
cmd.CommandText = "update [meet] set HOT_meet = HOT_meet + 1 where TITLE_meet='" + this.titlelabel.Text.ToString() + "'";
SqlCommand cmd2 = new SqlCommand();
cmd2.Connection = con;
cmd2.CommandType = CommandType.Text;
cmd2.CommandText = "insert into [care](NAME_user,TITLE_meet) values(@nameuser,@meettitle)";
cmd2.Parameters.Add("@nameuser",SqlDbType.VarChar,50);
cmd2.Parameters["@nameuser"].Value = Label3.Text;
cmd2.Parameters.Add("@meettitle", SqlDbType.VarChar,100);
cmd2.Parameters["@meettitle"].Value = titlelabel.Text;
int i = cmd.ExecuteNonQuery();
Response.Write("<script>alert('您已经关注成功');</script>");
hotlabel.Text = Convert.ToString(Convert.ToInt32(hotlabel.Text) + 1);
}
con.Close();
}
catch
{
}
}