NorthwindDatabase.gif' alt='Sqldataadapter Update Dataset Multiple Tables With A Join' title='Sqldataadapter Update Dataset Multiple Tables With A Join' />The Grid. View Grid. View. 1 fired event Sorting which wasnt handled. I have a gridview with a SQL data source, Allow Sorting True. The Gridview displays at the bottom of the form, and initially displays all the data in the SQL table. When I search the table, a single match will display to the form for updating purposes, and multiple matches  are displayed in the datagrid. I want to be able to sort the results but Im getting this error The Grid. Here Mudassar Ahmed Khan has explained how to perform Bulk Insert records and Update existing rows if record exists using C and VB. Net. SqlBulkCopy as the name. This lesson explains how to work with disconnected data, using the DataSet and SqlDataAdapter objects. Here are the objectives of this lesson. Ive got the following stored procedure Create procedure psfoo AS select from tbA select from tbB Im then accessing the data this way Sql Command. Im modifying someone elses code where a query is performed using the following DataSet ds new DataSet SqlDataAdapter da new SqlDataAdaptersqlString. Code/VBImages/SqlDataAdapterEventupdatedandupdating.PNG' alt='Sqldataadapter Update Dataset Multiple Tables With A Join' title='Sqldataadapter Update Dataset Multiple Tables With A Join' />View Grid. View. Sorting which wasnt handled. As I understand it I need to capture the current gridview in a view state, and bind it again. Sqldataadapter Update Dataset Multiple Tables With A Join' title='Sqldataadapter Update Dataset Multiple Tables With A Join' />What isnt clear is if I need to be handling the sorting event in the code behind as well. Some examples are saying it need to be handled through Page. Sqldataadapter Update Dataset Multiple Tables With A Join' title='Sqldataadapter Update Dataset Multiple Tables With A Join' />Issuu is a digital publishing platform that makes it simple to publish magazines, catalogs, newspapers, books, and more online. Easily share your publications and get. Multiple Result Sets. If the DataAdapter encounters multiple result sets, it creates multiple tables in the DataSet. The tables are given an incremental default name. Bind,Save,Edit,Update,Cancel,Delete,Paging example in GridView in asp. C. Index. Changing, while others are saying do it with On. Sort. I found the following code on EE, and Ive added it to the code behind. Im still getting the same error any ideas Private Property Grid. Dq5oF0.jpg' alt='Sqldataadapter Update Dataset Multiple Tables With A Join' title='Sqldataadapter Update Dataset Multiple Tables With A Join' />View. Sort. Direction As String Get Return IIfView. StateSort. Direction Nothing, ASC, View. StateSort. Direction End Get SetBy. Val value As String View. StateSort. Direction value End Set End Property Private Property Grid. View. Sort. Expression As String Get Return IIfView. StateSort. Expression Nothing, String. Empty, View. StateSort. Expression End Get SetBy. Val value As String View. StateSort. Expression value End Set End Property Private Function Get. Sort. Direction As String Select Case Grid. View. Sort. Direction Case ASC Grid. View. Sort. Direction DESC Case DESC Grid. View. Sort. Direction ASC End Select Return Grid. Software 4Ch H.264 Dvr more. View. Sort. Direction End Function Protected Sub gridview. Page. Index. ChangingBy. Val sender As Object, By. Val e As Grid. View. Page. Event. Args Grid. View. 1. Data. Source Sort. Data. TableGrid. View. Data. Source, True Grid. View. 1. Page. Index e. New. Page. Index Grid. View. 1. Data. Bind End Sub Protected Function Sort. Data. TableBy. Val data. Table As Data. Table, By. Val is. Page. Index. Changing As Boolean As Data. View If Not data. Table Is Nothing Then Dim data. View As New Data. Viewdata. Table If Grid. View. Sort. Expression lt String. Empty Then If is. Page. Index. Changing Then data. View. Sort String. Format0 1, Grid. View. Sort. Expression, Grid. View. Sort. Direction Else data. View. Sort String. Format0 1, Grid. View. Sort. Expression, Get. Sort. Direction End If End If Return data. View Else Return New Data. View End If End Function Protected Sub gridview. SortingBy. Val sender As Object, By. Val e As Grid. View. Sort. Event. Args Grid. View. Sort. Expression e. Sort. Expression Dim page. Index As Integer Grid. View. 1. Page. Index Grid. View. 1. Data. Source Sort. A Test Questions. Data. TableGrid. View. Data. Source. Tables0, False Grid. View. 1. Data. Bind Grid. View. 1. Page. Index page. Index End Sub. Select all. Open in new window.