Databases
StackOverflow2013
Postsdbo
POParameter.addwithvalue - ExecuteReader: CommandText property has not been initialized
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POParameter.addwithvalue - ExecuteReader: CommandText property has not been initialized
    primarykey
    data
    text
    <p>I get the error <em>ExecuteReader: CommandText property has not been initialized</em> at the <code>adapter.fill(ds)</code> line. The weird thing is that if I replace <code>@user</code> with an actual string (e.g. 'name') it works perfectly fine, so something seems to be broken in the part that sets the parameter. </p> <p>I've tried to set the string both with and without <code>'</code>'s (i.e. @user/'@user'). I've also tried using both <code>=</code> and <code>like</code>. <code>User.Identity.Name.ToString()</code> has been tested to return the logged in user correctly by setting a textbox to it. </p> <p>Sorry for the non-English database variables and if this question has been answered somewhere. I've almost given up after half a dozen hours of searching, though (maybe I just suck at it).</p> <p>Relevant code:</p> <pre><code>using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Configuration; using System.Data; using System.Data.SqlClient; public partial class Bruker : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { String conn = ConfigurationManager.ConnectionStrings["LocalSqlServer"].ConnectionString; SqlConnection sql = new SqlConnection(conn); sql.Open(); SqlCommand command = new SqlCommand(conn); command.CommandText = "SELECT klubb.KlubbNavn FROM Klubber klubb inner join User_Klubber_Connection conn on Klubb.Klubb_Id = conn.Klubb_Id inner join aspnet_Users bruker on bruker.UserId = conn.UserId WHERE bruker.UserName = @user"; command.Parameters.AddWithValue("@user", User.Identity.Name.ToString()); command.Connection = sql; SetDropDownList(command); DropDownList1.SelectedIndex = 0; ChangeGridView(GetMembersOfClub(), sql); sql.Close(); } protected void SetDropDownList(SqlCommand command) { SqlDataAdapter adapter = new SqlDataAdapter(command); SqlCommandBuilder builder = new SqlCommandBuilder(adapter); DataSet ds = new DataSet(); adapter.Fill(ds); DropDownList1.DataSource = ds; DropDownList1.DataTextField = "KlubbNavn"; DropDownList1.DataBind(); } } </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USIan R. O'Brien
    1. USuser1339253
    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
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POParameter.addwithvalue - ExecuteReader: CommandText property has not been initialized
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POParameter.addwithvalue - ExecuteReader: CommandText property has not been initialized
      1. USKhadim Ali
      1. VTFavorite
    3. VO
      singulars
      1. POParameter.addwithvalue - ExecuteReader: CommandText property has not been initialized
      1. This table or related slice is empty.
      1. VTUpMod
    1. This table or related slice is empty.
 

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