Entries for System

Help with paging and repeaters [Help with paging and repeaters]

System — Wed, 16 Jan 2008 13:52:27 GMT

I have two repeaters on my page. One for displaying data from a database and the other for holding pagenumbers as linkbuttons which allow navigation through the data.

This seems to work fine. However, I also have three combo boxes which control how the data is sorted. When the combo box is changed I call the DataLoad method which should refresh the PagedDataSource with the new sort details.

However, it doesnt work unless you click on a page number at which point it updates.

www.anon.co.uk/?cat=Music

As you can see, moving around pages works but if you change the combo boxes - nothing happens until you click on a page number.

The code I am using:

using System;
using System.Data;
using System.Collections;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

public partial class Pieces : System.Web.UI.Page
{
    public int PageNumber
    {
        get
        {
            if (ViewState["PageNumber"] != null)
                return Convert.ToInt32(ViewState["PageNumber"]);
            else
                return 0;
        }
        set
        {
            ViewState["PageNumber"] = value;
        }
    }

    protected override void OnInit(EventArgs e)
    {
        base.OnInit(e);
        rptPages.ItemCommand +=
           new RepeaterCommandEventHandler(rptPages_ItemCommand);
    }

    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            string check = Request.QueryString["cat"];
            if (check != null)
            {
                LoadDataCat();

            }

        }

    }

    private void LoadDataCat()
    {
        string cat = Request.QueryString["cat"];

        if (cat != null)
        {


            cat.Trim();
            cat.Replace("'", "''");

            System.Configuration.Configuration rootWebConfig = System.Web.Configuration.WebConfigurationManager.OpenWebConfiguration("/test");
            System.Configuration.ConnectionStringSettings connString;
            connString = rootWebConfig.ConnectionStrings.ConnectionStrings["ConnectionString"];

            SqlConnection cn = new SqlConnection(connString.ConnectionString);
            cn.Open();
            SqlDataAdapter da = new SqlDataAdapter("CatSearch", cn);
            da.SelectCommand.CommandType = CommandType.StoredProcedure;
            da.SelectCommand.Parameters.Add(new SqlParameter("@cat", SqlDbType.VarChar, 40));
            da.SelectCommand.Parameters["@cat"].Value = cat;
            da.SelectCommand.Parameters.Add(new SqlParameter("@RowCount", SqlDbType.Int, 4));
            da.SelectCommand.Parameters["@RowCount"].Direction = ParameterDirection.Output;
            DataTable dt = new DataTable();
            da.Fill(dt);

            cn.Close();

            PagedDataSource pgitems = new PagedDataSource();
            DataView dv = new DataView(dt);
            dv.Sort = getSort();
            pgitems.DataSource = dv;

            pgitems.AllowPaging = true;
            pgitems.PageSize = Convert.ToInt32(DropDownList3.Text);
            pgitems.CurrentPageIndex = PageNumber;

            if (!pgitems.IsLastPage)
            {
                Label2.Text = "Displaying items " + ((pgitems.PageSize * (PageNumber + 1)) - (pgitems.PageSize - 1)) + " - " + (pgitems.PageSize * (PageNumber + 1)) + " from " + da.SelectCommand.Parameters[1].Value;
            }
            else
            {
                Label2.Text = "Displaying items " + ((pgitems.PageSize * (PageNumber + 1)) - (pgitems.PageSize - 1)) + " - " + da.SelectCommand.Parameters[1].Value + " from " + da.SelectCommand.Parameters[1].Value;
            }

            if (pgitems.PageCount > 1)
            {
                rptPages.Visible = true;
                ArrayList pages = new ArrayList();
                for (int i = 0; i < pgitems.PageCount; i++)
                    pages.Add((i + 1).ToString());
                rptPages.DataSource = pages;
                rptPages.DataBind();

            }
            else

                rptPages.Visible = false;
            PageNumber = 0;

            rptItems.DataSource = pgitems;
            rptItems.DataBind();
        }
    }


    void rptPages_ItemCommand(object source,
                              RepeaterCommandEventArgs e)
    {
        PageNumber = Convert.ToInt32(e.CommandArgument) - 1;
        string check = Request.QueryString["cat"];
        if (check != null)
        {
            LoadDataCat();
        }

    }

    string getSort()
    {
        string sort = "fundraiserReserve ASC";
        switch (DropDownList1.Text)
        {
            case "Name":
                sort = "artistName";
                break;
            case "Fundraisers Reserve":
                sort = "fundraiserReserve";
                break;
            case "Normal Retail Price":
                sort = "retailPrice";
                break;
        }
        switch (DropDownList2.Text)
        {
            case "Ascending":
                sort += " ASC";
                break;
            case "Descending":
                sort += " DESC";
                break;
        }
        return sort;
    }

    protected void DropDownList3_SelectedIndexChanged(object sender, EventArgs e)
    {
        string check = Request.QueryString["cat"];
        if (check != null)
        {
            LoadDataCat();
        }

    }
    protected void DropDownList2_SelectedIndexChanged(object sender, EventArgs e)
    {
       string check = Request.QueryString["cat"];
        if (check != null)
        {
            LoadDataCat();
        }

    }
    protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
    {
       string check = Request.QueryString["cat"];
        if (check != null)
        {
            LoadDataCat();
        }
               }
    }
}

