using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using MySql.Data.MySqlClient;
using System.IO;
using MySql.Data;

public partial class uploadimages2 : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

        string a;
        string b;
        string b1;
        string b2;
        string c;

        MySql.Data.MySqlClient.MySqlConnection conn;
    
              string myConnectionString =
        System.Configuration.ConfigurationManager.ConnectionStrings["db_connection"].ConnectionString;


        conn = new MySql.Data.MySqlClient.MySqlConnection(myConnectionString);
        conn.Open();

     
        string sql = " SELECT * FROM images ORDER BY RAND() limit 12";

        MySqlCommand cmd = new MySqlCommand(sql, conn);
        MySqlDataReader rdr = cmd.ExecuteReader();




        while (rdr.Read())
        {
            //  Response.Write(rdr[0] + " -- " + rdr[1]);

            // converto in stringa il campo del database
            a = Convert.ToString(rdr["ImageName"]);

            //    Response.Write(Path.GetFileName(@a));
            b = Convert.ToString(Path.GetFileName(@a));
            //       Response.Write(Path.GetFileNameWithoutExtension(@a));
            b1 = Convert.ToString(Path.GetFileNameWithoutExtension(@a));


            // stampo sulla pagina il campo del database
          //  Response.Write(b1);

            //       Response.Write("<img src=\"images/minithumb/"+b1+".jpg\" />");

            //   Response.Write(rdr["ImageName"]);
            //Response.Write("<img src=\"" + rdr["ImageName"] + "\"/>");




       //     literal.Text = literal.Text + "<img border=0 vspace=0 src=\"images/minithumb/" + b1 + ".jpg\" />";



            literal.Text = literal.Text + "<a href=queryform.aspx target=_self>" 
                           + "<img border=0 vspace=0 src=\"images/minithumb/"
                           + b1 
                           + ".jpg\" />"
                           + "</a>";
                           

                          

        }

        rdr.Close();
        conn.Close();
        



    }