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(); }