Click here to Skip to main content
11,640,907 members (69,195 online)

Comments by db_developer (Top 2 by date)

db_developer at 27-Jun-13 5:01am View
   
thanks for reference about optimization
db_developer at 24-Jun-13 19:26pm View
   
I agree with answer and want to add:

your query can return more than 1 row and will return 2 columns, therefore ExecuteScalar() is not acceptable.
Use ExecuteReader() and Reader.ReadLine then.
or
edit procedure query using SELECT TOP 1 AdminName at beginning.

Advertise | Privacy | Mobile
Web04 | 2.8.150731.1 | Last Updated 1 Jan 1900
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid