ASP.NET

23-Apr-08 22:33

We are implemenmting the MicroSoft Indexing search in our site.our client asked to give provision to search the main folders only, not for SubFolders. So we decided to use the SHALLOW TRAVERSAL OF. But still now we didnt get the correct syntax.

My code:

System.Data.OleDb.OleDbConnection odbSearch = new System.Data.OleDb.OleDbConnection("Provider=\"MSIDXS\";Data Source=\"Agaram\";");
System.Data.OleDb.OleDbCommand cmdSearch = new System.Data.OleDb.OleDbCommand();
cmdSearch.Connection = odbSearch;
odbSearch.Open();
cmdSearch.CommandText = "select Vpath, path, FileName, size, write, attrib, Characterization, DocTitle, rank from scope('' SHALLOW TRAVERSAL OF ("/Software")'') where FREETEXT(contents,'" + searchText + "') order by rank desc ";
System.Data.OleDb.OleDbDataAdapter SqlDa = new System.Data.OleDb.OleDbDataAdapter(cmdSearch);
DataSet Ds = new DataSet();
SqlDa.Fill(Ds);
odbSearch.Close();

/Software is the main folder in my project

The Error is at the Select Query.
Error Details:

Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately.

Compiler Error Message: CS1002: ; expected

Source Error:

Line 34: cmdSearch.CommandText = "select Vpath, path, FileName, size, write, attrib, Characterization, DocTitle, rank from scope('' SHALLOW TRAVERSAL OF ("/Software")'') where FREETEXT(contents,'" + searchText + "') order by rank desc ";

eyeseetee23-Apr-08 22:52

23-Apr-08 22:52

Moghan wrote:
("/Software")'') where FREETEXT(contents,'" + searchText + "') order by rank desc ";

is a new line of code then you need to put a + in the line before at the end so that it knows its the end of that line of code

Moghan23-Apr-08 23:11

23-Apr-08 23:11

Thanks for ur reply. Harini's answer working fine.

Harini N K23-Apr-08 22:54

Harini N K

23-Apr-08 22:54

Hi

You need to split the string "\Software" as "\"" for each double quotes with escape character:

See below:

cmdSearch.CommandText = "SELECT Vpath, path, FileName, size, write, attrib, Characterization, DocTitle, rank FROM SCOPE('shallow traversal of " + "\"" + "/Software" + "\"" + "') where FREETEXT(contents,'" + searchText + "') order by rank desc ";

Let me know if that works.

Harini

Moghan23-Apr-08 23:08

23-Apr-08 23:08

Hi Harini,

Its working fine now. Thank u vary much. From morning onwards i tried a lot.

Harini N K23-Apr-08 23:14

Harini N K

23-Apr-08 23:14

Ok ... That is good!!

Harini

Harini N K23-Apr-08 23:19

Harini N K

23-Apr-08 23:19

Hi,

One more thing, replace the variable searchText as parameter to avoid security (SQL Injection).

Harini N K wrote:
cmdSearch.CommandText = "SELECT Vpath, path, FileName, size, write, attrib, Characterization, DocTitle, rank FROM SCOPE('shallow traversal of " + "\"" + "/Software" + "\"" + "') where FREETEXT(contents,'" + searchText + "') order by rank desc ";

This is a good coding practice in any langauge.

Harini

Moghan23-Apr-08 23:39

23-Apr-08 23:39

ok.Thanks for ur suggestion

size of page

ptvce23-Apr-08 22:03

ptvce

23-Apr-08 22:03

i write this code:
javascript:window.open('a.html') i want open a.html with small size how can i set the size of my form in my code?

eyeseetee23-Apr-08 22:30

23-Apr-08 22:30

use something like this:

window.open (this.href, 'popupwindow','width=1000,height=800');return false;"

ptvce23-Apr-08 23:48

ptvce

23-Apr-08 23:48

thanks for ur help, thats right i write this for:
javascript:window.open('../a.html','_blank','height=200,width=300,menubar=yes');

and thats right but return an object, do u know where should i write return false?

