Finally, i get the reason~ :laugh: I havnt set the primary key in my table,lol anyway, thank u all who have cared my msg~:rose:

Thank u for your reply~ ;P std::fstream really helps me.

thank u for ur replying, Rajesh ;) i c that,however, now i need to read the default value of a registry key, which means i could only use RegQueryValue. and i have checked if RegQueryValue returns ERROR_SUCCESS in my own codes.the codes i paste here is just for simple.anyway, thank u for ur reminding

see http://www.visualcpp.org/?p=37[^] of any help "Opinions are neither right nor wrong. I cannot change your opinion. I can, however, change what influences your opinion." - David Crow Never mind - my own stupidity is the source of every "problem" - Mixture cheers, Alok Gupta VC Forum Q&A :- I/IV Support CRY- Child Relief and You

Posted! http://www.codeproject.com/aspnet/FrmtAutoGenClmnASPNETGrid.asp[^]

I m using Datagrid with Autogenerated Columns. I want to set width of Autogenerated Columns. I used that Code told by you. But it is giving me error: Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index So can u explain me more and sort out this Problem... Any help will be greatly appreciated...........

sorry to add that the format of the query result is not determined at first. waiting for ur reply!

I don't know how do it from TSQL but here is how I have done it form C++ CString str; str.Format("SELECT * INTO [Excel 8.0;DATABASE=%s].[%s] FROM [%s]", ExcelFile, Worksheet, Table); // pConn is a database connection pConn->Execute(str.AllocSysString(), NULL, adExecuteNoRecords); I'd love to help, but unfortunatley I have prior commitments monitoring the length of my grass. :Andrew Bleakley:

The above link will solve you problem, very nice code and easy to use. http://www.codeproject.com/csharp/datasettoexcel.asp Ram

See an example about datagrid paging at : http://www.programmingknowledge.com/datagridpaging.aspx[^] postmaster

I assume VS.net 2005 is the same as VS.NET 2003 - go to Tools / Options / Enviornment / Help and select the Preferred Collection you want to use. Steve

The instructions on how to create a VB6 console app by hand would take a few pages. If you are not using, or have never heard of, vbAdvance, I HIGHLY recommend you check his product out: http://www.vbadvance.com/[^]. I've been using it for a few years and I don't know how I lived without it.

Hi: It is very easy. Lot of sites do use that. You can check blogs.wwwcoder.com Blog Posting. (1) Within a form or in the essential textboxes/textareas, onKeyUp event, set a JavaScript variable to true (isFormDirty=true). This should have been initialised to false on Window.OnLoad. (2) In onBeforeUnload event handler, you can check (isFormDirty). Like this: onBeforeUnload=return ("Are you sure?"). The browser will append its own messages like 'Are you sure to navigate away from the page etc. Deepak Kumar Vasudevan Personal Web: http://vdeepakkumar.netfirms.com/ I Blog At: http://deepak.blogdrive.com/