看看老外都没有解决的问题

[lnwuyaowei]

以下内容来自网址：http://forums.asp.net/959573/ShowPost.aspx
==========================
问题：
==========================
SqlDatasource parameter question
In SqlDataSource you can have several types of in parameters.

Control Parameter
QueryString Parameter
Form Parameter
Session Parameter
Cookie Parameter
Profile Parameter
My problem is I want my SqlDataSource to use the current logged in users Guid as the parameter for my Source.
I have solved this by Creating a Label control and assining the guid to this label and then using the control parameter for my SqlDataSource.
It works but it seems like a very akward way of doing this.

I have googled a couple of days in search for a good solution but I can't find it. Is there any way of using MemberShip.GetUser().ProviderUserKey
as the in parameter for a Datasource
回答：
===================================================================
Re: SqlDatasource parameter question

You can do something like this,

<SelectParameters>
<asp:Paramter Name=userGuid type="string" />
</SelectParameters>

with your sqlDataSource_selecting event
e.Command.Parameters("@userGuid").Value = MemberShip.GetUser().ProviderUserKey

解决：
==============================
Re: SqlDatasource parameter question

Thanks a lot. That worked very good.

Strange there isn't a default guid parameter to datasources as I would guess this is a very common situation.

A user put something into the database and you would like to show this for him next time he is logged in.
=====
但是：
=====
这个解决方法在asp.net2005express英文正式版中并不能用，出错提示如下：
Input string was not in a correct format.
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.FormatException: Input string was not in a correct format.
=====

[studydotnet]

太长了,不想看,不知道发这有什么意思?

[zeusvenus]

这个问题刚用VS.NET 2005 Beta2试了下，没有出现你遇到的错误。
但是关于他说的要将用户登录过后数据源类型存下来，需要扩展membership表。
楼主装SQL SERVER2005 EXPRESS了吗？上面的问题可能是程序没有从你的membership表中取到数据导致的。关于membership的详细介绍，可以参考msdn webcast苏鹏王洪超他们的讲座，msdn网站上提供下载。

[lnwuyaowei]

我用的是asp.net2005EXPRESS的正式英文版，而他的解答也是基于BETA2这个版本的，所以您测试是正常的。
MemberShip.GetUser().ProviderUserKey,这个取值没有问题，这段代码暂时不需要扩展MEMBERSHIP表。
SQLSERVER2005 EXPRESS没有装，用的是asp.net2005中自已带的那个版本。
谢谢楼上的解答。

[lnwuyaowei]

UP一下.