You should pass your records as table as "sqldbType.structured". and in database procedure handle the table.
in database create a type:
CREATE TYPE LogData AS TABLE(
[Date] [varchar](20) NULL,
[Scbytes] [bigint] NULL,
[CsHost] [varchar](256) NULL
)
then use that type in procedure
[prc_insertlog]
@intClientID INT ,
@tlbLogData LogData READONLY
In aspx page just create a datatable with the fields as in Type. and pass in the procedure.
In sql server, you should create cursor. OPen cursor and fetch the rows one by one. and loop until @@FETCH_STATUS = 0.
Hope your problem will be sorted out :)