how to view resume which is stored in sql server 2008r2

Question

I want code for viewing resume in textbox by selecting resume which are stored in database

Manoj Bhoir · Answer

Hi I think it depends on in what format you are going to store resume in your database. If it is plain text then you can directly retrieve data from database and display it in normal multiline textbox. and if it is stored in byte array format i.e. (Word or PDF Document) then you can use something like this : Response.ContentType = application/octet-stream; Response.AddHeader(content-disposition inline; filename= +fileName); Response.BinaryWrite(Buffer); Response.Flush(); Response.End();

Khargesh Rajput · Answer

get result into dataset using sql query. and bind resume text to textbox(Multiline=True) Txtbox.Text=Ds.Tables[0].Rows[0][resume].ToString();