lundi 14 avril 2014

Index was outside the bounds of the array (System.Byte to tinyint)


Vote count:

0




I'm stuck I have SP (dbo.getbalance) which returns multiple recordsets. Actually 2 recoredsets


and one of the SP's parameters is TINYINT ( lang_type ), which as i know in c# is System.Byte, but when I'm trying to pass this parameter I get an error: "Index was outside the bounds of the array"


Here is my code



public class Balance : DataClasses1DataContext
{
[Function(Name = "dbo.getbalance")]
[ResultType(typeof(BalanceUserList))]
[ResultType(typeof(UserBalanceAccount))]
public IMultipleResults GetUserBalance(int iclient_no, int session_id, DateTime? bal_date)
{
System.Byte lang_type = 0;// Helper.GetLanguage();
IExecuteResult result = this.ExecuteMethodCall(this,
((MethodInfo)(MethodInfo.GetCurrentMethod())),
iclient_no, session_id, bal_date, lang_type );
return (IMultipleResults)(result.ReturnValue);
}

}


and SP's parameters



@iclient_no INT,
@session_id INT,
@bal_date SMALLDATETIME ,
@lang_type TINYINT = NULL


What I'm doing wrong?



asked 45 secs ago






Aucun commentaire:

Enregistrer un commentaire