Filter RadGrid by Current User by default

[Carolee]

If I have a large list of assignments or orders in my SQL database, is there a way to present the logged-in user with only those which are his or hers, by default when they land on the page?  Or, I know there IS a way... But can someone give me explicit details on how to accomplish this?

Thank you  so much.

[Jayesh Goyani]

Hello,

Please write below code snippet in needdatasource event.

if(!ispostback)

{

 

RadGrid1.MasterTableView.FilterExpression = "([UserName] LIKE \'%" + "YOURLOGINUSERNAME" + "%\') ";

 

            GridColumn column = RadGrid1.MasterTableView.GetColumnSafe("UserName"); // Column unique name


            column.CurrentFilterFunction = GridKnownFunction.Contains;

            column.CurrentFilterValue = "YOURLOGINUSERNAME";

 

}

Thanks,
Jayesh Goyani

[Carolee]

Hello Jayesh,
Wow...Does this solution dynamically retrieve and apply the LoginName of the user who comes to the page? 

[Jayesh Goyani]

Hello,

No you have to get your logged in username by your own way.

Once you get username you can able to replace with "YOURLOGINUSERNAME" in above code.

Thanks,
Jayesh Goyani

[Casey]

Hi Carolee,

Another way to do this would be to pass the user ID to the method selecting the records, and only select the applicable records with the query. I think it would save some processing time due to the method return only the applicable rows, rather than all of the rows being returned, and then filtered by the RadGrid.

I hope this helps!
Casey

[Carolee]

Hi Casey,

That sounds like a plan.... But I am so green I don't know how to go about that... I don't suppose you could point me to an example?

Thanks so much!

[Casey]

Hi Carolee,

Well, in our apps we use Forms authentication mode, and I'm able to get the user ID of the person logged in by referencing "HttpContext.Current.User.Identity.Name" in the code behind. Based on the following forum, User.Identity.Name, this is not set unless you use FormsAuthentication.SetAuthCookie or FormsAuthentication.RedirectFromLoginPage.

If you are not currently doing that, then you could just set a session variable and assign the user name to it when they login. And then in the NeedDataSource of your RadGrid, you could pass Session["userName"].ToString() to the method.

I hope this helps!
Casey

protected void LoginButton_Click(object sender, EventArgs e)
{
        Session.Add("userName", TextBox1.Text);
}

protected  void RadGrid1_NeedDataSource(object sender, GridNeedDataSourceEventArgs e)
{
     RadGrid1.DataSource = YourClass.YourMethod(Session["userName"].ToString());
}