I have a sql procedure
string strCreare="CREATE PROCEDURE pret_select (@param INTEGER, @par INTEGER) AS "+" SELECT sum(pret)as suma FROM contracte WHERE datepart('yyyy',[data])=@param and datepart('m',[data])=@par ";
And a want to print this result in a textBox and i did this:
textBox2.Text=Convert.ToString(dr["suma"]);
but it's not working. What i've done wrong?
I test it in Acces and it work's.
