Dim sqlCmd As New SqlCommand
sqlCmd.Connection = sqlCon
sqlCmd.CommandTimeout = 1500
sqlCmd.CommandText = sqlQry
How can I execute this sqlcommand into xml ?
I know how to do it using selectcommand as follows:
sqlDa.SelectCommand = New SqlCommand(sqlQry, sqlCon)
but this method is not suitable as i load huge dataset which ends with timedout.
Whatever it is i want to write the resultset into xml without timedout error.