Database

Ah welcome to the correct forum. Your question however is still very obscure. What do you mean by upload? Are you trying to deploy the database to s server, restore a backup, connect to an existing database what! Never underestimate the power of human stupidity RAH

Do NOT ignore the advice you have been given. Just because David has given you a work around FIX YOUR DATA STRUCTURE. If you do not do this NOW you will be back here continiously asking how to get at your data. Never underestimate the power of human stupidity RAH

Please give me working link for that plug-in

Actually I think I could have left it a he's in trouble His level of understanding about database needs upgrading Never underestimate the power of human stupidity RAH

I think it has something to do with the characters sets installed under windows. I know we have chinese installed and the unicode display Ok but japanese is just boxes. Never underestimate the power of human stupidity RAH

Thnx its working perfect kindly tell me is this good approach or theres any other method to do this? second how can show message as i m usng sqldatasource(GridView) to update and delete

I'd like to STUFF all xml and it's derivatives where the sun don't shine. Never underestimate the power of human stupidity RAH

thnx alot

Thank you Rob Smiley. Its working ************ S G KORE *******************

lemarshall wrote: (breaking normalcy rules) These should be known as guidlines as they are subject to reality and business requirement. Having said that I alway looks very closely at a design that does not conform to these guidelines, it is usually wrong somewhere. You got it fixed - always satisfying. Never underestimate the power of human stupidity RAH

create table #table (affected item varchar, LN int, NY int, Zu int) insert(table) select Affected item,SUM( case region when 'LN" then 1 else 0) LN,SUM( case region when "NY" then 1 else 0) NY,SUM( case region when 'ZU" then 1 else 0) ZU from tablename groupby affected item please advice if i am wrong? Thanks, Abhishek

Instead of multiple fields for the address you might look into storing it as XML data or varchar using XML to structure the address. Never underestimate the power of human stupidity RAH

thanks for help but I decided to take all the data to a DataTable and then sort it in the C# part of the project, the hard way =) thanks again

The first download at http://www.oracle.com/technetwork/developer-tools/visual-studio/downloads/index.html should work. So to answer you're question, the version is 11.2.0.1.2 Can't remember exactly, but I think your code has to be compiled for x86 to use these drivers... "An eye for an eye only ends up making the whole world blind"

You need to contact the hosting provider to ascertain whether or not you can have full access - although this sounds like the server instance is not properly set up to accept remote connections to the SQL instance. I have CDO, it's OCD with the letters in the right order; just as they ruddy well should be Forgive your enemies - it messes with their heads My blog | My articles | MoXAML PowerToys | Onyx

kirankkk2009 wrote: Message=RESTORE cannot process database 'D:\WORKING DIRECTORY\WIN APPLICATION\NAKODA\DEVELOPMENT\BIN\DATABASE\CERP.MDF' because it is in use by this session. It is recommended that the master database be used when performing this operation. So you are connected to the database you want to restore - fail. Do what the exception advises you to, connect to the master database and restore your database. Never underestimate the power of human stupidity RAH