?? viewuser.ascx.cs
字號:
?using System;
using System.Data;
using System.Data.SqlClient;
using System.Text;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
public partial class controls_ViewUser : System.Web.UI.UserControl
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
//客戶名稱的模糊查詢
ControlParameter cp = new ControlParameter("username", "txtusername", "Text");
//獲取Select語句,并添加條件
string str = SqlDataSource1.SelectCommand;
str += " where username like '%' + @username +'%'";
//更新Select語句
SqlDataSource1.SelectCommand = str;
//添加參數(shù)-必須先清空參數(shù)
SqlDataSource1.SelectParameters.Clear();
SqlDataSource1.SelectParameters.Add(cp);
//重新綁定數(shù)據(jù)
GridView1.DataBind();
}
protected void Button3_Click(object sender, EventArgs e)
{
//通過軟件版本查詢
//建立一個與控件相關聯(lián)的參數(shù)
//構造函數(shù)中第一個參數(shù)表示SQL語句中的參數(shù)名
//第二個參數(shù)表示控件的ID,第三個參數(shù)表示控件的取值屬性
ControlParameter cp = new ControlParameter("softversion","txtsoftversion","Text");
//獲取Select語句,并添加條件
string str = SqlDataSource1.SelectCommand;
str += " where softversion=@softversion";
//更新Select語句
SqlDataSource1.SelectCommand = str;
//添加參數(shù)-必須先清空參數(shù)
SqlDataSource1.SelectParameters.Clear();
SqlDataSource1.SelectParameters.Add(cp);
//重新綁定數(shù)據(jù)
GridView1.DataBind();
}
protected void Button2_Click(object sender, EventArgs e)
{
//通過城市查詢
ControlParameter cp = new ControlParameter("cityname", "txtcity", "Text");
//獲取Select語句,并添加條件
string str = SqlDataSource1.SelectCommand;
str += " where cityname=@cityname";
//更新Select語句
SqlDataSource1.SelectCommand = str;
//添加參數(shù)-必須先清空參數(shù)
SqlDataSource1.SelectParameters.Clear();
SqlDataSource1.SelectParameters.Add(cp);
//重新綁定數(shù)據(jù)
GridView1.DataBind();
}
protected void Button4_Click(object sender, EventArgs e)
{
//分類查找
//獲取Select語句
string str = "";
//定義控件參數(shù)
ControlParameter cp = new ControlParameter("name", "txtseek","Text");
switch (DropDownList1.SelectedValue)
{
case "等級":
//定義查詢語句
str =SqlDataSource1.SelectCommand + " where gradename=@name";
break;
case "狀態(tài)":
str = SqlDataSource1.SelectCommand + " where statename=@name";
break;
case "業(yè)務類型":
str = SqlDataSource1.SelectCommand + " where typename=@name";
break;
}
//更新Select語句
SqlDataSource1.SelectCommand = str;
//添加參數(shù)-必須先清空參數(shù)
SqlDataSource1.SelectParameters.Clear();
SqlDataSource1.SelectParameters.Add(cp);
//重新綁定數(shù)據(jù)
GridView1.DataBind();
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -