public void ReadFromDB(SqlConnection connection)
{
string sQuery = @"
SELECT
DISTINCT f18_titel AS department
FROM
[OmniTracker].[dbo].[UserFields278] as u278,
[OmniTracker].[dbo].[UserFields407] as u407
WHERE
u278.request = u407.f44_ AND
f18_titel IS NOT NULL AND f18_titel > ''
ORDER BY
f18_titel
";
// string sQuery = @"SELECT DISTINCT f8_kundennr AS department
// FROM UserFields406
// WHERE f8_kundennr IS NOT NULL AND f8_kundennr > ''
// ORDER BY f8_kundennr";
SqlCommand sqlSelect = new SqlCommand(sQuery, connection);
bool connectionCloseOnExit = false;
Clear();
if (connection.State != System.Data.ConnectionState.Open)
{
connectionCloseOnExit = true;
connection.Open();
}
SqlDataReader sqlReader = sqlSelect.ExecuteReader();
_bEmpty = false;
while (sqlReader.Read())
{
if (sqlReader["department"] == null || sqlReader["department"] == DBNull.Value)
{
continue;
}
DepartmentRecord cr = new DepartmentRecord();
cr.Name = sqlReader["department"].ToString().Trim();
_Records.Add(cr);
}
sqlReader.Close();
if (connectionCloseOnExit == true)
{
connection.Close();
}
}
public void ReadFromDB(SqlConnection connection)
{
string sQuery = @"
SELECT
DISTINCT f18_titel AS department
FROM
[OmniTracker].[dbo].[UserFields278] as u278,
[OmniTracker].[dbo].[UserFields407] as u407
WHERE
u278.request = u407.f44_ AND
f18_titel IS NOT NULL AND f18_titel > ''
ORDER BY
f18_titel
";
// string sQuery = @"SELECT DISTINCT f8_kundennr AS department
// FROM UserFields406
// WHERE f8_kundennr IS NOT NULL AND f8_kundennr > ''
// ORDER BY f8_kundennr";
SqlCommand sqlSelect = new SqlCommand(sQuery, connection);
bool connectionCloseOnExit = false;
Clear();
if (connection.State != System.Data.ConnectionState.Open)
{
connectionCloseOnExit = true;
connection.Open();
}
SqlDataReader sqlReader = sqlSelect.ExecuteReader();
_bEmpty = false;
while (sqlReader.Read())
{
if (sqlReader["department"] == null || sqlReader["department"] == DBNull.Value)
continue;
DepartmentRecord cr = new DepartmentRecord();
cr.Name = sqlReader["department"].ToString().Trim();
_Records.Add(cr);
}
sqlReader.Close();
if (connectionCloseOnExit == true)
connection.Close();
}
