Passing values to sql datasource

[John]

Hi

I am trying to pass the asp.net membership username to the sqldatasource of
a gridview as below;

<asp:SqlDataSou rce ID="EventsSqlDa taSource" runat="server"
ConnectionStrin g="<%$ ConnectionStrin gs:MyConnStr %>" SelectCommand=" SELECT
* FROM [MyTable] WHERE [Username] =
'<%Me.User.Iden tity.Name%>'"></asp:SqlDataSour ce>

It is not working. How can I do it correctly?

Thanks

Regards

[Munna]

On Jun 1, 9:42 pm, "John" <[e-mail] fovis.co.ukwrot e:

Hi

I am trying to pass the asp.net membership username to the sqldatasource of
a gridview as below;

<asp:SqlDataSou rce ID="EventsSqlDa taSource" runat="server"
ConnectionStrin g="<%$ ConnectionStrin gs:MyConnStr %>" SelectCommand=" SELECT
* FROM [MyTable] WHERE [Username] =
'<%Me.User.Iden tity.Name%>'"></asp:SqlDataSour ce>

It is not working. How can I do it correctly?

Thanks

Regards

Hi i have tried your same code and worked okay make be you are meesing
some thing....

here is the code i tried..

<asp:SqlDataSou rce ID="SqlDataSour ce1" runat="server"
ConnectionStrin g="<%$Connectio nStrings:Connec tionString %>"
SelectCommand=" SELECT * FROM [testtable] where id = '<%
Page.User.Ident ity.Name %>' "></asp:SqlDataSour ce>

Best of luck

Munna
www.munna.shatkotha.com
www.munna.shatkotha.com/blog
www.shatkotha.com

[Munna]

Hi its me again...

I found another way to make things work i have tested it and works
pretty fine..
in markup i actually didn't put any select command.

instead i left the select command blank

i assigned the select command in code behind file in page load
event ...

SqlDataSource1. SelectCommand = "SELECT * FROM [testtable] where id
like '%" + Page.User.Ident ity.Name + "%'";

and

data source mark up is

<asp:SqlDataSou rce ID="SqlDataSour ce1" runat="server"
ConnectionStrin g="<%$Connectio nStrings:Connec tionString %>" ></
asp:SqlDataSour ce>
Best of luck

Munna
www.munna.shatkotha.com
www.munna.shatkotha.com/blog
www.shatkotha.com