Consider you have a database of vehicles, where a table named "Vehicle" stores all the vehicle information: 1. V_ID 2. V_Make 3. V Model 4. V Year 5. V_Owner Your task is to write the 'Select' and 'Update' command code in C# for the figures given in the image file. In the figures, you can see that there is 1 'dropdown list', 4 'textboxes', 1 'Update button', and a 'Label'. You have to write the code for two events as follows: 1. protected void ddl_Vehicle_SelectedIndexChanged(object sender, EventArgs e): In this event, you have to write the code to get all the details of the vehicle which the user selects from the dropdown list of ID's, and place these detail in the text boxes given. Int Varchar Varchar Int Varchar For Eg: When the user selects 1 from the dropdown list you have to get the detail of V_ID 1 and place it in the 4 boxes given. 2. protected void Button_Update_Click(object sender, EventArgs e): In this event, you have to write the code to update record in a database whose ID is been selected in the dropdown list with the values presents the textboxes. Form Control ID's: txt_Vid txt_Make txt_Model txt Year txt_Owner

visual studio

Consider you have a database of vehicles, where a table named "Vehicle" stores all the vehicle information: 1. V ID 2. V Make 3. V Model 4. VYear 5. V_Owner Int Varchar Varchar Int Varchar Your task is to write the 'Select' and 'Update' command code in CH for the figures given in the image file. In the figures, you can see that there is 1 'dropdown list', 4 'textboxes', 1 'Update button', and a 'Label'. You have to write the code for two events as follows: 1. protected void ddI_Vehicle_SelectedIndexChanged(object sender, EventArgs e): In this event, you have to write the code to get all the details of the vehicle which the user selects from the dropdown list of ID's, and place these detail in the text boxes given. For Eg: When the user selects 1 from the dropdown list you have to get the detail of V ID 1 and place it in the 4 boxes given. 2. protected void Button_Update_Click(object sender, EventArgs e): In this event, you have to write the code to update record in a database whose ID is been selected in the dropdown list with the values presents the textboxes. Form Control ID's: - txt_Vid - txt_Make - txt_Model - txt_Ycar - txt_Owner