open msword file in c#

Question

how to open a saved file in microsoft word.. example: suppose employee id is 1.and data are saved in varbinary(max) format. when i searching a record from id...how to open stored data in msword file.

Yin · Answer

http://www.dotnetspider.com/resources/43580-How-upload-download-files-using-database.aspx

vikas kanani · Answer

what should i write in place of response

Yin · Answer

This one also works with Windows Application

vikas kanani · Answer

this is correct ans.bt i want in c#.windows application

Yin · Answer

private DataTable GetData(SqlCommand cmd) { DataTable dt = new DataTable(); String strConnString = System.Configuration.ConfigurationManager.ConnectionStrings["conString"].ConnectionString; SqlConnection con = new SqlConnection(strConnString); SqlDataAdapter da = new SqlDataAdapter(); cmd.CommandType = CommandType.Text; cmd.Connection = con; try { con.Open(); da.SelectCommand = cmd; da.Fill(dt); return dt; } catch { return null; } finally { con.Close(); da.Dispose(); con.Dispose(); } } private void download(DataTable dt) { Byte[] bytes = (Byte[])dt.Rows[0]["FileBinary"]; Response.Buffer = true; Response.Charset = ""; Response.Cache.SetCacheability(HttpCacheability.NoCache); Response.ContentType = dt.Rows[0]["FileType"].ToString(); Response.AddHeader("content-disposition", "attachment;filename="+ dt.Rows[0]["Type_Name"].ToString() + ".DOC"); Response.BinaryWrite(bytes); Response.Flush(); } IN YOUR BUTTON: string strQuery = "select * from TABLE where COLUMN=@id"; SqlCommand cmd = new SqlCommand(strQuery); cmd.Parameters.Add("@id", SqlDbType.Int).Value = 1; DataTable dt = GetData(cmd); if (dt != null) { download(dt); }