Jump to content

Gauls

Members
  • Posts

    8
  • Joined

  • Last visited

Posts posted by Gauls

  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. This will give the number of keys in the tableDim cnt As Integer = hashtable.Keys.Count()

    sorry but that doesn't help as i am unable to retieve any value from the hashtable without the keys :)
  3. I am not sure if I understood the question correctly, To get the value from the hashtables....Dim key = "2"          'some numberResponse.Write(hashtable1(key))Response.Write(hashtable2(key))

    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. 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. 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. 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. Try this....SELECT    student.studentnameFROM        studentWHERE    (NOT (student.studentid =                          (SELECT    Mark.StudentID                            FROM          Mark                            WHERE      Mark.Lesson id = 'L2')))

    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. 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...