// 查询部门员工记录
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);
}
}
}
