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.
In order to do so select “Edit Columns…” from the smart tag of the Grid View. Select Company Name and Contact Name fields and click on “Covert this field into a Template Field” link.
This will convert them from Bound Field to Template Field.
Right click on the Grid View and select “End template editing” Run the web form.
After you have run the website, you will see the Grid View showing details of employees in tabular format.
We have selected four columns from Employee Details table.
Here, we set the Data Source of the Grid View to Sql Data Source1. We also enable paging, sorting and editing features of the Grid View.
By default when the Grid View controls goes in edit mode, it displays Text Boxes for entering values.
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.