📄 empsearch.aspx.cs
字号:
using System;
using System.Data;
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;
using DataAccess;
public partial class employees_EmpSearch : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
string cmd = "select EmployeeId,EmpLogin,EmpName,DepName,EmpMail from employees,Department where employees.DepartmentId=Department.DepartmentId and EmpName like '%" + txtName.Text + "%'";
DataBase db = new DataBase();
DataSet ds = db.QueryDataSet(cmd);
greEmployees.DataSource = ds;
greEmployees.DataBind();
if (greEmployees.Rows.Count == 0)
{
Response.Write("<script>alert('没有找到员工!')</script>");
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -