ASP.NET

Member 7767311 wrote:

develop a facility for image album on my website

var s = String.fromCharCode(e.which);
 if ( s.toUpperCase() === s && s.toLowerCase() !== s && !e.shiftKey ) {
    alert('caps is on');
}

alter procedure mdi_anu  
(  
@entry_date varchar(20),  
@updated_date varchar(20),  
@status varchar(20),  
@cno varchar(20),  
@eno varchar(20)
)  
  
as 
begin
declare @SQL varchar(max)  
set @SQL='SELECT * FROM anu123 where 1=1 '  
  
	--if (@status='ALL')  
	--	begin  
	--	set @status='ALL'  
	--	set @SQL=@SQL + 'and status=''' +@status
	--end  
  
	if (@status='A')  
		begin  
		set @status='A'  
		--set @SQL=@SQL+' and status='''+@status
	end  
  
	if (@status='R')  
		begin  
		set @status='R'  
		set @SQL=@SQL+' and status=''' +@status
	end  
  
	if (@status='D')  
		begin  
		set @status='D'  
		set @SQL=@SQL+' and status=''' +@status
	end  
  
	if (@status='P')  
		begin  
		set @status='P'  
		set @SQL=@SQL+' and status=''' +@status
	end 
	
	
	 
	if (@entry_date<>'' and @updated_date<>'')  
	begin  
   
	set @entry_date =CONVERT (datetime, @entry_date, 103)        
	set @updated_date= CONVERT(datetime, @updated_date, 103)  
	set @SQL=@SQL+'and entry_date>=''' +@entry_date+'''and updated_date<='''+@updated_date+''''  
	end
  
	if (@cno<>'')  
	begin  
	set @cno=@cno  
	set @SQL=@SQL+'and cno=''' +@cno+
	end  

  
	if (@eno<>'')  
	begin  
	set @eno=@eno  
	set @SQL=@SQL+'and eno=''' +@eno+
	end 

exec (@SQL)

end

Jassim Rahma wrote:

/member_id/images

Jassim Rahma wrote:

ExecuteNonReader

Jassim Rahma wrote:

ExecuteScalar