Click here to Skip to main content
15,886,864 members
Home / Discussions / ASP.NET
   

ASP.NET

 
GeneralRe: Refresh button resubmitting data - How to prevent this? Pin
saanj18-Mar-10 23:36
saanj18-Mar-10 23:36 
AnswerRe: Refresh button resubmitting data - How to prevent this? Pin
Arun Jacob18-Mar-10 23:50
Arun Jacob18-Mar-10 23:50 
QuestionPerformance: Many small file downloads Pin
Pavolh18-Mar-10 1:42
Pavolh18-Mar-10 1:42 
AnswerRe: Performance: Many small file downloads Pin
Aman Bhullar18-Mar-10 2:04
Aman Bhullar18-Mar-10 2:04 
AnswerRe: Performance: Many small file downloads Pin
R. Giskard Reventlov18-Mar-10 2:19
R. Giskard Reventlov18-Mar-10 2:19 
GeneralRe: Performance: Many small file downloads Pin
Pavolh18-Mar-10 3:33
Pavolh18-Mar-10 3:33 
QuestionTypical String Manipulation [modified] Pin
Satish - Developer17-Mar-10 23:40
Satish - Developer17-Mar-10 23:40 
AnswerRe: Typical String Manipulation Pin
Sneha Bisht18-Mar-10 0:54
Sneha Bisht18-Mar-10 0:54 
First create function in database(for split these val;ues)


CREATE FUNCTION [dbo].[Split](@String varchar(8000), @Delimiter char(1))
returns @temptable TABLE (i int identity(1,1), items varchar(8000))
as
begin
declare @idx int
declare @slice varchar(8000)

select @idx = 1
if len(@String)<1 or @String is null return

while @idx!= 0
begin
set @idx = charindex(@Delimiter,@String)
if @idx!=0
set @slice = left(@String,@idx - 1)
else
set @slice = @String

if(len(@slice)>0)
insert into @temptable(Items) values(@slice)
set @String = right(@String,len(@String) - @idx)
if len(@String) = 0 break
end
return

after that create sp(that should be like that )
create storedprocedure [dbo].[sp_notINMain]

@_mainstr navrchar(1000),
@_substr nvarchra(1000)
begin
as

select a.items , b.items from dbo.split(@_mainstr,',') a inner join
dbo.split(@_substr,',') b on a.i = b.i where a.items not in(b.items) order by a.i asc


end


Try This may HELP......
GeneralRe: Typical String Manipulation Pin
Satish - Developer18-Mar-10 2:22
Satish - Developer18-Mar-10 2:22 
GeneralRe: Typical String Manipulation Pin
Not Active18-Mar-10 2:36
mentorNot Active18-Mar-10 2:36 
AnswerRe: Typical String Manipulation Pin
JHizzle18-Mar-10 1:45
JHizzle18-Mar-10 1:45 
GeneralRe: Typical String Manipulation Pin
Satish - Developer18-Mar-10 2:07
Satish - Developer18-Mar-10 2:07 
GeneralRe: Typical String Manipulation Pin
JHizzle18-Mar-10 3:53
JHizzle18-Mar-10 3:53 
AnswerRe: Typical String Manipulation Pin
Not Active18-Mar-10 2:46
mentorNot Active18-Mar-10 2:46 
GeneralRe: Typical String Manipulation Pin
Satish - Developer18-Mar-10 3:01
Satish - Developer18-Mar-10 3:01 
GeneralRe: Typical String Manipulation Pin
Not Active18-Mar-10 3:04
mentorNot Active18-Mar-10 3:04 
Questionhow to give access permission on menu control based on user type from database using asp.net wit c# Pin
developerit17-Mar-10 22:19
developerit17-Mar-10 22:19 
AnswerRe: how to give access permission on menu control based on user type from database using asp.net wit c# Pin
VinodKumar0117-Mar-10 22:27
VinodKumar0117-Mar-10 22:27 
AnswerRe: how to give access permission on menu control based on user type from database using asp.net wit c# Pin
Paul Unsworth17-Mar-10 22:36
Paul Unsworth17-Mar-10 22:36 
Questionwhat is dll file for scanning the document using twain controlx in asp.net with vb.net [modified] Pin
vbmadhavi17-Mar-10 21:47
vbmadhavi17-Mar-10 21:47 
AnswerRe: what is dll file for scanning the document using twain controlx in asp.net with vb.net Pin
Catherine Sea22-Mar-10 22:08
Catherine Sea22-Mar-10 22:08 
QuestionRegular Expression Pin
rajanandal17-Mar-10 19:59
rajanandal17-Mar-10 19:59 
AnswerRe: Regular Expression Pin
Arun Jacob17-Mar-10 20:41
Arun Jacob17-Mar-10 20:41 
AnswerRe: Regular Expression Pin
carlecomm18-Mar-10 23:45
carlecomm18-Mar-10 23:45 
QuestionDownload Formview/ Gridview as PDF in Asp.net Pin
SamRST17-Mar-10 19:55
SamRST17-Mar-10 19:55 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.