I am using sql server 2005. In my project i wanna auto delete the data from the database after a fixed interval of time say (30 days); Is there any automatic process to delete the data from the database without the user intervention..
View 19 RepliesI have a webservice which needs to query the Database every hour to get the latest copy of the data. What would be the best way to have the websevice call a method every hour. I am condering using the imers.Interval to call a method every hour.
View 3 RepliesIf its posible I want to create a table with a primary key with auto-increment and a fixed value to differentiate the table from others tables
ex:
table 1 | table 2
ID | ID
----------|-----------
a1 |b1
a2 |b2
a3 |b3
I'm having a gridview in my aspx page with checkbox, User can select one or more than one record(s) at a time and clicks on delete button, Then i'm constructing an object of my DTO and adding all the checked row's Primary Key (DataKeyNames - GUID's in case) to a serializable class and generating an XML and sending it as parameter to the Stored Procedure.
My Doubt is, can i bulk delete all the rows from database table those are present in my XML document??
If it works, I can do bulk update with XML only, i already did bulk insertion by generating an XML..
My Another Question is, Will it affect the performance? Each time when i construct an DTO object and adding it to the Generic List??
WHich one is better, I mean ObjectDataSource or SQLDataSource or my XML method?
My XML will be like this
<root>
<Customer>
<CustomerID>GUID1</CustomerID>
<CustomerID>GUID2</CustomerID>
<CustomerID>GUID3</CustomerID>.....
I have a simple online web system where it possible for the visitors to "play around" with the system. They can like create categories and products and so forth. Everything they create are stored into a database.
What I want is to be able to reset this database with my default values (table data) every n hours.
So for example if we have a bunch of users that have played with the system and created new things. Then I want to be able to make some kode that deletes all data in the tables in this database and fill it with default data. The default data can come from a backup file, or another database with same tables structure or whatever.
I want this task to be done every day at 12 pm or every n hour.
Is this possible (by forexample scheduled webservice tasks or just something as long as it is simple).
I want to calculate the total data download and upload in a particular interval of time, and store it to a database so that it can be viewed later on. Thus, this particular user logged in at this time and downloaded and uploaded this much data.
I want to do this in C#.
In one of my website, i required to implement automatic refresh of webpage after 15 minute.
For this to achive i have write following line of code <meta http-equiv="refresh" content="60;url=" />
But i am facing one problem that after this duration of 15minute page will refresh as a new page load.
At my page i have used combo box having city list, there is a case when i select an item from this list at index 3. After that i just make page idle and after 15 minute page is refresh with the script i write for auto post back (mentioned above). But the problem is that due to this page is reload as a new page and code inside (!PostBack) execute which refill combobox and reset at index 1. My basic requirement is that whenever user reaches that page and makes it idle for longer time, session should not expire and hence i am writing above script so that session would be live.
in my application i need to generate/open a popup window automatically at some interval of time, when the user is working at some page in the application, like a alert message
the popup window contains some information which should take from the database,
and the information should be updated automatically when the popup window opens,
i am developing my application with c#.
I need to create a scheduler for a hospital appointment screen.. i am taking a time interval value and doctor schedules from MyDb. I want to fill the gridview based on the doctor's schedule timings and interval....
for Ex;
if Doctor A .
Time schedule is 09:00 Am - 09:40 AM && 10:00 Am - 11:00 AM
time interval is 20 minutes
i need to show the grid like this ....
09:00 AM
09:20 AM
10:00 AM
10:20 Am
10:40 AM
11:00 AM
we have to upgrade a database application.
In the previous application the transaction is updated 2 days later into the database.
Now we have to update that instantly when the transaction happens.
How this is possible. I want to know why the database update too late
I am writing a music related web site. What I am trying to do is have the user upload a song (MP3, MP4, Wav). I then want to be able to slice the song to a max lengh of 30 seconds. The user would be able to select a starting point and I would cut the song down to 30 seconds from that point.
View 1 RepliesI have a forum area on my website and i would like to make forum main page in such a way that it should refresh itself every 2 minutes. How i can accomplish this ?
View 8 Repliesi need to rotate images after a specific time interval and images coming from Database.
my main problem is that i am not allowed to use ajax or ajax toolkit for performing this function. and i don't know how to do that without ajax?
the way by which i rotate the image with out ajax
I have written the following code to display multiple markers in google map and i succeeded in it.Now i want to have a drop animation applied to markers and want to drop marker after a specific interval of time.I know i want to call setTimeout method ,but don't know where to call this method to achieve the result
<script type="text/javascript">
window.onload=function(){
if(markers.length>0){
var mapOptions={
center:new google.maps.LatLng(markers[0].lat,markers[0].lng),
[Code] ....
How to Automatically send birthday emails daily at specific time using in global.asax in asp.net without using windows services.
Firstly check and fetch all records of Students who have a Birthday today ....
I have Website Application , in which i have method ..i want to execute this after every 10 days automaticlally ..what is the concept of doing this , provice some code etc. if possible ..
my method includes some server side processing..
I have project in asp.net with sql server backend.i want to auto generate a number for particular column.with the auto generated number i want to insert some other data in the same row same table. on button click event.details
railway PNR no.:- want to autogenerat
passenger details:- want to inserted simultaneously
I m trying to save files like pdf, word, excel etc... into sql express, but m getting this error in my web page:An attempt to attach an auto-named database for file C:Usersmalek.safaDocuments est vbSavingFileInDBSavingFileInDBApp_Dataaspnetdb.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
m not getting errors inside my code, just this one appearing on the web page.
I want to generate 30,000 cards and each card must be duplicate check with database. In my card, there are 2 things. Serial No and CardID. If any card already exists then I generate another card id but with the same serial no.
So how faster way I can generate 30,000 card with duplicate check? Which one I have made application, it takes about 25 minutes to insert.
I am currently working on a module in which I am creating an auto generated column gridview, and I have set the Auto generate edit button field to true. What happens now when I click the edit button The primary key field is turned in to edit mode which I want to restrict from being updated.
To restrict the same I have hard coded a template field which holds that column, But as I have set the AutoGenerateColumns Property to true the gridview automatically creates a duplicate field for holding the primary key column. For which I want to delete that particular column.
My Designer Code is:-
[Code]....
in page load I am binding the grid view.
Even I have tried to hide that column doesn't make any difference for me.
I have a table which stores records about a promotion programs. For each record, there are different status such as Begin, Successful, Unsucessful, Expired and there are PromotionDate and PromotionExpiredDate. I am just wondering how I can set each promotion to auto expired (auto change the status of each promotion status to Expired) when the current date is bigger than the PromotionExpiredDate.
View 4 RepliesIs there any tool or way by which we can cache our pages after fixed time automatically instead of user to click link and then cache on server.
View 1 Repliesauto increment alphanumeric primary key(eg :ABC001) in sql server 2005 database table.
View 2 RepliesI have one question that is i have to run one program in host server at a particular interval (lets say in each & every 1 hour).
But the thing is that in host server we can't run scheduler , so i want to know is there any approach by which we can achieve this task.
i am using asp.net 4.0
i want to remove Auto Genrated Columns of Gridview at Run Time and change the header text of these columns.
[Code]....