hi I got this procedure to create database and tables using COLLATE from here but i am getting errors incorrect syntax near COLLATE I have checked several times but could not find the actual root cause of it. if i take any database say master or model it gives me th following errors:

Server: Msg 170, Level 15, State 1, Line 3Line 3: Incorrect syntax near 'SQL_Latin1_General_CP1_CI_AS'.
Server: Msg 911, Level 16, State 1, Line 2Could not locate entry in sysdatabases for database 'RiversideInternetForums'. No entry found with that name. Make sure that the name is entered correctly.
Server: Msg 170, Level 15, State 1, Line 6Line 6: Incorrect syntax near 'COLLATE'.
Server: Msg 4902, Level 16, State 1, Line 2Cannot alter table 'dbo.WS_Webs' because this table does not exist in database 'model'.
Server: Msg 1906, Level 11, State 1, Line 2Cannot create an index on table 'dbo.WS_Posts', because this table does not exist in database 'model'.
Server: Msg 208, Level 16, State 1, Line 1Invalid object name 'WS_Webs'.

if i create a new database name RiversideInternetForums i get the following errors:

Server: Msg 3702, Level 16, State 3, Line 2Cannot drop the database 'RiversideInternetForums' because it is currently in use.
Server: Msg 170, Level 15, State 1, Line 3Line 3: Incorrect syntax near 'SQL_Latin1_General_CP1_CI_AS'.
Server: Msg 170, Level 15, State 1, Line 6Line 6: Incorrect syntax near 'COLLATE'.
Server: Msg 4902, Level 16, State 1, Line 2Cannot alter table 'dbo.WS_Users' because this table does not exist in database 'RiversideInternetForums'.Cannot create an index on table 'dbo.WS_Posts', because this table does not exist in database 'RiversideInternetForums'.Cannot create an index on table 'dbo.WS_Users', because this table does not exist in database 'RiversideInternetForums'.
Server: Msg 208, Level 16, State 1, Line 1Invalid object name 'WS_Webs'.

i have wriiten to the author but no response . can u tell me what is wrong .so can anyone here help me out. thanks in advance sasi

hi I have a asp.net page here i am trying to call parameters from a xml file the parameter is an image and the given ".gif" is stored in Icon .When i try to call Icon in my image it give me error.The following code where i am using Icon and Value.

