I am having a tough time figuring this out. Its a program thats needs to be done in Visual Studio C# ..
i would really like to get the buttons figured out first. As i have already created my table.
Use Visual Studio to create a database named Personnel.mdf [10] The database should have a table named Employee, with columns for employee ID, name, position, and hourly pay rate. The employee ID should be the primary key. Insert at least 10 sample rows of data into the Employee table. [5] The application's main form should display the Employee table in a DataGridView control. The main form should also have a button that, when clicked, displays a second form. [5] The second form should display the Employee table in a Details view. 140]Add the following buttons to the Main form: 1) A button that, when clicked, sorts the data in ascending order by hourly pay rate. 2) A button that, when clicked, sorts the data in descending order by hourly pay rate. 3) A button that, when clicked, searches for the name in the Employee table. (the user should specify a name in a text box and then). Note: the application should display any rows that contain a full or partial match of the specified name. 4) A button that, when clicked, displays a message indicating the highest (maximum) pay rate in the table 5) A button that, when clicked, displays a message indicating the lowest (minimum) pay rate in the table. 6) A button that, when clicked, displays the average pay rate for all employees. 7) A button that, when clicked, will add a new Employee to the Table. 8) A button that, when clicked, will delete selected Employee from the Table. Use Visual Studio to create a database named Personnel.mdf [10] The database should have a table named Employee, with columns for employee ID, name, position, and hourly pay rate. The employee ID should be the primary key. Insert at least 10 sample rows of data into the Employee table. [5] The application's main form should display the Employee table in a DataGridView control. The main form should also have a button that, when clicked, displays a second form. [5] The second form should display the Employee table in a Details view. 140]Add the following buttons to the Main form: 1) A button that, when clicked, sorts the data in ascending order by hourly pay rate. 2) A button that, when clicked, sorts the data in descending order by hourly pay rate. 3) A button that, when clicked, searches for the name in the Employee table. (the user should specify a name in a text box and then). Note: the application should display any rows that contain a full or partial match of the specified name. 4) A button that, when clicked, displays a message indicating the highest (maximum) pay rate in the table 5) A button that, when clicked, displays a message indicating the lowest (minimum) pay rate in the table. 6) A button that, when clicked, displays the average pay rate for all employees. 7) A button that, when clicked, will add a new Employee to the Table. 8) A button that, when clicked, will delete selected Employee from the Table
