Get all rows for paticular column in one column.

For getting records returned by a sql query in one column  comma seperated we can use 

SELECT GROUP_CONCAT(columnname) AS columnname FROM tablename WHERE condition .

This query will return all query results for paticular column in one column comma seperated.

Use Mysql stored procedure in Vb.net

To use mysql stored procedure in vb.net we have to create command object and pass it text as call sp_name


            Dim cmd As New OdbcCommand()
            cmd.Connection = myConnection
            cmd.CommandText = " CALL getcatid(?)"
            cmd.CommandType = CommandType.StoredProcedure

            cmd.Parameters.AddWithValue("@catname1", "Kitchen")
            cmd.Parameters("@catname1").Direction = ParameterDirection.Input