video files upload

Question

How can i upload video files to sqlserver 2005. How can i do this task? Regards Manu.

Lalit M · Answer

You can try this code sample protected void Button1_Click(object sender EventArgs e) { //put these connection code here instead of pageload. string connectionString = ConfigurationManager.ConnectionStrings[uploadConnectionString].ConnectionString; sqlcon = new SqlConnection(connectionString); sqlcon.Open(); cmd1.Parameters.Add(@vid SqlDbType.Int); cmd1.Parameters.Add(@vidfile SqlDbType.VarBinary 1000); cmd1.Parameters.Add(@vidname SqlDbType.VarChar 1000); if (FileUpload1.HasFile && FileUpload1.PostedFile != null && FileUpload1.PostedFile.FileName != ) { HttpPostedFile file = FileUpload1.PostedFile; string fn = FileUpload1.PostedFile.FileName; cmd1.Parameters[@vid].Value = 1; buffer = new byte[file.ContentLength]; int bytesReaded = file.InputStream.Read(buffer 0 FileUpload1.PostedFile.ContentLength); cmd1.Parameters[@vidfile].Value = buffer; cmd1.Parameters[@vidname].Value = fn; if (bytesReaded > 0) { try { cmd1.CommandText = Insert into vidtable (vid vidfile vidname) + Values (@vid @vidfile @vidname); cmd1.Connection = sqlcon; int i = cmd1.ExecuteNonQuery(); Label1.Text = uploaded  + i.ToString() +  rows affected; } catch (Exception ex) { Label1.Text = ex.Message.ToString(); } } } else { Label1.Text = Choose a valid video file; } }