Count with xpath

( count(/*/Node[text() = 'Yes']) +
count(/*/Nod2[text() = 'No']) ) > 0
http://www.xmltools.dk/

Left outer join in Linq C#

Left join Linq

from a in aa
join a in xx on a.d equals x.y into DefaultOrEmptyXDetails
from a in DefaultOrEmptyXDetails.DefaultIfEmpty()
select new a)

Updating multiple rows from trigger byy inserted table

Hi All
Many times we are facing that we need to change the value of Column1 of Table2 when Table1 updates.

This below is given solution by- Nipam Budhabhatti
So we need trigger.
We can either select value in some variable.
but it has problem that we cannt update all rows.
so this is the solution
by implementing it we are sure that all records in Table2 are updated after updating table1.

CREATE TRIGGER [TrgName] ON Table1
FOR UPDATE
AS
UPDATE Table2
SET
Column1 = INSERTED.Column2
FROM INSERTED
WHERE
Column3 = Column4


Nipam Budhabhatti

textbox default button

javascript:



function clickButton(e, buttonid){

var evt = e ? e : window.event;

var bt = document.getElementById(buttonid);

if (bt){

if (evt.keyCode == 13){

bt.click();

return false;

}

}

}



TextBox1.Attributes.Add("onkeypress", "return clickButton(event,'" + Button1.ClientID + "')");

Explicit implement interfacess

Hi All

when we are explicitly implementing interface like..
if we have 2 interfaces which has same method; one class implements both,
then in derivced class we can not use public as access modifier to those implemented methods.

2 solve this i think we can create one wrapper method.
that method checks the type od object and according to type it will execute the method from those implemented.

I think this will help us to understand the working of interface little more.