We use code version tool. We also include the version number as comments in stored procedures and functions. Out versioning tool automatically applies the versioning comments.

Is this a .NET Chart or some 3rd party, such as DeveloperExpress? I am looking through the default toolbox in .net and can't find any sort of chart like you are talking about.

Like it.:thumbsup: "WPF has many lovers. It's a veritable porn star!" - Josh Smith As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes. My blog | My articles | MoXAML PowerToys | Onyx

Thanks So much for your help.Its Much appreciated.Sorry to mention another Problem i have is to Put a $ sign in fromt of the Y axis. .Series("Revenue").IsValueShownAsLabel = True I have to show numbers that are in $ Sign? How could i do that? When i do the formatting on the Numbers i get a problem with the layout of the Graph. Could you please advice? Thanks

Sorry Its Just by Mistake.

Thanks for your Help.

Thanks.I have already sorted it out. Cheers

Yes you can shrink the log file - look for shrink in BOL. If you have changed your logging method from simple to full then that will certainly make a big difference. Never underestimate the power of human stupidity RAH

Nice :) --edit The first argument should be a provider; the name of the server has already been provided as "(local)" - this gets replaced with "Kibrom\SqlDev". Something like below should work; SELECT * INTO #MyTempTable FROM OPENROWSET( 'SQLNCLI', 'Server=(local);Trusted_Connection=yes;', 'Exec [dbo].[C_WEB_sp_RevenueAchievedByShow] 1,2' ) I are Troll :suss: modified on Friday, June 4, 2010 2:35 PM

Mark Nischalke wrote: Do not remove or empty a message if others have replied.. Oh sorry. Will make sure about that before posting 'remove the message' next time. My signature "sucks" today

When you bind to multiple rows, what would you expect to see with a single ID for the textbox? You can't have multiple items called the same thing so you need to get at it some other way; and that way (unfortunately) is to use the Cells collection of the row you're interested in. This property provides you with indexer access to each cell, so you'll have to refer to something like Cells[0] to get the first textbox (bearing in mind you'll need to cast it to the appropriate type). "WPF has many lovers. It's a veritable porn star!" - Josh Smith As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes. My blog | My articles | MoXAML PowerToys | Onyx

Are you there?

Thanks

Hi There, Thanks for your answer.Your answer doesnt make sense.So could you please dont reply if you cant explain what you mean. It will Block others from Posting their view. Many thanks

Thanks so much for your help.

Hello m8 i have done this as a part of my program last year in school... My Solution is to First convert all the data from the first database into XML then You can either transfer the XML file to the other Web Service, Parse the XML create the schema and insert the data in the other database. ;) You have the option to also maybe encrypt the XML for security purposes. And what i think that is one of the advantages for this solutions is that XML is a standard that is read by many objects so this will make transfer easier. Hope this helps :) reply if this help you and take care

Sorry to bother you again.Can you please get me some links in getting this specific problem.I seem to get a general database copy procedures. Many thanks for your help.

Thanks so much it really works for me.What i want to find out now is How can i make sure that the copy process doesnt copy data already copied when doing it on another session. If the copy is done onece during the second operation will it know what records to add? How do you also solve the problem when the two databases run in Different virtual private networks? Lastly,when you copy the data it doesnt really check what has been copied before.So all the information will be be copied again every time the code runs. Many thanks modified on Wednesday, November 11, 2009 7:51 AM