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);
}
