Storing Data From Database In Static Property?
Mar 25, 2011
I have got an ASP.Net website, where the data is brought in from ISeries.The data connection to ISeries is quite slow and the speed is quite important for this website. Because of the slow speed of data retrieval from ISeries, I want to make as less database connections as possible.So, I was thinking about storing tables from the database which rarely changes as static properties in my website. Whenevera user logs in I submit a thread which refreshes the data in the static property. Is this approach correct? If not, what are the problems with this approach and what are the possible alternatives?
Example:-
For list of ports, I submit the below thread when user logs on:-
[Code]....
In class Ports, there are 2 methods -
one for populating the static property PortList, and the other checks if the thread is alive and waits for the thread to complete and retrieve the list of ports, once it is complete. The second method is the one which I use in my application whenever I need the list of ports (populating a dropdown, etc).
[Code]....
View 1 Replies
Similar Messages:
Mar 4, 2010
Since I'm using Postgresql and can't use LINQ to SQL, I wrote my own wrapper classes.
This is a part of the Student class:
[code]....
It works now! I replaces all Run methods in the Student class with DB.Run
But I want to know if it will work fine with a lot of people online, not me only. I'm not sure how static things work with ASP.NET, maybe it'll eat a lot of memory?..
View 3 Replies
Aug 28, 2010
I have written a property globally on page load i am storing setting some value into that property but on button click i am not able to retrieve the data. Is there any alternate way to save the data other than viewstate or sessionstate. Ex:
Partial Class _Default Inherits System.Web.UI.Page Private s As String Public Property Test() As String Get Return s End Get Set(ByVal value As String) s = value End Set End Property Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load If Not IsPostBack Then s = "Test" End If End Sub Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click s = "Champ" End Sub Protected Sub Button2_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button2.Click MsgBox(s.ToString()) End Sub End Class
View 11 Replies
Feb 28, 2010
public static int _CompanyId;
I am assigning some value to _CompanyId after login .After some post backs i lose value in_CompanyId .What could be the reason ?
View 4 Replies
Nov 29, 2010
i made an asp page for registration with the following fields name, address etc. i also created database in sql server. how to save these field data in my database.
View 2 Replies
Oct 29, 2010
I am writing an application in which a remote url web site ( says url1 that is sender) sends xml data to another web site (says url2 that is receiver) by using .NET WebRequest. On the receiver url2 if I use .NET Page.Response and .NET Page.Request to store posted/received xml data into an external text file, then the data is stored. However, if I store the received data into database, I do not see the data is stored into the database.
trouble shoot the codes so I can store such remotely posted data into database on the receiver side url2.
I host both url1 site and url2 site in my computer using IIS like [URL]
1/ Receiver page's codes that store remotely posted xml data into database do not work:
protected void Page_Load(object sender, EventArgs e)
{
Page.Response.ContentType = "text/xml";
StreamReader reader = new StreamReader(Page.Request.InputStream);
String xmlData= reader.ReadToEnd();
ProductNameSapce.ProductCollection.InsertReceivedProduct(xmlData).ToString(); // data is not stored ; the method is tested and works well with hard-coded data
reader.Close();
Page.Response.End();
}
2/ The version of the receiver page at url2 that stores into an external text file works:
protected void Page_Load(object sender, EventArgs e)
{
Page.Response.ContentType = "text/xml";
StreamReader reader = new StreamReader ( Page.Request.InputStream );
String xmlData= reader.ReadToEnd ();
StreamWriter s;
s= File.CreateText ( Server.MapPath(".")+@""+ Guid.NewGuid () + ".txt" );
s.WriteLine ( xmlData); // data is stored in an external text file
s.Close ();
reader.Close();
Page.Response.End();
}
View 10 Replies
Jan 27, 2010
I want to store Date as well as time in a label. The code that i am writing is Label1.Text = Datetime.Now.ToString();
I want to save this value in to the database. This is what i am writing
com.Parameters.Add ("@Dt ", SqlDbType.datetime).Value = label1.Text; // this is the problem.
View 6 Replies
Apr 15, 2010
Friends have quick question for you.i want to know storing videos and images into database(binary data) or local hard drive is efficent. What way general websites stores them in their websites.
View 6 Replies
Mar 19, 2013
i m having 4 radio buttons on default2.aspx page on the same page i m using a database it's columns are uname and status whenever the user clicks on the radiobutton the status of that name should increment by 1(counter variable).
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
[code]....
View 1 Replies
Oct 4, 2010
I am using javascript to validate user input on my aspx page. I am easily able to validate textboxes and dropdown list for differenet scenarios.
Now, on one of my dropdown lists (for country), I need to check if it is an allowed country or not for a particular service. I have stored the valid country list in a static property. Is there a way to validate my dropdownlist selected value against that static property?
function validateService(source, args)
{
var country = document.getElementById('<%= ddDestCountry.ClientID %>');
var service = document.getElementById('<%= ddService.ClientID %>');
// Get allowed country list from my static class
var countryList = document.getElementById('<%= StaticProperties.EUCountryList %>');
if (service.value == "P")
{
// I want to do something like this
if (!countrylist.Contains(country.value))
{
args.IsValid = false;
}
else {
args.IsValid = true;
}
}
return;
}
Update(Additional Information): The static property is read-only so it cannot be tampered with from the page.
View 1 Replies
Dec 15, 2010
I am working on the application that allows user to upload a file (from their local machine) and store the uploaded file in database.Then,the content of the file (such as ContentType,FileSize etc)can be view in a DetailsView control.
View 1 Replies
Oct 17, 2010
I want to know , how good / bad is it to save configuration values in a static properties?I am creating an application which reads configuration from an XML file and a DataContext file, instead of sending the CustomConfig class into the configuration.xml each time I tought about using an ReadXml() method on application_start at the global.ascx
the ReadXml() method would save the data in static properties of CustomConfig and whereever I would want to read that particler data I would ask CustomConfig.PROERTY_NAME
My question is ? how smart it is ? how long does IIS would save the data in a static member? (if as long as the application exists then I'm ok as long as I add the ReadXml() in the application_start)
View 2 Replies
Nov 6, 2010
I am fetching data from .xls file and storing it in to database. Then my users work on a single table where I stored all .xls data. But the problem is that it takes tooooo much time.. So, I want to use cache. But I never used this... Can any one tell me this example how can I use cache with database for increasing application speed?
View 2 Replies
Jan 6, 2010
just i am wondering is it possible to change the text of other than server controls
for example:
<table>
<tr>
<td>SOME TEXT</td>
</tr>
</table>
I want to change the SOME TEXT to its equivalent french text,
because in my project every data comes from database(even the static content)
View 3 Replies
May 7, 2015
I'm using jQuery and setInterval method in my asp.net web application.
I call the webservice every 5 seconds in order to check for DB changes. When i see a change, i want to change the photo of the linkButton that located on the master page, but i can to that due to static constrains.
An object reference is required for the non-static field, method, or property 'System.Web.UI.Page.Master.get'
my c# code is:
[WebMethod()]
public static bool checkDBChange(string userId) {
DBConnection dbConnection = new DBConnection();
if (dbConnection.isChanged(userId)) {
((Site1)Master).SetImageUrl = "~/Icons/a.ico";
}
return false;
}
The SetImageUrl is a setter in my master page that sets the new url to the linkButton. How I can implement it?
View 1 Replies
Jan 31, 2011
"'ErrorMessageResourceType' property specified was not found."
{"The resource type 'XXXX.XXXXXX' does not have a publicly visible static property named '_RequiredXXXX'."}
I'm getting this error when my Create.aspx view is called and steps over that line:
<%=Html.TextBoxFor(Function(model) model.NO_DEMND, New With {.class = "txtbox", .disabled = True})%>
<%=Html.ValidationMessageFor(Function(model) model.NO_DEMND)%>
The message is there in the Ressources file, I think the problem is deeper than that but i'm having a hard time finding it. It pops this error very early on the ASPX page. It's the first model component it goes thru, i tried removing this one and it's the same message for all the model.xxxx components. I guess it's an error somewhere in the linkage. The .EDMX is correct and I get no build errors,
View 1 Replies
Mar 24, 2010
I am getting a CS0120 error when trying turn a button visible after checking some variables. In plain english, If AmmohelpSession.UserActions contains AmmohelpEnums.UserAction.ArticleEdit then turn the Edit button visible. Here is my comparison:
[Code]....
In the code behind for AmmohelpSession, a public class AmmohelpSession which contains a private variable: private HashSet<UserAction> _userActions; has been stated. In that same file, there is a public function for the UserActions that does a get or set method.In the code behind for AmmohelpEnums, we are setting byte variables to specific actions. Mine would be something like:
[Code]....
Where is my error coming from ?????
View 1 Replies
Oct 5, 2010
how can i store image into database and view it in grid view?
View 3 Replies
Apr 22, 2010
I have a requirement to allow users in a content management system to create their own image maps through a gui interface, which I have accomplished. But instead of saving the image map to the page code, I want to save the image map code to a database (sql), which I've also accomplished. When I started down this road in my head I was thinking the whole time that I'd just add the "usemap" attribute at runtime shown below where promo1.ImageMap holds the entire map code:
if(promo1.HasImageMap) imgPromotion1.Attributes.Add("usemap", promo1.ImageMap);
I guess I didn't think it though well enough, because it seems that "usemap" only expects the name of the existing map to use from the page code, and not the map code as a string.
how to apply the map from the database to the image at run time?
View 1 Replies
Apr 14, 2010
I'm now working on a application which needs some pdf files (size 200kb -1Mb) to be stored into Mysql database.
View 2 Replies
Aug 16, 2010
Have a question about the best approach for file storage in a SQL database. I have a table called Widgets, and each row in the Widgets table can have multiple files. I also have another table called Extensions, and again each record in this table can have many files.
Here is what I am considering:
Approach #1:
[Code]....
That approach is very simple and easy to use, but I feel that I could merge the two file tables into one, then use lookup tables:
Approach #2:
[Code]....
The thing is, there are no duplicate or shared files between the two types of objects. So even though I feel better about approach #2, I am concerned that I may be adding additional complexity (and using more server resources to perform the joins), than needed.
View 1 Replies
Jan 28, 2011
i am a beginer and i want to know how to store images in the database tables like pictures of the pizzas and when the user selects one of the pizza from the dropdownlist he sees the image of the selected pizza.
View 2 Replies
Nov 8, 2010
I get a Exception while Storeing current datetime in sqlserver 2008.
UI-Sliverlight 4.0
BAL-WCf
DAL-ADO.Net Entity FrameWork
Tools-VS 2010
In Sqlserver 2008 DataBase one columns of a table is CreatedDate Having datatype :-datetime When i am passing Created Date as DateTime.Now i.e.( objRFEProxy.mCreateDate = DateTime.Now;) in sliverlight codebehind it through error. InnerException {"The conversion of a datetime2 data type to a datetime data type resulted in an out-of-range value. The statement has been terminated."} System.Exception {System.Data.SqlClient.SqlException}
View 1 Replies
May 25, 2010
I'm working on a blog and want to show my posts in eastern time zone. i figured that storing everything UTC would be the proper way. This creates a few challenges though:I have to convert all times from UTC to Eastern. This is not a biggie but adds a lot of code.And the "biggie" is that I use a short-date time to reference the posts by passing in a query, ala blogger. The problem is that there is no way to convert the short date time to the proper UTC date because I'm lacking the posted time info.
View 4 Replies
Jan 11, 2010
I'm creating a static helper class for web services I'm writing. I'm tapping into the API of Telligent and therefore creating these Telligent "service" objects that allow me to do things with the platform. For example, I'm creating a MembershipSerice object in my helper class so I can do membership stuff with the same object. In my helper class I have a property with a getter that creates a new one of these objects:
private static MembershipService _MembershipService {
get return new MembershipService(path, usr, pwd);
[code]...
View 3 Replies
