I am using page caching in one form they retrive some rows from data base for example i put caching time to 5 minutes, in between 5 min suppose the data has modified in server then it should be reflected in my form how to achieve this problem
View 1 RepliesRecently i am develop a tuition center management systemNow i want to show a timetable which admin can view and know what time the class room is emptyMy timetable is : On the top of x-axis is time (8am, 9am, ...)On the left of y-axis is date (monday, tuesday, ...)In database i will define the start time and end time for each class
View 6 RepliesI am using System.Web.Caching.Cache in an assembly used by my website.
I have set some key expiration (absolute expiration) to be 10 seconds (just for debugging).
I have also set a callback upon key removal.
The problem is that I see that the cache is getting refreshed after something like 20 seconds and not 10.
I am using HttpRuntime.Cache for this.
I would like to show a code sample, which can shed more light:
[code]....
What could be the problem ?
I have a lot of requests that read my Web Config file (eg. variable = WebConfigurationManager.AppSettings["BLAH"]). I am wondering... Do WebConfigurationManager.AppSettings read from disk each time, or is it cached in memory. If it's read from disk each time then I guess I will need to move the variable to a static variable so as to improve my app performance...
View 1 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 Repliesight now I'm using below '<connectionStrings>' for my system on my local computer.
<connectionStrings>
<add name="ConnectionString" connectionString="Data Source=MY-PCSQLEXP;Initial Catalog=DBSOS;Persist Security Info=True;User ID=sa;Password=abc123" providerName="System.Data.SqlClient"/>
</connectionStrings>
Because I have a plan to connect and retrieve data from SQL database table from another server. Can I do that?
I have a page with a number of user controls, In one of my user controls I have a button event. I turn on output cache for the user control that has the button and vary by control using the ID property of a hidden field control in the user control. whenever I turn on the output cache my button event doesn't fire.
View 2 RepliesCan anyone show me basic syntax to connect and retrieve data from a sql server via VB?
View 1 RepliesWhen I attempt to store the current time of 'DateTime.Now' in a column defined as time in a table within an SQL database, I get an error message that says: Cannot implicitly convert type 'System.DateTime' to 'System.Timespan'.
I have no trouble storing the current date of 'DateTime.Today' in a column defined as date, but this column will not also store time along with the date. The date column has properties that indicate it has a data and system type of date with a Length of 3 and a Numeric Precision of 10. The time column has properties that indicate it has a data and system type of time with a Length of 5, a Numeric Precision of 16 and a scale of 7. Did I define the time column incorrectly for storing the time of day?
I have some problems in database connection and wonder if I have something wrong in my code. Please review. This question is related: Switch between databases, use two databases simultaneously question.
[code]....
A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached. Cannot open database "db" requested by the login. The login failed. Login failed for user 'root'.
Failed to generate a user instance of SQL Server due to failure in retrieving the user's local application data path. make sure the user has a local user profile on the computer. The connection will be closed.
After I formated my system, When I run my website on local IIS databases, aspnetdb.mdf don't seem to work. But works fine on local Cassini (VS).
But this problem is only with one of my new website , rest everything work fine.
Does it have anything to do with SQL Managment Studio? I din't take any backup of master database and all.
im trying to retrieve the data of particular day(by input from calendar ex:2/25/2011)
but the column of table in which i have the data is in datetime datatype(ex:2011-02-25 14:02:10.293)
i tried the foolwing query but im unable to retrieve.
SELECT quantity,[saledate] FROM TblSales where [saledate]= '2/25/2011'
but when i try with complete date time ('2011-02-25 14:02:10.293') im able to retrieve.
i wanna have all the data of choosen day(date).
I'm not that fit with asp, but here's my situation:There are multiple machine's on the lan with each there own server who is providing asp site's with info I'am desperate to retrieve. All those machine's are connected to a central "client". On that client I'd like to run a form-application(vb.net).So I made a programm using HTTPwebrequest to retrieve the data, but this returned only the serverside asp-code.How con one retrieve data from a site and put it into a own variable to handle.??The serverside asp pages are accessable and editable to me.
View 4 Repliesretrieve data from sql server without using details or grid view.
i have a table in the SQL server called NewsTable which inculde the following fields: "titlename","bywho","datetime"."news"
anyway i need to retrieve the data from this table to my web page to appear this way ==> i am using C# by the way
TitleName
posted by bywho on datetime
News
need sql statements to retrive the records which addbefore one week ,two week,one month and two month depend on the date column in databaase i want to retrive the records which add before week and so onany one can help me how i doing this
View 7 RepliesI'm trying to make a dropdown list with data available based on the users login name. Heres what I have as my SQL Query in the SQLDataSource:
SELECT Client_Name, Client_ID FROM Client WHERE (Client_Name LIKE '%@Client_Name%')
So say if the login username is "User1" but the database client name is "User1 Steel" I want the dropdownlist to pull "User1 Steel" as the display and Client_ID as the value from the dropdown list.
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.
How can I retrieve the list of all the request I made it to server with respect to time required to process time for it.In my page I am using some web services. I want to retrieve list of all the web services I am using and time required to process this request.
View 2 RepliesI have a Timestamp column in my Table. I want to read the date time value and display in UI.
In Linq the Timestamp column is represented as System.Data.Linq.Binary.
I dont know how to retirve date time value in "MM-dd-YYYY" format from this Linq.Binary
- Why I am using Timestamp?.
I want to perform some operations based on the last modified date time of the particular row. Since I am using TimeStamp column in my Table as version column, It will contain the last modified date details, So i want to read the date time value from this time stamp column to do some other operations.
I have my field type nvarchar(50) and also save my aspx file with unicode with/ (without) signature?But still I am getting the return value ????? and saving also in database by ?????
I am usin SQL 2005 VS.net 2008 and also using some AJAX Controls in my file Like Clander etc.how I can Save and Retrive the Arabic DAta from my Entry Page?
I am creating a website that reads and writes from SQL Server 2005.
I am able to write to the database but I can't retrieve that data and display it in a label.
how to retrieve the data and display it in a label.
how to implement caching in wcf service using System.Web.Caching
View 2 RepliesDetails:
I am using visual studio 2005 on windows xp sp3. The website is stored on file system. I used subversion to checkout the code from the server.
Here is the issue:
When I run the application for the first time everything is fine. But when I makes changes in the application then I should just be able to see those changes by reloading the page in browser. But it's not happening. I have to stop the development server and re-run the application which will start a new instance of development server and now I can see the changes. This takes like 3-4 minutes and it's a lot of waste of time which I can't afford.
For my fellow developer who is here for a long time everything is just working fine. He can just modify the page and reload the page in browser to see the changes.
Reading some forums on web, I tried to clear the cache of my browser (IE, Firefox) and it's not working. So, it's not a browser's cache issue. It's related to cache in development server.
How a pdf file will save in database sqlserver(2008) and Reteriving all file(s)them in pageload() in required page? in C#
View 1 RepliesI have found this question in interview questions
"If i store cache in server the server will over load because of cache objects so how can i prevent that?"