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