Accessing indivdual columns from a xsd file - ASP.Net

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • DJOuk
    New Member
    • Dec 2007
    • 4

    Accessing indivdual columns from a xsd file - ASP.Net

    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:
    DataTable commentinfo = commentclass.GetCommentInfo(commentid);
            int userrating = Convert.ToInt32(commentinfo.Rows[0]["userrating"].ToString());
            int commentposterid = Convert.ToInt32(commentinfo.Rows[0]["userposterid"].ToString());
            int postrating = Convert.ToInt32(commentinfo.Rows[0]["rating"].ToString())
    ;


    not working, sad times, does anyone have an idea?
    Last edited by jhardman; Mar 17 '08, 02:55 PM. Reason: moved to the .NET forum, ASP forum is for "classic" ASP
  • jhardman
    Recognized Expert Specialist
    • Jan 2007
    • 3405

    #2
    DJ,

    Welcome to the Scripts.com, I hop[e you can find answers here. Unfortunately, you posted your question in the wrong forum. The ASP forum is for "classic" ASP only. I have moved your post to the .NET forum where hopefully it will get more attention.

    Jared

    Comment

    Working...