Advanced Search in database [modified] - ASP.NET Discussion Boards

Are you trying to track the number of times the banner is clicked, or the number of individual users who've clicked on the banner? The two aren't necessarily the same.

I'm not a stalker, I just know things. Oh by the way, you're out of milk.

Forgive your enemies - it messes with their heads

My blog | My articles | MoXAML PowerToys | Onyx

Agreed..., but that is more or less just a filtering mechanism layered on the same click counter, isn't it? (I haven't had to do something like this in a very long time)

Now he has to go and re-read his homework for the weekend...

I wasn't, now I am, then I won't be anymore.

Indeed it is - but I like to help them to realise that they should think the problem through some more.

I'm not a stalker, I just know things. Oh by the way, you're out of milk.

Forgive your enemies - it messes with their heads

My blog | My articles | MoXAML PowerToys | Onyx

the number of times the banner is clicked.

Store the number somewhere and increment when clicked. Again, what difficutlties are you having?

I know the language. I've read a book. - _Madmatt

A simple table in a database and an incrementing update statement will do nicely then.

I'm not a stalker, I just know things. Oh by the way, you're out of milk.

Forgive your enemies - it messes with their heads

My blog | My articles | MoXAML PowerToys | Onyx

test

hello,
I want code in asp.net using c# for web application searching in the database for articles.
for example: the sql server database contain columns for (Title, SubTitle, Author, Category, Date, Lead, Body, ImageURL,...) for the articles...
and I want to make web form which can search in this database with more option where user can search by Title, SubTitle, Author, Category, Date, and so on....
can I get help, pls...
I use linq technique

I made these files

Searhc.aspx
<%@ Page Title="" Language="C#" MasterPageFile="~/Admin/Templates/Level_Two.master"
    AutoEventWireup="true" CodeFile="Search.aspx.cs" Inherits="Admin_CMS_Article_Search" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="Server">
    <style type="text/css">
        
    </style>
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="Server">
    <table cellpadding="0" cellspacing="0" width="100%">
        <tr>
            <td height="15">
                &nbsp;
            </td>
        </tr>
        <tr>
            <td class="Searchby" height="50">
                Search by Article Name:
            </td>
        </tr>
        <tr>
            <td>
                &nbsp;
            </td>
        </tr>
        <tr>
            <td>
                <table cellpadding="0" cellspacing="0" class="style1">
                    <tr>
                        <td width="100">
                            &nbsp;</td>
                        <td>
                <asp:TextBox ID="txtSearch" runat="server" Width="396px"></asp:TextBox>
                        </td>
                    </tr>
                </table>
            </td>
        </tr>
        <tr>
            <td height="30">
                &nbsp;
            </td>
        </tr>
        <tr>
            <td>
                <table cellpadding="0" cellspacing="0" class="style1">
                    <tr>
                        <td width="250">
                            &nbsp;</td>
                        <td>
                <asp:Button ID="btnSearch" runat="server" Text="Search" OnClick="btnSearch_Click" />
                        </td>
                    </tr>
                </table>
            </td>
        </tr>
        <tr>
            <td>
                &nbsp;
            </td>
        </tr>
        <tr>
            <td>
                <asp:GridView ID="grdResults" runat="server" AutoGenerateColumns="False" EnableModelValidation="True"
                    GridLines="None" ShowFooter="True" OnRowDataBound="grdResults_RowDataBound">
                    <Columns>
                        <asp:TemplateField>
                            <ItemTemplate>
                                <table width="100%" border="0" cellspacing="0" cellpadding="0">
                                    <tr>
                                        <td>
                                            <ul class="Titlelist">
                                                <li>
                                                <asp:HyperLink ID="lnkTitle" runat="server">Title</asp:HyperLink>
                                                </li>
                                            </ul>
                                        </td>
                                    </tr>
                                    <tr>
                                        <td class="Leadtxt">
                                            <asp:Literal ID="ltrlLead" runat="server"></asp:Literal>
                                        </td>
                                    </tr>
                                    <tr>
                                        <td>
                                            <hr style="width: 90%; height: 2px;" />
                                        </td>
                                    </tr>
                                </table>
                            </ItemTemplate>
                        </asp:TemplateField>
                    </Columns>
                </asp:GridView>
            </td>
        </tr>
        <tr>
            <td>
                &nbsp;
            </td>
        </tr>
        <tr>
            <td align="center">
                <asp:Label ID="lblResults" runat="server" CssClass="Leadtxt"></asp:Label>
            </td>
        </tr>
        <tr>
            <td>
                &nbsp;</td>
        </tr>
    </table>
</asp:Content>

Search.aspx.cs:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

