TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Dorababu Meka
228
8.3k
1.7m
Help please
Jun 4 2009 2:35 AM
I have written the code for inserting data and retrieving the data in to sql. I am uploading any type of data by this but the problem is when i upload a word document or any other file and if i am viewing that the whole description contained in that document or file is viewing on the page can any one help...
For Inserting:
string Con = "Data Source=System1;Initial Catalog=master;Integrated Security=True";
SqlConnection Conn = new SqlConnection(Con);
Conn.Open();
SqlCommand Cmd = new SqlCommand("web", Conn);
Cmd.CommandType = CommandType.StoredProcedure;
SqlParameter p1 = Cmd.Parameters.Add("@data", SqlDbType.VarBinary);
p1.Direction = ParameterDirection.Input;
byte[] bImage = new byte[FileUpload1.PostedFile.ContentLength];
Stream Str = FileUpload1.PostedFile.InputStream;
Str.Read(bImage, 0, FileUpload1.PostedFile.ContentLength);
p1.Value = bImage;
Cmd.ExecuteNonQuery();
Conn.Close();
For viewing the data :
string str = "select * from blob where id="+Textbox1.Text+"";
SqlConnection Conn = new SqlConnection(Conn);
Conn.Open();
SqlCommand Cmd = new SqlCommand(str, Conn);
//SqlCommand objCmd = new SqlCommand("blob1", objConn);
//objCmd.CommandType = CommandType.StoredProcedure;
SqlDataReader dr = Cmd.ExecuteReader();
if (dr.Read())
{
Response.BinaryWrite((byte[])dr["data"]);
Conn.Close();
What i need is when i click on view if it is doc file or any other file it should ask me to download or open the file content to view
Reply
Answers (
0
)
need help, will pay consultant
Uploading Files and saving in SQL