Now you have to specify which database the Sql Data Source control will get data from. Click Next two times, leaving the default connection String name.At the end of this wizard, a “connection Strings” element will be added to your Web.config file.In the next step, select the table and the specific columns you want to retrieve.Also, click the Advanced settings and check the “Generate INSERT, UPDATE and DELETE statements”. From the Grid View “Smart Tasks” arrow, check enable Paging and Sorting. The “Item Template” is what we see when the gridview is in Normal mode.
Once this is done the Sql Data Source will automatically pick values from respective Text Boxes inside the Grid View row to be edited.This time also, Grid View control will support Editing, Updating and Deleting records. From the Grid View’s control “Smart Tag”, either in Design or Source view, select “New data source..”.To start with, open VS2012 and create an empty ASP. Then select “database” leaving the default name for datasource’s ID and click OK.Here Mudassar Ahmed Khan has explained how to Export a Grid View with Images or Pictures to Word Excel or PDF Formats in ASP. In this article the Grid View is displaying images stored on disk and th Hi, This is Mudassar Khan. Net Question Answer site, specially started to allow visitors of this site ask their doubts and queries. Just click the Ask Now button and ask your question now.Now you can ask questions directly to me on my new site ASPForums.