no. do your own search. regards, Torsten I never finish anyth...

pleas i need help:confused:

Hard to answer. How are you setting up a DB ? What DB is it ? Christian Graus Please read this if you don't understand the answer I've given you "also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

Don't use VBCRLF in VB.NET, it's just VB6 rubbish. Use .NET whereever you can, so it flows nicely to C# if you ever need to use it. Christian Graus Please read this if you don't understand the answer I've given you "also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

asha_s wrote: thanks, but i found the solution which was? Bob Ashfield Consultants Ltd

I seem to recall this guy had a problem with a gridview/datasource, he is expecting the datasource to autogenerate an update command if there is a select statement. As in: I got the data I changed the data Why won't it update the database, I clicked the update button. He is yet to work out that the datasource requires an Update command/script/procedure to actually write the data back to the database. Therefore the silly question. This has been answered at least once by Christian. Never underestimate the power of human stupidity RAH

thanks so much :) :)

Christian Graus wrote: this error is telling you that you need to specify the update command ( the SQL that does the update ) how can i specify it i am sure from the type of the sended perimeter if you have another way rather than command please tell me :(( :((

Um where is your update script!, I can see your select but no update Never underestimate the power of human stupidity RAH

thanks i put the primery key but it give me error in update statment please help if you can

thanks it work

Not to mention that there is about 400 threads in this forum relating to it. Please check out my articles: The ANZAC's articles

It doesn't come with the Express editions, as far as I know. I could be wrong because all I have is the Team Suite, which comes with everything. A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007, 2008

Merging cells is not supported. You'll have to use a third party grid control to do this, like DevExpress's XtraGrid Suite[^]. A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007, 2008

asha_s wrote: in may project i exploit my data to exl sheet but the styel not very will because the size of the sill is smailer than data size It's "export my data", not "exploit". asha_s wrote: but the styel not very will Are you saying that the cell formatting isn't correct?? asha_s wrote: the size of the sill is smailer than data size Are you saying the size of the CELL, not "sill", is too small to fit the width of the data? asha_s wrote: is their is way to make the sill size larger in my code not from the excel You can't do it in your file, but you can use the Excel object model to do this. You would need either the Visual Studio Tools for Office (recommended) or add a reference to the Excel x.x Object Model. This method requires that you have a good working knowledge of Excel and it's object model to do this. A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007, 2008

hi i am searching in Google and i am reading but i want to get extra value from people how use it and expert on this part i am not waiting for some one to replay i am not lays and waiting some one to write my work

thanks it work :laugh: :laugh:

thanks :-D :-D i found the error

thanks :) do you think that using ( ArrayList ) is butter than dynamic array

You are welcome... I Love T-SQL Don't torture yourself,let the life to do it for you.