Well...first of all the date format is driven by the locale set in the installed version of Windows. This is a LOCALE default NOT a Microsoft default. That said you need to look at how the locale is set either on your machine or on your machine AND your servers. Locale defines your formatting for money, dates, etc. Now if you MUST display the date in that format the first question is if that format is included in the Canadian locale definition? At the Region and Language settings within Windows 7, I'm allowed to set Short Date format to yyyy-mm-dd and I expect that the operating system level is where you will get that set for your code.

See here. "One man's wage rise is another man's price increase." - Harold Wilson "Fireproof doesn't mean the fire will never come. It means when the fire comes that you will be able to withstand it." - Michael Simmons "Man who follows car will be exhausted." - Confucius

I guess I probably should start at the beginning and get some asp basics under my belt. Haha. Thanks Mike.

I came across this error to when I thought the parent value did exist. For me the solution was that I had to make sure that the ParentColumns and ChildColumns for the constraint listed the columns in the same order.

Yeah, I know, which is why I was so confused by it. :(

You are using the property well, but on checking back you have the wrong event: private void maskedEdit\_GotFocus(object sender, EventArgs e) { MaskedTextBox mtb = (MaskedTextBox)sender; mtb.SelectionStart = 0; } It appears that after the Enter event, the selection is set to the previous values. But if you use GotFocus it works. Just add the event handler manually after InitializeComponent in the constructor: InitializeComponent(); maskedTextBox1.GotFocus += new EventHandler(this.maskedEdit\_GotFocus); maskedTextBox2.GotFocus += new EventHandler(this.maskedEdit\_GotFocus); Panic, Chaos, Destruction. My work here is done.

The most common method to convert a non-string value to an int is implicit or explicit casting. Example: // implicit casting: byte b = 42; int answer = b; // explicit casting: double d = 42.0; int answer = (int)d; Despite everything, the person most likely to be fooling you next is yourself.

It's a nullable datetime. int? is a nullable int, for example. Christian Graus Driven to the arms of OSX by Vista.

EliottA wrote: I never ran into a problem like that before That's probably because it's not that usual to divide two literal values. Usually one of the operands is a double variable, then the compiler will cast the other operand to double also. Despite everything, the person most likely to be fooling you next is yourself.

Ah, I misread it :) The need to optimize rises from a bad design.My articles[^]

I don't seen anything there that will help me in the copying process of an entire datagridview. I am filling my initial dgv in that manner. In any case, I was hoping to find an easy way to transfer the data for easy viewing on an invoice form, but since as you said there are no examples of code... I'm now using a for loop to collect the data from my rows and populate the child form's dgv. It's probably better this way in the long run. Thanks for the help, Mike.

Lodeclaw wrote: I'm writing that involves creating new rows in a table that has no primary key and two foreign keys Isn't there any natural key present? Also could you create a key column in your datatable and let the datatable to generate a unique value to it? Lodeclaw wrote: followed up by a number of similar new rows in the same listbox How do you recognize similarity? Lodeclaw wrote: I'm also not sure then how to associate the datarow with it's respective item in the listbox If I understood correctly your problem in this, you would use ValueMember[^] definition in your binding. Lodeclaw wrote: use it to delete the row it's associated with from the datatable When the listbox is binded to the datatable, you would actually delete the row from the datatable. The listbox reflects the changes in your datatable. The need to optimize rises from a bad design.My articles[^]

If statements will work fine if (checkBox1.CheckState == CheckState.Checked) { // } else if (checkBox1.CheckState == CheckState.Indeterminate) { // } else { // } Lodeclaw wrote: Thank you for your help No problem :) Dave BTW, in software, hope and pray is not a viable strategy. (Luc Pattyn) Visual Basic is not used by normal people so we're not covering it here. (Uncyclopedia)

Well, I got around the issue with a try/catch block. Out of curiosity, however, I'd love to know if there are other alternatives to this. :doh:

It looks as though the problem lies in my sql query. I'm not sure how it went wrong, since I've been using it successfully for a week. Reconfiguring the query has not helped, either. My query is as follows: SELECT Address, Customer_ID, First_Name, Last_Name, Phone_No FROM Customer WHERE (Last_Name LIKE @Last_Name) AND (First_Name LIKE @First_Name) AND (Phone_No LIKE @Phone_No) called by the code I posted previously: this.finder.customerTableAdapter.FillByFirstLastPhoneNo(this.finder.edsDBDataSet.Customer, txtLastName.Text, txtFirstName.Text, txtPhone.Text); Thank you for trying to help thus far. I'll keep working on this; maybe someone will have some insight on what's going wrong. :wtf:

I am attempting to find another way to get around this problem, so I have another question regarding this: Is it possible to call an event in a child form from the parent form? I've attempted this in the past without success, but I feel that it should be possible given that events that don't involve "physical" (such as a button click event) components on the form can be called by the parent. Can anyone verify this and/or explain why/how it is or is not possible? Thanks so much!