Add text N\A on empty gridview cell in jquery

 Add alternate text on empty grid-view cell in jquery

youtube instant using Asp.net

Hi*.*,

I'm grad to announce here that.I created a YouTube instant in just 1.48 hr.i'm soooo happy. for  just  a craze started after my friend told the story abt Feross Aboukhadijeh. my friend prajeesh encouraged me to do it.After finish it passed code to my friends @ night !!!! i'm so carzy @ that moment.On morning i got a call from my friend who working on cyber crime told me don't publish the code !!!!. i got surprise y?. using that logic and alternation of code anyone can steel data from any website with out visiting.after his call i gone through wht he said.i tried. yes i'm able to download all the links in a webpage.(didn't gone through capcha page,will try it).

Then y i announce is, i feel i should announce here.but if ur webpage is entirely scripted like gmail.com and facebook.com. my code has limitation.

DEMO

Download

Stay Tune... Have a nice day... 'N happy Coding :)

Remove Duplicate record from Table

Hi *.*,

create table #tbdemo (

id int identity(1,1),

StrName Nvarchar(50),

StrCity Nvarchar(50)

)

insert into #tbdemo values ('Arun','Kollam')

insert into #tbdemo values('Arun','Kollam')

insert into #tbdemo values('Prajeesh','Kochi')

insert into #tbdemo values('Prajeesh','Kochi')

insert into #tbdemo values('Sibi','Patnapuram')

insert into #tbdemo values('Sibi','Patnapuram')

insert into #tbdemo values('Dasapan','Kozikodi')

insert into #tbdemo values('Dasapan','Kozikodi')

select * from #tbdemo

select MIN(id) as ID from #tbdemo

GROUP BY StrName,StrCity

DELETE FROM #tbdemo

WHERE id NOT IN(select MIN(id) as ID from #tbdemo GROUP BY StrName,StrCity)

If u had any trouble just ask, Happy to help u :)
Stay Tune...
Have a nice day... 'N happy Coding :)