Sharing the goodness…
Beth Massi is a Senior Program Manager on the Visual Studio team at Microsoft and a community champion for business application developers. Learn more about Beth.
More videos »
I just uploaded more videos to Microsoft Downloads! I wanted to post the direct links here and the matching code downloads for all of you immediately even though MSDN will be creating a pretty landing page like this one for them this week, probably tomorrow or Wednesday. (I'll update this post when that's up).
Download the Forms over Data Video Series #2 and the associated code now!
I have been watching your videos series for about 4 months now, and they are really helpful. Your videos have inspired me a lot to engage on creating windows form application.
My question is I have created a customers database a similar to the that have on the videos series, but I would like to is have a feature of code in the datagridview that allows users o search for a specific customer and select any customer from the datagridview to be added to the main form instead of just use that option to search for customers.
I hope you can help me with this question.
Thank you in advance for your help.
@Bari, if you are using local mode then you should be able to just supply a parameterized query to the TableAdapter and call that from the ReportViewer. Check out this site, it may help you: http://www.gotreportviewer.com/
@Helder, I'm not sure what you mean by "add to the main form". Take a look at this post and see if it helps you: http://blogs.msdn.com/bethmassi/archive/2007/10/01/using-data-across-multiple-windows-forms.aspx
My question is how to create a search from that allows you to select a customer from the query result, and by double clicking the selected customer should be automatically added to the main form (example: Orders form). Let's take your OMS windows application from videos series as an example, You have the following tables: Customers, Orders, OrderDetails and Products. Assuming I have a huge number of customers, I have a created a customer search windows form that displays the customers' information that I am looking for.What I would like to do is once I find the customer I am looking for, I would like to just double click that customer specific customer and have him/her added directly to my orders form.
You can just return the data from the search form back to your main form. You may only need an ID and a name to display though and not the whole datarow.