Database Error: There is no row at position 0

by

This is very simple … it means that no results were returned from your query. You always have to code defensively and check to see if the Rows array has any items in it before trying to index into it. Something like:

if (dt.Rows.Count > 0)
    soptype = dt.Rows[0]["SOPTYPE"].ToString();
else
    somethingWentWrong();

More Related Contents:

  1. How do I update a value in C# and SQL Server? [closed]
  2. What is passing parameters to SQL and why do I need it?
  3. How to make an algorithm to get all column names from across tables that relations with their primary key in SQL Server and C#?
  4. Delete from two tables? [closed]
  5. Procedure or function xxxxx has too many arguments specified [duplicate]
  6. Entering keys manually with Entity Framework
  7. Pass table valued parameter using ADO.NET
  8. Insert entire DataTable into database at once instead of row by row?
  9. Getting return value from stored procedure in C#
  10. SQL error: Incorrect syntax near the keyword ‘User’
  11. Passing List to SQL Stored Procedure
  12. Query extremely slow in code but fast in SSMS
  13. DropdownList DataSource
  14. How to retrieve data from a SQL Server database in C#?
  15. Stop SQL query execution from .net Code
  16. Queuing in OneWay WCF Messages using Windows Service and SQL Server
  17. Any way to SQLBulkCopy “insert or update if exists”?
  18. SQLException : String or binary data would be truncated
  19. Multi threading C# application with SQL Server database calls
  20. What’s the fastest way to bulk insert a lot of data in SQL Server (C# client)
  21. What SqlDbType maps to varBinary(max)?
  22. ExecuteNonQuery returning -1 when using sql COUNT despite the query string
  23. How can I convert ticks to a date format?
  24. How to make LINQ execute a (SQL) LIKE range search
  25. Add WHERE clauses to SQL dynamically / programmatically
  26. Index (zero based) must be greater than or equal to zero
  27. How to insert data into SQL Server
  28. Query validation using C#
  29. Use SQL Server time datatype in C#.NET application?
  30. Generating sql code programmatically

Leave a Comment