Counting the number of data submitted

As the title, how do I count the number of data submitted.
I've tried but somehow I cant get it right.
The following is the code for your understanding
Public Sub AddNewSN() count = 0 strSql = " " objConn = db.openConnection() strSql = "SELECT * FROM ship where model = '" & Trim(txt_model.Text) & "' and " & _ "serialnum='" & Trim(txt_sn.Text) & "' " dataAdapter = New OracleDataAdapter(strSql, objConn) count = dataAdapter.Fill(dataSet) If count = 0 Then strSql = " " strSql = "Insert into ship (model, item, lotnum, serialnum, userid, logdatetime ) values " & _ "('" & Trim(txt_model.Text.ToUpper) & "', '" &am ...