Click on the login control and click the events lightning button. Double click on the LoggedIn event.

protected void Login1_LoggedIn(object sender, EventArgs e)

        {

            if (Roles.IsUserInRole(this.Login1.UserName, "administrator"))

            {

                this.Login1.DestinationPageUrl = "~/admin/default.aspx";

            }

            else if (Roles.IsUserInRole(this.Login1.UserName, "member"))

            {

                this.Login1.DestinationPageUrl = "~/member/default.aspx";

            }

            Response.Redirect(ResolveClientUrl(Login1.DestinationPageUrl));

        }

 protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)

        {

            if ((string)e.CommandName == "Select")

            {

                int index = Convert.ToInt32(e.CommandArgument);

                int itemID = Convert.ToInt32(this.GridView1.DataKeys[index].Value);

                string urlRedirect = string.Format("~/yourpage.aspx?ID={0}", itemID);

                Response.Redirect(urlRedirect);

            }

        }

In order to show the picture in the asp.net GridView control, you have to preload the image in a separate aspx page and then use the GridView imageField Column to pass the image id to the aspx page.

Create a getimage.aspx page.

Create a function GetImage()

Protected void GetImage()

{

int imageID = Convert.ToInt32((Request.QueryString["imageID"] ?? "0"));

SqlConnection con = new SqlConnection();

con.ConnectionString = ConfigurationManager.ConnectionStrings["youraspdotnetconnectionstring"].ConnectionString;

SqlCommand cmd = new SqlCommand();

cmd.CommandText =  yourImageTableQuery;

cmd.CommandType = System.Data.CommandType.Text;

                cmd.Connection = con;

            SqlParameter ImageID = new SqlParameter("@imageID", System.Data.SqlDbType.Int);

            ImageID.Value = imageID;

            cmd.Parameters.Add(ImageID);

            con.Open();

            SqlDataReader dReader = cmd.ExecuteReader();

            dReader.Read();

            Response.BinaryWrite((byte[])dReader[queryColumn]);

            dReader.Close();

            con.Close();

}

protected void Page_Load(object sender, EventArgs e)

{

            GetImage ();

}

Now back to your GridView aspx page. Add an imageField column to your GridView and configure it to point to your getimage.aspx page.

Configure your bound field.

<asp:BoundField DataField=" imageID " HeaderText=" imageID " ReadOnly="True"

            SortExpression=" imageID " Visible="False" />

Configure your ImageField.

<asp:imagefield headertext="Picture" dataimageurlfield=" imageID "

         dataimageurlformatstring='~ getimage.aspx? imageID ={0}’>

         </asp:imagefield>

Hope this helps J