How to send datatable as a parameter to mysql store procedure through asp.net code

Question

How to send datatable as a parameter to mysql store procedure through asp.net code. if any solution is there, can anyone please tell me. Its urgent

thank you,

score 0 · Answer 1 · edited May 23 '17 at 11:50

0

You could write it to a .csv and use LOAD DATA INFILE
- LOAD DATA INFILE Syntax

Else you you have to loop through the datatable and insert one by one row.

References

edited May 23 '17 at 11:50

Community

answered Apr 17 '13 at 05:35

शेखर

hi, can we send datatable as a parameter to mysql storeprocedure.if possible can you please tell me how to do this. – siva Apr 17 '13 at 08:59
No it can't be done in `mysql`. It is possible in `sql-server`. – शेखर Apr 17 '13 at 09:17

score 0 · Answer 2 · edited May 23 '17 at 11:57

0

I would parse the data set and for each data row call a stored procedure passing parameters for one data row. If you don't want that, then there are other import facilities (bulk import) like http://brockangelo.com/2009/04/27/how-to-bulk-import-into-a-mysql-database or MySQL bulk insert from CSV data files.

edited May 23 '17 at 11:57

Community

answered Apr 17 '13 at 05:35

L-Four

hi, can we send datatable as a parameter to mysql storeprocedure, if possible can you please tell me how to do this – siva Apr 17 '13 at 09:00

2 Answers2