DJO
03-13-2008, 04:16 AM
How can I access the result of an SQL XSD query? I have called the tableadapter and the query but not sure how to access it:
I tried this:
Code: ( text )
1.
DataTable commentinfo = commentclass.GetCommentInfo(commentid);
2.
int userrating = Convert.ToInt32(commentinfo.Rows[0]['userrating'].ToString());
3.
int commentposterid = Convert.ToInt32(commentinfo.Rows[0]['userposterid'].ToString());
4.
int postrating = Convert.ToInt32(commentinfo.Rows[0]['rating'].ToString())
;
not working, sad times, does anyone have an idea?
I tried this:
Code: ( text )
1.
DataTable commentinfo = commentclass.GetCommentInfo(commentid);
2.
int userrating = Convert.ToInt32(commentinfo.Rows[0]['userrating'].ToString());
3.
int commentposterid = Convert.ToInt32(commentinfo.Rows[0]['userposterid'].ToString());
4.
int postrating = Convert.ToInt32(commentinfo.Rows[0]['rating'].ToString())
;
not working, sad times, does anyone have an idea?