Page, ICallback Event Handler ..:: Whereever you go, stay in touch. NET Web Forms application that exports generated Excel files directly to the browser. NET application to export an Excel file into PDF format in a Medium Trust Environment since the specified location is under ASP. Net is useful for displaying large data in a tabular format.On the next step select Customer ID, Company Name, Contact Name and Country columns (Figure 2).Click on the “Advanced” button and check the “Generate INSERT, UPDATE and DELETE statements” checkbox (Figure 3). Now that you have configured the SQL Data Source control let’s bind it with a Grid View control. Open its smart tag and configure it as shown in Figure 4.Just like we attached the Required Field Validator control to the Text Box, attach a Custom Validator to the Contact Name column. If you run the web form and try entering wrong value in the Contact Name column then you will see the error message displayed as before and the value will not be accepted by the Grid View control.Set the Control To Validate and Error message properties to the appropriate values. Up till now we used the validation controls to validate Grid View input on client and server side.
Out of these events Row Updating and Row Deleting are possibly the most common ones.There can be several approaches taken for validating data. On the first step of the wizard click on “New Connection” button to open a dialog as shown in Figure 1.Enter the database details as per your setup and click on OK.Next, drag and drop a Required Field Validation control below the Text Box.Set the Control To Validate property of Required Field Validator control to Text Box1 (i.e. Also, set its Error Message property to “Please enter company name”.