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 isFirst 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 2008Download
mail to me : narenkumar851@gmail.com for project source codeDesigning 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();
}
}
Tidak ada komentar:
Posting Komentar