How to retrive the procedure return value in vb.net?

Thirupathi v

18y8.9kLearn iOS Programming

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)

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

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Thirupathi v18y ago
Thanks for ur reply. i ill try it and get back to u.
Anand Thakur18y ago
Use ParameterDirection.Output in command

conn.Open();
EDBCommand command = new EDBCommand("DEPT_SELECT
(:pDEPTNO,:pDNAME,:pLOC)", conn);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add(new EDBParameter("pDEPTNO",
EDBTypes.EDBDbType.Integer,10,"pDEPTNO",
ParameterDirection.Input,false ,2,2,
System.Data.DataRowVersion.Current,1));
command.Parameters.Add(new EDBParameter("pDNAME",
EDBTypes.EDBDbType.Varchar,10,"pDNAME",
ParameterDirection.Output,false ,2,2,
System.Data.DataRowVersion.Current,1));
command.Parameters.Add(new EDBParameter("pLOC",
EDBTypes.EDBDbType.Varchar,10,"pLOC",
ParameterDirection.Output,false ,2,2,
System.Data.DataRowVersion.Current,1));
command.Prepare();
command.Parameters[0].Value = 10;
EDBDataReader result = command.ExecuteReader();
int fc=result.FieldCount;

while(result.Read())
{
for(int i=0;i {
Response.Write("RESULT["+i+"]="+ Convert.ToString
(command.Parameters[i].Value));
Response.Write("
");
}

}