Archive
Calender
<<  February 2012  >>
MoTuWeThFrSaSu
303112345
6789101112
13141516171819
20212223242526
2728291234
567891011
Blogroll
    Recent comments

    None

     

    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