c# - Store currency exchange rates in SQL Server and displaying them -

i'm trying allow user use page currency exchange rate few currencies (2-3 of them) , display them based on rates stored in sql server. want display 3 different rates each single currency when user clicks button convert can let user compare has best rate.

what better it? using c#, asp.net , sql server.

this sql table structure:

create table currencyexchange ( currency char(3) not null, rate money not null, source varchar not null, primary key (currency, rate)) 

a better way it? never gave requirements of program. that's hard question answer when give 2-3 sentences worth.

you might try , cache sql data somewhere (another hidden page, .csv document, or other) , retrieve values cache on page-load. way aren't bogging down sql server. sure make stored procedure on sql update cache find necessary.

that's simplest way can imagine doing this. prevents having directly connect sql website, might want security reasons.

but said, it's hard suggest methods when know little information. have tried far? trying avoid? trying achieve? ask questions, go there.

you might start looking here: http://www.codeproject.com/articles/4416/beginners-guide-to-accessing-sql-server-through-c