How to Extract data from a SQLDataSource to a datatable

Question

Is it possible to store data that is retrieved by SqlDataSource in a DataTable? I mean, If I dragged and dropped a GridView and an SqlDataSource and then I set up those controls in page designer in Visual Studio, is it possible at some time later to retrieve the data retrieved by the SqlDataSource and then store the data in a DataTable?

Best regards,

Yassine Edouiri

Robbie · Accepted Answer · 2012-05-29 22:36:39Z

1

Probably worth having a look at this: DataTable out of SQLDataSource

As far as I can gather, what egoldin is doing is filling the gridview, then using the rowDataBound event, he/she is then taking this data returned and converting it to a table, which can be used at a later stage.

answered May 29, 2012 at 22:36

Robbie

3371 gold badge4 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Robbie Over a year ago

Just as a tip, it may be easier if you were to Google search some of your problems, for this answer I searched: "get datatable from sqldatasource". In the future you would get your answer a lot faster instead of consulting Stack. Hope it helps!

Yassine EDOUIRI · Accepted Answer · 2012-05-29 23:12:07Z

1

i got the answer from @Robbie

Protected Sub DossierGV_RowDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewRowEventArgs) Handles DossierGV.RowDataBound
    If (e.Row.RowType = DataControlRowType.DataRow) Then
        If Me.firstTime Then
            Dim dv As System.Data.DataView = CType(e.Row.DataItem, System.Data.DataRowView).DataView
            Me.dtDS = dv.ToTable

            Me.firstTime = False
        End If
    End If
End Sub

answered May 29, 2012 at 23:12

Yassine EDOUIRI

3914 gold badges15 silver badges32 bronze badges

Collectives™ on Stack Overflow

How to Extract data from a SQLDataSource to a datatable

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related