In my application (asp.net) I am uploading the video and storing the video in databaselike videoname,videotitle,dateofuploded these are the fields. My problem is when I am displaying that video I want to display the date like '2 days ago' or ' one month ago' or 'one year ago'
How can I write the function for converting the date into that process.
Take example of youtube. On that site below the video display the date when it was uploaded.
i want to convert my website built in vs 2005 (2.0) to vs 2008 (3.5) application.could u plz send me simple and precise steps...i tried out what microsoft ppl are saying...but i m not getting that prompting message ("do u want to convert all webs to .net 3.5"), when i open my application in vs2008..
We currently have a DB in SQL 2005 and would like to convert it to SQL 2008 taking advantage of all the new features (if there are any) in SQL 2008. Would like to know the best approach or if there are any tools which can convert all the tables/views/storeprocs etc to 2008 specifications...
I have a text box; txtPriceQuoted, and want to submit it's value to my SQL Server Database, I get an error about the conversion:
"Conversion failed when converting the varchar value '12.5' to data type int."The error only occurs when there is a decimal point in the number, how should i convert it so that I can input the value into my database....?
What I'd like to do is a find-and-replace for certain words appearing in the body text of a web page. Every time a certain word appears in the body text, I'd like to convert that word into a hyperlink that links to another page on our site.
I am using web services to retrieve one record from database. here in this record there is one image field.In web service, the record is converted to xml document and sent to client
when i send this record to client thru webservice , this photo is converted as byte.
to check before giving to client, i checked my webservice. for that i took a new .aspx page and i retreived my record in to dataset and binded that to gridview. In gridview, I could see my image in byte format
I want to change this byte to previous image format in my asp.net page.
I am unable to change. I searched in google, I am unable to solve my problem.
strquestion=<P>Which one is rectangle?</P><P>1 <IMG src="http://localhost:3032/IHSOnline/editorimages/UserImages/35907.JPG" width=150></P><P>2 <IMG src="http://localhost:3032/IHSOnline/editorimages/UserImages/df943.JPG" width=150></P>
My texteditor will contain both text and image as seen in the string.
Now i want to store it in database and retrieve and display in a gridview.
The top imageUrl declartion is taking in a Base64 image string, and I want to convert it into an image. I think my set of code only works for images like "www.mysite.com/test.jpg" not for a Base64 string.
I have this code in c# and I want to convert this to T-SQL and put in stored proc. I'm having a problem in speed as I am processing more than 50000 records at a time and the Update statement slows it down. I was thinking stored procedure could help on my problem. here's what I have:
sqlStmt = "SELECT DISTINCT(phone_no) FROM TEMPTABLE WHERE sUSER='" + USERName + "' ORDER BY phone_no";
I have embedded a Google Calendar Reminder button into an aspx page. It assumes the date is in a yyyyddmm format. So that 08/14/2010 in my text box needs to be converted to 20101408 What would be the format to take a date (string) from a textbox and convert it into a string will be in the desired format for Google?