ASP.NET

y_mmohd wrote:

When I retrieve an image from sql database in the grid view I had the following (System.Byte[]) instead the image.

public partial class comicBrowser : System.Web.UI.UserControl
{
    public int currentComics;
    private Panel thumbnails = new Panel();
    private string connectionString;
    protected void Page_Load(object sender, EventArgs e)
    {
        currentComics = 6;
        setConnectionString();
        UpdatePanel1.ContentTemplateContainer.Controls.Add(thumbnails);
        accessDatatables();
    }

    private void setConnectionString()//gets the connection string from the .comfig file
    {
        Configuration Config =
                System.Web.Configuration.WebConfigurationManager.OpenWebConfiguration("/WebSite");
        ConnectionStringSettings connString;
        if (0 < Config.ConnectionStrings.ConnectionStrings.Count)
        {
            connString =
                Config.ConnectionStrings.ConnectionStrings["data"];
            if (null != connString)
                connectionString = connString.ConnectionString;
        }
    }

    private void accessDatatables()
    {
        SqlConnection conn = new SqlConnection(connectionString);

        SqlDataReader readr = null;

        SqlCommand cmd = null;

        try
        {
            conn.Open();
            cmd = new SqlCommand("SELECT comicUrl, comicId, comicRating, comicName FROM comicDatabase WHERE (comicId <= " + currentComics +
                ") AND (comicId > " + (currentComics - 6) + ")", conn);

            readr = cmd.ExecuteReader();

            while (readr.Read())
            {
                loadMenu(readr.GetString(0), readr.GetInt32(1), readr.GetInt32(2), readr.GetString(3));
            }
        }
        catch(Exception ex)
        {
            this.Page.Title = ex.ToString();
        }
        finally
        {
            if (conn != null)
                conn.Close();

            if (readr != null)
                readr.Dispose();
        }
    }

    private void loadMenu(string comicUrl, int comicId, int comicRating, string comicName)...

    protected void right_Click(object sender, ImageClickEventArgs e)
    {
        currentComics += 6;

        thumbnails.Controls.Clear();//clears previous images

        accessDatatables();//gets and displays the images

        updatejavascript();
    }

    protected void left_Click(object sender, ImageClickEventArgs e)
    {
        currentComics -= 6;

        thumbnails.Controls.Clear();//clears previous images

        accessDatatables();//gets and displays the images

        updatejavascript();
    }
    private void updatejavascript()
    {
        ScriptManager.RegisterStartupScript(UpdatePanel1, typeof(UpdatePanel), "scriptkey", "updateJavascript();", true);
        //calls a javascript function to reload animations for the elements
    }
}

toprogramminguy wrote:

protected void Page_Load(object sender, EventArgs e)
{
currentComics = 6;
setConnectionString();
UpdatePanel1.ContentTemplateContainer.Controls.Add(thumbnails);
accessDatatables();
}

protected void Page_Load(object sender, EventArgs e)
    {
        if (!this.IsPostBack)
        {
            currentComics = 6;
            setConnectionString();
            UpdatePanel1.ContentTemplateContainer.Controls.Add(thumbnails);
            accessDatatables();
        }
        else currentComics = (int)ViewState["currentcomics"];
    }

protected void right_Click(object sender, ImageClickEventArgs e)
    {
        currentComics += 6;

        ViewState["currentcomics"] = currentComics;

        thumbnails.Controls.Clear();//clears previous images

        accessDatatables();//gets and displays the images

        updatejavascript();
    }

else currentComics = (int)ViewState["currentcomics"];

toprogramminguy wrote:

Am i using the viewstate wrong?

toprogramminguy wrote:

but it wasnt on the first run that the exception was thrown

toprogramminguy wrote:

does the accessDatatables(); get called when i call it in the buttonclick event handler or when the updatepanel is reloaded?

Mohammad Rakibul Hasan wrote:

Hi, guys. Can any one help me to build a forum site in asp.net.
I want to build it from scratch.