Any help would really be appreciated. Thanks!

in reply to Help with paging and repeaters

#define Macro's [#define Macro's]

System — Thu, 25 Oct 2007 10:58:42 GMT

I was reading through a text book today and noticed that the author had used #define to create a macro for deleting objects.

#define SAFE_DELETE( p )    { if( p ) { delete ( p );     ( p ) = NULL; } }

So, I thought this would be a perfect opportunity to replace this macro with a template inline function.

template<typename T>
inline void safeDelete(const T&p)
    {
    if (p)
        {
        delete (p);
        }
    }

However, it then dawned on me that if I was to use this function - it wouldnt be possible to pass in a pointer to an object? Wouldnt it have to be a const reference?

For example if I had a pointer to an object g_engine of type Engine which I now wanted to delete could I call:

safeDelete <Engine> (g_engine);

I wouldnt of thought so because you would get a conversion error, wouldnt you?

Could this of been why the author used a #define macro or is there a way to do this using a inline function? Also, if there is - are #define macros pretty much dead now - or are there still situations where you would prefer to use them over inline functions?

in reply to #define Macro's

Calling javascript function from server side control [Calling javascript function from server side control]

System — Mon, 24 Sep 2007 09:01:22 GMT

I have a for loop which places values into three textboxes on my webpage.

I then want to call a javascript funtion before the loop restarts. Is this possible?

So,

protected void Page_Load(object sender, EventArgs e)
{

foreach (GenericBasket.Product itemProduct in Basket1)
{
            string productName = itemProduct.sName;
            string id = itemProduct.sID;
            float totPrice = itemProduct.TotalPrice;

            TextBox1.Text = productName;
            TextBox2.Text = totPrice.ToString();
            TextBox2.Text = id;

          //I want to be able to call my javascript function here
          //myFunction();
}

}

in reply to Calling javascript function from server side control

wsdl.exe [wsdl.exe]

System — Tue, 18 Sep 2007 13:16:27 GMT

Ok, so I am trying to generate a proxy from a WSDL contract using wsdl.exe however, every time I try and run it, I get the error

"Windows cannot find 'wsdl.exe'. Make sure you typed the name correctly..."

I'm simply using:

wsdl.exe /l:CS WebServiceTest.wsdl

Now, since I am using vista, shouldnt wsdl.exe be built into the OS?

Am I doing something wrong here?

in reply to wsdl.exe

Novice CSS Question [Novice CSS Question]

System — Wed, 05 Sep 2007 13:57:15 GMT

Hi. I am having trouble understanding css compatibility with IE and other browsers. I am a complete novice when it comes to css and any web technology in general so bear with me.

I have implemented a simple website in asp.net which uses div tags and css to manage the layout. However, depending on the browser I get different results!

I cant seem to work out why? Why does the same site in Firefox and IE look so different?

http://www.anon.co.uk

in reply to Novice CSS Question

Advice on Masters [Advice on Masters]

System — Wed, 22 Aug 2007 21:30:44 GMT

Hi Guys. Just after some advice.

I will be starting a Masters programme this October and am in the process of selecting modules.

Now, I have an extremely strong interest in Artificial Intelligence. I find the topic to be interesting and a challenge, thus, I would love to take modules relating to AI.

On the other hand, I can't say for sure that next year, AI will be what I am interested in and/or working on. I'm sure I will learn a lot that I can apply to whatever area of development I go into, but I am unsure as to whether I should take the more tradition software development modules.

