<%@ Page Language="C#" CodePage="1200" %>
<%@ import Namespace="System.Data.OleDb" %>
<%@ import Namespace="System.Data" %>
<script runat="server">
void Page_Load(object sender, EventArgs e) {
}
void btnSearch_Click(object sender, EventArgs e) {
/* OleDbConnection odbsearch = new OleDbConnection();
OleDbCommand cmdsearch = new OleDbCommand();
odbsearch.ConnectionString = "Provider=\"MSIDXS\";Data Source=\"learning\";";
cmdsearch.Connection = odbsearch;
cmdsearch.CommandText = "SELECT doctitle,filename,vpath,rank,characterization FROM scope() WHERE FREETEXT(Contents, '"+txtSearch.Text.Trim()+"')ORDER BY rank desc";
odbsearch.Open();
OleDbDataAdapter cmd = new OleDbDataAdapter(strQuery, conn);
OleDbDataReader drsearch = cmdsearch.ExecuteReader();
while (drsearch.Read())
{
Response.Write(Convert.ToString(drsearch["doctitle"])+Convert.ToString(drsearch["filename"])+Convert.ToString(drsearch["vpath"])+Convert.ToString(drsearch["rank"])+Convert.ToString(drsearch["characterization"])+"<br>");
}
odbsearch.Close();
*/
string strCatalog = "learning";
string strQuery = "Select DocTitle,vPATH,rank,characterization from Scope() where FREETEXT(Contents,'" +txtSearch.Text.Trim()+"')ORDER BY rank desc";
string connstring = "Provider=MSIDXS.1;Integrated Security .='';Data Source="+strCatalog;
System.Data.OleDb.OleDbConnection conn = new System.Data.OleDb.OleDbConnection(connstring);
conn.Open();
System.Data.OleDb.OleDbDataAdapter cmd = new System.Data.OleDb.OleDbDataAdapter(strQuery, conn);
System.Data.DataSet dsSearch = new System.Data.DataSet();
cmd.Fill(dsSearch, "SearchResults");
DataView source = new DataView(dsSearch.Tables[0]);
DataGrid.DataSource = source;
DataGrid.DataBind();
}
</script>
<html>
<head>
</head>
<body dir="rtl">
<form runat="server">
<table height="150" width="100%" align="center">
<tbody>
<tr>
<td align="middle">
<asp:TextBox id="txtSearch" runat="server"></asp:TextBox>
</td>
</tr>
<tr>
<td align="middle">
<asp:Button id="btnSearch" onclick="btnSearch_Click" runat="server" Font-Size="12px" Font-Names="Tahoma" Text="جستجو"></asp:Button>
</td>
</tr>
<tr>
<td>
<div align="center">
<asp:DataGrid id="DataGrid" runat="server" CellPadding="4" BackColor="White" BorderColor="#3366CC" BorderWidth="1px" BorderStyle="None" Width="100%" AutoGenerateColumns="False">
<FooterStyle forecolor="#003399" backcolor="#99CCCC"></FooterStyle>
<HeaderStyle font-bold="True" forecolor="#CCCCFF" backcolor="#003399"></HeaderStyle>
<PagerStyle horizontalalign="Left" forecolor="#003399" backcolor="#99CCCC" mode="NumericPages"></PagerStyle>
<SelectedItemStyle font-bold="True" forecolor="#CCFF99" backcolor="#009999"></SelectedItemStyle>
<ItemStyle forecolor="#003399" backcolor="White"></ItemStyle>
<Columns>
<asp:BoundColumn DataField="DocTitle" HeaderText="عنوان">
<HeaderStyle font-size="14px" font-names="Tahoma" horizontalalign="Center" width="15%" verticalalign="Middle"></HeaderStyle>
<ItemStyle font-size="12px" font-names="Tahoma" horizontalalign="Center" verticalalign="Top"></ItemStyle>
</asp:BoundColumn>
<asp:BoundColumn DataField="vPATH" HeaderText="آدرس">
<HeaderStyle font-size="14px" font-names="Tahoma" horizontalalign="Center" width="25%" verticalalign="Middle"></HeaderStyle>
<ItemStyle font-size="12px" font-names="Tahoma" horizontalalign="Left" verticalalign="Top"></ItemStyle>
</asp:BoundColumn>
<asp:BoundColumn DataField="rank" HeaderText="انطباق">
<HeaderStyle font-size="14px" font-names="Tahoma" horizontalalign="Center" width="10%" verticalalign="Middle"></HeaderStyle>
<ItemStyle font-size="12px" font-names="Tahoma" horizontalalign="Center" verticalalign="Top"></ItemStyle>
</asp:BoundColumn>
<asp:BoundColumn DataField="characterization" HeaderText="characterization">
<HeaderStyle font-size="14px" font-names="Tahoma" horizontalalign="Center" width="50%" verticalalign="Middle"></HeaderStyle>
<ItemStyle font-size="12px" font-names="Tahoma" horizontalalign="Right" verticalalign="Top"></ItemStyle>
</asp:BoundColumn>
</Columns>
</asp:DataGrid>
</div>
</td>
</tr>
</tbody>
</table>
<!-- Insert content here -->
</form>
<div align="center">
</div>
</body>
</html> void btnSearch_Click(object sender, EventArgs e) {
string strCatalog = "learning";
string strQuery = "Select DocTitle,vPATH,rank,characterization from Scope() where FREETEXT(Contents,'" +txtSearch.Text.Trim()+"')ORDER BY rank desc";
string connstring = "Provider=MSIDXS.1;Integrated Security .='';Data Source="+strCatalog;
System.Data.OleDb.OleDbConnection conn = new System.Data.OleDb.OleDbConnection(connstring);
try
{
conn.Open();
System.Data.OleDb.OleDbDataAdapter cmd = new System.Data.OleDb.OleDbDataAdapter(strQuery, conn);
System.Data.DataSet dsSearch = new System.Data.DataSet();
cmd.Fill(dsSearch, "SearchResults");
DataView source = new DataView(dsSearch.Tables[0]);
DataGrid.DataSource = source;
DataGrid.DataBind();
}
catch(System.Data.OleDb.OleDbException DE){
Label1.Text = DE.Message
}
}
: void btnSearch_Click(object sender, EventArgs e) {
string strCatalog = "learning";
string strQuery = "Select DocTitle,vPATH,rank,characterization from Scope() where FREETEXT(Contents,'" +txtSearch.Text.Trim()+"')ORDER BY rank desc";
string connstring = "Provider=MSIDXS.1;Integrated Security .='';Data Source="+strCatalog;
OleDbConnection conn = new OleDbConnection(connstring);
try
{
conn.Open();
OleDbCommand Comm = new OleDbCommand(strQuery, conn);
DataGrid.DataSource = Comm.ExecuteReader();
DataGrid.DataBind();
DataGrid.DataSource.Close();
conn.Close();
}
catch(System.Data.OleDb.OleDbException DE){
Label1.Text = DE.Message
}
}
