troubleshooting Question

sqlite c# datareader

Avatar of murfinp
murfinp asked on
7 Comments2 Solutions1297 ViewsLast Modified:

I have the following code

                tickDB = new SQLiteConnection("Data Source =" + @txbData.Text);
                tickCommand = new SQLiteCommand();
                tickCommand.Connection = tickDB;
                tickCommand.CommandText = "SELECT DATE,TIME,LAST,BID,ASK FROM TICKS;";

                tickReader = tickCommand.ExecuteReader();

                    while (tickReader.Read())
                        string aaa = tickReader.GetString(0);
                        string bbb = tickReader.GetString(1);

it seems to be reading fine ... loops through fine but in the debugger when i try and look at string aaa or string bbb it says not in the current conext? Am I going crazy?

Alexandre Simões
Software Architect

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 2 Answers and 7 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 7 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros