public DataTable readAllInDataTable() { string readSQL = "SELECT * FROM " + table_Name; SqlDataAdapter dataAdapter; DataTable dt = new DataTable(); using (SqlCommand cmd = new SqlCommand(readSQL, getConnection.getConnection())) { try { dataAdapter = new SqlDataAdapter(cmd); dataAdapter.Fill(dt); return(dt); } catch (SqlException) { return(dt); throw; } finally { cmd.Parameters.Clear(); cmd.Dispose(); } } }
public DataTable readByPlate(string plate) { string readSQL = "SELECT * FROM " + table_Name + " WHERE CarPlate = @plate;"; SqlDataAdapter dataAdapter; DataTable dt = new DataTable(); using (SqlCommand cmd = new SqlCommand(readSQL, getConnection.getConnection())) { try { cmd.Parameters.AddWithValue("@plate", plate); dataAdapter = new SqlDataAdapter(cmd); dataAdapter.Fill(dt); return(dt); } catch (SqlException) { return(dt); throw; } finally { cmd.Parameters.Clear(); cmd.Dispose(); } } }