Advanced C#

2. View the Vendor States Form in the Designer window 3. Add a button to the DataGridView control with the following property settings a. Name- btnViewStateVendors. b. Text-View State Vendors c. UseColumnTextForButtonValue True. 4. View the PayablesDataSet schema file within the Designer window. Configure the StatesTableAdapter Fill method to sort the states by StateName. When you run the application the form should look like the following: a. b. View Vendors in States Vendor States Alabama Alaska rizona Arkansas Calfomia Colorado Connecticu Delaware District of ColumbiaView State Vendors lew State Vendors Vew State Vendors Vew State Vendors View Stata Vendors ew State Vendors iew State Vendos View State Vendors Mew State Vendors 5. Uncomment the statesDataGridview_CellContentclick even procedure. Finish coding event procedure by replacing "?" with correct C# code. 6. View the PayablesDataset schema file in the Designer window. Add the following query to the VendorsTableAdapter and name it Fi11Bystate: SELECT Name, Addressl, Address2, City, State, ZipCode FROM dbo.Vendors where State = @State 7. Display ViewVendorsinState form in the Designer window. Uncomment the ViewVendorsInState Load event method. Finish coding the event procedure by replacing the "?" character. a. b