Tableadapter record count

[John]

Hi

I am using the below statement;

Me.MyTableAdapt er.Fill(Me.MyDa taSet.tblMyTabl e)

How can I now check the record count of the data table and specifically if
the record count returned by fill is not 0?

Thanks

Regards

[Cor Ligthert[MVP]]

MyDataSet.tblMy Table.Count
"John" <in**@nospam.in fovis.co.ukschr eef in bericht
news:%2******** ********@TK2MSF TNGP06.phx.gbl. ..

Hi

I am using the below statement;

Me.MyTableAdapt er.Fill(Me.MyDa taSet.tblMyTabl e)

How can I now check the record count of the data table and specifically if
the record count returned by fill is not 0?

Thanks

Regards

[amdrit]

Really, is that your question?

With MSDN installed
1. Dim x as System.Data.SQL CLient.SQLDataA dapter
2. Highlight SQLDataAdapter
3. Press F1

Without MSDN installed
1. Open your favorite browser
2. Navigate to msdn.microsoft. com
3. Search on SQLDataAdapter Class
Some more help.

Intellisense shows Me.MyTableAdapt er.Fill has several signatures, and that
it returns an integer. I wonder what that integer is for?

After filling Me.MyDataSet.tb lMyTable, there should be a collection of rows
(0-N). Me.MyDataSet.tb lMyTable.Rows.C ount will either equal 0 or N. If the
table already had rows then:

dim iRowCount as integer = Me.MyDataSet.tb lMyTable.Rows.C ount
dim iSomeInteger as integer =
Me.MyTableAdapt er.Fill(Me.MyDa taSet.tblMyTabl e)
dim iNewRowCount as integer = Me.MyDataSet.tb lMyTable.Rows.C ount

msgbox iNewRowCount - iRowCount & " rows have changed" & vbcrlf & "With a
return value of " & iSomeInteger & vbcrlf & "Which means " & iSomeInteger -
(iNewRowCount - iRowCount) & " rows were simply refreshed."
http://msdn2.microsoft.com/en-us/lib...xk(VS.80).aspx

Snip ...
Return Value
The number of rows successfully added to or refreshed in the DataSet. This
does not include rows affected by statements that do not return rows.
.... Snip
"John" <in**@nospam.in fovis.co.ukwrot e in message
news:%2******** ********@TK2MSF TNGP06.phx.gbl. ..

Hi

I am using the below statement;

Me.MyTableAdapt er.Fill(Me.MyDa taSet.tblMyTabl e)

How can I now check the record count of the data table and specifically if
the record count returned by fill is not 0?

Thanks

Regards