//根据EmployeeName条件获取数据
public DataTable GetEmployeeToTable(string EmployeeName)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT EmployeeID,EmployeeName,EmployeeMajor, EmployeeDepartment,EmployeeTel,EmployeeEmail, EmployeeJiGuan,EmployeeAddress,EmployeePosition,EmployeeBirthday ");
strSql.Append(" WHERE EmployeeName=@EmployeeName ");
SqlParameter[] parameters = {
new SqlParameter("@EmployeeName",SqlDbType.VarChar,50)
};
parameters[0].Value = EmployeeName;
return DbHelperSQL.GetDataTable(strSql.ToString());
}
1 public DataTable GetEmployeeToTable(string EmployeeName)
2 {
3 StringBuilder strSql = new StringBuilder();
4 strSql.Append("SELECT EmployeeID,EmployeeName,EmployeeMajor, EmployeeDepartment,EmployeeTel,EmployeeEmail, EmployeeJiGuan,EmployeeAddress,EmployeePosition,EmployeeBirthday ");
5 strSql.Append(" WHERE EmployeeName=@EmployeeName ");
6 SqlParameter[] parameters = {
7 new SqlParameter("@EmployeeName",SqlDbType.VarChar,50)
8 };
9 parameters[0].Value = EmployeeName;
10 return DbHelperSQL.Query(strSql.ToString(), parameters).Tables[0];
11 }