I am very new to this web test testing using VSTS 2008. I have created one request plugin to retrive values from database. The table has different data types i.e. real, varchar, int and smallint etc etc. I am trying to read real data type from sql data reader but it gives me error i.e."Request failed: Arithmetic overflow error converting varchar to data type numeric."
Here is how the select statement I am using--------------
Actually in Database 'sessionid' field have data type varchar(100) and 'Score' have data type 'Real'

int SFScore = 0;
System.String connectionString""
e.Request.ThinkTime = 20;
SqlConnection connection = new SqlConnection(connectionString);
string queryString = "Select CAST(Score as Int) from tablename where sessionid =" + e.WebTest.Context["sessionid"];
SqlCommand command = new SqlCommand(queryString, connection);
SqlDataAdapter da = new SqlDataAdapter(queryString,connection);
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())

e.WebTest.Context.Add("SScore", 'Score');
Can anyone tell me how to read 'Score' value using this request plugin? I tried using CAST and Convert functions as well but none of them is working for me.
Your help would be appreciated.