![](images/## DataItem.GetMember()

the error is

Could not find any attribute 'Icon' of element 'img'
Could not find any attribute 'Value' of element 'img'

I really dont know how to call the parameters in this regard plus what actuall went wrong. sasi -- modified at 2:50 Friday 26th May, 2006

hi I have created an excel sheet and saved in the application under wwwroot i like to know how i can pick up certain details like age or name from sheet and displayed in the webpage (using asp.net & C#).is there any external tool required for this?Since i am using file explorer where drive, folders, files,excelsheet appear.I tried to use xml file but was able to call of the entire file not certain parameters from xml. anyone could tell how i can proceed this problem sasi

Hi I am creating a dynamic treeview from sql database while running the page i get the following error

System.ArgumentException: Format of the initialization string does not conform to specification starting at index 52.

I am writing the small code snipet where the error is occuring

private void GenerateTreeView()
{
SqlConnection con=new SqlConnection("server=server-name;database=pubs;user id=sa;password=sa;" + Server.MapPath("~/data/Tree.sql"));
con.Open();

I dont know what causing it this error. sasi

hi I am able to resolve my earlier issue but now a new problem has come up in this a web page "tvOnDemand.aspx" has some nodes if i click colors node i get a msg box Error loading callback data.I i run the XmlGenerator.aspx page i get the following error: (Its in ComponentArt)

The XML page cannot be displayed
Cannot view XML input using XSL style sheet. Please correct the error and then click the Refresh button, or try again later.

Only one top level element is allowed in an XML document. Error processing resource 'http://localhost/reere/XmlGenerator.as...

-^

Earlier i got error in the following lines "" so i just removed it now i am getting the above error "Only one top elemt..." Here can anyone help me to solve this problem thanks in advance

:confused:hi Ihave uninstall Microsoft IE WebControls and install ComponentArt still i didnt get any license key and performed a small program while compiling i get the following error

componentart_webui_client/2006_1_1208/A573G988.js not found

I am trying to search but in vain what exaclty this js file is .Can anyone who has worked with ComponentArt can explain me what went wrong. When I can get the key I am using this coponent as trial basis .Please Guide me thanks in advance sasi

hi I am using Visual studio 2003 server and i have installed Microsoft IE WebControls since I want to use certain methods and properties which is not supported by the microsoft i want to uninstall but i dont know how to do it. I am going install some other product but confused which is best-AdvancedWebControls,ComponentArt,telerik r.a.d.treeview ,obout inc,Otrix,Panoramic netware,aspnetexpert.com.Can anyone guide me in this regard. sasi

hi whenever i create/recreate treeview my memory is consumed by 1mb if i clear folders which are not in use in the wwwroot still it consumes memory .Did anyone here encountered such situation ,if yes how i can deal with this .Iam using microsoft.web.ui.webcontrols.dll (IE webcontrols)installed externally in visual 2003. sasi

Hi I am doing a project in asp.net with C#,in my project i am creating dynamically treeview in the local system.When the page is called only a particular drive is called along with the folders,sub-folders and files .Problem is files inside the folders and drive say D are not shown only the main folder and sub-folders which comes under the drive is shown. Could anyone give me an idea how to proceed here further. thanks in advance sasi

hi is it possible that i can use some methods,functions or properties of java in my asp.net environment.As the current tool doesnt support certain properties or methods in my project(i am using microsoft.web.ui.wecontrols.treeview ).I searched in google and found some tools which i felt will be quite useful but i cant use these tools since my team members are using microsoft only. In that case is it feasible for me to use a little java coding in the project to make it work. Please throw some light in this. thank in advance sasi

used for loop where p is string for directories here is the full code

// recursive method to load all folders and files into tree
private void GetFolders( string path, TreeNodeCollection nodes )
{
// add nodes for all directories (folders)
string[] dirs = Directory.GetDirectories( path );
foreach( string p in dirs )
{
string dp = p.Substring( path.Length );
nodes.Add(Node("",p.Substring( path.Length + 1), "folder" ) );
}

		// add nodes for all files in this directory (folder)
		string\[\] files = Directory.GetFiles( path, "\*.\*" );
		foreach( string p in files )
		{
			nodes.Add( Node( p, p.Substring( path.Length ), "file" ) );
		}			

		// add all subdirectories for each directory (recursive)
		for( int i = 0; i < nodes.Count; i++ )
		{
			if ( nodes\[ i \].Type == "folder" )
			{
				GetFolders( dirs\[ i \] + "\\\\", nodes\[i \].Nodes );
			}
		}				
	}

hi From the code project i downloaded a source code and used in my project and got the following error: 1.The best overloaded method match for 'Microsoft.Web.UI.WebControls.TreeNodeCollection.Add(Microsoft.Web.UI.WebControls.TreeNode)' has some invalid arguments

nodes.Add( Node( p, p.Substring( path.Length ), "file" ) )
nodes.Add(Node("",p.Substring( path.Length + 1), "folder" ) );

2.Argument '1': cannot convert from 'Test.WebForm7' to 'Microsoft.Web.UI.WebControls.TreeNode' it comes near

n.Text = nodeText.ToString();

		**return n;**

It is from TreeView in a customized tool I am unable to understand what went wrong thanks in advance sasi

Microsoft web IE controls only

Microsoff web IE controls.but calling a drive and only 2 to 3 folders and its contents and is not getting populated dynamically

hi how to populate both statically and dynamically files and folders in the treeview without using xml .I am trying this for days but no use.Could anyone give me some hint in this.I am using asp.net with C# sasi -- modified at 8:05 Thursday 23rd March, 2006

hi Does anyone here used a file(txt) or word document which contains some words or lines where you have to select a particular line and display on the webpage.I am using asp.net with C#. If a user selects a folder some lines about the folder appears on the webpage. For this I refer some document that it required some external tools like FileUp,Software Artisian File ,AspTear.How far this is true?Does it useful if i install this and work or whether there is any other method to deal with this . -- modified at 7:09 Thursday 16th March, 2006

hi in my project of asp.net with c# I am doing project in the dynamic format ,i am using treeview,if i click any folders it should display description about the folder in a label.The details are there in the .doc file which i have to fetch from treeview.How I can achieve this? From the Doc file there are some urls which clicked will take the user to the next page .How i can achieve this ? sasi

hi in the class library i am using filereaders,fileinfo,filestreams for reading and writing files for source and destination paths but i am getting error near the filereaders,filestreams "namespace or assembly missing" .Even if i use System.IO it still gives me an error. Any solution for the above problem sasi

hi like console applications is run in the cmd prompt how i can run the classlibrary in the cmd prompt .Does any one know the command for it . sasi

hi I need help in almost all my cs files I am getting the following error:

C:\Inetpub\wwwroot\WebApplication2\treebase.cs(150): The type or namespace name 'Category' could not be found (are you missing a using directive or an assembly reference?)

Category, DefaultValue,Editor,DesignerSerializationVisibility,Browsable,HtmlTextWriter, IStateManager,StateBag,ParenthesizePropertyName,Control are coming i dont know the assembly reference for it It mainly occurs in this format

[DefaultValue("")]
[ParenthesizePropertyName(true)]
[ResDescription("BaseID")]

Can anyone help me in this regard sasi