Advanced search .... - ASP.NET Discussion Boards

Re: Apply them only in content page.

pss.srinivasan16-Nov-09 20:12

pss.srinivasan

16-Nov-09 20:12

Sample Code of my Content page

<%@ Page Language="C#" MasterPageFile="~/common/MasterPage.master" AutoEventWireup="true"<br />
    CodeFile="AdminSetting.aspx.cs" Inherits="admin_AdminSetting" %><br />
<br />
<%@ Register TagPrefix="igtbl" Namespace="Infragistics.WebUI.UltraWebGrid" Assembly="Infragistics2.WebUI.UltraWebGrid.v7.3, Version=7.3.20073.1043, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb" %><br />
<br />
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="Server" ><br />
<br />
    <table border="0" cellpadding="0" cellspacing="0" style="height: 100%" align="left"><br />
     <br />
        <tr><br />
            <td style="height: 10px; width: 903px;" valign="top"><br />
                <asp:ScriptManagerProxy id="ScriptManagerProxy1" runat="server"><br />
                    <scripts><br />
                    <asp:ScriptReference Path="~/scripts/Admin_grid.js" /><br />
                </scripts><br />
                </asp:ScriptManagerProxy><br />
            </td><br />
            <td><br />
            </td><br />
        </tr><br />
</table><br />
</asp:Content>

in this page where i want to apply them?
<link href="../App_Themes/Blue/DefStyles.css" rel="stylesheet" type="text/css" />

Re: Apply them only in content page. [modified]

sashidhar16-Nov-09 20:18

sashidhar

16-Nov-09 20:18

If You Dont Know Where to write ..!I think this is style sheet..!
So Go to the design view of the required page drag and drop the style sheet on the page..!

If i Misunderstood please explain in detail..!
Exactly what do u want to do?
What did you do?
When is the error comming..?

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

Re: Apply them only in content page.

pss.srinivasan16-Nov-09 20:30

pss.srinivasan

16-Nov-09 20:30

thnx a lot friend

So Go to the design view of the required page drag and drop the style sheet on the page..!

it is working for me.

Re: Apply them only in content page.

sashidhar16-Nov-09 20:31

sashidhar

16-Nov-09 20:31

pss.srinivasan wrote:
thnx a lot friend

Any Time..! Thumbs Up | :thumbsup:

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

Re: Apply them only in content page.

RajpootRohan16-Nov-09 20:20

RajpootRohan

16-Nov-09 20:20

Hi,

You can write this in

<br />
<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server"><br />
</asp:Content><br />

of the content page.

cheers,
sneha

Re: Apply them only in content page.

pss.srinivasan16-Nov-09 22:28

pss.srinivasan

16-Nov-09 22:28

hi what u send like that i written code but this error coming

Error 40
Cannot switch views: Validation (XHTML 1.0 Transitional):
Element 'link' cannot be nested within element 'td'.

my code is like this

<br />
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="Server" ><br />
    <link href="../App_Themes/Blue/DefStyles.css" rel="stylesheet" type="text/css" /><br />
</asp:Content><br />

Re: Apply them only in content page. [modified]

RajpootRohan16-Nov-09 23:41

RajpootRohan

16-Nov-09 23:41

Hi,

You must be having a ContentPlaceHolder tag in the of the master page, you are using. Then in the content page there must be content tag having that contentPlaceHolderID. You can put the link tag in that <content>.

cheers,
sneha

modified on Tuesday, November 17, 2009 6:14 AM

Advanced search ....

RajpootRohan16-Nov-09 19:54

RajpootRohan

16-Nov-09 19:54

Hi to all,

I am working on an advanced search module. It consist of 6 fields given to user to fill and search. The user can fill any one or two and may be all the fields to search. Some fields are text based and some are float.

The logic is that after taking the input, the application should check which fields are filled up by the user. And neglect the fields which are not filled from the sql query.

What I did is that, I fetched all the values from the textboxes and the values which are not empty has been added to a arraylist. Now I got the filledup values. But application will know that it is productid, description or what...

Please assist me.

protected void Button1_Click(object sender, EventArgs e)
{

        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["newcon"].ConnectionString);
        SqlCommand cmd = new SqlCommand();
        cmd.Connection = con;

    //find out which feilds are not null, then make search on the basis of those feilds
    //Now the feilds which are not empty are:

        ArrayList arl = new ArrayList();
        if (TextBox1.Text.Trim() != "")
    {
        arl.Add("productid");
    }
        if (TextBox2.Text.Trim() != "")
    {
        arl.Add("sh_desc");
    }
        if (TextBox3.Text.Trim() != "")
    {
        arl.Add("weight");
    }
        if (TextBox4.Text.Trim() != "")
    {
        arl.Add("length");
    }
        if (TextBox5.Text.Trim() != "")
    {
        arl.Add("width");
    }
        if (TextBox6.Text.Trim() != "")
    {
        arl.Add("height");
    }

    //Now take out the items from the arraylist

    for (int i = 0; i <= arl.Count; i++ )
    {
        if (arl[i].ToString().StartsWith("productid"))
        {

        }
    }
    cmd.CommandText = "select sh_desc,productid,price from PRODUCTS where ";

        cmd.Connection.Open();

        dt = new DataTable();
        dt.Columns.Add("REF", typeof(string));
        dt.Columns.Add("Description", typeof(string));
        dt.Columns.Add("Price", typeof(float));
        SqlDataReader rdr = cmd.ExecuteReader();
        while (rdr.Read())
        {
            pr_id = (rdr["productid"]).ToString();
            testsh_desc = (rdr["sh_desc"]).ToString();
            test_price = Convert.ToSingle(rdr["price"]);

            DataRow myrow = dt.NewRow();

            myrow["REF"] = pr_id;
            myrow["Description"] = testsh_desc;
            myrow["Price"] = test_price;

            dt.Rows.Add(myrow);
            dt.AcceptChanges();
            Session["sear"] = dt;
        }

        if (testsh_desc != null)
        {
            Response.Redirect("~/Results.aspx");
        }
        else
        {
            Response.Redirect("~/ErrorResult.aspx");
        }
        cmd.Connection.Close();
}

