Hello Friends
I am trying to save the mpg files in database. i am using file upload control. it is working fine for files upto 2mb. but when i try to upload the file of size greater than 2 mb. it doesnot works. i don't know what happens to it. even i use breakpoints in it. but when file is more than 2mb control not moves to that break point. one thing more i just saved file names in database and clips in a folder in the project.
Thanks
Sarbjit
Hi Pals...
I have a problem that uploading an video file into the database
using asp.net2.0 and sqlserver as database.This is urgent for me .
Please help me any one................
thanks in advance
I am rewritting our DTS that upload tables in FoxPro to SQL Server using SSIS. I am finding the that SSIS is way slower. My uploads using DTS take just 7 minutes where doing the same thing in SSIS is taking 1 hour 15 minutes.
View 2 Replies View RelatedStumbled onto a good URL:
(I have checked out a few and they are pretty well done)
http://www.asp.net/learn/sql-videos/
JasonL @msft
http://blogs.msdn.com/usisvde/
Hey everyone,
Is there any way to embed a video in a report? It doesn't seem like it but I thought I may be missing something. Maybe directly editing the xml code? Thanks.
-Keith
Hello All,
I was watching Bob Tabor's SQL Server 2005 Express for Beginners videos from the ASP.net 2.0 website http://www.asp.net/learn/videos/default.aspx?. In lesson 5 Manipulating the Database Data he refers to download the sample database SQLVideoResources.zip file from the above website.
I searched and did not find it. Can anyone please direct me?
Thanks,
Hi i have a video file path stored in my sql database and i have an embedded media player in my web page, how can i load up a different video file into the embedded media player based on movie id or movie name, this is the code i have written so far but im unsure if im in the right direction, thanks
View 2 Replies View RelatedHiii everyone,
Can anyone send me the link of SQL Server 2005 Video tutorial please..
I am waiting for it.....
designing a video rental database system and i want the options of storing
more copies of video titles i have
eg . if i wanted to find a particular film title which has more than one copy,
can someone help me with this databse deisgn and the query
any hlp appreciated
Does any body know for any link of pictorial tutorial for getting start to management studio.
View 1 Replies View RelatedDear sir or Madam
Can sql server 2005 can store video? because I dont want to store video path in database
I look forward to hearing from you
Thank you in advance.
seyha moth
how store video files in sql database.Also i want to know cording part
View 3 Replies View RelatedHello,
After searching the SQL reporting services forum for a while, I decided to lay this problem before you.
I am faced with the following problem:
I want to generate a report containing video data, this videodata is streamed into a SQL 2005 database.
The main question I have is whether it is at all possible to show moving images in an report? (for instance with a CRI?)
Or should I look in another direction (I initially thought of an external link to HTML file with an MediaPlayer Object and having the file stored on a harddisk for instance?)
Any help on this subject would be greatly appreciated!
kind regards,
Michiel
can you help me ? i want watch television on internet , good quality screen , no tracking , good audio , fast stream , can you show me ? or fix or update ,, thank you very much ,,,, have a nice day ,,,,,
View 1 Replies View RelatedThe contents of the msi file available to download with Lesson 8 "Connecting your Web Application to SQL Server 2005 Express Edition" does not provide files referenced by the project solution "sln" file.
Is this download available anywhere else?
Having visited the above Video learning site, I tried the option of Downloading each of several of the videos, in order to play them at leisure, and perhaps, repeatedly.
On clicking the Download buttons, however, the video immediately starts playing in Windows Media Player 11, exactly as if I had clicked on Play the video.
How can I download these videos please?
Windows XP Pro; 2.6 GHz Pentium 4; 1 GB RAM
Keith Bromley
Hi All,
How can I upload Video Clip in Sql Server 2005?
Regards,
Hi
I uploaded a video file into the sql database converting into binary data.
i have a problem that to retrieve video file(.wmv) from sql server 2000 database and which has to play on media player.
Plz help me any one .
Itz urgent for my website.............
Plz plz Plz Help me Urgent...................
Thanks in Advance
Regards Shiva
For some reason when I go to view any video on http://msdn.microsoft.com/vstudio/express/sql/learning/default.aspx
it doesn't run. Can someone help?
Thanks,
Mark
New to AJAX and ASP .Net. I am trying to follow along with Scott's Todo List video. When I try to add a sql database by right-clicking on App_Data and selecting add new item and then sql database, I get the following message 'Connections to SQL Server Files (*.mdf) require SQL Server Express 2005 to function properly. Please verify the installatio of the component or download from the URL: http://go.microsoft.com/fwlink/?LinkId=49251' . I have installed Sql Server Express but still get the message. I would appreciate it if anyone can help me with this issue, thanks.
View 2 Replies View RelatedI would like to create a table which can store a VLOB or BLOB.. which are pictures and images.. How do I insert them into the database and how do I select them into the data base for playing in a media player
I really do not have a background on this.. much.. I just know how to connect to a database and insert texts.. and updating and stuffs...
Hello,
Please help me find solution to these questions?
1. How do I store audio and video files in sql server 2000.
2. Is it possible to store and retrieve audio and video files using t-sql
3. Which is the most efficient way to store and retrieve audio and video files in sql server
Your suggestions are most valued.
Thanks!
I watched the How do I video "Create a Full-Featured Customer Login Portal" several times, and have compared my code to the downloaded VB code. I seem to be missing something.
I am trying to replicate what he does in the video, where he uses the login name to query another database and display the matching data. In the video he starts by using a querystring (page.aspx?userID=name) before creating a login page.. My program works with this method. However, later he creates the login page, and the system seems to automatically link the user database with the northwind database and give results without the querystring. There is no indication of how this is done. When I examined the downloaded code, he actually uses a session variable in the Page_Load event on the orders page. There is no explanation of this either, just a quick "I'll paste this from the clipboard."
I have compared my code line by line, and it matches exactly. I can only guess that there is a missing step where a relationship is established between the ASPNETDB.mdf file and the northwind.mdf file. Can anyone explain this to me? Thank you.
My goal is to have a user log in, and the site automatically query the second database for that users statistics, and display them.
I cannot play any of these video files in RealPlayer or in Windows Media Player. Any suggestions? Anyone else having this problem?
Thanks,
Brian
Video Series: SQL Server 2005 Express Edition for Beginners
C00D1199: Cannot play the file
Hi Guys,
I have one question, must be simple for you guys. I want to upload .pdf document into the SQL server database.
I have one question, that which data type I should use. Should I use TEXT or IMAGE.
Could you please tell me which data type I should use and why?
Thanks for your help in advance.
how to upload data from excel sheet to table in sql server is there any command for that
View 1 Replies View RelatedI used upload image feature and below is the code that I used. The image is stored in a folder. I want to save the image in sql database. I create the database which is “database�, and I create a table which is “user�. User table has auto “id� field and “image� field. I want to save the image in the image field. I need your help to do the other codes.
I am using asp.net with VB
This is what I did so far:
============================
Partial Class upload
Inherits System.Web.UI.Page
Dim strFileName As String
Protected Sub btnupload_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnupload.Click
UploadImage()
End Sub
Sub UploadImage()
If Not (fileupload1.PostedFile Is Nothing) Then 'Check to make sure we actually have a file to upload
Dim strLongFilePath As String = fileupload1.PostedFile.FileName
Dim intFileNameLength As Integer = InStr(1, StrReverse(strLongFilePath), "")
strFileName = Mid(strLongFilePath, (Len(strLongFilePath) - intFileNameLength) + 2)
Select Case fileupload1.PostedFile.ContentType
Case "image/pjpeg", "image/jpeg" 'Make sure we are getting a valid JPG image
FileUpload1.PostedFile.SaveAs(Server.MapPath(" estimages") & strFileName)
lbstatus.Text = strFileName & " was uploaded successfully to: " & Server.MapPath(" estimages") & strFileName
Case Else
'Not a valid jpeg image
lbstatus.Text = "Not a valid jpeg image"
End Select
InsertToDatabase()
End If
End Sub
End class
I am using the article, "
Storing Binary Files Directly in the Database Using ASP.NET 2.0 By Scott Mitchell "
http://aspnet.4guysfromrolla.com/articles/120606-1.aspx
I have tried to modify the code and my datatable to replicate the function, but I am getting an error, "MIMEType" is not a SQL Parameter
An SqlParameter with ParameterName 'Type' is not contained by this SqlParameterCollection.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.IndexOutOfRangeException: An SqlParameter with ParameterName 'Type' is not contained by this SqlParameterCollection.Source Error:
Line 53:
Line 54: 'Specify the values for the MIMEType and ImageData parameters
Line 55: e.Command.Parameters("Type").Value = MIMEType
Line 56:
Line 57: 'Load FileUpload's InputStream into Byte arraySource File: E:homeDefaultetances.ushtdocshomeadminaddNews.aspx Line: 55
Code: Protected Sub AddNewsBut_Click(ByVal sender As Object, ByVal e As System.EventArgs)
If Page.IsValid Then
InsertDs.Insert()
Response.Redirect("~/news/default.aspx")
End If
End Sub
Protected Sub InsertDs_Inserting(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.SqlDataSourceCommandEventArgs)
'Reference the FileUpload control
'Make sure a file has been successfully uploaded
If UploadedFile.PostedFile Is Nothing OrElse String.IsNullOrEmpty(UploadedFile.PostedFile.FileName) OrElse UploadedFile.PostedFile.InputStream Is Nothing Then
Label1.Text = "If there is no photo of this event, please use a stock photo if you have none available. Else, please upload a photo of the event."
e.Cancel = True
Exit Sub
End If
'Make sure we are dealing with a JPG or GIF file
Dim extension As String = Path.GetExtension(UploadedFile.PostedFile.FileName).ToLower()
Dim MIMEType As String = Nothing
Select Case extension
Case ".gif"
MIMEType = "image/gif"
Case ".jpg", ".jpeg", ".jpe"
MIMEType = "image/jpeg"
Case ".png"
MIMEType = "image/png"
Case Else
'Invalid file type uploaded
Label1.Text = "Please use the correct file type: .jpg, .jpe, .gif, or .png."
e.Cancel = True
Exit Sub
End Select
'Specify the values for the MIMEType and ImageData parameters
e.Command.Parameters("Type").Value = MIMEType
'Load FileUpload's InputStream into Byte array
Dim imageBytes(UploadedFile.PostedFile.InputStream.Length) As Byte
UploadedFile.PostedFile.InputStream.Read(imageBytes, 0, imageBytes.Length)
e.Command.Parameters("Photo").Value = imageBytes
End Sub Please help.
I created a website a year ago. I remember I need to download something from Microsoft (some kind of sql admin thing), which allows me to convert my database in the Express Visual Web developer to sql file, then I can copy those sql commands into my web hosting company's sql admin window to upload the database online. I forgot what things I should download from Microsoft? Please help.
View 1 Replies View RelatedI am building this project and for all the data i put in to the DB Title,Author, etc.... ineed to also add a picture of the book. I terms on space what is the best way to do this? In the DB? Or ref a folder? If so does anyone have sample code for each.
ThanksMike
Hi, I am trying to upload a file to database.
I have used the following code, every loads good to the database apart from the image, does it go anywhere?
I have created a column in the table called 'FileUploadAdvert' and made it an image?
Any ideas where I'm going wrong?
ThanksGordon
Protected Sub btnAdvertSubmit_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnAdvertSubmit.ClickDim dashDataSource As New SqlDataSource()dashDataSource.ConnectionString = ConfigurationManager.ConnectionStrings("DashConnectionString1").ToString()
dashDataSource.InsertCommandType = SqlDataSourceCommandType.Text
dashDataSource.InsertCommand = "INSERT INTO tblAdvert (AdvertOwner, AdvertName, TopLeftH, TopLeftV, Height, Width, ToolTip, WebLink, AcceptTerms, DateTimeStamp, IPAddress) VALUES (@AdvertOwner, @AdvertName, @TopLeftH, @TopLeftV, @Height, @Width, @ToolTip, @WebLink, @AcceptTerms, @DateTimeStamp, @IPAddress)"dashDataSource.InsertParameters.Add("AdvertOwner", txtName.Text)
dashDataSource.InsertParameters.Add("AdvertName", txtCompName.Text)dashDataSource.InsertParameters.Add("TopLeftH", DropDownAccross.Text)
dashDataSource.InsertParameters.Add("TopLeftV", DropDownDown.Text)dashDataSource.InsertParameters.Add("Height", DropDownHeight.Text)
dashDataSource.InsertParameters.Add("Width", DropDownWidth.Text)dashDataSource.InsertParameters.Add("ToolTip", txtOver.Text)
dashDataSource.InsertParameters.Add("Weblink", txtURL.Text)dashDataSource.InsertParameters.Add("AcceptTerms", CheckBoxAgree.Checked)
dashDataSource.InsertParameters.Add("IPAddress", Request.UserHostAddress.ToString)dashDataSource.InsertParameters.Add("DateTimeStamp", DateTime.Now)
If Not FileUploadAdvert.PostedFile Is Nothing ThenDim filepath As String = FileUploadAdvert.PostedFile.FileName
Dim pat As String = "\(?:.+)\(.+).(.+)"Dim r As Regex = New Regex(pat)
'runDim m As Match = r.Match(filepath)
Dim file_ext As String = m.Groups(2).Captures(0).ToString()Dim filename As String = m.Groups(1).Captures(0).ToString()
Dim file As String = filename & "." & file_ext
'save the file to the server FileUploadAdvert.PostedFile.SaveAs(Server.MapPath(".") & file)
lblStatus.Text = "File Saved to: " & Server.MapPath(".") & fileEnd If
Dim rowsAffected As Integer = 0
Try
rowsAffected = dashDataSource.Insert()Catch ex As Exception
Server.Transfer("Register_Fail.aspx")
Finally
dashDataSource = Nothing
End Try
If rowsAffected <> 1 ThenServer.Transfer("Register_Fail.aspx")
ElseServer.Transfer("Register_Complete.aspx")
End If
End Sub
Can anyone give me an example of how to Upload a file to SQL in asp.net 2.0 using VB?
Thanks
Randy
We have to upload the database from the production server to the ineternet server. We are making a backup and restoring the databse on the internet sever, this requiers somebody on the serrver to restore the database manually. Is there any other way? Can i overwrite or update the new design the database on the server in any other way? Thanks.
View 1 Replies View Related