Accessing Session Value in JavaScript

< script type="text/javascript" >

function ShowName()

{

var mySessionvalue='< %= Convert.ToString(Session["name"]) % >';

document.getElementById('txtName').value = '< %= Convert.ToString(Session["name"]) % >';

}

< /script >

ACID Properties

ACID Properties

• Atomicity—The transaction is all or nothing.
• Consistency—All constraints and other data integrity rules have been adhered to, and all related objects (data pages, index pages) have been updated completely.
• Isolation—Each transaction is completely isolated from any other transaction. The actions of one transaction cannot be interfered with by the actions of a separate transaction.
• Durability—After a transaction is completed, its effects are permanently in place in the system.

Query for Max Salary and empname with managername

--Show employeename with manager name
select a.id,a.name,b.name as 'mgrname',a.salary from
emp a left join emp b on(b.id=a.mgrid)

--Nth max salary
select * from emp e1 where (N-1)=(select count(distinct e2.salary) from emp e2
where e2.salary>e1.salary)

View State for TextBoxes, CheckBoxes, DropDownLists

There is a common misunderstanding among developers that view state is somehow responsible for having TextBoxes, CheckBoxes, DropDownLists, and other Web controls remember their values across postback. I was one of them.

This is not the case, because the values are identified via posted back form field values, and assigned in the LoadPostData() method for those controls that implement IPostBackDataHandler.

In the page lifecycle, LoadPostBackData happens after LoadViewState stage. They are independent. The value of a textbox is restored in LoadPostBackData stage. If the view state for this textbox is enabled, then what happens in LoadViewState? Yes, the textbox could got a value, but that could be the wrong one, because the information in the view state represents the state before submission. For example, if the textbox’s value is “Hello my world” before you take any action to the page; at this moment, in the viewstate, it is “Hello my world”. Then from the browser, you change it to “Hello your world”, and submit the page. A new trip of the page life cycle happens. As we have known now, LoadViewState happens before LoadPostBackData. Guess what is the textbox’s value in the LoadViewState stage gotten from view state? It is “Hello my world” rather than “Hello your world”. Fortunately, LoadViewState follows, so that you can get the correct “Hello your world”. Untill the moment before the control is rendered, the viewstate is updated to “Hello your world”. Have you seen enabling the ViewState for such a control only wastes the resource if your application cares performance a lot?

Here we only talk about changing the value for this textbox. If we need to change it’s BackColor, for example, then viewstate is useful; or use other method to remember the changed BackColor if ViewState is not enabled.

Here is the list of controls which could be form fields meanwhile implement IpostBackDataHandler. CheckBox, DropDownList, ImageButton, ListBox, RadioButton, TextBox.

SQL Table Caching

Step 1:

Enabling the Database and Table

aspnet_regsql.exe -S "192.168.0.181" -U sa -P sa123 -d DMS -ed

aspnet_regsql.exe -S "192.168.0.181" -U sa -P sa123 - d DMS -t Userlogin -et

Step 2:

< connectionStrings >

< add name="GetitDMConnectionString2" connectionString="Data Source=192.168.0.181;Initial Catalog=DMS;Persist Security Info=True;User ID=sa;Password=sa123;Connect Timeout=900; pooling='true';Max Pool Size=200" providerName="System.Data.SqlClient"/>

< /connectionStrings >

< system.web >

< caching >

< sqlCacheDependency enabled="true" >

< databases >

<add name="DMS" connectionStringName="GetitDMConnectionString2" pollTime="500" />

< /databases >

< /sqlCacheDependency >

< /caching >

Step 3:

using System.Data.SqlClient;

using System.Web.Caching;

DataSet mycustomers;

mycustomers = (DataSet)Cache["firmCustomers"];

if (mycustomers == null)

{

SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["GetitDMConnectionString2"].ConnectionString);

SqlDataAdapter da = new SqlDataAdapter("Select * from userlogin", conn);

mycustomers = new DataSet();

da.Fill(mycustomers);

SqlCacheDependency myDependency = new SqlCacheDependency("DMS", "userlogin");

Cache.Insert("firmCustomers", mycustomers, myDependency);

Label1.Text = "Producing From database";

}

else

{

Label1.Text = "Produced From Cache";

}

GridView1.DataSource = mycustomers;

GridView1.DataBind();