protected void add_Click(object sender, EventArgs e) { try { string stringSql = "select * from tb_User where Name='" + this.username.Text.Trim() + "' and PassWord='******'"; string sqlstring = "insert into tb_User (Name,PassWord,Level) values('" + this.username.Text.Trim() + "','" + this.pwd.Text.Trim() + "','" + "2" + "')"; SqlDataReader dr = da.ExecuteRead(stringSql); dr.Read(); if (dr.HasRows) { this.lblMessage.Text = "该用户已存在"; dr.Close(); } else { dr.Close(); SqlDataReader sdr = da.ExecuteRead(sqlstring); this.lblMessage.Text = "用户添加成功"; Response.Redirect("~/Default.aspx"); } } catch { this.lblMessage.Text = "添加失败"; } }
protected void gvEditAdmin_RowDeleting(object sender, GridViewDeleteEventArgs e) { int id = Convert.ToInt32(gdvUserManage.DataKeys[e.RowIndex].Value.ToString()); SqlDataReader sdr = da.ExecuteRead("Delete from tb_User where ID='" + id + "'"); sdr.Close(); Bind(); }
protected void btnUpdate_Click(object sender, EventArgs e) { string sqlstring = " UPDATE tb_News SET Title = '" + this.txtNewsTitle.Text + "', Content = '" + this.txtNewsContent.Text + "', Categories = '" + this.labTitle.Text.Trim() + "', Type = '" + this.dlstNewsType.SelectedValue.ToString() + "' WHERE ID = '" + Request.QueryString["id"] + "'"; SqlDataReader sdr = da.ExecuteRead(sqlstring); lblMessage.Text = "新闻修改成功!"; }
public static SqlDataReader GetDataReader(string sqlstr) { SqlData sql = new SqlData(); SqlDataReader reader = sql.ExecuteRead(sqlstr); return(reader); }
protected void btnAdd_Click(object sender, EventArgs e) { string sqlstring = "INSERT INTO tb_News( Title, Content, Categories, Type, IssueDate)VALUES ('" + this.txtNewsTitle.Text.Trim() + "', '" + this.txtNewsContent.Text.Trim() + "', '" + this.labTitle.Text.Trim() + "', '" + this.dlstNewsType.SelectedValue.ToString() + "', '" + DateTime.Now.ToString("yyyy-MM-dd") + "')"; SqlDataReader sdr = da.ExecuteRead(sqlstring); this.lblMessage.Text = "新闻添加成功!"; }
protected void btnAdd_Click(object sender, EventArgs e) { string fn = this.FileUpload1.FileName; string url = "~/accessory/" + fn; this.FileUpload1.PostedFile.SaveAs(Server.MapPath(url)); string sqlstring = "INSERT INTO tb_News( Title, Content, Categories, Type, IssueDate, url)VALUES ('" + this.txtNewsTitle.Text.Trim() + "', '" + this.txtNewsContent.Text.Trim() + "', '" + this.labTitle.Text.Trim() + "', '" + this.dlstNewsType.SelectedValue.ToString() + "', '" + DateTime.Now.ToString("yyyy-MM-dd") + "', '" + url + "')"; SqlDataReader sdr = da.ExecuteRead(sqlstring); this.lblMessage.Text = "新闻添加成功!"; }
protected void btnUpdate_Click(object sender, EventArgs e) { string fn = this.FileUpload1.FileName; string url = "~/accessory/" + fn; this.FileUpload1.PostedFile.SaveAs(Server.MapPath(url)); string sqlstring = " UPDATE tb_News SET Title = '" + this.txtNewsTitle.Text + "', url = '" + url + "', Content = '" + this.txtNewsContent.Text + "', Categories = '" + this.labTitle.Text.Trim() + "', Type = '" + this.dlstNewsType.SelectedValue.ToString() + "' WHERE ID = '" + Request.QueryString["id"] + "'"; SqlDataReader sdr = da.ExecuteRead(sqlstring); lblMessage.Text = "新闻修改成功!"; }
protected void gvdNews_RowDeleting(object sender, GridViewDeleteEventArgs e) { SqlDataReader sdr = da.ExecuteRead("delete from tb_News where id='" + this.gvdNews.DataKeys[e.RowIndex].Value.ToString() + "'"); sdr.Close(); if (number == 1) { this.SelectBind(); } else { bind(); } }
protected void submit_Click(object sender, EventArgs e) { string sqlstring = "select * from tb_User where Name='" + this.username.Text.Trim() + "' and PassWord='******'"; SqlDataReader sdr = da.ExecuteRead(sqlstring); sdr.Read(); if (sdr.HasRows) { if (this.checkCode.Text.Trim() == this.verifyCode.Text.Trim()) { Response.Redirect("Default.aspx?validate=1"); } else { Response.Write("<script>alert('输入的验证码错误!')</script>"); } } else { Response.Write("<script>alert('输入的姓名或密码错误误!请重新输入')</script>"); Server.Transfer("Login.aspx"); } }
protected void Page_Load(object sender, EventArgs e) { SqlData da = new SqlData(); string strShiShi = "select top 5 * from tb_News where Categories='时事新闻' order by issueDate desc"; string strEconomic = "select top 5 * from tb_News where Categories='环球经济' order by issueDate desc"; string strMilitary = "select top 5 * from tb_News where Categories='军事世界' order by issueDate desc"; string strScience = "select top 5 * from tb_News where Categories='科学技术' order by issueDate desc"; string strSocial = "select top 5 * from tb_News where Categories='社会百态' order by issueDate desc"; string strSports = "select top 5 * from tb_News where Categories='世界体育' order by issueDate desc"; string strFun = "select top 5 * from tb_News where Categories='娱乐综艺' order by issueDate desc"; string strLife = "select top 5 * from tb_News where Categories='生活理财' order by issueDate desc"; SqlDataReader dar = da.ExecuteRead(strShiShi); dlstShiShi.DataSource = dar; dlstShiShi.DataKeyField = "id"; dlstShiShi.DataBind(); dar.Close(); SqlDataReader sdrEco = da.ExecuteRead(strEconomic); dlstEconomic.DataSource = sdrEco; dlstEconomic.DataKeyField = "id"; dlstEconomic.DataBind(); sdrEco.Close(); SqlDataReader sdrM = da.ExecuteRead(strMilitary); dlstMilitary.DataSource = sdrM; dlstMilitary.DataKeyField = "id"; dlstMilitary.DataBind(); sdrM.Close(); SqlDataReader sdrS = da.ExecuteRead(strScience); dlstScience.DataSource = sdrS; dlstScience.DataKeyField = "id"; dlstScience.DataBind(); sdrS.Close(); SqlDataReader sdrSoc = da.ExecuteRead(strSocial); dlstSocial.DataSource = sdrSoc; dlstSocial.DataKeyField = "id"; dlstSocial.DataBind(); sdrSoc.Close(); SqlDataReader sdrSp = da.ExecuteRead(strSports); dlstSports.DataSource = sdrSp; dlstSports.DataKeyField = "id"; dlstSports.DataBind(); sdrSp.Close(); SqlDataReader sdrFun = da.ExecuteRead(strFun); dlstFun.DataSource = sdrFun; dlstFun.DataKeyField = "id"; dlstFun.DataBind(); sdrFun.Close(); SqlDataReader sdrLife = da.ExecuteRead(strLife); dlstLife.DataSource = sdrLife; dlstLife.DataKeyField = "id"; dlstLife.DataBind(); sdrLife.Close(); }
protected void Page_Load(object sender, EventArgs e) { object validate = Request.QueryString["validate"]; if (validate == null || !validate.ToString().Trim().Equals("1")) { this.login_flag.Text = "please login"; return; } SqlData da = new SqlData(); string strShiShi = "select top 5 * from tb_News where Categories='时事新闻' order by issueDate desc"; string strEconomic = "select top 5 * from tb_News where Categories='环球经济' order by issueDate desc"; string strMilitary = "select top 5 * from tb_News where Categories='军事世界' order by issueDate desc"; string strScience = "select top 5 * from tb_News where Categories='科学技术' order by issueDate desc"; string strSocial = "select top 5 * from tb_News where Categories='社会百态' order by issueDate desc"; string strSports = "select top 5 * from tb_News where Categories='世界体育' order by issueDate desc"; string strFun = "select top 5 * from tb_News where Categories='娱乐综艺' order by issueDate desc"; string strLife = "select top 5 * from tb_News where Categories='生活理财' order by issueDate desc"; SqlDataReader dar = da.ExecuteRead(strShiShi); dlstShiShi.DataSource = dar; dlstShiShi.DataKeyField = "id"; dlstShiShi.DataBind(); dar.Close(); SqlDataReader sdrEco = da.ExecuteRead(strEconomic); dlstEconomic.DataSource = sdrEco; dlstEconomic.DataKeyField = "id"; dlstEconomic.DataBind(); sdrEco.Close(); SqlDataReader sdrM = da.ExecuteRead(strMilitary); dlstMilitary.DataSource = sdrM; dlstMilitary.DataKeyField = "id"; dlstMilitary.DataBind(); sdrM.Close(); SqlDataReader sdrS = da.ExecuteRead(strScience); dlstScience.DataSource = sdrS; dlstScience.DataKeyField = "id"; dlstScience.DataBind(); sdrS.Close(); SqlDataReader sdrSoc = da.ExecuteRead(strSocial); dlstSocial.DataSource = sdrSoc; dlstSocial.DataKeyField = "id"; dlstSocial.DataBind(); sdrSoc.Close(); SqlDataReader sdrSp = da.ExecuteRead(strSports); dlstSports.DataSource = sdrSp; dlstSports.DataKeyField = "id"; dlstSports.DataBind(); sdrSp.Close(); SqlDataReader sdrFun = da.ExecuteRead(strFun); dlstFun.DataSource = sdrFun; dlstFun.DataKeyField = "id"; dlstFun.DataBind(); sdrFun.Close(); SqlDataReader sdrLife = da.ExecuteRead(strLife); dlstLife.DataSource = sdrLife; dlstLife.DataKeyField = "id"; dlstLife.DataBind(); sdrLife.Close(); }