Comments by Stu Baby (Top 30 by date)

The code does not finish executing, so the List<Brand> is never returned

Hi Craig, you've confused me. Isn't that a part of SqlCommand?

By exit, I mean leave the code altogether, no exceptions and everything looks fine. If I'm hitting F11, stepping through the code, line by line, it hits the mentioned line and then goes to the form.show that calls this. (This is called from a constructor)

Thank you Mr Griff

Are you sure Mahesh? c.ImageLayout highlights when I try this with "Cannot resolve symbol ImageLayout" when I hover over it. ImageLayout is not an option from Intellisense either.

Hello Wes, is there an MSN document/webstie or your wisdom that you can direct me to that explains this all to me. Now I've got the debug directory database retaining the data, after closing visual studio and restarting. But then If I want to run a quick query on the data, I have to use a connection to the debug directory as the root directory continues to contain no data. Meanwhile all connections associated with the solution, continue to point to the database in the root directory, which all seems very counter-intuitive. Is this how it is supposed to work?

That makes a lot of sense, how do I solve this?

C:\USERS\DEVELOPMENT\DOCUMENTS\VISUAL STUDIO 2008\PROJECTS\PROJECTA\PROJECTA\PROJECTA.MDF

C:\USERS\DEVELOPMENT\DOCUMENTS\VISUAL STUDIO 2008\PROJECTS\PROJECTA\PROJECTA\BIN\DEBUG\PROJECTA.MDF

These are the two connection properties and I don't see how these could have been mixed up. It's a new project, with nothing else going on

OK, my computer is still alive, and I've done what you suggested. So am I now doing something wrong in Visual Studio? I also did what the guy in the blog suggested at http://visualstudiomagazine.com/blogs/tool-tracker/2012/05/dealing-with-local-databases-or-why-your-updates-dont-stick.aspx and when I close the application, the data is there in the debug directory database. However, if I close visual studio, it goes away again and I have to start again to put our test data into the table. Is there a setting I'm supposed to activate or something like that?

Mohamed, thank you so much for your time and effort. I'm so frustrated with what is going on, that i'm going to call it a day for now. I'm new to codeproject, so please advise how I should handle this question as I've spent 20 hours on this now, and I need to stop before I smash my computer. Once again, thank you so much for you efforts.

I've now successfully run a rebuild, but the same thing is still happening. do I have to do something to make my project "Live"?

http://visualstudiomagazine.com/blogs/tool-tracker/2012/05/dealing-with-local-databases-or-why-your-updates-dont-stick.aspx

I've just read this online, and now I'm completely confused. I thought I was i a sandbox, so to speak and could do what I want. I really appreciate your time here, and what do you mean by "Check the update solution" part?

THe code above is the entire project. Beyond this is a dataset, allowing strongly typed entry of ProjectADataSetTableAdapters.tblCurrenciesTableAdapter from the one single table inthe project. I'm trying to re load visual studio 2008, but it's coming up with an error and won't allow me to run a repair/install.

Yeah, sorry, but I already ahve that. Don't know how I didn't get that in the posting. So does this mean my problem is "Bigger"

Intellisense doesn't bring up Tables after ds., and typing it in causes an error.

The tablename doesn't come up with intellisence. I was assuming that this was because there was only one table in the database. If I type in ds.tblCurrencies, then it won't compile, so how do I actually enter what you are suggesting? Thanks for your input.

Thanks Christain, most appreciated.

Thanks Lukeer, your comments and suggestions led me to now fully understand DateTime.tryParseExact which I think is the only way I was going to be able to solve this. My final answer:
<pre>
bool succes = DateTime.TryParseExact(pRow[26].ToString(), "d", new System.Globalization.CultureInfo("en-US"), DateTimeStyles.None , out suppliedDate);
</pre>

Thanks Lukeer, but this creates the error:
No overload for method 'TryParse' takes '3' arguments.

Thanks Lukeer, but this is either missing my point, or I'm not making myself clear, to which I apologise. The data is coming from an external source. I know the nationality of where that source is from, but how do I tell the computer that using TryParse?

I've tried solution 3 with:

string myTime = DateTime.Parse(pRow[26].ToString()).ToString(CultureInfo.GetCultureInfo("en-US").DateTimeFormat.ShortDatePattern);
and I'm still getting
"FormatException was Unhandled" error "String was not recongnized as a valid DateTime". The value of pRow[26] is "7/3-/2008"

OK, but is there a way I can insert the supplied format? The logical expansion of this then being a way to allow the method to handle any supplier's dates. EG Supplier#1 is French, Supplier #2 is US. The dates themselves DO appear to all be correct, the problem I'm trying to solve is how to tell the computer WHY they are correct. Or am I missing something and this will happen or am I not explaining myself properly.

Thanks for the explanation and the link. From the link I fathomed that all I needed to do was change
textBox.Text = value.Date.ToString();
to
textBox.Text = value.Date.ToString("d");

The data is then saved with the midnight seconds, which if I assume is how it will always be, I can then prepare for.
Once again, thanks for your input

Thank you, really appreciated!!