can someone please help me how to pass a return value from a stored procedure to a variable in c#. I am new in c# and I've been stucked to that problem for about 2 days. here is my code:
private void CheckSmsStatus()
{
string stat = null;
ShortMessage l = new ShortMessage();
stat.DataSource = l.checksmsstatus_query().Tables[0];
stat.DisplayMember = "Status";
}
Any help would be much appreciated. Thank you.