troubleshooting Question

For Ken Haley

Avatar of rmmarsh
rmmarshFlag for United States of America asked on
C#
5 Comments1 Solution247 ViewsLast Modified:
Continuation from last post:  C# code used to build the query...

            string selectString = "select COUNT(*) from tBooks where DateU > '" + lastExport.ToString("dd MMM yyyy") + "'";
            traceSource.TraceInformation("selectString: " + selectString);
            traceSource.Flush();

            SqlDataReader rdr = null;
            if (bookConn.State == ConnectionState.Closed)
                bookConn.Open();

            SqlCommand cmd = new SqlCommand(selectString, bookConn);
            rdr = cmd.ExecuteReader();
            rdr.Read();

            lBooksWaiting.Text = rdr[0] + " books waiting to be exported";  //  on import/export tab
            lBooksWaiting.Refresh();

            rdr.Close();


Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 5 Comments.
Join the Community
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 1 Answer and 5 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