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 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 RepliesHow can i trigger my update panel to refresh after a certain period of time.
View 3 Repliesi got a problem to update my database which i bounded to datagrid. The problem is, i want to update my database only by clicking one update button at the bottom.. when the user click it, all the fields will be updated to database.
View 3 RepliesBasically I am trying to execute this code:
[Code]....
ERROR:Error 1 Cannot create an object of type 'System.Int32' from its string representation 'Convert.ToInt32(ViewState["RefreshInterval"])' for the 'Interval' property.
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
i want to update the data of a database through a gridview update button
how can i attach a dataconvertion like this
[Code]....
I 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 RepliesI 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#.
update database using data from dropdownlist on gridview C#
<asp:GridView ID="GridView" runat="server" AutoGenerateColumns="False"
DataTable to update database? tbl.Columns.Add("COL1");
View 2 RepliesSometimes the database clears everything and keeps the original status record.I don't know why this won't update,
[Code]....
How do I view rows in a table and then be able to update the image stored on the database for that specifc row?
View 1 RepliesAm trying to build a page that will display one record at a time. That is the user searches a records table and the page displays the record. Than when the user us done making any changes and clicks save, i want the page to update the records table. So far, i have the page displaying the search results, but the save functionality is not working. Actually after changing an entry and the save button is clicked, the records change are currently reverting back to the old data that they want to change it from. How do i go about updating the records in the database? Here is the code that I have been able to come up with so far.
[Code]....
I want to update my cached data , if there is any change in database. , if any change in database/tables happens then my cached data should be updated.
View 1 RepliesI am using button field in gridview after user clicking a button data in the row want to add in my database table. i am using a storedprocedure to fill a data in grid achieve . i didnt know how to add a row field in database .
View 7 RepliesI have an admin page in which I need to change the list whenever a user signs up on our web site.How can I put and event to MySql database so that whenever the count of a table row changes it refreshes my update panel for me to see the new user.
View 2 RepliesMy gridview was working just fine until I converted the Officer Report collum to a templatefield so I could have a multiline text box. Now when I go into edit mode and press update, it doesn't update. I don't know what I am missing here?
[Code]....
Here is the datasource information.
[Code]....
I am developing an application in which we have to fetch data from the database and update data at regular interval in marque or in any other control.
View 3 RepliesI have a gridview with a button and when this button is pressed i want to update a database record that corresponds to that gridview post.
View 17 Replies've using adrotator in my web page store few images using xml file .The problem is only image change when refresh but i want to be change in regular interval.
View 5 RepliesI wonder how it will be possible to have an imagebutton to switch between Image1.jpg and Image2.jpg with an interval of 1 second. It will loop like this Image1.jpg,Image2.jpg,Image1.jpg all the time.
For example in this case, the images will start switch if the public variable blinkImage is "true".
[Code]....
If you use a space <br /> this is a little too much space.Is it possible to reduce the interval between two textbox?
View 6 RepliesI am *VERY* new to ASP.net. This may seem simple to you all, but I'm really lost. I have a small sized page with three text boxes (part of the InsertItemTemplate) of a formview, and a slightly modified link the system generated to submit the data to be inserted in the database:
[Code]....
If this page is run, it inserts the data into the database fine, clears the form and sits there. I want it to return a simple "Thank you" page in a window of the same size, with a Close Window buttom at the bottom to close the window:
[Code]....
When I set the postbackurl property on the first page, everything appears to work, except the write is never done to the database. If I remove the postback, it works as it did previously.
through clicking the title from gridview it willl update the status of the lecture from 0 to 1
0 means new while 1 means already opened..
this is my code
[Code]....
[Code]....