Answer / jitender.chauhan

SQL cache invalidation enables you to make the cache entry
dependent on the database, so the cache entry will only be
cleared when data in the database is changed.

Polling-based Invalidation
This mechanism uses polling to check if a table has been
updated since the page was cached.

SQL Server 2005 Notification-based Cache Invalidation
This mechanism uses the query change notification mechanism
of Sql Server 2005 to detect changes to the results of
queries. Unlike polling based invalidation for Sql Server
7.0 and 2000, notification based invalidation requires much
less setup.

1. Unlike polling based validation, no <sqlCacheDependency>
needs to be registered in your application's configuration.
Furthermore, no special configuration using the
aspnet_regsql.exe tool is needed.

2. A notification based dependency is configured on the
OutputCache directive using the string CommandNotification.
This value indicates to ASP.NET that a notification based
dependency should be created for the page or datasource
control.

3. System.Data.SqlClient.SqlDependency.Start() method must
be called somewhere in the application before the first SQL
query is executed. This method could be placed in
Application_Start() event in global.asax file.

Whenever a command is issued to Sql Server 2005, ASP.NET
and ADO.NET will automatically create a cache dependency
that listens to change notifications sent from the SQL
Server. As data is changed in Sql Server, these
notifications will cause the cached queries to be
invalidated on the web server. The next time a page or
datasource control associated with the dependency is
requested, the page or datasource control will be executed
again as opposed to serving cached information.

Hi this is the coding for adding data in to an xml table i want the coding for update and delete Try Dim emp_xml_doc As New XmlDocument If System.IO.File.Exists(Server.MapPath("emp.xml")) Then emp_xml_doc.Load(Server.MapPath("emp.xml")) Dim myrow_element As XmlElement myrow_element = emp_xml_doc.CreateElement("EmpDetails") Dim str As String str = "<EmpID>" & TxtEmpId.Text & "</EmpID>" & _ "<Empname>" & TxtName.Text & "</Empname>" & _ "<EmpSalary>" & TxtSalary.Text & "</EmpSalary>" myrow_element.InnerXml = str emp_xml_doc.DocumentElement.AppendChild(myrow_element) emp_xml_doc.Save(Server.MapPath("emp.xml")) Response.Write("Record Saved") Dim ds As New DataSet ds.ReadXml(Server.MapPath("emp.xml")) GridView1.DataSource = ds GridView1.DataBind() Else Response.Write("File does not exist.") End If Catch ex As Exception Response.Write(ex.ToString) End Try *********************** this is the xml file <?xml version="1.0" encoding="utf-8" ?> <Employee> <empdetails> <empid>100</empid> <empname>xxx</empname> <empsalary>2000</empsalary> </empdetails> <EmpDetails> <EmpID>yyy</EmpID> <Empname>dddd</Empname> <EmpSalary>77777</EmpSalary> </EmpDetails> <EmpDetails> <EmpID>rrrr</EmpID> <Empname>rrrr</Empname> <EmpSalary>6666</EmpSalary> </EmpDetails> <EmpDetails> <EmpID>qaqa</EmpID> <Empname>sini</Empname> <EmpSalary>50000</EmpSalary> </EmpDetails> <EmpDetails> <EmpID>errrrrrrrr</EmpID> <Empname>rrrrrrrrr</Empname> <EmpSalary>677777</EmpSalary> </EmpDetails> <EmpDetails> <EmpID>rrr</EmpID> <Empname>rrr</Empname> <EmpSalary>33</EmpSalary> </EmpDetails> </Employee>

0 Answers   InfoCom,

---

Advantage of Update Panel over Asp.net 2.0 + C#+ Microsoft Ajax 1.0

1 Answers   InfoSpace,

---

What are the Application_Start and Session_Start subroutines used for?

5 Answers   Siebel Systems,

---

What is the difference between user control an custom control?

0 Answers  

---

What is difference between viewstate and session state in javascript?

0 Answers  

---

---

Explain form level validation and field level validation?

0 Answers  

---

What tags do you need to add within the asp:datagrid tags to bind columns manually? How?

0 Answers  

---

Can you explain the basic use of dataview?

0 Answers  

---

What are the different kinds of assemblies?

0 Answers  

---

What are the security types in ASP/ASP.NET? Different Authentication modes?

0 Answers  

---

what is roles in asp.net

2 Answers  

---

Give a few examples of page life cycle events.

0 Answers   Accenture,

---