If i am expecting a single row or value what command should i follow ?command.executescalar() or command.executereader(commandbehaviour.singleresult)

single row = executereader
single value = excutescalar. This will return the first column of the first row only so will not be any use for a single row that has more than one column.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.