C# SQL Data Adapter System.Data.StrongTypingException

Question

I get my data from SQL to Dataset with Fill. It's just one table with two columns (CategoryId (int) and CategoryName (varchar)).

When I look at my dataset after fill method, CategoryId Columns seems to be correct. But in the CategoryName I have a System.Data.StrongTypingException.

What could that mean?

Any Ideas?

score 13 · Accepted Answer · edited Jul 08 '16 at 03:58

13

When you get the value of a row/column in a typed dataset, by default it raises this exception when the value is DBNull. So

string x = Row.CategoryName;//Raises this exception when CategoryName is null.

You can correct this with the typed dataset designer.
Set the property "Nullvalue" of the CategroyName column to "(Empty)"

edited Jul 08 '16 at 03:58

sujith karivelil

28,671
6
55
88

answered Apr 29 '10 at 08:00

Julian de Wit

3,084
2
29
29

C# SQL Data Adapter System.Data.StrongTypingException

1 Answers1