Executes a select statement or stored procedure and reads the first row of the returned record set
Declaration Syntax| C# | Visual Basic |
public bool ExecuteSingletonQuery( string Sql, IDictionary Params )
Public Function ExecuteSingletonQuery ( _ Sql As String, _ Params As IDictionary _ ) As Boolean
Parameters- Sql (String)
-
The SQL statement
- Params (IDictionary)
-
Parameter values collection
Return Value
Returns True if a record is found otherwise False
Examples
CopyC#DbNetData Data = new DbNetData( ConfigurationSettings.AppSettings[ "nwind" ] ); Data.Open(); ListDictionary Params = new ListDictionary(); CmdConfig.Params["id"] = ProductID.Value; if ( Data.ExecuteSingletonQuery("select productname from products", Params) ) ProductName.Text = Data.ReaderValue("productname"); Data.Close();