ASP.NET

4-Oct-11 14:46

I'm currently programming on ASP.NET 3.5 and started learning about URL routing. I found an article on it here. I went through it and tried to implement it in my site but came across an issue that I can't figure out.

I'm trying to use this for a web store. Right now to see a products details the user would need to go to an address such as /Shopping/ProductDetails.aspx?productID=XXX where 'XXX' is the product GUID from the database. I wanted to make it simpler so a customer could go to /Products/Computer250 and it would bring up a specific product.

I got the routing to work where it would redirect to the correct product page. However on the product details page I have a form view with controls it is to display information like price, description, In Stock/Backordered, etc. After the products information is loaded from the database, I use the following code to set the In Stock/Backordered label:

Dim totalStock As Integer = CInt(ds.Tables(0).Rows(0).Item("TotalStock"))
Dim StockLabel As Label = DirectCast(fvProduct.FindControl("lblStock"), Label)
        If totalStock > 0 Then
            StockLabel.Text = "In Stock"
            StockLabel.ForeColor = Drawing.Color.Green
        Else
            StockLabel.Text = "Backordered"
            StockLabel.ForeColor = Drawing.Color.Red
        End If

Now this code work's fine if the customer got to the product's details page if they clicked on a link with the products GUID. When they arrive at the product's details page because of the URL routing, the StockLabel object is nothing and this causes a error.

Why does fvProduct.FindControl return the correct label when the user follows a direct link but when the user gets to the page based on URL routing the fvProduct.FindControl returns nothing?

Any help would be greatly appreciated as I haven't been able to figure this out, or find an answer online. Thanks in advanced for any help you can provide.

Parwej Ahamad4-Oct-11 17:54

Parwej Ahamad

4-Oct-11 17:54

What is fvProduct? is this control placed on current page?

Parwej Ahamad

Dominick Marciano5-Oct-11 11:08

5-Oct-11 11:08

It is a form view control.

Parwej Ahamad5-Oct-11 19:13

Parwej Ahamad

5-Oct-11 19:13

I am not sure where is the problem existing. Can you post here code snippet of HTML and Code behind? As per my understanding we can find control only in which state we are like Edit Temple/insert template etc.

So please post Html and C#/VB code in which event you are trying to find.

Parwej Ahamad

Dominick Marciano6-Oct-11 14:26

6-Oct-11 14:26

In my Global.asax:

Imports System.Web.Routing

Sub Application_Start(ByVal sender As Object, ByVal e As EventArgs)
        RegisterRoutes(RouteTable.Routes)
End Sub


Sub RegisterRoutes(ByVal routes As RouteCollection)
        routes.Add("View Product", New Route("Products/{*ProductName}", New ProductRouteHandler()))
End Sub

In a class file ProductRouteHandler:

Imports System.Data.SqlClient
Imports System.Web.Routing

Public Class ProductRouteHandler
    Implements IRouteHandler

#Region "Variables"
    Dim connectionString As String = ConfigurationManager.ConnectionStrings("SQLMembership").ConnectionString
    Dim myConnection As New SqlConnection(connectionString)
#End Region

Public Function GetHttpHandler(ByVal requestContext As System.Web.Routing.RequestContext) As System.Web.IHttpHandler Implements System.Web.Routing.IRouteHandler.GetHttpHandler
        Dim productName As String = requestContext.RouteData.Values("ProductName").ToString

        If String.IsNullOrEmpty(productName) Then
            Return CType(System.Web.Compilation.BuildManager.CreateInstanceFromVirtualPath("~/Shopping/PageNotFound.aspx", GetType(Page)), Page)
        End If

        Dim selectSQL As String = "SELECT ProductID FROM Products WHERE ProductShortName='" & productName & "'"
        Dim selectCommand As SqlDataAdapter = New SqlDataAdapter(selectSQL, myConnection)
        Dim ds As New DataSet

        selectCommand.Fill(ds)

        If ds.Tables(0).Rows.Count > 0 Then
            HttpContext.Current.Items("ProductID") = ds.Tables(0).Rows(0).Item("ProductID").ToString
            Return CType(System.Web.Compilation.BuildManager.CreateInstanceFromVirtualPath("~/Shopping/ProductDetails.aspx", GetType(Page)), Page)
        Else
            Return CType(System.Web.Compilation.BuildManager.CreateInstanceFromVirtualPath("~/Shopping/PageNotFound.aspx", GetType(Page)), Page)
        End If
    End Function
End Class

Then the section of the web page that is having trouble is in the ProductDetails.aspx page. I have only included the full text of the form view control:

<asp:FormView ID="fvProduct" runat="server" DataKeyNames="ProductID" DataSourceID="ProductDataSource">
        <ItemTemplate>
            <div id="ContentHead" class="ContentHead" runat="server">
                <%#Eval("ProductName")%></div>
            <br />
            <table style="border: 0px;">
                <tr>
                    <td style="vertical-align: top;">
                        <section>
                            <div id="section_articleOneIdentifier">
                            </div>
                            <article id="article_one">
                                <div id="gallery">
                                    <asp:PlaceHolder ID="ImageLightBox" runat="server" />
                                </div>
                            </article>
                        </section>
                        <%-- <img src='../Product_Images/<%#Eval("ProductImageName") %>' width="100" height="75"
                            alt='<%#Eval("ProductName") %> Image' />--%>
                    </td>
                    <td style="vertical-align: top;">
                        <%#Eval("ProductLongDescription")%>
                        <br />
                    </td>
                </tr>
            </table>
            <div style="padding-left: 250px; text-align: right">
                Your Price:  <%#Eval("ProductPrice", "{0:c}")%>
                <br />
            </div>
            <div style="padding-left: 400px; text-align: right;">
                <input type="number" id="itemCount" value="1" min="1" max="999" required="true" onblur="checkItemCount();"
                    onchange="revertColors();" />
                    <br />
                <a style="border: 0 none white" onmouseover="setCursorPointer();" onmouseout="setCursorNormal();">
                    <img id="imgAddToCart" src="Images/AddToCart.png" runat="server" alt="Add To Cart"
                        style="border-width: 0" onclick="process();" /></a>
                        <div style="vertical-align:top;text-align:right;padding-right:10px;">
                <asp:Label ID="lblStock" runat="server" Font-Size="10px" Font-Bold="true" Text="" />
                </div>
                <br />
                <br />
            </div>
        </ItemTemplate>
    </asp:FormView>