cheers,
sneha

Re: Advanced search ....

Amit Patel198516-Nov-09 19:58

Amit Patel1985

16-Nov-09 19:58

Hi ,

I think u can prepare u query based on input how many valuse is filled by the user based on this u can concat string. and get result

Thanks and regards,

Amit PAtel

Re: Advanced search ....

RajpootRohan16-Nov-09 20:04

RajpootRohan

16-Nov-09 20:04

Hi Amit,

Thanks for the reply. I am the count of the values filled by the user through arraylist. Suppose I get 3 values but how I will know that these 3 values are which values. Is it a product id, description and short description or it is price, weight and length.

Please provide me an example if you have..I am confused..

cheers,
sneha

Re: Advanced search ....

Amit Patel198516-Nov-09 20:23

Amit Patel1985

16-Nov-09 20:23

Hi sneha,

what i am saying u need to put if and else in ur code.

intially ur query will be like this

String query = Select * from urtablename where

if(product id!=null)
{
query = query +"product id = input"
}

if(price)
{
query =query+ add ur query;
}
thanks and regars

Re: Advanced search ....

Christian Graus16-Nov-09 20:09

Christian Graus

16-Nov-09 20:09

I suspect your best bet is to build your SQL based on what fields were entered.

Doing a response.redirect obviously means throwing away the results you've found, and the data that has been entered.

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.

Re: Advanced search ....

RajpootRohan16-Nov-09 20:17

RajpootRohan

16-Nov-09 20:17

you mean to say if I have 3 fields. Then I should use all the permutations and combinations.

That is if

all three are filled
none is filled
1 is not filled , 2 & 3 are filled
.
.
.
.
.

cheers,
sneha

Re: Advanced search ....

Amit Patel198516-Nov-09 20:24

Amit Patel1985

16-Nov-09 20:24

Re: Advanced search ....

RajpootRohan16-Nov-09 20:31

RajpootRohan

16-Nov-09 20:31

Ok I got it. I will try like this and came back to you with the results. Smile | :)

cheers,
sneha

Re: Advanced search ....

Amit Patel198516-Nov-09 20:31

Amit Patel1985

16-Nov-09 20:31

Hi
u can uee dictionary collection to store key value pair.

Thanks and regards,

Amit

Re: Advanced search ....

sashidhar16-Nov-09 20:32

sashidhar

16-Nov-09 20:32

I think You have to work on the query..!
make the query parameter default as null in the store procedure
and write the store procedure depending on the params..!

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

Re: Advanced search ....

RajpootRohan16-Nov-09 21:38

RajpootRohan

16-Nov-09 21:38

Hi,

I did that but every time result was all the products.

ALTER PROCEDURE [dbo].[ap_SearchProduct]
(
@productid nvarchar(100) = null,
@product_type nvarchar(100) = null,
@sh_desc nvarchar(4000) = null,
@weight float = null,
@length float = null,
@width float = null,
@height float = null
)

as

    SET NOCOUNT ON

    SELECT productid,sh_desc,price FROM PRODUCTS e
        WHERE
		(@productid IS NULL OR e.productid = @productid)
		OR (@product_type IS NULL OR e.product_type = @product_type)
		OR (@sh_desc IS NULL OR e.sh_desc = @sh_desc)
        OR (@weight IS NULL OR e.weight = @weight)
        OR (@length IS NULL OR e.length = @length)
        OR (@width IS NULL OR e.width = @width)
        OR (@height IS NULL OR e.height = @height)
return

cheers,
sneha

Re: Advanced search ....

sashidhar16-Nov-09 21:45

sashidhar

16-Nov-09 21:45

You have to keep cases..!

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

Re: Advanced search ....

sashidhar16-Nov-09 22:07

sashidhar

16-Nov-09 22:07

You have to go for 6 cases..!For one Case..!

SELECT productid,sh_desc,price FROM PRODUCTS e
        
WHERE   productid = CASE WHEN @productid IS NULL
                                       THEN productid
                                       ELSE @productid
                                  END
AND.....

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

Session management

Amit Patel198516-Nov-09 19:43

Amit Patel1985

16-Nov-09 19:43

Hi All,

how gmail or yahoo maintain the session of different server because user can get its mail from any server.

Thanks and regards,

Amit Patel

Re: Session management

Christian Graus16-Nov-09 20:11

Christian Graus

16-Nov-09 20:11

What do you mean ? You mean, how to set up a web farm ?

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.

Re: Session management

Amit Patel198516-Nov-09 20:27

Amit Patel1985

16-Nov-09 20:27

hi ,

yes when i login we always retrive data from many server through only one session.
thanks and regards

Amit PAtel

Re: Session management

Abhijit Jana16-Nov-09 20:31

Abhijit Jana

16-Nov-09 20:31

Amit Patel1985 wrote:
yes when i login we always retrive data from many server through only one session.
thanks and regards

They may use OutProc Session mode !
Have a look into this,
Exploring Session in ASP.Net[^]

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.

full text search example implement in .net

Member 287607116-Nov-09 19:42

Member 2876071

16-Nov-09 19:42

hello
i want to implement full text search technique in asp.net
pls provide me example

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.