public partial class Admin_CMS_Article_Search : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void btnSearch_Click(object sender, EventArgs e)
    {
        thedb.islamonlineDataClassesDataContext db = new thedb.islamonlineDataClassesDataContext();
        List<thedb.Article> articles = (from art in db.Articles where art.Title.Contains(txtSearch.Text.Trim()) select art).ToList();
        grdResults.DataSource = articles;
        grdResults.DataBind();

        if (articles.Count == 0)
        {
            lblResults.Text = "Sorry, No Article Found for " + txtSearch.Text.Trim();
            lblResults.Visible = true;
        }
        else
        {
            lblResults.Visible = false;
        }
    }
    protected void grdResults_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            HyperLink lnkTitle = (HyperLink)e.Row.Cells[0].FindControl("lnkTitle");
            Literal ltrlLead = (Literal)e.Row.Cells[0].FindControl("ltrlLead");

            lnkTitle.Text = DataBinder.Eval(e.Row.DataItem, "Title").ToString();
            lnkTitle.NavigateUrl = "~/Admin/CMS/Article/Show.aspx?id=" + DataBinder.Eval(e.Row.DataItem, "id").ToString();
            ltrlLead.Text = DataBinder.Eval(e.Row.DataItem, "Lead").ToString();
        }
    }
}

so, user can search by Title only... now I want to give user search option by title, date, author, subtitle, body contain...

modified on Saturday, January 1, 2011 9:41 AM

Please Use "pre" tag to wrapped your code to make it readability.

thanks RaviRanjankr..
I did it..

hassanmorsy wrote:
I want code in asp.net using c#

It is extremely ride to start demanding code to solve your problem. I doubt you get many responses.

Format your code snippets. Again, you will get few responses if no one can read your question.

I know the language. I've read a book. - _Madmatt

thanks Mark, I finished formating the code.. now it appear more readable...

it's not possible to write whole code for you but you can focus on given ideas

I suggest you to customize your code by adding functionality to user to select their option as you mention title,date,author,subtitle,body. for this goal you can use various control Checkbox,Combobox or even Radiobutton with assigning corresponding value.
when use select any one option then Value should fire and passed it into parameter where you are using "Title" [Right now].
Please navigate the given link to know more Link[^]

modified on Tuesday, January 4, 2011 11:55 AM

Can't you use Full text search capability of SQLServer? Check Blog post at this[^] URL for possible solution

in my page , Showing a gridview which has four coloums all four coloums have combobox. At begining of page defaultly showing single row And if want more than one row clicka a button for adding new row ... for these scnario , what are the asp components used ... And How can acheive these ..
.
Thans

Use templated columns in teh grid to display the comboboxes. When adding a row add an emprty, or default, row to the datasource bound to the grid and rebind it.

I know the language. I've read a book. - _Madmatt

You will find lots of solution around the .net if you try to find it.

Here's my search work for you. change Your program accordingly.

First[^]

Second[^]

Third[^].

Regards,
Hiren.

My Recent Article: - Way to know which control have raised a postback
My Recent Tip/Trick: - Building Hierarchy using Recursive CTE

In my asp .net web application,I have to use all languages.How it will be done..Help me..

You mean localization[^], don't you?

There are very good articles on Globalisation and Localisation, available at CP itself. Have a look to the links
Globalization and localization demystified in ASP.NET 2.0

ASP.NET 2.0 Globalization & Localization solution

Hope these helps

Cheers!!
Brij
Visit my Blog: http://brijbhushan.net

My latest Articles: Give it a view
Data linking with jQuery

Exploring Client Callback

Hi to all,

I'm having a problem that I hope someone can help me with.

I'm trying to export data from an asp.net page to an Excel file and I'm basically just outputting HTML to the XLS file and let Excel interprets it, by using this type of coding:

HttpContext.Current.Response.Clear();
HttpContext.Current.Response.ClearHeaders();
HttpContext.Current.Response.ClearContent();
HttpContext.Current.Response.Charset = "utf-8";
HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.GetEncoding("Windows-1252");
HttpContext.Current.Response.AddHeader("content-disposition", String.Format("attachment; filename={0}", "\"File.xls\""));
HttpContext.Current.Response.ContentType = "application/ms-excel";

using (StringWriter sw = new StringWriter())
{
	using (HtmlTextWriter htw = new HtmlTextWriter(sw))
	{
		gridview.RenderControl(htw);
		
		HttpContext.Current.Response.Write(sw.ToString());
		HttpContext.Current.Response.Flush();
		HttpContext.Current.Response.End();
	}
}

However, although this is doing fine for exporting raw text, I now have to export to the same Excel file an image. However, the same kind of method I'm using right now only seems to insert a "linked" image, I mean, the image appears in the file, however, the user viewing the file has to be online since it's a direct link to the file in the server. I would like to able to "embeded" the image in the file, just like how it's made when you insert manually an image using Excel.

However, after some online research I can't seem to find any solution for this. Can anybody help me out here and point me to what a possible solution would be?

I can't use Microsoft.Office.Interop.Excel library, and a third party software isn't advisable also, that's what made me try out the HTML output solution, which worked ok for the text. But now, for inserting an image, what can I do? Is it possible to achieve what I pretend?

Thanks in advance.

hello
I work on a intranet site of management review, to insert the markes I have files for each module I want only the professor of module has the right
access to his file.How ?

Thanks

Can you elaborate your requirement? Then It will better to answer your question.

Parwej Ahamad
ahamad.parwej@gmail.com

Hi ;
1-files visible to the people of Registration Service
2-files for teachers:
semester 1
file visible to teachers of Module 1
file visible to teachers of Module2
file visible to teachers of Module 3
semester 2
file visible to teachers of Module 4
file visible to teachers of modules 5
file visible to teachers of Module 6
3- the other file are visible to all users
Thanks

You can use Roles. Have a look at this[^].