Click here to Skip to main content
13,152,063 members (37,379 online)
Rate this:
Please Sign up or sign in to vote.
See more:
Hi All,

Please help me.
I need to pass a DataSet in MySQL.

It is feasible in MSSQL since I already tried it.

I do it like this in MSSQL:
In my c# code:
DataSet ds = new DataSet("Uploads");
ds.Tables.Add(new DataTable("exclution"));
SqlCommand oCommand = new SqlCommand("spUpdateDatabase", oConnection);
oCommand.CommandType = CommandType.StoredProcedure;
oCommand.Parameters.AddWithValue("@LocalDatabase", ds.GetXml());

And my stored procedure would be like this:
DECLARE @index int
EXEC sp_xml_preparedocument @index OUTPUT, @LocalDatabase
        INSERT INTO		        exclution
	SELECT			        @BranchCode
				,	ExclutionID
				,	InsuredID
				,	InsuredRelationship
				,	ExclutionDiagnoses
	FROM	OPENXML(@index, 'Uploads/exclution')
	WITH	(	ExclutionID          int         'ExclutionID'
		  ,	InsuredID            int         'InsuredID'
		  ,	InsuredRelationship  varchar(45) 'InsuredRelationship'
		  ,	ExclutionDiagnoses   varchar(100)'ExclutionDiagnoses')
EXEC sp_xml_removedocument @index  
IF (@@ERROR <> 0)

But I cant find a way to do it in MySQL.
Any help would be greatly appreciated.

Thanks in advance.
Posted 15-Aug-11 22:25pm
Updated 18-Aug-11 22:51pm
unknowndentified10111 19-Aug-11 4:51am
No one is answering... :(
Simon_Whale 19-Aug-11 5:14am
For me personally I can't see a way to implement what you are asking for in the same manner as SQL Server does. I think you may have to change your approach. maybe someone else has a different idea for you

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

The MySQL Documentation might be a good place to start

MySQL XML functions[^]
unknowndentified10111 16-Aug-11 5:02am
I already looked into that. But the xml function of MySql can't return a Table Set. It only return a scalar value. What I need is like what I do in my MSSQL stored procedure. But thanks anyways..
Simon_Whale 16-Aug-11 5:08am
dont know if this will help?

as I dont know how big your dataset that you want to pass in, someone here has found a way to pass in a parameter array
unknowndentified10111 16-Aug-11 20:18pm
That would'nt work for me, the parameter array was only always a single dimension array, If I'm going to pass a dataset, I atleast need a two dimension array for rows and columns. Thanks for the reply. But I still need help.....

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy |
Web03 | 2.8.170924.2 | Last Updated 19 Aug 2011
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100