Reading from a DB - please help

[almurph]

Hi everyone,

Hope that you can help me please. I am parsing approx 1.34M record in
a database. I read a line, parse it and then write out this new line to
a new column.
However I have notice that occasionally the system reports an error of
the type:
************** Exception Text **************
System.Data.SqlClient.SqlException: Timeout expired. The timeout
period elapsed prior to completion of the operation or the server is
not responding.
at System.Data.SqlClient.SqlCommand.ExecuteReader(Com mandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream)

I reckon its occuring during the reading process. The function
associated with this is included below. I reckon that I am gobbling up
too many resources or its inefficient or something. Perhaps I should
use the Dispose() method somewhere.
Could you have a look at it please? Any
comments/suggestions/improvements/ideas/code-samples would be much
appreciated.

Al.
The confused


************ INEFFICIENT READ FUNCTION AS FOLLOWS
***********************

Public Function ReadSoundexWords(ByVal rowNo As Integer) As String

'Read a soundex field from a particular row
Dim asFieldSqlCmd As New SqlCommand
asFieldSqlCmd.Connection = mySqlConn
asFieldSqlCmd.CommandType() = CommandType.StoredProcedure
asFieldSqlCmd.CommandText() = "dbo.spReadSoundexField"
Dim strSoundexwords As String
Dim strParsedSoundexwords As String

'Input parameter: alp_pk
Dim Prmt_geo_pk As SqlParameter = New SqlParameter("@"alp_pk",
SqlDbType.Int)
Prmt_geo_pk.Value() = rowNo
asFieldSqlCmd.Parameters.Add(Prmt_alp_pk)
Dim soundexwordsReader As SqlDataReader =
asFieldSqlCmd.ExecuteReader

While soundexwordsReader.Read
strSoundexwords = soundexwordsReader.Item(0).ToString()
strSoundexwords = strSoundexwords.Trim()
End While

'Close the reader
soundexwordsReader.Close()
Return strSoundexwords

End Function