xoitsmebaby
New Member
I have 3 textboxes-Name,FromDate and StartDate.When i enter name in 1st textbox and click button,it should display record cooresponding to that record.If i enter from date and to Date ,it should display record having Date of Birth within that range of entered value.Name searching is working.But Search based on Date is not working..I want code in asp.net.Pls Help...\[code\]ALTER PROCEDURE [dbo].[usp_GetSearchResume] @Name varchar(50)='' ,@FromDate varchar(15)='', @ToDate varchar (15)='' AS BEGIN DECLARE @SQL AS VARCHAR(8000) SET @SQL = 'SELECT Name,Address,Gender,Marital_Status,Email_Id,Country,State,District,Current_Salary,Total_Salary,Experience,Current_Position, convert(varchar(15),DOB,101) as DOB from Resume'if(@Name <> '') BEGIN SET @SQL = @SQL + ' where Name like ''%'+ @Name + '%''' END IF(@FromDate<>'' and @ToDate<>'' ) begin set @SQL=@SQL+'or DOB between '''+ CONVERT(varchar(12),@FromDate,101) +''' and ''+ CONVERT(varchar(12),@ToDate,101) +''' ' End print @SQL --select (@SQL) exec (@SQL) END \[/code\]If i dont enter name and i enter from date and to date,it should display record based on that dates...Pls help