// 查询部门员工记录 protected void QueryInfo(object sender, EventArgs e) { string sql = getInfoWithSqlString(); if (sql == null) { Response.Write("数据不能为空!"); return; } string connStr = System.Configuration.ConfigurationManager.ConnectionStrings["MyDataBase"].ConnectionString; using (System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(connStr)) { try { System.Data.SqlClient.SqlDataAdapter adpater = new System.Data.SqlClient.SqlDataAdapter(sql, conn); System.Data.DataSet data = new System.Data.DataSet(); // TODO: 检查adpater, data adpater.Fill(data); // 填充data ResultView.DataSource = data; ResultView.DataBind(); Response.Write("查询成功!"); } catch (Exception ex) { Response.Write(ex.Message); } } }