Databases
StackOverflow2013
Postsdbo
POAdo.net data provider is throwing an error when I try to return a command from a method
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POAdo.net data provider is throwing an error when I try to return a command from a method
    primarykey
    data
    text
    <p>I'm sorry for the bad title, not certain how to describe the issue completely. </p> <p>I'm using SQLBase NET data provider.</p> <p>When I attempt to create a command and add parameters, it is throwing an exception</p> <blockquote> <p><em>Object not set to instance of an object</em> </p> </blockquote> <p>However, when I create a command outside of my object, I can add parameters with no issues.</p> <p><code>SQLBaseDatabase</code> class is a wrapper I wrote that will basically return a connection and create a command.</p> <pre><code>var db = new SQLBaseDatabase(ConfigurationManager.ConnectionStrings["UDSConnectionString"].ConnectionString); </code></pre> <p>This code works: I created this code in my <code>HomeController</code> as a test. I can add parameters with no problem.</p> <pre><code>var command = new SQLBaseCommand(); command.Connection = db.GetConnection() as SQLBaseConnection; command.Parameters.Add(db.GetParameter(":1", "1234", DbType.String)); </code></pre> <p>This code fails:</p> <pre><code>var parameters = new List&lt;IDataParameter&gt;(); parameters.Add(db.GetParameter(":1", "1234", DbType.String)); var cmd = db.GetCommand(db.GetConnection(), "Select * From DX_CODES Where (DX = :1)", parameters); </code></pre> <p>When I try to add parameters in this method via the passed in parameters, it throws the object not set error.</p> <pre><code>public IDbCommand GetCommand(IDbConnection connection, string sql, IEnumerable&lt;IDataParameter&gt; parameters) { var command = new SQLBaseCommand(connection as SQLBaseConnection); foreach (var parameter in parameters) command.Parameters.Add(parameter); // This throws an error. Command.Parameters is read only. command.CommandText = sql; return command; } </code></pre> <p>The command parameters is read only</p> <p>Here is my method that creates the parameter</p> <pre><code> public IDbDataParameter GetParameter(string name, object value, DbType type) { return new SQLBaseParameter(name, type, value); } </code></pre> <p>I'm not sure if I'm fundamentally doing some wrong in c# that could be causing this error. Or how I can fix it considering it works in one case, but not the other.</p> <p>** Update ** Same issue happens with the SqlServer ADO.Provider.</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USsinclairchase
    1. USsinclairchase
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COyou are passing / referencing the Params incorrectly.. use "{0}",parameters also try to use a better name opposed to using lower case reserved names.. and replace the Parameters.Add() method with Parameters.AddWithValue(@yourParam, yourValue);
      singulars
      1. POAdo.net data provider is throwing an error when I try to return a command from a method
      1. USMethodMan
    2. COCommand.Parameters dot anything is throwing an error because there is no instance. Why is it not creating the instance in my class, but outside my class it works fine.
      singulars
      1. POAdo.net data provider is throwing an error when I try to return a command from a method
      1. USsinclairchase
    3. CO@DJKRAZE that's not the problem. `{0}` is string formatting, this is using parameterized queries. `AddWithValue` is not a member of `IDbCommand` or `SqlBaseCommand`, so that's out too.
      singulars
      1. POAdo.net data provider is throwing an error when I try to return a command from a method
      1. USJason Meckley
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload