Пример #1
0
    protected void Page_Load(object sender, EventArgs e)
    {
        String HTNo   = Request.QueryString["HTNo"];
        String examid = Request.QueryString["examid"];

        String query = "SELECT a.htno, a.subcode, b.subname, a.im, a.em, a.credits " +
                       "FROM results AS a INNER JOIN subjects AS b " +
                       "ON (a.subcode = b.subcode) " +
                       //     "WHERE (a.examid = 4) AND (a.htno = '08U31A0568')";
                       "WHERE (a.examid = " + examid + ") AND (a.htno = '" + HTNo + "')";



        readDB ndb = new readDB();

        ndb.makeConnection(query);
        List <List <string> > ligdb = ndb.readListList();

        ndb.readDBClose();
        int countDivs = ligdb.Count;

        String divHTML = "";

        if (countDivs > 0)
        {
            divHTML = "<div>Hall Ticket No : " + HTNo + "</div><div class=\"resultsDiv\"><table>" +
                      "<th>Subject Code</th><th>Subject Name</th><th>Internal</th><th>External</th><th>Total</th><th>Credits</th>";
            for (int i = 0; i < countDivs; i++)
            {
                int total = 0;
                if (int.Parse(ligdb[i][3]) < 0 && int.Parse(ligdb[i][4]) < 0)
                {
                    ligdb[i][3] = "A"; ligdb[i][4] = "A"; total = 0;
                }
                else if (int.Parse(ligdb[i][3]) < 0)
                {
                    ligdb[i][3] = "A"; total = int.Parse(ligdb[i][4]);
                }
                else if (int.Parse(ligdb[i][4]) < 0)
                {
                    ligdb[i][4] = "A"; total = int.Parse(ligdb[i][3]);
                }
                else
                {
                    total = int.Parse(ligdb[i][3]) + int.Parse(ligdb[i][4]);
                }


                divHTML += "<tr class='row" + i % 2 + "'><td>" + ligdb[i][1] + "</td><td>" + ligdb[i][2] + "</td><td>" + ligdb[i][3] + "</td><td>" + ligdb[i][4] +
                           "</td><td>" + total + "</td><td>" + ligdb[i][5] + "</td></tr>";
            }
            divHTML += "</table></div>";
        }
        else
        {
            divHTML += "No results found";
        }

        Response.Write(divHTML);
    }
Пример #2
0
    protected void Page_Load(object sender, EventArgs e)
    {
        /*  HttpWebRequest request = (HttpWebRequest)HttpWebRequest.Create("http://www.facebook.com");
         * try
         * {
         *    using (HttpWebResponse response = (HttpWebResponse)request.GetResponse())
         *    {
         *        facebookStatus.Value = response.StatusCode.ToString();
         *    }
         * }
         * catch (System.Net.WebException)
         * {
         *    facebookStatus.Value=HttpStatusCode.NotFound.ToString();
         * }*/

        readDB tdq = new readDB();

        tdq.makeConnection("Select * from quotes ORDER BY quoteid DESC LIMIT 1");
        List <List <string> > quotationFull = tdq.readListList();
        String quotation   = quotationFull[0][1];
        String quotationBy = quotationFull[0][2];

        tdq.readDBClose();

        todaysQuoteContainer.InnerHtml = quotation + "-<b><i>" + quotationBy + "</i></b>";
    }
Пример #3
0
    protected void executeQuery(object sender, EventArgs e)
    {
        readDB rdb = new readDB();

        int s = rdb.executeNonQuery(TextBox1.Text.ToString());

        Label1.Text = "Rows Effected : " + s.ToString();

        rdb.readDBClose();
    }
Пример #4
0
    protected void Page_Load(object sender, EventArgs e)
    {
        //############# Imp Notes
        readDB impN = new readDB();

        impN.makeConnection("Select * from impnotes WHERE (`show` IS NULL) ORDER BY impNotesid DESC LIMIT 1");


        List <String> impNR = impN.readColumn(1);


        if (impNR.Count() > 0)
        {
            impNotesDiv.InnerHtml = impNotesDiv.InnerHtml.ToString() + impNR[0];
        }
        else
        {
            impNotesDiv.Disabled = true;
        }

        impN.readDBClose();



        //#############For Search Engine Crawlers.

        if (Request.QueryString["params"] != null)
        {
            String href = Request.QueryString["params"].ToString();

            String[] hrefArr = href.Split('-');

            String url = "";

            if (Request.Browser.EcmaScriptVersion.Major < 1)
            {
                if (hrefArr[1].IndexOf('?') < 0)
                {
                    url = hrefArr[1] + ".aspx";
                }



                Response.Write(getSoureCodeFromFile("http://" + Request.Url.Host + "/" + url));
            }
        }
    }