Guid Parameter in LINQDataSource

Question

Thanks for your help in advance!!! I've been banging my head on the wall for 2 days trying to figure out what I'm missing.  I've tried many things... these are the latest ideas...

I would like to use a value in a BoundField of a GridView as the parameter for a LINQDataSource which populates another GridView.  The Value in the Parent GridView is a Guid. 

This is my LINQDataSource:

<

 

asp:LinqDataSource ID="LocationLinqDataSource" runat="server" ContextTypeName="SoftwareCustomerDataContext" EnableDelete="True" EnableInsert="True" EnableUpdate="True" OrderBy="LocationName" TableName="Locations" onselecting="LocationLinqDataSource_Selecting" Where="CustomerID = @CustomerID" >
<WhereParameters>
      <asp:ControlParameter ControlID="GridView1" Name="CustomerID" PropertyName="Columns[2]" Type="Object" />
</WhereParameters>
</asp:LinqDataSource>

when I couldn't get the above to work I tried this in the _Selecting event.

 

Parameter whereParam = new Parameter();
whereParam.Name = "customerID";
whereParam.DefaultValue = "00000000-0000-0000-0000-000000000000" ;
whereParam.Type = TypeCode.String;
LocationLinqDataSource.WhereParameters.Add(whereParam);
LocationLinqDataSource.Where = "CustomerID == @customerID";

That didn't work either.... 

Answer 1

Hi,

 

I recommend you post this question at ASP.NET Data Access related forums, http://forums.asp.net/default.aspx/16, for better response. Here are some related articles and threads for your references:
http://www.intrepidstudios.com/blog/2009/7/16/using-guids-in-linqdatasource-controls.aspx
http://forums.asp.net/t/1420239.aspx
http://forums.asp.net/t/1256097.aspx

 

Have a nice day!

 

Best Regards,
Lingzhi Sun

MSDN Subscriber Support in Forum

If you have any feedback on our support, please contact [e-mail]

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.