I guess my question is:

Should I take the modules in AI which I enjoy, or the more traditional software development modules. Will the AI specific modules hinder me in any way - would the software development modules be better suited for a general development future?

in reply to Advice on Masters

Sending Email [Sending Email]

System — Tue, 14 Aug 2007 16:08:03 GMT

I have a problem with sending an email from my web app. It seems to send two copies of the mail and I am not sure why.

I am using:

Protected Sub Wizard1_FinishButtonClick(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.WizardNavigationEventArgs) Handles Wizard1.FinishButtonClick

SendMail("Senders Email Address", "Body")

End Sub

Private Sub SendMail(ByVal from As String, ByVal body As String)

Dim mailServerName As String = "smtp.mail.yahoo.co.uk"

Dim message As MailMessage = New MailMessage(from, "Email Address", "Subject", body)

Dim mailClient As SmtpClient = New SmtpClient

mailClient.Host = mailServerName

mailClient.Send(message)

message.Dispose()

End Sub

What I cant seem to understand is why would SendMail get called twice when the Finish Button on the ASP Wizard is only pressed once?

in reply to Sending Email

XPath Expressions [XPath Expressions]

System — Tue, 24 Jul 2007 13:27:42 GMT

Hi guys, just a quick question.

Could someone give me some advice on xpath expressions?

I have an xml file which holds a title and a description of some images and using a form view (asp), I would like to display the description of the image based on the title (which I would like to pull from Image1.ImageUrl).

Is this possible? I seem to be having a very brainless day today!

in reply to XPath Expressions

One quick question before I rush out and buy Vista [One quick question before I rush out and buy Vista]

System — Tue, 30 Jan 2007 09:51:50 GMT

Hi guys. Just have one quick question to ask regarding vista. Is it possible to install vista on my desktop and laptop using the same key? Or would I have to purchase additional keys?

Thanks!

in reply to One quick question before I rush out and buy Vista

Xbox 360 support [Xbox 360 support]

System — Fri, 26 Jan 2007 20:41:33 GMT

Well I just had an interesting experience with Xbox support. My launch 360 was working perfectly. I thought I was one of the lucky ones who got a good batch, but alas not so more. Turned it on tonight and it keeps freezing on the dashboard and I get system error messages all over the place. So I though I'll ring Xbox support; they will be able to help.

Well I was wrong. I was told simply that there was nothing they could do because I purchased it Christmas 2005 and that I would be better off going to local electronics store to have it fixed!

I really can’t understand support. I have, not even once, been given useful information from a support line. I don't know why I even bother!

Now for the important question. Does anyone know what I can do to get this fixed? I don't feel I should have to pay for what is ultimately Microsoft’s error - especially with MS even admitting the first batch was dodgy!

in reply to Xbox 360 support

ASP.NET problems with IE7 [ASP.NET problems with IE7]

System — Fri, 01 Dec 2006 11:58:57 GMT

Hi.

I have developed a website using ASP .NET 2.0 and everything works fine when viewed with IE6. However, if I view the page with IE 7 or Firefox the div header and footer seem to disappear?

The website is www.essexfarmersmarkets.co.uk. If you view it with IE 6 eveything looks how it should, but any other browser and it does not! Could it be something to do with the style sheet?

I am a relative novice when it comes to asp so any help or advice would be appreciated.

in reply to ASP.NET problems with IE7

asp browser detection [asp browser detection]

System — Wed, 16 Aug 2006 14:03:20 GMT

Hi.

Im trying to implement some very basic browser detection that will just inform the user they are not using IE6.

What I have done is have a start page with the code:

