Dear all ,

First, I am very glad to be a member of this forum from today and I hope to gain knowledge from other experts here .

My problem is ,whenever I set Username as session source in gridview with a where clause and Sql expression [UserName] = @UserName .Nothing is displayed .Data is inserted in my Sql 2012 management studio database without any problems after querying the table .

My aim is to allow users to view only their information in grid view without seeing others .I have tried setting Session variable Username in load page ,but still the problem persists .

I would be very grateful for any assistance rendered.Many thanks in advance.

Refer the following :
http://www.codeproject.com/Questions...Select-command