C#

DineshSharmain wrote:

its related to performance & scalability of static classes.

DineshSharmain wrote:

if 100 users are trying to access the same method of class at the same time

belzer wrote:

How can i extract all the text strings

belzer wrote:

How can i extract all the text strings such as message box messages, text box values etc. so i know what i need to translate.

Xmen wrote:

is there anyway to add resource at runtime ?

CrimeanTurtle2008 wrote:

Cache.Insert("Client", ds);

CrimeanTurtle2008 wrote:

source = new DataView(ds.Tables["FirstName"]);
Cache["Client"] = source;

CrimeanTurtle2008 wrote:

Would I need to insert the dataset into the cache after declaring what the
source is?

CrimeanTurtle2008 wrote:

How would I remedy this?

CrimeanTurtle2008 wrote:

Would I need to insert the dataset into the cache after declaring what the
source is?

public partial class Caching_ApplicationCaching : Page
{
	const string QUERY = "SELECT firstname, lastname FROM customers";
	const string CACHE_KEY = "Client";

	protected void Page_Load(object sender, EventArgs e)
	{
		DataTable source = GetCustomersTable();

		DropDownList1.DataSource = source;
		DropDownList1.DataTextField = "FirstName";
		DropDownList1.DataBind();
	}

	private DataTable GetCustomersTable()
	{
		DataTable source = (DataTable)Cache[CACHE_KEY];

		if (source == null)
		{
			source = PopulateCustomersCache();
		}

		return source;
	}

	private DataTable PopulateCustomersCache()
	{
		using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString))
		{
			using (SqlCommand command = new SqlCommand(QUERY, conn))
                        {
			    conn.Open();
			    command.CommandType = CommandType.Text;

			    SqlDataAdapter adapter = new SqlDataAdapter(command);

			    DataSet ds = new DataSet();
			    adapter.Fill(ds, "Customers");

			    DataTable dt = ds.Tables["Customers"];
			    Cache.Insert(CACHE_KEY, dt);

			    return dt;
                        }
		}
	}
}

KaptinKrunch wrote:

and is working. Currently I'm not making this call or similar in any of the service events.