And in the code behind of ProductDetails.aspx that is causing the error is:

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        If String.IsNullOrEmpty(Request.QueryString("productID")) Then
            productID = CType(HttpContext.Current.Items("ProductID"), String)
        Else
            productID = Request.QueryString("productID")
        End If
        DetermineStock()
        CreateLightBox()
End Sub

Private Sub DetermineStock()
        Dim selectSQL As String = "SELECT TotalStock FROM Products WHERE ProductID='" & productID & "'"
        Dim selectCommand As SqlDataAdapter = New SqlDataAdapter(selectSQL, myConnection)
        Dim ds As New DataSet

        selectCommand.Fill(ds)

        Dim totalStock As Integer = CInt(ds.Tables(0).Rows(0).Item("TotalStock"))
        Dim StockLabel As Label = DirectCast(fvProduct.FindControl("lblStock"), Label)

        If totalStock > 0 Then
            StockLabel.Text = "In Stock"
            StockLabel.ForeColor = Drawing.Color.Green
        Else
            StockLabel.Text = "Backordered"
            StockLabel.ForeColor = Drawing.Color.Red
        End If
End Sub

In the user arrives at this page using the direct link www.mywebsite.com/Shopping/ProductDetails.aspx?id=ProductID then everything works fine. However if they come to this page from the routing class by visiting a page such as www.mywebsite.com/Products/ProductName then in the DetermineStock method, the line that finds the control lblStock returns nothing and therefore I cannot set the text or color of the label. However, if they follow the direct link that has the product id (and therefore the routing class was not used) the same line that finds the control lblStock in the form view returns the correct control and I can set the text and color appropriately.

Parwej Ahamad6-Oct-11 18:26

Parwej Ahamad

6-Oct-11 18:26

One more thing I would like to ask, Are you sure your custom handler is executing when you try to access routing URL?

Please post here Web.Config Handler configuration section too and go through once below descussion.

http://stackoverflow.com/questions/4320247/asp-net-custom-httphandler-and-url-routing[^]

Parwej Ahamad

Dominick Marciano7-Oct-11 16:21

Asp.net and uploading large files

7-Oct-11 16:21

<httpModules>

<add name="ScriptModule" type="System.Web.Handlers.ScriptModule, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>

<add name="QueryStringModule" type="QueryStringModule"/>

<add name="UrlRoutingModul" type="System.Web.Routing.UrlRoutingModule, System.Web.Routing, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>

</httpModules>

<system.webServer>
		<validation validateIntegratedModeConfiguration="false"/>
		<modules>
                         ...
			<add name="UrlRoutingModule" type="System.Web.Routing.UrlRoutingModule, System.Web.Routing, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />
		</modules>
		<handlers>
			...
                        <add name="UrlRoutingHandler" preCondition="integratedMode" verb="*" path="UrlRouting.axd" type="System.Web.HttpForbiddenHandler, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
		</handlers>
</system.webServer>

Ahmad Safwat4-Oct-11 14:30

Ahmad Safwat

4-Oct-11 14:30

I'm using Asp.net 3.5 on Godaddy, and I need a way for users to upload large files using Asp.net FileUpload Control, I don't want to use a third party

I've changed the value of maxRequestLength in web.config as follows:
<httpRuntime executionTimeout="1100" maxRequestLength="512000" />

but when uploding a file of about 32 MB, upload process goes well (I can see percentage for the process in the down-left corner of Chrome browser), but after a while, the process restarts !! and after going with upload for a while page crashes without errors (just telling me that page cannot be displayed)

The same happens on IE (but of course without percentage)

Please help me to solve this issue without third party

uspatel4-Oct-11 21:31

uspatel

4-Oct-11 21:31

It may helps you

string filename = fuUploadVideo.FileName;
            string path = Server.MapPath("Uploads4");
            string strFinalFileName = Path.GetFileName(fuUploadVideo.FileName);
            long FileLength = fuUploadVideo.PostedFile.ContentLength;
            long uploadchunklimit;
            int SizeLimit = (int)FileLength;
            if (FileLength <= 1024)
            {
                uploadchunklimit = 1;
                SizeLimit = (int)FileLength;
            }
            else if (FileLength > 1024)
            {
                uploadchunklimit = FileLength / 1024;
                SizeLimit = 10;
            }
            else if (FileLength <= 10240 && FileLength > 1024)
            {
                uploadchunklimit = FileLength / 1024;
            }
            else
            {
                uploadchunklimit = FileLength / 1024;
            }

            long lngSize = (long)SizeLimit;
            lngSize = 1024 * 1024;
            string ext = Path.GetExtension(fuUploadVideo.PostedFile.FileName);

            fuUploadVideo.PostedFile.SaveAs(Server.MapPath("~\\Uploads4\\" + filename));

Ahmad Safwat5-Oct-11 2:55

Ahmad Safwat

5-Oct-11 2:55

Thank you for your reply, but I don't understand how this code helps me

Ravindra Bisen5-Oct-11 6:41

Ravindra Bisen

5-Oct-11 6:41

you can use fileuploader control