David Mujica wrote: Sometimes when you don't have the actual data to test with, you forget some stuff. Tell me about it. :rolleyes: That's almost something I can put in my CV. Light moves faster than sound. That is why some people appear bright, until you hear them speak. List of common misconceptions

Do you mean something like this[^]? "If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair. nils illegitimus carborundum me, me, me

Well, as I suggested before, you need to add some debug code to find out which object is throwing the exception. Unrequited desire is character building. OriginalGriff I'm sitting here giving you a standing ovation - Len Goodman

Thats the whole issue mate. If I say Show(this) or ShowDialog(this) I get the error which says "Form that is not a top-level form cannot be displayed as a modal dialog box. Remove the form from any parent form before calling showDialog." Ohh I better ask Uncle Google instead. Cheers

Can you tell me how to update the database when the binding source is modified please? In this case the textBox text is being modified and I want to know how the selected item changed (i think ur trying to say SelectedIndexChanged event ?) and changing the property of the combobox to dropdownlist would solve this issue? Thanks,

Something like this: var customer=new Customer(12,"Pavel","Yermalovich"); YourDataContext db=new YourDataContext(); db.Customers.InsertOnSubmit(customer); db.SubmitChanges();

so how do i enable it ? Thanks

try MessageBox.Show(string.Join(Environment.NewLine,test.ToArray())); :) Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Prolific encyclopedia fixture proof-reader browser patron addict? We all depend on the beast below.

What you've presented is gibberish to me. I want to know what you are trying to accomplish, not how you are trying to accomplish it (especially if it doesn't work). 0) Is there a database? 1) Is there a table in the database? 2) Are you trying to retrieve some information from that database table? 3) What is the schema of the table?

You can add more than one validator, or use a custom validator, self validator Introduction to Validation Application Block[^] I know the language. I've read a book. - _Madmatt

"Cannot add items to the combobox when a datasource is assigned" You need to add the blank row to a datatable before you bind it to the combobox. This is off the top of my head so will need debugged obviously but you will get the idea: SqlConnection MyConnection = new SqlConnection(PublicVars.ConnectionString); MyConnection.Open(); SqlDataAdapter sqlDA1 = new SqlDataAdapter("SELECT ItemID FROM some\_items", MyConnection); DataSet sqlDS = new DataSet(); sqlDA1.Fill(sqlDS, "some\_items"); DataTable tblItems= sqlDS.Tables\["some\_items"\]; DataRow NewRow = tblItems.NewRow(); NewRow\[0\] = "-- Click To Select --"; tblItems.Rows.InsertAt(NewRow, 0); cboItems.DataSource = tblItems; cboItems.DisplayMember = "ItemID"; cboItems.ValueMember = "ItemID"; cboItems.SelectedIndex = 0; MyConnection.Dispose(); You should get the idea.

Thanks, I stand corrected. I checked as far as it is a structure and missed the interface declaration. If you have knowledge, let others light their candles at it. Margaret Fuller (1810 - 1850) [My Articles]  [My Website]

could show me a snippet please.

AFAIK, you should be creating separate instances of the combobox, one for each row of your datagridview. Me, I'm dishonest. And a dishonest man you can always trust to be dishonest. Honestly. It's the honest ones you want to watch out for...

Maybe this will help Introduction to Validation Application Block[^] I know the language. I've read a book. - _Madmatt

Good answer

This should work: var objUser = (from user in userList where user.UserName = newUser.UserName select user ) Although, you should consider the number of users in your database as well. There is no point in getting 10000 or likewise records just for validation. IMO a trip to database server would cost less than this. "No matter how many fish in the sea; it will be so empty without me." - From song "Without me" by Eminem

Just pasted code in the reply above

If I understand your questions correctly, why dont you create an audit table and always add a record before each update.. so you want an update triger[^]