call a procedure in a textbox

[Qendro]

i have a procedure in SQL Server which takes a sum of a column between two values and the ID of the partner but how should I call that procedure on a button click event and populate that sum in a textbox by giving as an argument of the values from tree comboboxes which are the two values and the partner. here is the procedure create procedure pvShuma ( @PartneriID int, @XhiroPrej int, @XhiroDeri int ) as select sum(Hyrje) from dbo.tblXhiro where NrXhiro between @XhiroPrej and @XhiroDeri and PartneriID = @PartneriID thanks for any advice!

Qendro

[Henry Minute]

Take a look at this[^]. The example code should get you well on the way to solving your problem.

Henry Minute Do not read medical books! You could die of a misprint. - Mark Twain Girl: (staring) "Why do you need an icy cucumber?" “I want to report a fraud. The government is lying to us all.”

[Qendro]

thanks a lot! It was the perfect example for my example

Qendro