Click here to Skip to main content
12,697,178 members (25,346 online)

Comments by db_developer (Top 2 by date)

db_developer 27-Jun-13 5:01am View
thanks for reference about optimization
db_developer 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.
edit procedure query using SELECT TOP 1 AdminName at beginning.

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