Date: 09/26/06 (C Sharp)    Keywords: web, microsoft, google

...my brain has decided that it can't remember what a circle is. Worse yet, the internet has no definition for "circle," or else my ability to use google search has terribly degraded.

Two intensely, incredibly stupid questions, for which I apologize profusely before we even begin. Both refer to a winform* I have to rebuild thanks to an executive-level decision to change the structure of its underlying table. This winform has a large number of databound controls, all of which tie to one bindingsource and its tableadapter. (This, BTW, is in VS 2005 Standard.)

* i.e., "winform" as opposed to "webform".

1. Two of the controls ar DateTimePickers, dtpEffective and dtpExpiration. All of the other simple controls are changing every time the value of the "main" control (cboName) is changed, but I cannot for the life of me figure out the correct property to set to get the DTPs to change from their default values of '1/1/1900' and '[insert current date here]'. Presently, both Text and Value are set to be bound to the table column that contains the date in question; I have tried it with just Text and just Value bound, and have gotten similar results with each of those options. What's the obvious binding I'm missing to get the DTPs to change with everything else?

2. One of the simple controls is txtID (not surprisingly, a text box containing an ID number). The complex control-- there's only one-- is a datagridview, dgRates. At present, dgRates vomits up the entire CombinedRateData table when the form runs. This makes sense, because I have not incorporated a WHERE clause into the Fill() query. Here's brainfart #2: I can't remember how to turn "txtID.Text" into a parameter that the query will understand, because I am entirely too sleepy, and every time I search for this on the web, I end up back at Microsoft's "How to create a master/detail form using two datagridviews" walkthrough. (Which is cool, but not applicable.)

Thank you, and again, you have my humble apologies for consulting you on such trivial matters. My brain has just decided to switch itself off this afternoon, and I can't kick it back into gear.

Source: http://community.livejournal.com/csharp/76120.html