Retrieving a single value/result from a database with ASP.NET (C#)
string strConn = @"PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=d:\test.mdb;";
string strSQL = "SELECT COUNT(*) FROM persons WHERE uID < 100";
OleDbConnection objConnection = new OleDbConnection(strConn);
OleDbCommand objCommand = new OleDbCommand(strSQL,objConnection);
objCommand.Connection.Open();
Response.Write(objCommand.ExecuteScalar().ToString());
objConnection.Close();
string strSQL = "SELECT COUNT(*) FROM persons WHERE uID < 100";
OleDbConnection objConnection = new OleDbConnection(strConn);
OleDbCommand objCommand = new OleDbCommand(strSQL,objConnection);
objCommand.Connection.Open();
Response.Write(objCommand.ExecuteScalar().ToString());
objConnection.Close();