ASP.NET

25-May-12 8:45

Not a good idea to post your email address. Also, what is the color trackbar? Be more specific.

There are only 10 types of people in the world, those who understand binary and those who don't.

HTTP 404

Franco Cipriano24-May-12 23:43

24-May-12 23:43

Hi,

I am new in ASP.NET c# web application development. I am creating a simple Account Management application. I am experiencing an error when using QueryString to pass value to a form. I have a main form named WebForm1.aspx. When I click a button named View List, it will pop-up a separate window with a gridview displaying all the account from a SQL database. The new window is called frmList.aspx, the gridview has a button on each row, and when I click the button it should transfer the data from the row to several textbox in the first page, WebForm1.aspx. But after I click the button it gives me an error. Below is the code behind for frmList.aspx

protected void Page_Load(object sender, EventArgs e)
        {
            if (ClassProj.GetDBconn() == true)
            {
                String SQLstr = "SELECT a.ID, a.NAME AS Name,b.NAME AS Industry,a.subindustry as SubIndustry,a.geo AS Geo,c.NAME AS LocType FROM mpsacct AS a,industry AS b,location AS c WHERE a.industry=b.id AND a.loctype=c.id";
                MySqlCommand cmd = new MySqlCommand(SQLstr, ClassProj.mycon);
                MySqlDataReader reader = cmd.ExecuteReader();

                //Bind the grid view
                grdAll.DataSource = reader;
                grdAll.DataBind();

                reader.Close();
                cmd.Dispose();
            }

            ClassProj.CloseConn();
        }

        public void MPS_Selected(Object sender, GridViewCommandEventArgs e)
        {
            if (e.CommandName == "Select")
            {
                // Convert the row index stored in the CommandArgument
                // property to an Integer.
                int index = Convert.ToInt32(e.CommandArgument);
                //Populate textbox with selected values

                //String s = Request.QueryString["grdAll.Rows[index].Cells[1].Text.ToString();"];
                string name = grdAll.Rows[index].Cells[1].Text.ToString();
                string Industry = grdAll.Rows[index].Cells[2].Text.ToString();
                string SubInd = grdAll.Rows[index].Cells[3].Text.ToString();
                string geo = grdAll.Rows[index].Cells[4].Text.ToString();
                string location = grdAll.Rows[index].Cells[5].Text.ToString();

                Page.Response.Redirect("WebForm1.aspx?name=" + name + "&industry=" + Industry + "&subind=" + SubInd + "&geo=" + geo + "&location=" + location);
            }
        }

ZurdoDev25-May-12 4:44

25-May-12 4:44

I see a lot of issues but I am not sure if any are the actual error.

1. You likely need to check for Page.IsPostBack() in your Page_Load event and only DataBind when it is not a postback.
2. When you Respone.Redirect go to the root. So, do Response.Redirect("~/WebForm1.aspx") or whatever the path is. 404 means the page cannot be found.
3. URLEncode your parameters in case they have spaces or other special characters.

There are only 10 types of people in the world, those who understand binary and those who don't.

Franco Cipriano25-May-12 4:48

25-May-12 4:48

Thanks!I will try those changes. I am not sure what Page.IsPostBack() but I will do a research on that.

Thanks!

ZurdoDev25-May-12 4:51

25-May-12 4:51

There are a lot of controls in .Net which cause postbacks. For example a button when clicked and even dropdowns, although you can control it. So, you normally only want to retrieve your data when the page loads for the first time, not when controls are causing a postback. So, in Page_Load check if (!IsPostBack()) then do your select.

There are only 10 types of people in the world, those who understand binary and those who don't.

Franco Cipriano25-May-12 5:45

25-May-12 5:45

I tried your suggestions but, this time everytime I click the select button it still gives me the same error. Here is the code behind from the WebForm1.aspx

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using MySql.Data.MySqlClient;

namespace AccoutMgt
{
    public partial class WebForm1 : System.Web.UI.Page
    {

        protected void Page_Load(object sender, EventArgs e)
        {
            if (Page.Request.QueryString["name"] != null)
            {
                txtMPSname.Text = Page.Request.QueryString["name"];
                txtLoc.Text = Page.Request.QueryString["location"];
                DlstGeo.DataValueField = Page.Request.QueryString["geo"];
            }
        }

        protected void BtnSearch_Click(object sender, EventArgs e)
        {

        }

    }
}

