In the first part of the code I obtain the Customer_ID (an integer) via a query. I then use that value to populate a textbox, but much more importantly I would like to limit the GridView results on the page by taking that value and assigning it to @theCustomer in my Selectcommand statement
var query = from Customer in db.Customers
where Customer.UserName == Profile.UserName
select Customer.Customer_ID;
//Now we have found the Customer_ID value based upon the Profile.UserName
//Convert that value to string
//Create a TextBox (CustomerID) based upon TextBox1 (Customer_ID) to show the Customer_ID value in the DetailsView
// and limit the results (GridView) to the logged in Customer_ID value
foreach (var result in query)
{
value = result.ToString();
theCustomer = Convert.ToInt32(value);
TextBox CustomerID = ((TextBox)DetailsView1.FindControl("TextBox1"));
CustomerID.Text = value;
e.Command.Parameters["@theCustomer"].Value = theCustomer;
}//end foreach
In the SqlDataSource SelectCommand I have a reference to @theCustomer in my WHERE filter and then call the method SqlDataSource1_Seclecting which is where the above code resides.
SelectCommand="SELECT [Customer_ID], [Player_ID], [Player_Name], [Handicap] FROM [Player] WHERE ([Customer_ID] = @theCustomer)" onselecting="SqlDataSource1_Selecting">
<SelectParameters>
<asp:Parameter Name="Customer_ID" Type="Int32" />
</SelectParameters>
My error message is the following:
An SqlParameter with ParameterName '@theCustomer' is not contained by this SqlParameterCollection.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.IndexOutOfRangeException: An SqlParameter with ParameterName '@theCustomer' is not contained by this SqlParameterCollection
Just wondering if you see anything obvious, my code seems to follow examples that I have googled?
Thanks again as this is the key to my "show"
Cliff
button below this post to show your appreciation!
