protected void btnSearch_Click(object sender, EventArgs e) { SqlData da = new SqlData(); string search = ddlSearch.SelectedValue; switch (search) { case "联系人ID": da.BindData(GridView1, "Select * From tb_Message Where MessageID Like '%" + txtKey.Text + "%' and BlogID='" + ID + "'"); break; case "姓名": da.BindData(GridView1, "Select * From tb_Message Where FriendName Like '%" + txtKey.Text + "%' and BlogID='" + ID + "'"); break; case "QQ": da.BindData(GridView1, "Select * From tb_Message Where QQ Like '%" + txtKey.Text + "%' and BlogID='" + ID + "'"); break; default: Response.Write("<script lanuage=javascript>alert('出错拉!');location='javascript:history.go(-1)'</script>"); break; } }
protected void btnSearch_Click(object sender, EventArgs e) { //定义一个字符变量search来存储下拉列表框中条件值 string search = ddlSearch.SelectedValue; //根据选择的条件不同显示不同结果 switch (search) { //根据文章编号进行模糊查询 case "文章ID": da.BindData(GridView1, "Select * From ST_news Where ST_n_id Like '%" + txtKey.Text + "%' and BlogID='" + ID + "'"); break; //根据文章主题进行模糊查询 case "文章主题": da.BindData(GridView1, "Select * From ST_news Where ST_n_title Like '%" + txtKey.Text + "%' and BlogID='" + ID + "'"); break; default: //查询如果失败,弹出失败对话框 Response.Write("<script lanuage=javascript>alert('查询失败!');location='javascript:history.go(-1)'</script>"); break; } }
protected void btnSearch_Click(object sender, EventArgs e) { SqlData da = new SqlData(); string search = this.ddlSearch.SelectedValue; switch (search) { case "文章ID": da.BindData(this.GridView1, "Select * From tb_Article Where ArticleID Like '%" + this.txtKey.Text + "%' and BlogID='" + ID + "'"); break; case "文章主题": da.BindData(this.GridView1, "Select * From tb_Article Where Subject Like '%" + this.txtKey.Text + "%' and BlogID='" + ID + "'"); break; default: Response.Write("<script lanuage=javascript>alert('出错拉!');location='javascript:history.go(-1)'</script>"); break; } }
protected void btnSearch_Click(object sender, EventArgs e) { SqlData da = new SqlData(); string search = this.ddlSelect.SelectedValue; switch (search) { case "类型编号": da.BindData(this.ClassList, "Select * From ST_class Where ST_c_id Like '%" + this.txtKey.Text + "%'"); break; case "文章类型": da.BindData(this.ClassList, "Select * From ST_class Where ST_c_name Like '%" + this.txtKey.Text + "%'"); break; default: Response.Write("<script lanuage=javascript>alert('出错啦!');location='javascript:history.go(-1)'</script>"); break; } }
protected void btnSearch_Click(object sender, EventArgs e) { SqlData da = new SqlData(); string search=this.ddlSearch.SelectedValue; switch (search) { case "管理员ID": da.BindData(this.gvAdmin, "Select * From tb_Admin Where ID Like '%" + this.txtKey.Text + "%'"); break; case "用户名": da.BindData(this.gvAdmin, "Select * From tb_Admin Where UserName Like '%" + this.txtKey.Text + "%'"); break; case "QQ": da.BindData(this.gvAdmin, "Select * From tb_Admin Where QQ Like '%" + this.txtKey.Text + "%'"); break; default: Response.Write("<script lanuage=javascript>alert('出错拉!');location='javascript:history.go(-1)'</script>"); break; } }
protected void btnSearch_Click(object sender, EventArgs e) { SqlData da = new SqlData(); string search = this.ddlSearch.SelectedValue; switch (search) { case "地址ID": da.BindData(this.GridView1, "Select * From ST_link Where ST_l_id Like '%" + this.txtKey.Text + "%'"); break; case "网站名称": da.BindData(this.GridView1, "Select * From ST_link Where ST_l_name Like '%" + this.txtKey.Text + "%'"); break; case "链接网址": da.BindData(this.GridView1, "Select * From ST_link Where ST_l_url Like '%" + this.txtKey.Text + "%'"); break; default: Response.Write("<script lanuage=javascript>alert('查询失败!');location='javascript:history.go(-1)'</script>"); break; } }
protected void btnSearch_Click(object sender, EventArgs e) { SqlData da = new SqlData(); string search=this.ddlSearch.SelectedValue; switch (search) { case "联系人ID": da.BindData(this.GridView1, "Select * From tb_Message Where MessageID Like '%" + this.txtKey.Text + "%' and BlogID='"+ID+"'"); break; case "姓名": da.BindData(this.GridView1, "Select * From tb_Message Where FriendName Like '%" + this.txtKey.Text + "%' and BlogID='" + ID + "'"); break; case "QQ": da.BindData(this.GridView1, "Select * From tb_Message Where QQ Like '%" + this.txtKey.Text + "%' and BlogID='" + ID + "'"); break; default: Response.Write("<script lanuage=javascript>alert('出错拉!');location='javascript:history.go(-1)'</script>"); break; } }
protected void btnSearch_Click(object sender, EventArgs e) { SqlData da = new SqlData(); string search = ddlSearch.SelectedValue; switch (search) { case "地址ID": da.BindData(GridView1, "Select * From ST_link Where ST_l_id Like '%" + txtKey.Text + "%'"); break; case "网站名称": da.BindData(GridView1, "Select * From ST_link Where ST_l_name Like '%" + txtKey.Text + "%'"); break; case "链接网址": da.BindData(GridView1, "Select * From ST_link Where ST_l_url Like '%" + txtKey.Text + "%'"); break; default: Response.Write("<script lanuage=javascript>alert('查询失败!');location='javascript:history.go(-1)'</script>"); break; } }
protected void btnSearch_Click(object sender, EventArgs e) { SqlData da = new SqlData(); string search = this.ddlSearch.SelectedValue; switch (search) { case "地址ID": da.BindData(this.GridView1, "Select * From tb_Href Where HrefID Like '%" + this.txtKey.Text + "%'"); break; case "网站名称": da.BindData(this.GridView1, "Select * From tb_Href Where Name Like '%" + this.txtKey.Text + "%'"); break; case "链接网址": da.BindData(this.GridView1, "Select * From tb_Href Where Url Like '%" + this.txtKey.Text + "%'"); break; default: Response.Write("<script lanuage=javascript>alert('出错拉!');location='javascript:history.go(-1)'</script>"); break; } }
protected void btnSearch_Click(object sender, EventArgs e) { SqlData da = new SqlData(); string search = this.ddlSearch.SelectedValue; switch (search) { case "博客ID": da.BindData(this.gvBlog, "Select * From tb_Blog Where BlogID Like '%" + this.txtKey.Text + "%'"); break; case "博客姓名": da.BindData(this.gvBlog, "Select * From tb_Blog Where UserName Like '%" + this.txtKey.Text + "%'"); break; case "QQ": da.BindData(this.gvBlog, "Select * From tb_Blog Where QQ Like '%" + this.txtKey.Text + "%'"); break; default: Response.Write("<script lanuage=javascript>alert('出错拉!');location='javascript:history.go(-1)'</script>"); break; } }
protected void Page_Load(object sender, EventArgs e) { mySqlData.BindData(GridView1, sql); }
protected void Page_Load(object sender, EventArgs e) { mySqlData.BindData(NewsList, mySql); }