Program ms index server with c#

[ʹÃûÑï]

i want connect ms index server with ado.net
here is my code
KB is a new index dir.it works correctly.

string constr="PROVIDER=MSIDXS;DATA SOURCE=KB";
OleDbConnection con=new OleDbConnection(constr);
try
{
OleDbCommand cmd=new OleDbCommand();
cmd.Connection=con;
cmd.CommandText="SELECT Rank, DocAuthor, DocAppName, DocTitle,
FileName, Create, Access, Characterization, VPath from FROM SCOPE()";
con.Open();
OleDbDataReader reader=cmd.ExecuteReader();//<- error here
reader.Close();
}
catch(Exception E)
{
Response.Write(E.Message);
}
finally
{
con.Close();
}

but it cannot run correctly. the exception says the sql is wrong .from need
" '(', SCOPE, ID, TEMPVIEW¡£SQLSTATE=42000 "

can anybody give me a correct example?

[ʹÃûÑï]

sorry. it's my fault. there are two from .:(

"ʹÃûÑï" <to*************@hotmail.com> дÈëÏûÏ¢ÐÂÎÅ
:eE**************@TK2MSFTNGP12.phx.gbl...

i want connect ms index server with ado.net
here is my code
KB is a new index dir.it works correctly.

string constr="PROVIDER=MSIDXS;DATA SOURCE=KB";
OleDbConnection con=new OleDbConnection(constr);
try
{
OleDbCommand cmd=new OleDbCommand();
cmd.Connection=con;
cmd.CommandText="SELECT Rank, DocAuthor, DocAppName, DocTitle,
FileName, Create, Access, Characterization, VPath from FROM SCOPE()";
con.Open();
OleDbDataReader reader=cmd.ExecuteReader();//<- error here
reader.Close();
}
catch(Exception E)
{
Response.Write(E.Message);
}
finally
{
con.Close();
}

but it cannot run correctly. the exception says the sql is wrong .from need " '(', SCOPE, ID, TEMPVIEW¡£SQLSTATE=42000 "

can anybody give me a correct example?