protected void Page_Load(object sender, EventArgs e){

if (Request.Browser.Browser == "IE"){

if (Request.Browser.MajorVersion == 6){

Server.Transfer("Default.aspx");}

}

This seems to work when I run the webpage locally. If open the page with IE6 I get directed to Default.aspx and when I open it in Firefox I get a blank page. However, when I upload this to my webserver, it doesnt work. Anyone know why?

Thanks

in reply to asp browser detection

ASP.NET 2.0 Menus and Logins [ASP.NET 2.0 Menus and Logins]

System — Wed, 12 Jul 2006 19:06:04 GMT

I posted this thread in the Techoff forum, but I really need some help and thought this would get more responses.

Im pretty new to ASP. I have a menu control on my webpage, and a login control. What I would like is to only show a menu item when the user is logged in.

What would be the easiest way to do this? I was thinking about using the IsAuthenticated() method, and if it was true, adding the line of code to the .sitemap file, thus showing the menu item. Would this even work?

Thanks

in reply to ASP.NET 2.0 Menus and Logins

ASP.Net 2.0 Menus and Logins [ASP.Net 2.0 Menus and Logins]

System — Wed, 12 Jul 2006 14:48:26 GMT

Hi,

Im pretty new to ASP. I have a menu control on my webpage, and a login control. What I would like is to only show a menu item when the user is logged in.

What would be the easiest way to do this? I was thinking about using the IsAuthenticated() method, and if it was true, adding the line of code to the .sitemap file, thus showing the menu item. Would this even work?

Thanks

in reply to ASP.Net 2.0 Menus and Logins

Browers and VS 2005 [Browers and VS 2005]

System — Thu, 22 Jun 2006 09:52:15 GMT

Is there a way to change which browser Visual Studio uses when debugging a web application? From what I read in the help files, it uses the default browser, however its not using mine.

I had BT Yahoo browser installed which was the default and so VS used, but I uninstalled that. Now when I try and debug the website, I get the error: "unable to start program 'C:Program Files ~ ybrowser.exe' The system cannot find the file specified."

Anyone come across this error before? IE6 is my default browser. I tried resetting the settings in VS without any luck.

in reply to Browers and VS 2005

Future of TV [Future of TV]

System — Sat, 17 Jun 2006 13:50:01 GMT

I was browsing through the BBC's website today, and saw two articles relating to TV, that I thought warranted a discussion.

The first was Google's tv eavesdropping plan. The TV, using a microphone, captures 5 second samples of the TV channel you are watching, and then ultilising an online database, could indentify the show you are watching, and how far you are through it. It could exploit this knowlegde by sending targeted adverts during the commercial breaks. Sounds interesting albeit slighty scary. I'd rather people didn't always know what I was watching!

The second news article, was that DirecTV an American TV network, has signed a deal to broadcast live gaming events. They would actualy have virtual cameras set up in the game world, which I assume a 'camera man' would control, walking around the game environment watching the game unfold. Sounds like my kind of TV!

I was wondering about Microsofts plans for the future of TV? I keep hearing Bill and Steve Ballmer mention TV in their plans, but havent really been made aware of any hard information about what they are planing. I remember reading a white paper wrote in 97 I think, about MS interactive TV, but the ideas put forward there are bit old and thus, already been implemented by BskyB. Media Centre is the only thing I can think of, but thats not really the future of TV.

Also, BskyB providers of Sky televison, are in talks to buy the UK operations of AOL. They have already started providing movies via broadband, and with AOL and Easynet, which they purchased for £211mill they stand a good chance in being in the running for providing high end, interactive, on demand TV.

in reply to Future of TV

Question regarding vista desktop [Question regarding vista desktop]

System — Sun, 11 Jun 2006 18:08:24 GMT

Hi. I have a question regarding vista's desktop. To me, the icons look very big and a bit ugly. Is there anyway to have smaller icons on the desktop?

in reply to Question regarding vista desktop

Saving information from a webpage [Saving information from a webpage]

System — Fri, 09 Jun 2006 12:34:58 GMT

Hi guys, I need some advice.

There is a website that contains a list of address which I want to put into an access database. At the moment I am copying and pasting the information into the database, however it is very very inefficient. Can you suggest a better method of doing this? Maybe some tool which can read the website, and put this information into the fields in the database. Its just really killing me to copy thousands of addresses.

Thanks

in reply to Saving information from a webpage

Error compiling in VC++ 2005 because of missing dll? [Error compiling in VC++ 2005 because of missing dll?]

System — Thu, 25 May 2006 12:10:57 GMT

Hi guys, I need some help.

I'm trying to compile a project using VC++ but everytime I get this error:

Project : error PRJ0002 : Error result -1073741515 returned from 'C:\Program Files\Microsoft Visual Studio 8\VC\bin\cl.exe'.

I tried to run cl.exe from the command prompt but that displays this error:

This application failed to start because mspdb80.dll was not found. Re-installing the application may fix this problem

I tired reinstalling Visual Studio but that hasn't helped. Anyone know why I could be missing this dll, and where I can get it from? I've tried dll-files.com but had no luck.

Thanks

in reply to Error compiling in VC++ 2005 because of missing dll?