Now i think its time for Chase to be down. www.chase.com site seems to be down.

Nothing is Impossible. Even impossible spells "i m possible"

Hi, For that you will need to write a PL/SQL for this kind of stuff. In MS SQL 2000/2005 there is an extended stored proc named xp_cmdshell which can be used to access the windows command line which can be used to save file. I have got an example which you can use for this... DECLARE @FileName varchar(50), @bcpCommand varchar(2000) SET @FileName = 'c:\data.txt' SET @bcpCommand = 'bcp "SELECT * FROM TableName for xml auto" queryout "' SET @bcpCommand = @bcpCommand + @FileName + '" -U sa -P pwd -c' EXEC master..xp_cmdshell @bcpCommand But for this kind of extended proc access the procedure has to run in 'sa' context... or you need administrator rights to do that... Hope this helps Maharishi

Nothing is Impossible. Even impossible spells "i m possible"

You can pass this values as parameters to the constructor also public class Foo{ string a1, b1; Foo(string A, string B){ a1=A; b1=B; } } Hope this helps. Maharishi

Nothing is Impossible. Even impossible spells "i m possible"

There are two options of doing that. 1. You can access it via our normal ADO.Net by creating the connection to that server and doing what you want on that server. 2. If your database server is MS SQL Server then you can create what is called a linked server... in this case you have to connect to you own server and fire select and insert queries on the remote server. Hope this helps.. Maharishi

Nothing is Impossible. Even impossible spells "i m possible"

what do you mean by CSharp Program?????

Nothing is Impossible. Even impossible spells "i m possible"

In MS SQL Server 2000 there is a "FOR" clause which you can use to retrive the select query result in xml. Basic syntax is as follows, FOR XML mode [, XMLDATA] [, ELEMENTS][, BINARY BASE64] Arguments XML mode Specifies the XML mode. XML mode determines the shape of the resulting XML. mode can be RAW, AUTO, or EXPLICIT. XMLDATA Specifies that an XML-Data schema should be returned. The schema is prepended to the document as an inline schema. ELEMENTS If the ELEMENTS option is specified, the columns are returned as subelements. Otherwise, they are mapped to XML attributes. This option is supported in AUTO mode only. BINARY BASE64 If the BINARY Base64 option is specified, any binary data returned by the query is represented in base64-encoded format. To retrieve binary data using RAW and EXPLICIT mode, this option must be specified. In AUTO mode, binary data is returned as a reference by default. Example : Select * from TableName for xml auto You can search the SQL transact help for further details.

Nothing is Impossible. Even impossible spells "i m possible"

I am new in XML and XSLT. I have got a problem where i have to convert flat records into hierarchial records. I have an XML containing the following records 1 something1 0 2 something2 1 3 something3 1 4 something4 2 5 something5 0 Now this data has to be arranged in the following manner the level will decide how much recursion dept will be there. Can anyone please help me with the XSLT transformer for this problem. Thanks Maharishi Nothing is Impossible. Even impossible spells "i m possible"

Hi All, I am working on a .Net library to be used within the organization. There are lot of configuration settings for the library which will be accessed via a wrapper class so the developer doesnt have to take care of passing of settings to the library. Now the question is whether i put all the configuration in the web.config file and access using the configsectionhandler interface or should i put the configuration in a seperate xml file and access using XML DOM. One of the reason i asking this bcos if we change anything in the web.config file the whole application resets which i donot want. Can anyone please tell me which one is a better approach and why ???? Thanxs in advance. Maharishi Bhatia :) Nothing is Impossible. Even impossible spells "i m possible"

Hi Steven, Thanxs for the prompt answer. Let me rephrase my question... I have already made the library with librarys method and constructors that accept the settings as parameter. I am trying to make a wrapper class which will read from a settings file so that the developer doesnt have to write any code to pass setting data to the library. So actually i was looking for a solution whether to put the config settings in the web.config file or to put it in a seperate xml file. And which solution will be better... Thanxs in advance. Maharishi Bhatia Nothing is Impossible. Even impossible spells "i m possible"

Hi All, I am working on a .Net library to be used within the organization. There are lot of configuration settings for the library. Now the question is whether i put all the configuration in the web.config file and access using the configsectionhandler interface or should i put the configuration in a seperate xml file and access using XML DOM. One of the reason i asking this bcos if we change anything in the web.config file the whole application resets which i donot want. Can anyone please tell me which one is a better approach and why ???? Thanxs in advance. Maharishi Bhatia :)

me

Hi all Can anyone suggest me which way of string replacment is much better ?? 1) string str = "Date today is " + Date.Now.ToString() + " !!!!" Or 2) string str = String.Format("Date today is {0} !!!!",Date.Now.ToString()) Thanxs Maharishi Bhatia

Hi All What is nmake used for?? Can anyone give me an example for its usage ??? Thanxs Maharishi Nothing is Impossible. Even impossible spells "i m possible"

we have kept the source files also with the client (we have to give the source codes also , part of company agreement). so i am at the client side and i try to change a particular code within the source code and decide to build but the problem is that the classes are interdependant on each other and the csc compiler will not understand which file to compile first and which to compile next...... Thanxs Maharishi Bhatia

this remote control will work only if i was there at my pc and then make the changes but if u r at the clients place then how will that happen Thanxs Maharishi P.S : and BTW i liked ur trailer signature

but the problem is there are many interdependant cs files so how does my csc compiler know which to pick first and which to pick second Thanxs Maharishi

Hi all i have a .net application for the web which is deployed on my machine. The live server doesnt have Visual Studio IDE, only .Net framework. If i have a small changes in the code behind file then i have to build the whole code in my machine and then again tranfer all the related files to the live server. Is there any possibility of building my application on the live server without using an IDE for the build. The reason for this requirement is bcos sometimes we r placed at the client side and the client asks us to do a small change urgently and usually we dont have access to IDE so i could open the codebehind files in notepad and build the whole application to make the changes reflect. Thanxs for the help Maharishi Bhatia