使用存储过程填充tableadapter比在SQL中运行存储过程要长得多

I have been trying to fill my ultracombo box with data yet it takes a signifigant amount of time. However when I run the same stored procedure from withing sql server it takes relatively no time. The line of code that the program gets hung up on is:I have been trying to fill my ultracombo box wi