when i write javascript:window.open('../a.html','_blank','height=200,width=300,menubar=yes');return false;
it give an error "return statement outside of function"

eyeseetee23-Apr-08 23:52

23-Apr-08 23:52

That should work, where is the code, is it in the c#?

ptvce23-Apr-08 23:59

ptvce

23-Apr-08 23:59

yes its in c#.

exactly its this form:
cell8.Controls.Add(new LiteralControl("<A HREF=" + "javascript:window.open('../a.html','_blank','height=200,width=300,menubar=yes');return false;" + " ??? ????? ???</A>"));

and thast error is :return statement outside of function

samMaster23-Apr-08 22:38

samMaster

23-Apr-08 22:38

Hi,
Test this code: window.open("a.html", "_blank", "innerHeight=200,innerWidth=300");
for more information see this: http://www.webreference.com/js/tutorial1/features.html[^]

list box control

rajkumar.323-Apr-08 21:43

rajkumar.3

23-Apr-08 21:43

hey any one can help me in making a list box control as muliple columns.

with this code its looking nasty.

UserList.Items.Add(pcon.dr1(0) & "|" & pcon.dr1(1) & "|" & pcon.dr1(2))

Re: list box control

eyeseetee23-Apr-08 21:50

23-Apr-08 21:50

I was told before I think on this forum that you can't put two columns in a listbox control, I think you can join two different listboxes together but you cant use two columns in one

Re: list box control

rajkumar.323-Apr-08 22:05

rajkumar.3

23-Apr-08 22:05

www.codeproject.com/KB/webforms/MCEnhancedListBoxControl.aspx

hey in above exapmle i want to assign a datareader to get list box items.
and when transfering like in above page can i transfer datavaluefield ? there i can transfer only selected text only. i want to transfer datavaluefield also can any one suggest.

Re: list box control

eyeseetee23-Apr-08 22:27

downloading a large file using asp.net 2.0 with C#

23-Apr-08 22:27

I thought it was already taken the datavalue field because it is using lstBox.SelectedItem.Value.ToString();

rich text format

krishnaveer23-Apr-08 20:57

krishnaveer

23-Apr-08 20:57

hi i am using rich text format in our project
and want to store data in html format

every body

but at storing time its taking some spical charcter

hievery boby 

if any one know plz help me

thanks

krishna veer singh

Re: rich text format

Kannan.Coder23-Apr-08 21:08

Kannan.Coder

23-Apr-08 21:08

I don’t know your exact requirement. May be you are looking for the Server.HtmlDecode function.

Re: rich text format

krishnaveer23-Apr-08 21:46

krishnaveer

23-Apr-08 21:46

acctully i wamt to store data in html format

becoz when i retrive this data it will shown in formated way

krishna veer singh

ganeshMohan23-Apr-08 20:29

ganeshMohan

23-Apr-08 20:29

hai

my code:
Response.Clear();
Response.AppendHeader("Content-Disposition","attachment; filename=" + filename);
Response.AppendHeader("Content-Length", filename.Length.ToString());
Response.ContentType = "text/plain"; //if pdf file "application/pdf"
string strMapPath = Server.MapPath("~FolderName/filename);
FileStream fs = new FileStream(strMapPath, FileMode.Open,FileAccess.Read, FileShare.ReadWrite);
long bytesToGo;
int bytesRead;
Byte[] buffer = new byte[1048576];
bytesToGo = fs.Length;
while (bytesToGo > 0)
{
bytesRead = fs.Read(buffer, 0, 1048576);
Response.OutputStream.Write(buffer, 0, bytesRead);
Response.Flush();
bytesToGo -= bytesRead;
}
fs.Close();
Response.End();

my problem is downloaded file .sql file[size:4mb], which was not fully downloaded, it partially downloaded.i.e the download file doesn't show the full content it shows only 10 or 15 lines.

if anyone known about this,help me

Thanks in Advance

Known is a drop , Unknown is an Ocean

Re: downloading a large file using asp.net 2.0 with C#

eyeseetee23-Apr-08 21:28