Arithmetic overflow error converting expression to data type nvarchar.

See more:

C#

Now I Run a program and enter a Member in textbox and leave, go to next textbox
Arithmetic overflow error converting expression to data type nvarchar.

database sqlserver2008. all filed in tables datatype is int.


code in form: event Member_Leave

dataset = Ds.DataTab("select M.*,(Select SUM(dbo.DatesMinus(" + Ds.GetDate() +
                    ",Dates))as ss from Pay Where Member = M.Id) as sumDate ,(Select SUM(amount)as ss1 from Pay Where Member = M.Id) as AmountSum" +
                    ",dbo.SumScore(M.Id," + Ds.GetDate() + ") as SumScore ,dbo.memsor(" + Ds.GetDate() + ",dbo.SumScore(M.Id," + Ds.GetDate() + ")) as SCo From Members M where M.Id = " + Ds.TrueInt(Member.Text));
           SumAmount.Text = dataset.Rows[0].Field<Int64>("AmountSum").ToString();
           FinalScore.Text = dataset.Rows[0].Field<Int64>("SumScore").ToString();
           Grade.Text = dataset.Rows[0].Field<Int64>("SCo").ToString();
      DayFinalScore.Text = dataset.Rows[0].Field<Int64>("sumDate").ToString();

code in my class

public DataTable DataTab(string SqlStatement)
{
SqlDataAdapter SQLDA = new SqlDataAdapter(SqlStatement, connectionString);
DataTable DTable = new DataTable();
SQLDA.Fill(DTable);
SQLDA.Dispose();
return DTable;
}