Introduction
Search engine means , you can search any item from the database. Basically a search engine depends on various algorithms. In this project we use simple search algorithm. That algorithm is
First you fill the table by some value like insert title, description, URL, keywords etc. After feeding the data you can search in it.
Software requirement of the project are
1. Visual Studio 2010 with sql server 2008
Download
mail to me : narenkumar851@gmail.com for project source code
Designing patterns
1. First prepare master page for outer structure.
2. Search item using TextBox from database also take output in Gridview.
3. Design Admin Login page for feeding data into database table.
4. Also set permission for admin (admin can remove item from database table)
Search Code using stored procedure
<%@ Page Title="Home Page" Language="C#" MasterPageFile="~/Site.master" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
<asp:Content ID="HeaderContent" runat="server" ContentPlaceHolderID="HeadContent"></asp:Content><asp:Content ID="BodyContent" runat="server" ContentPlaceHolderID="MainContent"> <p> Enter Text Here : <asp:TextBox ID="TextBox1" runat="server" Height="32px" Width="237px"></asp:TextBox> </p> <p> <asp:Button ID="Button1" runat="server" Height="33px" onclick="Button1_Click" Text="Search" Width="122px" /> </p> <p> <asp:GridView AutoGenerateColumns ="false" ID="GridView1" runat="server" Height="180px" Width="426px" GridLines ="None" AllowPaging="True" onpageindexchanging="GridView1_PageIndexChanging" PageSize="5" ShowHeader="False"> <Columns> <asp:TemplateField> <ItemTemplate> <asp:HyperLink ID="HyperLink1" runat="server" Text ='<%# Eval("title") %>' NavigateUrl='<%# Eval("URL") %>'/> <br /> <asp:Label ID="Label1" runat="server" Text='<%# Eval("title") %>'/><br /> <asp:Label ID="description" runat="server" Text='<%# Eval("metaDescription") %>'/> <asp:Label ID="Label2" runat="server" Text='<%# Eval("keywords") %>'/> </ItemTemplate> </asp:TemplateField> </Columns> </asp:GridView> </p><p> </p></asp:Content>Csharp File code
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Configuration;
using System.Data;
public partial class _Default : System.Web.UI.Page
{
SqlConnection con = new SqlConnection();
SqlCommand cmd = new SqlCommand();
DataSet ds = new DataSet();
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
loadgrid();
}
private void loadgrid()
{
con.ConnectionString = connection.Connectionstring;
con.Open();
cmd.CommandText = "GetEngine";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@parameter", TextBox1.Text);
cmd.Connection = con;
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds);
GridView1.DataSource = ds;
GridView1.DataBind();
}
protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
GridView1.PageIndex = e.NewPageIndex;
loadgrid();
}
}
The keywords const and goto are reserved, even though they are not currently used. This may allow a Java complier to produce better error message if these Java keywords incorrectly appear in programs.
