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 System.Data.SqlClient;public partial class Default4 : System.Web.UI.Page{
protected SqlConnection myconn = new SqlConnection();
protected DataSet myds = new DataSet();
protected DataGrid mygr = new DataGrid();
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
myconn.ConnectionString = "Server=(local) ;database=xue;user=sa;pwd=xue";
SqlDataAdapter myda = new SqlDataAdapter("Select'职工号','姓名','身份证号','地址','电话','部门编号' from Table2 where 部门编号 ='" +"0000"+ DropDownList1.SelectedItem.Value + "'", myconn);
myda.Fill(myds, "Tabel4");
mygr.DataSource = myds.Tables["Tabel4"].DefaultView;
mygr.DataBind();
}} |