100分求站内全文搜索的asp.net(C#)代码？

pmk 2004-09-23 09:50:15

不知道怎么写站内全文搜索的asp.net(C#)，现在急需，如那位有的话拿出来学习学习？谢谢

...全文

1116 23 打赏收藏转发到动态举报

写回复

用AI写文章

23 条回复

切换为时间正序

请发表友善的回复…

发表回复

ywcyj 2004-10-17

打赏
举报

mark

meilixueshan2009 2004-10-17

打赏
举报

webdiyer 2004-10-17

打赏
举报

也许对楼主有帮助：

Create a Site Search Engine in ASP.NET
http://www.developerfusion.com/scripts/print.aspx?id=4389

Internal Site Search Engine
http://www.codeproject.com/aspnet/SearchDotnet.asp

czhenq 2004-10-17

打赏
举报

学习

asuntea 2004-10-17

打赏
举报

pmk 2004-10-09

打赏
举报

一次要搜索10多个表啊？现有的例子都是搜索一个表的？请问一次要搜多个表，怎么实现？

8LY8Apollo 2004-10-09

打赏
举报

标记以后慢慢看

19820911 2004-10-09

打赏
举报

#region 执行存储过程
/// <summary>
/// 执行存储过程
/// </summary>
/// <param name="procName">存储过程的名称</param>
/// <returns>返回存储过程返回值</returns>
public int RunProc(string procName)
{
SqlCommand cmd = CreateCommand(procName, null);
cmd.ExecuteNonQuery();
this.Close();
return (int)cmd.Parameters["ReturnValue"].Value;
}

/// <summary>
/// 执行存储过程
/// </summary>
/// <param name="procName">存储过程名称</param>
/// <param name="prams">存储过程所需参数</param>
/// <returns>返回存储过程返回值</returns>
public int RunProc(string procName, SqlParameter[] prams) {
SqlCommand cmd = CreateCommand(procName, prams);
cmd.ExecuteNonQuery();
this.Close();
return (int)cmd.Parameters["ReturnValue"].Value;
}

/// <summary>
/// 执行存储过程
/// </summary>
/// <param name="procName">存储过程的名称</param>
/// <param name="dataReader">返回存储过程返回值</param>
public void RunProc(string procName, out SqlDataReader dataReader) {
SqlCommand cmd = CreateCommand(procName, null);
dataReader = cmd.ExecuteReader(System.Data.CommandBehavior.CloseConnection);
//return (int)cmd.Parameters["ReturnValue"].Value;
}

/// <summary>
/// 执行存储过程
/// </summary>
/// <param name="procName">存储过程的名称</param>
/// <param name="prams">存储过程所需参数</param>
/// <param name="dataReader">存储过程所需参数</param>
public void RunProc(string procName, SqlParameter[] prams, out SqlDataReader dataReader) {
SqlCommand cmd = CreateCommand(procName, prams);
dataReader = cmd.ExecuteReader(System.Data.CommandBehavior.CloseConnection);
//return (int)cmd.Parameters["ReturnValue"].Value;
}

/// <summary>
/// 执行存储过程
/// </summary>
/// <param name="procName">存储过程的名称</param>
/// <param name="prams">存储过程所需参数</param>
/// <param name="dataReader">存储过程所需参数</param>
/// <returns>返回DataSet</returns>
public void RunProc(string procName, SqlParameter[] prams, out DataTable dt)
{
DataSet ds=new DataSet();
SqlCommand cmd = CreateCommand(procName, prams);
sda.SelectCommand=cmd;
sda.Fill(ds);
dt=ds.Tables[0];
//return (int)cmd.Parameters["ReturnValue"].Value;
}
#endregion

悄悄的回来了 2004-10-09

打赏
举报

打个记号

sequelbo 2004-10-09

打赏
举报

index server

dcren118 2004-10-09

打赏
举报

ding

zhjingwei168 2004-10-09

打赏
举报

UP!UP!

voodgen 2004-09-23

打赏
举报

用sql2000的全文检索很爽的

lkk2073 2004-09-23

打赏
举报

当然要在操作系统中添加新的索引服务,指向要查询的文件夹...

另:

#region 执行存储过程
/// <summary>
/// 执行存储过程
/// </summary>
/// <param name="procName">存储过程的名称</param>
/// <returns>返回存储过程返回值</returns>
public int RunProc(string procName)
{
SqlCommand cmd = CreateCommand(procName, null);
cmd.ExecuteNonQuery();
this.Close();
return (int)cmd.Parameters["ReturnValue"].Value;
}

/// <summary>
/// 执行存储过程
/// </summary>
/// <param name="procName">存储过程名称</param>
/// <param name="prams">存储过程所需参数</param>
/// <returns>返回存储过程返回值</returns>
public int RunProc(string procName, SqlParameter[] prams) {
SqlCommand cmd = CreateCommand(procName, prams);
cmd.ExecuteNonQuery();
this.Close();
return (int)cmd.Parameters["ReturnValue"].Value;
}

/// <summary>
/// 执行存储过程
/// </summary>
/// <param name="procName">存储过程的名称</param>
/// <param name="dataReader">返回存储过程返回值</param>
public void RunProc(string procName, out SqlDataReader dataReader) {
SqlCommand cmd = CreateCommand(procName, null);
dataReader = cmd.ExecuteReader(System.Data.CommandBehavior.CloseConnection);
//return (int)cmd.Parameters["ReturnValue"].Value;
}

/// <summary>
/// 执行存储过程
/// </summary>
/// <param name="procName">存储过程的名称</param>
/// <param name="prams">存储过程所需参数</param>
/// <param name="dataReader">存储过程所需参数</param>
public void RunProc(string procName, SqlParameter[] prams, out SqlDataReader dataReader) {
SqlCommand cmd = CreateCommand(procName, prams);
dataReader = cmd.ExecuteReader(System.Data.CommandBehavior.CloseConnection);
//return (int)cmd.Parameters["ReturnValue"].Value;
}

/// <summary>
/// 执行存储过程
/// </summary>
/// <param name="procName">存储过程的名称</param>
/// <param name="prams">存储过程所需参数</param>
/// <param name="dataReader">存储过程所需参数</param>
/// <returns>返回DataSet</returns>
public void RunProc(string procName, SqlParameter[] prams, out DataTable dt)
{
DataSet ds=new DataSet();
SqlCommand cmd = CreateCommand(procName, prams);
sda.SelectCommand=cmd;
sda.Fill(ds);
dt=ds.Tables[0];
//return (int)cmd.Parameters["ReturnValue"].Value;
}
#endregion

famousun 2004-09-23

打赏
举报

SQL server2000 实现全文搜索功能：
http://www.microsoft.com/china/msdn/archives/library/dnsql2k/html/sql_fulltextsearch.asp

lkk2073 2004-09-23

打赏
举报

private void FileSearch(string catalog)
{
//全文检索的数据库连接及操作
Database mySQL = new Database();
DataSet ds = new DataSet();
String myConnStr = "Provider=MSIDXS; Data Source=" + catalog+ ";";
String mySql = "SELECT FileName, Path, Characterization, Rank, Create, Size FROM SCOPE() WHERE CONTAINS ('" + keyString + "')> 0";
OleDbConnection myConn = new OleDbConnection(myConnStr);
OleDbDataAdapter myAdapter = new OleDbDataAdapter(mySql,myConn);
try
{
myAdapter.Fill(ds,"Search");
}
catch (Exception ex)
{
UDS.Components.Error.Log(ex.ToString());
Response.Redirect("../Error.aspx");
}
finally
{
myAdapter =null;
myConn.Close();
myConn = null;
}

//将全文检索的数据填充到临时表中
for(int i=0;i<ds.Tables["Search"].Rows.Count;i++)
{
DataRow myDr;
myDr = ds.Tables["Search"].Rows[i];

SqlParameter[] pparameters = {
mySQL.MakeInParam("@FileName",SqlDbType.VarChar,300,myDr["FileName"]),
//mySQL.MakeInParam("@Path",SqlDbType.VarChar,300,myDr["Path"].ToString().Replace(Server.MapPath("..\\UnitiveDocument\\Document").Replace("/","\\").ToLower() ,"") ),
mySQL.MakeInParam("@Path",SqlDbType.VarChar,300,Enter.changeString_Path(myDr["Path"].ToString())),
mySQL.MakeInParam("@Characterization",SqlDbType.NText ,10000,myDr["Characterization"] ),
mySQL.MakeInParam("@Rank",SqlDbType.VarChar,300,myDr["Rank"]),
mySQL.MakeInParam("@Create",SqlDbType.DateTime ,10,myDr["Create"]),
mySQL.MakeInParam("@Size",SqlDbType.Int,4,myDr["Size"])
};
mySQL.RunProc("sp_AddScope",pparameters);
}

yichuan1982 2004-09-23