I am writing an application that changes the datagrid dynamically when a dropdown value is changed.
Works fine - but I'd like for it to auto-generate the updatecommand for me when the selectcommand is changed.
Using this code:
SqlDataSource1.SelectCommand = "select * from tableA"
In this case; you can edit the datagrid; the updatecommand is built for me at compile.
When the dropdown is changed using
SqlDataSource1.SelectCommand = "select * from " & DropDownList1.Text
The datagrid updates fine, but the updatecommand is still using the previous sql.
I can build an updatecommand statement with parameters for every possible dropdown table (25 diff tables); but If there is an easy way to force it to 'update' the updatecommand based on a new selectcommand; that would be optimal.
A while ago, I was working on a Windows Forms application and I needed a special label control with reflection (glass) effect to show some titles in a stylish way.
I've always enjoyed working with graphics, but it's never too clever to re-invent …
Creating an analog clock UserControl seems fairly straight forward. It is, after all, essentially just a circle with several lines in it! Two common approaches for rendering an analog clock typically involve either manually calculating points with…
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so.
This will be demonstrated using Adobe Premiere Pro CS6.
How can you see what you are working on when you want to see it while you to save a copy?
Add a "Save As" icon to the Quick Access Toolbar, or QAT.
That way, when you save a copy of a query, form, report, or other object you are modifying, you…