load file address??

Question

Hi...
 
I'm trying to get a file address that i stored "manually" in an SQL server database using c#, i stored in the database the string "c:\projects\vids\simpsonslidetector.flv" and when i try to retrive, it ignores everything except "simpsonslidetector"... this is used as webservice, the webservice receives an int so it can match with a certain id in the table and when finds that id, returns the string (in this case not the whole string, in other cases with "simplier" strings it return well):
 
the table name on the database is 'info' and as 3 colums: id(int), name(nvarchar(100)), address(nvarchar(100))...what type of data should i use for the address?
 
also i have other methods that connect to the database to return a value or list of values, and goes fine, the only problem is the address string (i think the cause of not getting the result i want, is because, for some reason the reader does not receive the formatted string stored in the database ("c:\projects\vids\simpsonslidetector.flv")).
 
this is the code i use to retrieve the string:

[WebMethod]
    public String getAddressByID(Int32 id)
    {
        String strReader = "";
        SqlConnection conn = new SqlConnection(strCon);
        conn.Open();
        String readCmd = "SELECT address FROM info WHERE id = " + id.ToString();
        SqlCommand cmd = new SqlCommand(readCmd, conn);
        strReader = (String)cmd.ExecuteScalar();
        conn.Close();
        if (strReader == null)
        {
            return "No Result";
        }
        else
        {
            return strReader;
        }
    }