What am I doing wrong with this? (DataRow)

[vbMark]

When I call the below code what I get returned
is the string "System.Data.DataRow"

I don't understand how this works. What am I doing wrong?

private string GetData(string strQuery)
{
SqlConnection sqlCN = new SqlConnection(CONNECTION_INFO);
SqlDataAdapter sqlDA = new SqlDataAdapter(strQuery, sqlCN);

try
{
sqlCN.Open();

DataSet DS = new DataSet();

sqlDA.Fill(DS);

System.Data.DataRow drDataRow;
drDataRow = DS.Tables[0].Rows[0];

DS.Dispose();
sqlCN.Close();

return drDataRow.ToString();
}
catch (SqlException sqlExcp)
{
return "Error: " + sqlExcp;
}
finally
{
sqlCN.Dispose();
sqlDA.Dispose();
}
}

 

[Marina]

The ToString method of the datarow just returns the name of the class. So
you get what you are supposed to get when calling this method.

If you want the contents of the datarow, you have to create that string
yourself by iterating through the contents of the row.

 

[vbMark]

@tk2msftngp13.phx.gbl:

That was it. Thanks!

The ToString method of the datarow just returns the name of the class. So
you get what you are supposed to get when calling this method.

If you want the contents of the datarow, you have to create that string
yourself by iterating through the contents of the row.

When I call the below code what I get returned
is the string "System.Data.DataRow"

I don't understand how this works. What am I doing wrong?

private string GetData(string strQuery)
{
SqlConnection sqlCN = new SqlConnection(CONNECTION_INFO);
SqlDataAdapter sqlDA = new SqlDataAdapter(strQuery, sqlCN);

try
{
sqlCN.Open();

DataSet DS = new DataSet();

sqlDA.Fill(DS);

System.Data.DataRow drDataRow;
drDataRow = DS.Tables[0].Rows[0];

DS.Dispose();
sqlCN.Close();

return drDataRow.ToString();
}
catch (SqlException sqlExcp)
{
return "Error: " + sqlExcp;
}
finally
{
sqlCN.Dispose();
sqlDA.Dispose();
}
}