locked
c# and mysql problem RRS feed

  • Question

  • User1439632775 posted

    hi everybody

    i have a problem that my this query i execute in workbench. the query successfully execute in workbench, i can't run in soruce code in c#. please help me how execute and fill adapter in c#

    this query is:

    SELECT  CONCAT(REPEAT('-----', level - 1), CAST(hi.userid AS CHAR)) AS userid, parentuserid, level
    FROM    (
            SELECT  shema.hierarchy(userid) AS userid, @level AS level
            FROM    (
                    SELECT  @start_with := '10000000',
                            @userid := @start_with,
                            @level := 0
                    ) vars, shema.users
            WHERE   @userid IS NOT NULL
            ) ho
    JOIN    shema.users hi
    ON      hi.userid = ho.userid

    Tuesday, July 16, 2013 3:37 PM

All replies

  • User269602965 posted

    show your C# code to make the connection and pass the SQL query

    Tuesday, July 16, 2013 9:05 PM