ASP.NET

Re: Looking for solution / article for multi parameters search engine

11-Nov-09 22:22

I have already written one this month. Just have a look..

See the signature below to find it. Wink | ;)

Abhishek Sur
Don't forget to click "Good Answer" if you like this Solution.
My Latest Articles-->
Simplify Code Using NDepend
Basics of Bing Search API using .NET
Microsoft Bing MAP using Javascript

Abhishek Sur11-Nov-09 22:29

Crystal Reports showing blank page after few hours in Asp.net

11-Nov-09 22:29

Ohh... you might be asking for how to search using SQL ??

is this is so, read basic books on SQL.

Let me give you one instance on how the query look like:
Say you want to search name, state and city based on variables. If variables doesnt have value, your search doesnt need to hamper. Do like this :

SELECT * FROM TABLE
WHERE (CASE WHEN ISNULL(@P_NAME,'') = '' THEN '' ELSE NAME END)= ISNULL(@P_NAME,'')
AND (CASE WHEN ISNULL(@P_CITY,'') = '' THEN '' ELSE CITY END)= ISNULL(@P_CITY,'')
AND (CASE WHEN ISNULL(@P_STATE,'') = '' THEN '' ELSE STATE END)= ISNULL(@P_STATE,'')

Note : It could be optimized.

Thus if you ask 
@P_Name = 'xxx'
@P_CITY = NULL
@P_STATE = 'yyyy'

It will not consider @P_CITY as search criteria..
Hopefully this gives you an idea.

Abhishek Sur
Don't forget to click "Good Answer" if you like this Solution.
My Latest Articles-->
Simplify Code Using NDepend
Basics of Bing Search API using .NET
Microsoft Bing MAP using Javascript

hammadahsan11-Nov-09 20:55

hammadahsan

11-Nov-09 20:55

Crystal Reports problem in .Net 2.0 showing blank pages after few hours

problem always resolve after restarting IIS

Please note that many users access application at a time.

please suggest any permanent solution

Re: Crystal Reports showing blank page after few hours in Asp.net

sashidhar11-Nov-09 21:46

sashidhar

11-Nov-09 21:46

hammadahsan wrote:
problem always resolve after restarting IIS

Why Would you do tht..!IIS should run at background..!If You restart the IIS..!i.e. you a re restarting the application..!

LatestArticle :Log4Net
Why Do Some People Forget To Mark as Answer .If It Helps.

Re: Crystal Reports showing blank page after few hours in Asp.net

hammadahsan11-Nov-09 22:04

hammadahsan

11-Nov-09 22:04

Because this is the only way to fix this problem.

Re: Crystal Reports showing blank page after few hours in Asp.net

Abhishek Sur11-Nov-09 22:07

Re: Crystal Reports showing blank page after few hours in Asp.net

11-Nov-09 22:07

I think the problem might be with memory.

Try to see what you are placing into Session or application when you call the Crystal Report. I think the memory is not cleared properly when reports are opened.. and thus killing the solution..

You can also use Separate Application pool area rather than using the shared one to ensure have more memory.

But you should really look into the memory management for your solution. Rose | [Rose]

Abhishek Sur
Don't forget to click "Good Answer" if you like this Solution.
My Latest Articles-->
Simplify Code Using NDepend
Basics of Bing Search API using .NET
Microsoft Bing MAP using Javascript

Shameel12-Nov-09 6:53

Shameel

12-Nov-09 6:53

Either your application is getting killed or your database (or both). Your solution does not scale up properly to accommodate more simultaneous users. To find out a "permanent" solution, you need to first find out where the problem is and what the problem is.

Strange Issues on ASP.NET App

Vimalsoft(Pty) Ltd11-Nov-09 20:41

11-Nov-09 20:41

Good Day All

I have a ASP.NET app. There is a button one of the pages. I have placed a Break point in the Click event and when i click the Button it does not even go to the Break Point it shows this

http://www.tiyaneproperties.co.za/SSIS/Strange.jpg[^]

Thanks

Vuyiswa Maseko,

Spoted in Daniweb-- Sorry to rant. I hate websites. They are just wierd. They don't behave like normal code.

C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.com
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/

Christian Graus11-Nov-09 21:02

Christian Graus

11-Nov-09 21:02

Is the URL shown correct ? Are you connected to the web ?

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

Vimalsoft(Pty) Ltd11-Nov-09 21:08

