try
            {
                TableAdapters.QueriesTableAdapter qa = new TableAdapters.QueriesTableAdapter();
                qa.SPUpdateTaxi(Convert.ToInt32(tbTaxiID.Text), tbProvision.Text, tbKind.Text, Convert.ToInt32(tbAvailable.Text));

                TableAdapter.Fill(DataSet.Taxi);
            }
            catch (SqlException ex)
            {
                MessageBox.Show(ex.Message);

                throw;
            }

create procedure SPUpdateTaxi
(
    @TaxiID int,
    @Special_Need varchar(45),
    @Kindvarchar(45),
    @Available_Spaces int


)
as
begin

if exists(select Special_Need, Soort, Available_Spaces from Taxi)
update Taxi set Special_Need = @Special_Need, Kind = @Kind, Available_Spaces= @Available_Spaces
 where TaxiID = @TaxiID

 else
 rollback transaction
 end