selectmethod

JDBC connection to very busy SQL 2000: selectMethod=cursor vs selectMethod=direct?

In the process of trying to help out an app dev team with performance issues on a SQL 2000 server (from a bunch of Java applications on separate app servers), I ran a SQL trace and discovered that all calls to the database are full of API Server Cursor statements (sp_cursorprepexec, sp_cursorfetch, sp_cursorclose). Looks like they're s...

Assign a datasourceid to a datagridview asp.net and add select parameters

Hi, I have a datagridview which I assign an objectdatasource to bind data. My selectmethod has a parameter which is assigned at gridview_databinding. The code does not work as expected, using the debugger, it keeps firing the gridview_databinding event and entering the databind method in what seems like an infinite loop. Please help me f...