MYSQL and C#

[LogicalPerson]

Hi Iam new here and to .net.

I have aproblem.Iam trying to run a procedure depending upon results from another query.

Iam using visual studio 2008.Language:C#

back end:mysql 5.0.1

.

my code

:

DataColumnCollection drc = myDataSet.Tables["industry1"].Columns;
       DataRowCollection dra = myDataSet.Tables["industry1"].Rows;
 foreach (DataRow dr in dra)
       {
          
DataColumnCollection drc = myDataSet.Tables["industry1"].Columns;
       DataRowCollection dra = myDataSet.Tables["industry1"].Rows;
           foreach (DataColumn col in drc)
           {
           
             
               //prefereed method
                //Console.WriteLine(dr[col]);
//this method should run a procedure sending P3 which is dr[col]
                  runQuery()
               
              
          }
           Console.WriteLine("--------------------------------");
           //Console.WriteLine(dr[col]);
       }

---------------------------

current output is:

 

4 rows and 3 columns.=12 values

i want that for each value using mysqlcommand

a query should be made to a stored procedure:

sending parameters.

lets say P1,P2,P3.

P1-column name,P2-tablename,P3-value.

I want that P1 and P2 should be taken in from the column index :col[],

and table name using the col[] and like wise index.(iam working on it).

my back end procedure:

[highlight=sql]

DROP PROCEDURE `procGetPoints7`//

CREATE DEFINER=`root`@`localhost` PROCEDURE `procGetPoints7`(IN P1 varchar(3),IN P2 varchar(30),IN P3 int(6),OUT pt int(3))

BEGIN

DECLARE req1 varchar(30);

DECLARE ID varchar(10);

 

SET req1=P2;

SET ID=P1;

SELECT Points INTO pt

FROM req1

WHERE req1.ID = (

SELECT s.ID

FROM standard1 s, tblcandidate c

WHERE s.STID = c.STID

AND s.ID =P3 )

LIMIT 0 , 30 ;

END

[/highlight]

Edited July 31, 2008 by PlausiblyDamp