thank you Ramana

Ramana.Gali wrote: connectionString=DRIVER=MERANT 3.60 32-BIT If you installed a 32 bit ODBC driver, you must set the target platform of your solution to x86.

The coding part is completely correct, file connection is open and closed also. I guess window 7 does not support this function. best face cleanser

what's the endpoint configuration on the server? Mark Salsbery Microsoft MVP - Visual C++ :java:

If you wish to Transpose a DataTable follow the link: Transpose a DataTable using C#[^] If you wish to Pivot a DataTable, follow the link: Pivoting DataTable Simplified[^] Hope this will help. Anurag Gandhi. http://www.gandhisoft.com Life is a computer program and every one is the programmer of his own life.

I blogged about a DataSet/DataTable extension for Linq here[^]. "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

Please do not attempt to bump your posts. Very rude!! It is only 5 hours since your previous post. Have a little patience!!! Whilst your problem is obviously urgent to you, we give our time on a voluntary basis. Therefore your need is greater than ours and if your need is so great I suggest thet you get your Credit Card out and visit rentacoder.com. :) Henry Minute Do not read medical books! You could die of a misprint. - Mark Twain Girl: (staring) "Why do you need an icy cucumber?" “I want to report a fraud. The government is lying to us all.”

yes, if you have any other way to do. please help me Ramana

store the viewstate as GridviewID$ID and then split it on restoring.

Have a look at: Recursive Queries Using Common Table Expressions[^] The need to optimize rises from a bad design. My articles[^]

Don't cross post. "The clue train passed his station without stopping." - John Simmons / outlaw programmer "Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon "Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham

I am using Vista Ultimate and it is okay. Not great, not bad, just okay ( running it on a machine that is plenty able to handle it :-\ ). It all depends on how powerful of a machine you have. "The clue train passed his station without stopping." - John Simmons / outlaw programmer "Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon "Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham

Ok.Take one div and write some text and make this div visible true or false on MouseOver and MouseOut event of Hyperlink. For Example Sample This is Sample text. Your Javascript function function display(i) { if(i==0) document.getElementById('myDiv').style.display='block'; else document.getElementById('myDiv').style.display='none'; } please don't forget to vote on the post that helped you.

Have you ever heard of Google? Took a few seconds to find this: Northwind and pubs Sample Databases for SQL Server 2000[^] They should work fine. me, me, me

Think you would have learned from your previous attempts. Marking it urgent just gets you ignored. only two letters away from being an asset

Their is No way to add check box on a header. But What I suppose you want to give a Check box on header that and on selection of that all the checkboxes of remaining rows are automatically selected right...? If it is true then do this... 1. Place a check box control on a form. 2. Remove its text and set its position to the column header. 3. On Checked Change event of it write this for (int cnt = 0; cnt <= DataGridView1.Rows.Count - 1; cnt++) { DataGridView.Rows[cnt].Cells["ColSelect"].Value = true; } Regards Pankaj Joshi If you want to shape your dreams into reality, please wake-up...