results to string array for reference within CLR Proc

Hot Topic

Question about SQL query
Using "in" in a case statement
Undocumented sp supported...
Report Design & Layout
Open Xml
Problem: SSIS, ODBC and Progress Database
2 datasets with same parameters
Required Day as string; Ex: Sunday
Datasource-Microsoft Visual Studio
DataReader output column length

SQL Server

Smorgasboard of Encrpytion questions !
Generating and Printing Reports
Eval between SQL 2000 32bit and SQL 2005 64bit
Few simple (silly) questions on SQL 2005 & CLR integration.
Database.EnumObjectPermissions throws InvalidCastException
Year to date verses Last Year to Date
procedure or function Login has too many arguments specified
Deploying packages with SQL Server based configuration
Parsing CSV name=value pairs into columns
Matrix control

results to string array for reference within CLR Proc

I keep running into a problem with the debugger freezing up. I'm trying to pull results from a query into an array (not more than 10 rows)

cmd.ExecuteReader();

while (rdr.Read() == true) {

letterIdea = rdr[0].ToString();

i += 1;

}

if I comment out the "letterIdea = rdr[0].ToString();" portion of code, the project runs fine. With that code there, I can not step into the proc from the SQL test script. No errors are raised. VS just freezes.



Answer this question

results to string array for reference within CLR Proc

  • Aaron Oneal

    Hi,

    Were you able to resolve this issue I tried this code and i am able to debug this just fine.

    Does the problem occur only during debugging or outside of debugging as well (executing the test script without debugging) Are you able to successfully debug (or just execute) without the assignment statement

    Thanks,

    -Vineet.



  • results to string array for reference within CLR Proc
Answer this question