Hi I am Thiru. i am try to create the small search engine. i can retirve all the values using the below queries.
-----------------------------
create procedure FindtestThree
@Name varchar(25),
@Location
varchar(25),
@EmpId
varchar(25)
as
select
* from TbInfo where Name like + '%' + @Name + '%'
select
* from TbInfo where Location like + '%' + @Location + '%'
select
* from hi where ComName like + '%' + @EmpId + '%'
Exec
FindtestThree 'aa','a','d'
---------------------------------------
The above Procedure will return the three table values. i need to retrive all the values in vb.net by using Dot Net application.
i can retrive the single table values by using Sqlcommand object. and other two table value should get it for me. how can i achieve this goal? is there any ideas? please give me suggestion for it