Using SQLDataSource to fill a datatable or dataset

  • Thread starter Thread starter tom c
  • Start date Start date
T

tom c

I am using Visual Web Developer 2005 Express Edition. I created a
SQLDataSource just by draging the control to the form and filling in
the blanks in the wizard.

In code I need to use the SQLDataSource to load data from several
tables into datasets or datatables, work with the data, then insert new
rows into tables in the SQL Server database.

I can not find any example code showing me how to do this. I don't
even see any example code showing me how fill a datatable using
SQLDataSource

In OLE I would just do

OleDbDataAdapter.fill(datatable)

How do I do that with a SQLDataSource?
 
Dim dv As System.Data.DataView
dv = CType(mdsAllowanceDebit.Select(New DataSourceSelectArguments), DataView)

If dv.Count = 1 Then
txtAmount.Text = dv(0)("Amount")
txtDescription.Text = dv(0)("Description")
txtStamp.Text = dv(0)("Stamp")
Else
txtAmount.Text = "0.00"
txtDescription.Text = String.Empty
txtStamp.Text = Now.ToShortDateString
End If
 
Back
Top