Hi,
I want to have as little code as necessary in my winforms code pages, as there are going to be LOTS of them. Therefore I'm looking for a way to fill my child datagridviews and the like automatically when the user selects a row in a parent datagridview/similar. I'm using stored procedures that require paramteres and I was thinking I could insert them via the GUI's filter field, but that doesn't seem to be the case. Is there a way that I wouldn't need to manually write connection, datareader, etc code for this? If not, how can I write as little as possible?
(In case I'm unclear, the post below from another user is about the same thing.)
Thanks!
Pettrer
VB.Net, Visual Studio 2008
I want to have as little code as necessary in my winforms code pages, as there are going to be LOTS of them. Therefore I'm looking for a way to fill my child datagridviews and the like automatically when the user selects a row in a parent datagridview/similar. I'm using stored procedures that require paramteres and I was thinking I could insert them via the GUI's filter field, but that doesn't seem to be the case. Is there a way that I wouldn't need to manually write connection, datareader, etc code for this? If not, how can I write as little as possible?
(In case I'm unclear, the post below from another user is about the same thing.)
Thanks!
Pettrer
VB.Net, Visual Studio 2008
"Ok, I have a DataGridView, and I want to fill it with data from a
stored procedure (which is on a SQL server express database). This
procedure requires a parameter called "Country." The user selects the
country from a ComboBox elsewhere on the form.
All seems to be working fine except one thing: How do I get the value
from that Country ComboBox to be the value that gets used for the
Country parameter?
Do I need to do hand code this? Seems impossible with the GUI. There is
a "Parameters Collection" in the properties for the Fill query, but
when I go into that, there seems to be no way to bind to other
controls.
If I do need to write code for this, any tips?
Thanks,
-Dan"