Executes the query, and returns the first column of the first row in the result set returned by the query. Extra columns or rows are ignored.

Overload List

Executes the query, and returns the first column of the first row in the result set returned by the query. Extra columns or rows are ignored.

[Visual Basic] Shared  OverloadsPublic Function ExecuteScalar(ByVal SqlConnection,ByVal String) As Object

[C#] public static object ExecuteScalar(SqlConnection,string);

[C++] public: static Object* ExecuteScalar(SqlConnection*,String*);

[JScript] public static function ExecuteScalar(SqlConnection,String): Object;

Executes the query, and returns the first column of the first row in the result set returned by the query. Extra columns or rows are ignored.

[Visual Basic] Shared  OverloadsPublic Function ExecuteScalar(ByVal SqlConnection,ByVal String,ByVal CommandType) As Object

[C#] public static object ExecuteScalar(SqlConnection,string,CommandType);

[C++] public: static Object* ExecuteScalar(SqlConnection*,String*,CommandType);

[JScript] public static function ExecuteScalar(SqlConnection,String,CommandType): Object;

Executes the query, and returns the first column of the first row in the result set returned by the query. Extra columns or rows are ignored.

[Visual Basic] Shared  OverloadsPublic Function ExecuteScalar(ByVal SqlConnection,ByVal String,ByVal CommandType,ByVal ParamArray SqlParameter()) As Object

[C#] public static object ExecuteScalar(SqlConnection,string,CommandType,params SqlParameter[]);

[C++] public: static Object* ExecuteScalar(SqlConnection*,String*,CommandType,SqlParameter* __gc[]);

[JScript] public static function ExecuteScalar(SqlConnection,String,CommandType,SqlParameter[]): Object;

Executes the query, and returns the first column of the first row in the result set returned by the query. Extra columns or rows are ignored.

[Visual Basic] Shared  OverloadsPublic Function ExecuteScalar(ByVal SqlConnection,ByVal String,ByVal ParamArray SqlParameter()) As Object

[C#] public static object ExecuteScalar(SqlConnection,string,params SqlParameter[]);

[C++] public: static Object* ExecuteScalar(SqlConnection*,String*,SqlParameter* __gc[]);

[JScript] public static function ExecuteScalar(SqlConnection,String,SqlParameter[]): Object;

Executes the query, and returns the first column of the first row in the result set returned by the query. Extra columns or rows are ignored.

[Visual Basic] Shared  OverloadsPublic Function ExecuteScalar(ByVal SqlConnection,ByVal String,ByVal String) As Object

[C#] public static object ExecuteScalar(SqlConnection,string,string);

[C++] public: static Object* ExecuteScalar(SqlConnection*,String*,String*);

[JScript] public static function ExecuteScalar(SqlConnection,String,String): Object;

Executes the query, and returns the first column of the first row in the result set returned by the query. Extra columns or rows are ignored.

[Visual Basic] Shared  OverloadsPublic Function ExecuteScalar(ByVal SqlConnection,ByVal String,ByVal String,ByVal CommandType) As Object

[C#] public static object ExecuteScalar(SqlConnection,string,string,CommandType);

[C++] public: static Object* ExecuteScalar(SqlConnection*,String*,String*,CommandType);

[JScript] public static function ExecuteScalar(SqlConnection,String,String,CommandType): Object;

Executes the query, and returns the first column of the first row in the result set returned by the query. Extra columns or rows are ignored.

[Visual Basic] Shared  OverloadsPublic Function ExecuteScalar(ByVal SqlConnection,ByVal String,ByVal String,ByVal CommandType,ByVal ParamArray SqlParameter()) As Object

[C#] public static object ExecuteScalar(SqlConnection,string,string,CommandType,params SqlParameter[]);

[C++] public: static Object* ExecuteScalar(SqlConnection*,String*,String*,CommandType,SqlParameter* __gc[]);

[JScript] public static function ExecuteScalar(SqlConnection,String,String,CommandType,SqlParameter[]): Object;

Executes the query, and returns the first column of the first row in the result set returned by the query. Extra columns or rows are ignored.

[Visual Basic] Shared  OverloadsPublic Function ExecuteScalar(ByVal SqlConnection,ByVal String,ByVal String,ByVal ParamArray SqlParameter()) As Object

[C#] public static object ExecuteScalar(SqlConnection,string,string,params SqlParameter[]);

[C++] public: static Object* ExecuteScalar(SqlConnection*,String*,String*,SqlParameter* __gc[]);

[JScript] public static function ExecuteScalar(SqlConnection,String,String,SqlParameter[]): Object;

Executes the query, and returns the first column of the first row in the result set returned by the query. Extra columns or rows are ignored.

[Visual Basic] Shared  OverloadsPublic Function ExecuteScalar(ByVal String) As Object

[C#] public static object ExecuteScalar(string);

[C++] public: static Object* ExecuteScalar(String*);

[JScript] public static function ExecuteScalar(String): Object;

Executes the query, and returns the first column of the first row in the result set returned by the query. Extra columns or rows are ignored.

[Visual Basic] Shared  OverloadsPublic Function ExecuteScalar(ByVal String,ByVal CommandType) As Object

[C#] public static object ExecuteScalar(string,CommandType);

[C++] public: static Object* ExecuteScalar(String*,CommandType);

[JScript] public static function ExecuteScalar(String,CommandType): Object;

Executes the query, and returns the first column of the first row in the result set returned by the query. Extra columns or rows are ignored.

[Visual Basic] Shared  OverloadsPublic Function ExecuteScalar(ByVal String,ByVal CommandType,ByVal ParamArray SqlParameter()) As Object

[C#] public static object ExecuteScalar(string,CommandType,params SqlParameter[]);

[C++] public: static Object* ExecuteScalar(String*,CommandType,SqlParameter* __gc[]);

[JScript] public static function ExecuteScalar(String,CommandType,SqlParameter[]): Object;

Executes the query, and returns the first column of the first row in the result set returned by the query. Extra columns or rows are ignored.

[Visual Basic] Shared  OverloadsPublic Function ExecuteScalar(ByVal String,ByVal ParamArray SqlParameter()) As Object

[C#] public static object ExecuteScalar(string,params SqlParameter[]);

[C++] public: static Object* ExecuteScalar(String*,SqlParameter* __gc[]);

[JScript] public static function ExecuteScalar(String,SqlParameter[]): Object;

Executes the query, and returns the first column of the first row in the result set returned by the query. Extra columns or rows are ignored.

[Visual Basic] Shared  OverloadsPublic Function ExecuteScalar(ByVal String,ByVal String) As Object

[C#] public static object ExecuteScalar(string,string);

[C++] public: static Object* ExecuteScalar(String*,String*);

[JScript] public static function ExecuteScalar(String,String): Object;

Executes the query, and returns the first column of the first row in the result set returned by the query. Extra columns or rows are ignored.

[Visual Basic] Shared  OverloadsPublic Function ExecuteScalar(ByVal String,ByVal String,ByVal CommandType) As Object

[C#] public static object ExecuteScalar(string,string,CommandType);

[C++] public: static Object* ExecuteScalar(String*,String*,CommandType);

[JScript] public static function ExecuteScalar(String,String,CommandType): Object;

Executes the query, and returns the first column of the first row in the result set returned by the query. Extra columns or rows are ignored.

[Visual Basic] Shared  OverloadsPublic Function ExecuteScalar(ByVal String,ByVal String,ByVal CommandType,ByVal ParamArray SqlParameter()) As Object

[C#] public static object ExecuteScalar(string,string,CommandType,params SqlParameter[]);

[C++] public: static Object* ExecuteScalar(String*,String*,CommandType,SqlParameter* __gc[]);

[JScript] public static function ExecuteScalar(String,String,CommandType,SqlParameter[]): Object;

Executes the query, and returns the first column of the first row in the result set returned by the query. Extra columns or rows are ignored.

[Visual Basic] Shared  OverloadsPublic Function ExecuteScalar(ByVal String,ByVal String,ByVal ParamArray SqlParameter()) As Object

[C#] public static object ExecuteScalar(string,string,params SqlParameter[]);

[C++] public: static Object* ExecuteScalar(String*,String*,SqlParameter* __gc[]);

[JScript] public static function ExecuteScalar(String,String,SqlParameter[]): Object;

See Also

DatabaseUtility Class | Joel.Net Namespace