Blob In SQL

Question

Hi i use the following code to get the image from SQL database

string sConn = @"Data Source=SYSTEM1;Initial Catalog=BLOBTest4;Integrated Security=True";
        SqlConnection objConn = new SqlConnection(sConn);
        objConn.Open();

        string sTSQL = "SELECT TheName FROM FileInfo";

        SqlCommand objCmd = new SqlCommand(sTSQL, objConn);
        objCmd.CommandType = CommandType.Text;

        SqlDataReader dr = objCmd.ExecuteReader();
        dr.Read();

        Response.BinaryWrite((byte[])dr["TheName"]);

        objConn.Close();

My SQL table is as follows
column name : The Name Datatype : varchar
column name : Dirpath Datatype : varchar

I am geeting the following error can any one rectify this error

Unable to cast object of type 'System.String' to type 'System.Byte[]'.

Suchit Khanna · Answer

I suppose it should be Response.Write(reader[MyName]) that you are trying to do????

Niradhip Chakraborty · Answer

Try this: 1.http://www.datamasker.com/SSE2005_NetworkCfg.htm 2.http://www.codeproject.com/KB/database/SQL_Server_2005_remote.aspx

Kishore Pal · Answer

I can not perform the Remote Access Procedure of SQL server please help me.

Dorababu Meka · Answer

Actually when i click on Linkcontrol on webform1 i would like to display the image on the next webpage. So can u get the code for me for that

Dorababu Meka · Answer

Actually when i click on Linkcontrol on webform1 i would like to display the image on the next webpage. So can u get the code for me for that

Suchit Khanna · Answer

If you are trying to display the Name just use Response.Write(Convert.ToString(dr[TheName]));

Dorababu Meka · Answer

What i should write there can u tell

Suchit Khanna · Answer

You are trying to cast MyName in reader to byte[] but it is of type Varchar.. that is why your getting the error. Check the statement--> Response.BinaryWrite((byte[])reader[Myname]).... that is which is causing error.