Re: Looking for solution / article for multi parameters search engine - ASP.NET Discussion Boards

i'm asking how to get password using emailid given in the textbox..
other things are alright

Make sure the MailMessage.From is a valid email address that exists on the SmtpMail.SmtpServer.
Replace it with your own emailid to check if it works.
Allow relaying for your MailMessage.From address
Allow relaying for your IP Address
(I recommend that u see your specific mail server documentation for this or contact ur administrator).

FemDev
Don't forget to vote if you like answer

Hi all,

i find so many expert here so that is why i m posting my question here i would like abt LINQ.Is it going to come in demand in future i want suggestion from u guys.I know basics of it should i explore this and will this be help ful for my future.

Thanks and regards,

Amit Patel

Erhm, yes and yes....

LINQ will be quite helpfull if you use collections (no matter what collections) and will increase both performance of your software, and the time it takes to develop your software.

.: I love it when a plan comes together :.
http://www.zonderpunt.nl

Why do you expect others to worry about your career? Please post only relevant technical questions here. For other things, use The Lounge.

Hello, Im tryin to build some search engin using asp.net/C# and can't find any article. i have table in SQL DB with customers and want to create search engine with 3 parameters (name, state, city) is anyone know good article or had a solution for that?

you're talking about basic SQL here. Do you own any books on SQL ?

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.

Yes, i have some books but none of them explain how to build search engine....if you talk about the select parameters, i think i know what to write

ALTER PROCEDURE dbo.advancedSearching
	@indexKindword varchar(250) = NULL,
	@indexKindword2 varchar(250) = NULL,
	@indexKindword3 varchar(250) = NULL
	
AS
BEGIN
	SELECT [companiesIndex].indexCatID, [companiesIndex].compantName, [companiesIndex].companyAddress, [companiesIndex].companyState, [companiesIndex].companyCity, [companiesIndex].companyPhone, [companiesIndex].companyFax, [companiesIndex].companyWebsite, [companiesIndex].keyWords
FROM companiesIndex
WHERE ([companiesIndex].cat LIKE '%' + @indexKindword + '%' OR [companiesIndex].cat IS NULL
AND [companiesIndex].companyState LIKE '%' + @indexKindword2 + '%' OR [companiesIndex].companyState IS NULL
AND [companiesIndex].companyCity LIKE '%' + @indexKindword3 + '%' OR [companiesIndex].companyCity IS NULL)
ORDER BY [compantName] 
END
	RETURN

but i dont know how to handle the results in the aspx.cs page (i know how to handle one parameter search)

protected void Page_Load(object sender, EventArgs e)
    {
        if (Request.QueryString["searchString"] != null)
        {
            DisplaySearchResults(Request.QueryString["searchString"]);
            Label50.Text = Repeater1.Items.Count.ToString();
        }
    }
    public void DisplaySearchResults(string strSearch)
    {
        SqlConnection newconn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["ASPNETDBConnectionString"].ConnectionString);
        SqlCommand cmd = new SqlCommand("spSearchByString", newconn);
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.AddWithValue("@SearchString", strSearch);
        newconn.Open();

        Repeater1.DataSource = cmd.ExecuteReader();
        Repeater1.DataBind();

        newconn.Close();
        newconn.Dispose();
    }

How you translate this page to get 3 parameters?

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

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

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

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.

Because this is the only way to fix this problem.

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

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.

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