I am using MSACCESS as back end.And as we can get database back up in the SQL server after particular time.I want that kind of back up in MS ACCESS.How can i get it..
View 5 Replies
I have one asp.net 2.0 application with MS Sql 2005 database.. As i deploy this database with client Machine.. now what i need is i need to take a backup of MS Sql 2004 database.. so is that any free tool is available which take daily backup...
View 16 Repliesin my application i want to display the duration time of the video ( that is time of the video) in asp.net
View 2 Repliescreated a project in c3.net of online exam wan to set time duration on server side
View 1 RepliesI have a query like i want to show the time information in custom format like(1min 06sec) from date .I have a filed Duration in database and when i am binding my data control then in item i want to display in above format(1min 06 sec),so is it possible?
View 3 RepliesALTER PROCEDURE [dbo].[backup_database]
(
@DbName VARCHAR(250),
@dbpath VARCHAR(500)
)
AS
DECLARE @Currentdate VARCHAR(10)
DECLARE @Currenttime VARCHAR(15)
BEGIN
BEGIN TRY
SET @Currentdate =CONVERT(VARCHAR(10),GETDATE(),105)
SET @Currenttime = REPLACE(RIGHT('0'+LTRIM(RIGHT(CONVERT(varchar,getDate(),100),8)),8),':','-')
SET @dbpath = @dbpath +'' +@Currentdate+'_'+@Currenttime+'_'+@DbName +'.' + 'bak'
PRINT @dbpath
BACKUP DATABASE @DbName TO DISK = @dbpath
END TRY
BEGIN CATCH
SELECT
ERROR_NUMBER() as ErrorNumber,
ERROR_MESSAGE() as ErrorMessage
PRINT 'Backup Could not be taken for '+@DbName+''
END CATCH
END
I want to run the above procedure at an interval of 8 hours.
I use media player control to play mp3 files in asp.net application. I want to find When the playing process gets end and the total time require to finish the file using javascript.
[Code].....
How find out time duration in asp.net using drop down list Control? Result will display in textbox.
View 13 RepliesI want to terminate the session after specific time. So how can solve it.
View 3 RepliesInvalid column name 'is_compressed'.
Invalid column name 'compressed_backup_size'.
Could not insert a backup or restore history/detail record in the msdb database. This may indicate a problem with the msdb database. The backup/restore operation was still successful.
Processed 264 pages for database 'E:ASP.NET4.0_CalculatorhicalcApp_DataASPNETDB.MDF', file 'ASPNETDB_1847a276f17a4e2cb63c95936431bc26_DAT' on file 1.
Processed 1 pages for database 'E:ASP.NET4.0_CalculatorhicalcApp_DataASPNETDB.MDF', file 'ASPNETDB_TMP_log' on file 1.
BACKUP DATABASE successfully processed 265 pages in 0.404 seconds (5.124 MB/sec).
[Code]....
Actually i need to transfer data from one table to another table in mysql with codition of Time.for example i need to transfer data at 10.00am when user login at 10.00am it must be insert into another data table.. if anybody know time control
please reply me..C#
I am trying to create a function that will automatically log a client in using VB.The code below successfully gets the authentication cookies but when I add the cookies to the resultant response code I just get the OWA login page.
[Code]....
when I make restore to backup database display this error :
The backup set holds a backup of a database other than the existing 'elib' database. (Microsoft.SqlServer.Smo)
how I can solve this error ?
IBecuase if they the UrlReferrer is my applicatin then i want them to allow access to a file.Otherwise not.I know the urlReferrer is null if you go directly to the link, but thats not possible.In my test solution it works great, but if i put it online i got null values, sometimes he gives a value but mosly its null...
View 5 Replieshow to submit two different form in same time?
The form is in one page, and i cannot do it in one form because there are two different reference table used.
have two different applications. The only access between those two applications is Web Service.I want to delete records in the another application database by passing primary key of that table.I don't have access to database where I have to delete the records.For this, where I have to write the delete functionality.? In web service or or in my application.
View 14 RepliesI can probably figure out how to automatically insert data into two tables using ADO.net, and make one insert directly following the first automatically.
But can this be done using a single SQL statement? I've googled it and can't find much to help me out.
Note: I'm using MS Access as my database.
I'm using .Net 2008 and Oracle 10g as my database. The problem I'm getting is after deploying the application in IIS, when multiple users access the same page at a time i'm getting the error. Can't get the output.
Note: Both the users accessing the same page, same menu at a time.
How can I resolve this?
I am building a website that mostly uses Stored Procedures, but now I am facing a problem such that I want to execute the Stored Procedure more than one time each with a different value .
such that when I am calling it from the .vb page I could not execute it more than one time
this is my sql SP code:
ALTER PROCEDURE dbo.plnCs
Currently I run 2 separate queries to update + retrieve a tickent number. What happens if there're 2 users clicking on the same button at the same time? Could somehow two updates being run first and then both users get back the same ticket number?
string mySql = "UPDATE TicketCounter SET TicketNumber = (TicketNumber + 1)";
OleDbConnection myConnection = new OleDbConnection(accessConnStr);
OleDbCommand myCmd = new OleDbCommand(mySql, myConnection);
myCmd.Connection.Open();
myCmd.ExecuteNonQuery();
mySql = "SELECT TicketNumber FROM TicketCounter"
myCmd.CommandText = mySql;
OleDbDataReader myReader = myCmd.ExecuteReader();
I am deciding to output cache my page and i need to set duration as never expiring. how can i achieve this? Also if i do not specify any location, where will the cache get stored? client or server? Ram or hard disk ?
View 4 RepliesI have created a web form where users input there details and submit it to an acess database. I also want the current data and time of there submition to be stored into the database along with the other information. I was thinking about making the time and data displaying in a lable or textbox and submit the the values within them into the database. I have been looking around the internt on how to do this but I couldn't get any of the examples I have tried working. Is there another way to create this funnctionality.
View 5 RepliesHere's my problem: I have an asp.net app that invokes a java/axis based webservice through a wsdl file provided by my customer. But, as i had no access to this webservice at the dev time, i've created a fake .net based webservice, with the same methods, returning some valid data, so i'd be able to test the integration interface. The problem is, when i add the service reference on my app, pointing to my fake webservice (.net), it's class has a certain name, and when i point it to my customer's wsdl file, it's class has a different name. Generated class name when i add the service reference by:
- .NET fake webservice = "TransferenciaEndpointSoapClient"
- wsdl file of the java/axis webservice = "TransferenciaEndpointClient"
I want the class i've created in my fake webservice to keep the same name of the wsdl, when i add the service reference on my app. I tried to add a "web reference" instead of a "service reference", but it did not work. I also tried to change the name of the class on the "Reference.cs" file, it works on my environment, but it doesn't when i put the generated bin on my customer's environment. I'd like to solve this without having to create a java/axis based fake webservice.
I am able to store the current time of day in a column defined as time with the C# code as:notestable.NoteTime = DateTime.Now.TimeOfDay;The hour, minutes, seconds, and even millionth of a second is stored. But now, I need to retrieve the time and convert it into a string. I tried to use DateTime statements to accomplish this as with:
DateTime nt = notestable.NoteTime;
String FirstT = nt.Hour.ToString() + ":" + nt.Minute.ToString().PadLeft(2, '0');
Regarding the 'nt' variable, I got an error message that said: Cannot implicitly convert type 'System.TimeSpan?' to 'System.DateTime'.Regarding the 'Hour' designation, I changed the definition of 'nt' to 'var' and got an error message that said: System.Nullible<System.TimeSpan>' does not contain a definition for 'Hour' and no extension method could be found.So, how do I access the time from a table and convert it into a string for display in a TextBox?
Is there any method for finding the duration of an uploaded video without running any exe (ffmpeg.exe) in asp.net?
View 1 Replies