11-Nov-09 21:08

Good Day

The URL is Correct. When the Button is Clicked this will import the xml File. This works in other Browsers. yes am Connected to web.

Thanks

Christian Graus11-Nov-09 21:11

Christian Graus

11-Nov-09 21:11

Import an XML file from where ? Have you put a breakpoint in page load to see if any of your code is run ? What if you refresh the page when it fails ?

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

Vimalsoft(Pty) Ltd11-Nov-09 22:35

11-Nov-09 22:35

When the Page load the the Break point works and when i click the Button, it gave that strange page. When i refresh the page, it goes back.

Vimalsoft(Pty) Ltd11-Nov-09 23:40

11-Nov-09 23:40

That is the First thing i did when i got this problem. I have resolved the Problems. The File that i wanted to import when that button is Clicked was too big. So i have resolved this by adding the Following entry in the web config in the System.web Section

< httpRuntime maxRequestLength="102400" />

Thanks once more time

Abhishek Sur11-Nov-09 22:39

11-Nov-09 22:39

Are you submitting the page to a location using form action

or have you manually modified your form onsubmit event ?

Abhishek Sur
Don't forget to click "Good Answer" if you like this Solution.
My Latest Articles-->
Simplify Code Using NDepend
Basics of Bing Search API using .NET
Microsoft Bing MAP using Javascript

Vimalsoft(Pty) Ltd11-Nov-09 22:50

11-Nov-09 22:50

here is my page definition am not sure what is wrong this works on other machines

<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="ImportTimetable.aspx.cs" Inherits="ImportTimetable" Title="o!Booking Version 3" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
    <span>
        <br />
        <table border="0" cellpadding="2" cellspacing="0" style="font-family: Verdana">
            <tr>
                <td style="width: 72px">
                    <asp:Image ID="Image1" runat="server" Height="72px" ImageUrl="~/Images/CDICons/timetable72.png"
                        Style="behavior: url(PngBehaviour.htc)" Width="72px" /></td>
                <td>
                </td>
                <td style="width: 600px">
                    <span style="font-size: 13pt"><strong>Import Timetables<br />
                    </strong><span style="font-size: 8pt">Perform bulk bookings for class and/or exam timetables.
                        For a description of the file formats, see the online help.</span></span></td>
            </tr>
        </table>
        <span style="font-family: Verdana">
            <hr align="left" width="800" />
            <br />
        </span></span>
    <table border="0" cellpadding="0" cellspacing="0" style="font-size: 10pt; width: 82%;
        font-family: Verdana">
        <tr>
            <td style="width: 195px; height: 22px;" valign="top">
                Import Timetable</td>
            <td style="height: 22px">
                <asp:FileUpload ID="FileUploadTimetable" runat="server" Width="421px" />
                <asp:Button ID="btnImport" runat="server" BackColor="Transparent" BorderStyle="None"
                    Font-Names="Verdana" Font-Size="10pt" OnClick="btnImport_Click" Text="[Import]"
                    Width="64px" />
                <br />
                </td>
        </tr>
    </table>
    <br />
    <span style="font-size: 10pt; font-family: Verdana">
            <asp:Label ID="lblStatus" runat="server" Font-Names="Verdana" Font-Size="10pt" ForeColor="#8080FF"
        Width="100%"></asp:Label><br />
    </span>
 
</asp:Content>

Thanks

Vimalsoft(Pty) Ltd11-Nov-09 23:41

11-Nov-09 23:41

I got the Solution. please check the Reply to colin

Thanks for your time

Abhishek Sur11-Nov-09 23:51

11-Nov-09 23:51

you are most welcome ... Smile | :)

so it is the problem with Response size .. Wink | ;)

Abhishek Sur
Don't forget to click "Good Answer" if you like this Solution.
My Latest Articles-->
Simplify Code Using NDepend
Basics of Bing Search API using .NET
Microsoft Bing MAP using Javascript

Vimalsoft(Pty) Ltd11-Nov-09 23:52

11-Nov-09 23:52

Yes

Thanks Smile | :)

Shameel12-Nov-09 6:57

Shameel

12-Nov-09 6:57

The problem is not with the response size, it is with the request size, which is by default 4MB, if you try to upload anything greater than that, your request is simply denied and you get this strange behavior.

Abhishek Sur12-Nov-09 8:44