and here is the code from frmList.aspx

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using MySql.Data.MySqlClient;


namespace AccoutMgt
{
    public partial class List : System.Web.UI.Page
    {
        //public static string connStr = "SERVER=157.184.82.187;DATABASE=acctinformation;UID=root;PASSWORD=l3xmark;pooling=false;";
        //public static MySqlConnection mycon;
        //ClassProj cs1 = new ClassProj();
        
        protected void Page_Load(object sender, EventArgs e)
        {
            if (ClassProj.GetDBconn() == true)
            {
                if (!IsPostBack)
                {
                    String SQLstr = "SELECT a.ID, a.NAME AS Name,b.NAME AS Industry,a.subindustry as SubIndustry,a.geo AS Geo,c.NAME AS LocType FROM mpsacct AS a,industry AS b,location AS c WHERE a.industry=b.id AND a.loctype=c.id";
                    MySqlCommand cmd = new MySqlCommand(SQLstr, ClassProj.mycon);
                    MySqlDataReader reader = cmd.ExecuteReader();

                    //Bind the grid view
                    grdAll.DataSource = reader;
                    grdAll.DataBind();

                    reader.Close();
                    cmd.Dispose();
                }
            }

            ClassProj.CloseConn();
        }

        public void MPS_Selected(Object sender, GridViewCommandEventArgs e)
        {
            if (e.CommandName == "Select")
            {
                // Convert the row index stored in the CommandArgument
                // property to an Integer.
                int index = Convert.ToInt32(e.CommandArgument);
                //Populate textbox with selected values

                //String s = Request.QueryString["grdAll.Rows[index].Cells[1].Text.ToString();"];
                string name = grdAll.Rows[index].Cells[1].Text.ToString();
                string Industry = grdAll.Rows[index].Cells[2].Text.ToString();
                string SubInd = grdAll.Rows[index].Cells[3].Text.ToString();
                string geo = grdAll.Rows[index].Cells[4].Text.ToString();
                string location = grdAll.Rows[index].Cells[5].Text.ToString();

                Page.Response.Redirect("~/WebForm1.aspx?name=" + name + "&industry=" + Industry + "&subind=" + SubInd + "&geo=" + geo + "&location=" + location);
            }
        }

               
    }
}

ZurdoDev25-May-12 5:50

25-May-12 5:50

Is WebForm1 in the root of the site? That is what the ~ does. It puts you to the root so make sure that Response.Redirect(path) is correct.

There are only 10 types of people in the world, those who understand binary and those who don't.

Franco Cipriano25-May-12 7:11

25-May-12 7:11

They are located on the same path. The WebForm1.aspx is the start page and serves as the parent. The frmList.aspx is a pop-up window. Basically what should happen is the frmList.aspx will call back the WebForm1.aspx and pass the values to the controls of WebForm1.aspx.

Thanks,

ZurdoDev25-May-12 7:18

25-May-12 7:18

I know, but is WebForm1 under a folder? Or is it at the root of your site?

There are only 10 types of people in the world, those who understand binary and those who don't.

Franco Cipriano25-May-12 7:27

25-May-12 7:27

It's in the root of the site. I'm not sure where the problem is, since when I run the debug it does not go anywhere when I click the button in the GridView. Here is the ASP code of the GridView at frmList.aspx

XML

<asp:GridView ID="grdAll" runat="server" OnRowCommand="MPS_Selected" AutoGenerateColumns="false">
            <Columns>
                <asp:BoundField DataField="ID" HeaderText = "" Visible="false" />
                <asp:BoundField DataField="Name" HeaderText = "MPS Account Name" />
                <asp:BoundField DataField="Industry" HeaderText = "Industry" />
                <asp:BoundField DataField="SubIndustry" HeaderText = "Sub-Industry" />
                <asp:BoundField DataField="Geo" HeaderText = "Geo" />
                <asp:BoundField DataField="LocType" HeaderText = "Location" />
                <asp:buttonfield buttontype="Button" commandname="Select" headertext="" text="Select"/>
            </Columns>

        </asp:GridView>

ZurdoDev25-May-12 7:30

25-May-12 7:30

404 means it cannot find the file. So, put a breakpoint and see what url it is trying to go to. Also, if the url is correct try adding the Everyone group to the folder with full control because you may have an issue where file level security is preventing IIS from seeing the file.

There are only 10 types of people in the world, those who understand binary and those who don't.

Franco Cipriano25-May-12 7:38