Home > Software engineering >  VB call a stored procedure returns a result set
VB call a stored procedure returns a result set

Time:10-23

VB to call a stored procedure returns a result set problems



Stored procedure 1:

The ALTER proc [dbo] [hg_deviceno_order]

As

Select * from log_device_list
The set @ "reason='query success! '
Return 0



Stored procedure 2:

The ALTER proc [dbo] [hg_deviceno_order]

As

The update log_device_list set a='2' where a='1'

Insert into log_device_list...

Select * from log_device_list
The set @ "reason='query success! '
Return 0



These two stored procedures, using VB to call first, DataGrid1 can display the result set, the second not stored procedure;

If my first displays, VB call statement there is no problem,

Storage process can't be like the first so simple ah,

If the second I want how to modify it, thank you all for the
  • Related