Jump to content

Gauls

Members
  • Content Count

    8
  • Joined

  • Last visited

Community Reputation

0 Neutral

About Gauls

  • Rank
    Newbie
  1. Hello I have created a user defined table inherited from Datatable,and a custom row inherited from Datarow while sending across webservice i have added them to a dataset. Now i can receive the dataset on my client but when i am trying to refer the table it is a datatable instead of the custom oneCan some one help??????????????
  2. Gauls

    Hashtable

    sorry but that doesn't help as i am unable to retieve any value from the hashtable without the keys
  3. Gauls

    Hashtable

    My Question is Incase if i have two hashTables and does not contain same key values , so there is no link between the two tables right. Now i want to loop thru both the hashtables at a time like one value from 1st hashtable and one value from the 2nd hashtable then move next ....so on Can i use for i as integer=0 to ht.count or something like that ??
  4. Gauls

    Hashtable

    Hi i have two hashtablesexample :Hashtable 1 Hashtable 2key Value key ValueDetails Order Details ProductCan i get One Order from 1st hashtable and then One product from the second hashtable ?Thanks
  5. Gauls

    TypeLoadException

    Nope all the three of them have the same configuration really. But want to know what causes such errors, may be i can pick up some link from the list of causes
  6. Gauls

    TypeLoadException

    TypeLoadExceptionCould not load type OpenNETCF.Web.Services2.Dime.DimeAttachmentCollection from assembly OpenNETCF.Web.Services2, Version=1.4.50804.0, Culture=neutral, PublicKeyToken=30C767B29D52D6E6.This the error i get when i try running my application on the HP Ipaq out of three Pocket PC just one of them is facing this problemAfter installing the application Cab file i am getting a msgbox "Requires the installation of OpenNETCF.SDF.ppc3.ARM.CAB for it to run properly. Install the Cab file before running this application" Can some one help?
  7. Gauls

    Many to Many Tables

    Thanks pulpfiction But this query gives an error as the result returns more then one value so can't use subqueries with = != operatorsCan we use joins?
  8. Gauls

    Many to Many Tables

    I have a query to make with three tables, they are as followsTable names ColumnsLesson LessonID(PK), Lesson NameStudent StudentID (PK), Student Name Mark MarkID, Mark, StudentID (FK),LessonID (FK)The Combination of StudentID and LessonID are unique in the Marks TableExample :LessonLessonID , Lesson Name1. L1 Lesson12. L2 Lesson23. L3 Lesson3StudentStudentID , Student Name1. S1 Student12. S2 Student23. S3 Student34. S4 Student4 MarkMarkID, Mark , StudentID, LessonID1.M1, Mark1 S1 L12.M2, Mark1 S2 L13.M3, Mark1 S3 L14.M1, Mark1 S1 L25.M2, Mark1 S2 L26.M3, Mark1 S3 L3Result Should be If the Selected Lesson is Lesson2 (L2)Student3 (S3)Student4 (S4)my query is Get all the Students that are not in the selected Lesson The problem is to get all the students Name from the students table that are not listed under lesson2 in the marks table All in one single query
×
×
  • Create New...