Depening on the role at runttime the GridView should bind to different SqlDataSources.I searched in Google alreday,but not clear.Can anyone please help me?Can anyone complete following,Becoz following code will not work at all,it doesnot give error ,but it will not run also!

             if (Roles.IsUserInRole("supervisor"))
        {
            GridView4.DataMember=default;
            GridView4.DataSource=SqlDataSource1;
        }


Vedavathi

__________________
Vedavathi

Hi Use this
if (Roles.IsUserInRole("supervisor"))
{
GridView4.DataMember=default;
GridView4.DataSource=SqlDataSource1;
GridView4.DataBind();
}


harjinder

Hi Friend,
   Thank U for suggesting..but that doesnot work...If i give DefaultView I get error,If I keep that in comment ,it doesnot display anything.I ned this solution badly.
Here is my code in page_load :----------------

if (Roles.IsUserInRole("employee"))
        {

                //GridView1.DataMember=DefaultView ;
                 GridView1.DataSource=SqlDataSource1;
                 GridView1.DataBind();
             }
         if (Roles.IsUserInRole("hr"))
             {

              // GridView1.DataMember = DefaultView;
                 GridView1.DataSource=SqlDataSource2;
                 GridView1.DataBind();
             }


Vedavathi

I got it!!!!!!
      Credit goes to u by 50%,harjinder.Here is the code to be written in different roles.I have 5 roles.

 GridView1.AutoGenerateColumns = true;
            GridView1.DataSource = SqlDataSource4;
            GridView1.DataBind();

Vedavathi