how to read values for a select statement

[gnchishti]

DataTable.Rows [0]["ColumName"] not returning expected value.

[Neutrinora]

You might be not including all fields in query
try using
SELECT *FROM <table_name>
instead of
SELECT <column_names> FROM <table_name>