my requirement is to delete database value automatically on a given date. In my application i am inserting records in database, now admin will give the expiration date for the value inserted in db. On that particular date, the value should be deleted automatically. I want a logic for this in asp.net. I am using SQL 2005 with C#.
View 5 RepliesI have an asp.net application consisting of two web pages and a web service. All components are part of the same project, i.e. I have a solution with only one project. The web service queries a server and fills the information it retrieves into container objects which are stored in the cache of the application. This done using the Cache.Insert method:
Context.Cache.Insert("DemoCacheEntryKey",
"DemoCacheEntryValue",
null,
Cache.NoAbsoluteExpiration,
Cache.NoSlidingExpiration,
CacheItemPriority.Default, OnRemove);
OnRemove is my handler that writes the reason into the log file in case the item is removed from the cache. Now from what I understand this example item should never be automatically removed from the cache. Basically this is what I want: It shall stay in the cache until I explicitely remove it. Once the cache is populated by the web service one of the web pages visualizes the cache content using html. The other web site contains a button to manually kick on the web service and one button to clear the cache content, i.e. remove everything in the cache. Unfortunately somehow the cache seems to get cleaned up once in a while. In irregular intervals all containers that are created by the web service and are stored in the cache are removed from the cache. I don't understand the reason for this. The only place in the code I remove something from the cache is when I manually press the clean cache button on one of the web pages.
What is strange is that all container objects in the cache are removed, not just a few. But this is not because the button that cleans the cache is pressed. I know this because a log entry is created whenever that button is pressed. To find out what is going on I attached the OnRemove handler which just logs the reason why a cache item is removed. In my case the reason is "Removed". I simply don't get it. How can I ensure that the cache just stays as it is? Items placed in there shall just stay there. Nothing shall be cleaned up automatically.
nvironment : [Asp .Net Application in Visual studio Team System 2008 + SP 1 ]+ Windows 7 Enterprise + IE 8+ IIS 7.5
I am running into a odd problem with Visual studio 2008.
A scaled down version of problem is as:
Consider ASP .Net application with a simple ASP .net page.
Write Cookie on one button click as:
[code]....
Why Visual studio 2008 is automatically deleting the cookies on closing of Broswer?
I have a FormView through which I set up the default new, update and delete commands for communicating with an SQL Server database. When the CREATE command is executed the data is added to the database and some images are uploaded to a server and linked to the database.
When I press the Visual Studio's default FormView DELETE command I obviously only delete the selected row in the database and not the images on the server. I marked the uploaded images with images ID + "name" , so I could delete them if I could only retrieve the ID of the row being deleted by the DELETE command. How do I do retrieve the ID of the deleted row in C#?
i am using sqlserver 2008 express.
i have a problem here, unfortunately i deleted "Manually" some important tables from my database, now i need to retrieve those tables,
i didnot take a backup for those tables,
can i retrive those tables or roll back delete process?
I have a site that show infomation that are contained in div blocks. The info is taken from a database so the user can change the info or delete it. When the user deletes a div block i want to use jQuery to animate that its disappearing and also that its deleted from the database. How can i do this without doing a postback, i dont want the site to reload, i just want the Div block to disappear visually and be gone from the database at the same time. Would i use Ajax update panel to achieve this ?
View 3 Repliesi have a web application with sql server 2008 i wanna know if its possible to load the data automatically after its been inserted to DB..i have a alerts table which store message and user name to which the alert is to be send i wanna display the alert msg to user after it has been inserted...
View 3 RepliesWhen I use RequiredFieldValidator inside a DetailsView control field template, it automatically prevented DetailsView from inserting new records into the database, when triggered. JavaScript was disabled.
I'm a bit surprised and I'd like to know whether this is caused by the validator or is there a built-in feature in DetailsView that prevents database from being updated if some validators on the page are triggered?
If so, how is it possibly implemented (e.g. inside when eventhandler)?
I want to send clients remainder automatically when he set remainder for particular date. mail automatically send to his mail on that day.
View 1 RepliesHow to generate a employee code in textbox automatically while in run time in web application.......when i run the page it will check the employee code in the database and it automatically shows the next value in the textbox how? Â
View 1 RepliesLets take an example of online ticket booking system. Many users could be booking the tickets at any point of time. a GridView displays the list of Allotted and Free seats If a seat gets booked, this information must get updated in all the opened pages in user's browser. User need not require to refresh the page to see if a seat is booked or not Should i put GridView in update panel and keep looking into the databse constantly ??? This could turn out to be a heavy work if databse is too large any other alternative?? or should i stick with the above approach....?
View 10 RepliesI had created Data Entry webform. Data is stored in Database. I have created 'Date' coloumn in database table with data type datetime. I want to isnert todays date automatically when data is inserted through form in DataBase.My current query to store data in database is:
public bool MyData(string COL1,string COL2,string COL3,string COL4,string COL5)
{
string SQL = "insert into TABLE values('" + COL1+ "','" + COL2+ "','" + COL3 + "','" + COL4 + "','" + COL5 + "')";
}
At current we have about 100 websites that we host, a lot of those are database drive, what i wanted to do is build a script that would let me enter the details for this website into a DB (domain name, ftp username, password, database name, username and password etc) and then download that website / database on a regular basis
I wanted to do this in .net so i could add it into our intranet and add some reporting so when our clients log into the extranet they can see their website has been copied etc
How does UpdateModel() works? In the mvcmusic application the postback code contained the following:
UpdateModel();
storeDb.saveChanges();
How is this automatically saving changes to database?
My previous impression of RequiredFieldValidator and similar have been that they show you an error label and set Page.IsValid false and that is it. Meaning they leave the rest of the task (preventing the use of wrong input data) to you. But today I have realised say if you use a DetailsView to insert a new record to a database, and you use validators to check the TextBoxes inside the DetailsView, they automatically prevent the database from being updated.
I would like to know how this is implemented behind the scene. I'm guessing it aborted the Page Lifecycle at Validator.PreRender event, so that database connections at later stage could not be reached? I'm probably wrong. I'm trying to use Reflector to get inside the RequiredFieldValidator to see how it is implemented, but I don't really know where to look.
Is there any framework or tool to generate web services (WCF) access to all the non transactional tables in my database? something like asp.net dynamic data but with web services, I need to do this for homologation with other systems.
View 3 RepliesHi creating a simple blog site where u can login and save blog entries. I want to use the loginname control to automaticly save the username of the one entering the blog.
View 2 RepliesIn my ASP.Net application I have several pages that provide a list of items from the database. Currently we are using an UpdatePanel to refresh the whole list on a certain interval so that changes from other users will be propagated the screen. Obviously this isn't very efficient and we don't think it will scale well.What are some other methods for accomplishing this. Is there a specific pattern for addressing this issue?
View 1 RepliesI'm currently developing a software application for my client. Part of the project is to keep track of his stock's shipping status. The client must insert the stock's pick-up date, expected time of departure (ETD) and expected time of arrival (ETA). The stocks will be called out using Grid View and the status, being one of the keys of the database, will be shown. Before the current date reaches pick-up date, the status must show "in warehouse", and after the current date reaches pick-up date and is before ETD, status must show that its "on the way to the port", and after ETD and before ETA, "in freight", and finally after ETA, "arrived". What datatype should I use for the database and where should I program it so that it changes automatically accordingly ?
View 5 Repliesdoes DbCommand.Dispose() automatially close the database connection?
Here is my code:
Database db = DatabaseFactory.CreateDatabase("DBIS");
string sqlCommand = "procUIBillingAdjustmentsCreditInvoicedSegment";
DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
DataSet ds = new DataSet();
[Code]....
I am working on an ASP.NET web application, we are a small team (4 students) and we do not have access to a dedicated server to host the database instance. So for this web application we decided just to put the database file in the App_Data folder.
The problem is that our project is source controled on TFS, so every time you open the solution and try to launch the web application, we get an expcetion saying that database is read-only. That is logical because the databse file is not automatically checked-out.
I want to take first Full backup of my database then Differential backup of database automatically on a fixed interval of time and save it into my files of system. After that i want to upload these files on server. when uploading is successful then i want to delete these files from the system. If backup of database is failed then a mail should go to the related person. How i will do it.
View 1 Replieswhen im deleting rows in a grid view only the first row getting deleted i mean if i want to delete the third row the first row is getting deleted instead of third i dnt know y below is my code
[Code]....
I am creating a website using ASP.NET (C#) using FTP
problem:
I have assigned a folder with a storage space let say 1GB to a user now what i want is to keep track of the storage space ulitilized by the user. for eg if a user saves/deletes a file in his folder, how to know that user has saved/deleted something to/from his folder.
I have a GridView. One of its columns contains monetary amounts. Underneath the GridView, I have a SqlDataSource which calculates the sum of this column and displays it in a label which is in a DIV called totalsbox (that I have added runat="server" to).
Obviously, if the GridView is empty, I don't want this label to be visible.
In the Page_Load, I have placed the following code:
[Code]....
[Code]....
This works fine. When the Page first loads, if the GridView is empty, the entire DIV is hidden; if not, the DIV is visible and the label displays the column SUM. imagine now the GridView DOES have rows, the DIV is visible and the total is displayed properly in the DIV ("£10.00", say).
I have a RowDeleted event handler in the code behind which contains exactly the same code as I put in the Page_Load. As I delete rows, one by one, the sum is recalculated and displayed properly. But, when I delete the final row, I would expect this code to hide the DIV as the GridView is now empty.
This doesn't happen, however, the DIV remains visible and I have, in the label, something like "£ ".
Why is it that the code works in the Page_Load but not in the RowDeleted event handler?