sql query

Question

Hi alli hav a textbox control which is a search field and lets say ex:abc123456787 i will pass value FCI based on partial search i want to display records in grid and also if i pass values like ex:absc4696489piok8756592 i need to fetch data from database how to acheive this either in db2/sql server.Thanks

Amit Singh · Answer

--Employee_proc 0'A''''''''S' ALTER PROCEDURE [dbo].[Employee_proc] ( @Id INT @NAME VARCHAR(50) @GENDER VARCHAR(50) @SALARY VARCHAR(50) @COUNTRY VARCHAR(50) @Opt varchar(5) ) AS BEGIN BEGIN TRY IF(@Opt='S') BEGIN SELECT NAME FROM Employee WHERE NAME like @NAME + '%' END IF(@Opt='S1') BEGIN SELECT * FROM Employee END END TRY BEGIN CATCH DECLARE @ErrorMSG NVARCHAR(4000) @ErrorSeverity VARCHAR(10) @ErrorState VARCHAR(10) @ErrorProcedure NVARCHAR(200) SET @ErrorMSG = ERROR_MESSAGE() SET @ErrorSeverity = ERROR_SEVERITY() SET @ErrorState = ERROR_STATE() SET @ErrorProcedure = ERROR_PROCEDURE() RAISERROR(@ErrorMSG @ErrorSeverity @ErrorState @ErrorProcedure) END CATCH END

Shubham Kumar · Answer

Hi Follow this link it may help you: http://www.aspsnippets.com/Articles/Search-records-in-GridView-and-highlight-results-in-ASPNet-using-C-and-VBNet.aspx http://www.c-sharpcorner.com/UploadFile/0c1bb2/searching-records-from-database-and-display-in-gridview-usin/ http://www.aspdotnet-suresh.com/2011/12/search-records-in-gridview-and.html