{"action":"created","issue":{"url":"https://api.github.com/repos/jascam/CodePlexFoo/issues/234","repository_url":"https://api.github.com/repos/jascam/CodePlexFoo","labels_url":"https://api.github.com/repos/jascam/CodePlexFoo/issues/234/labels{/name}","comments_url":"https://api.github.com/repos/jascam/CodePlexFoo/issues/234/comments","events_url":"https://api.github.com/repos/jascam/CodePlexFoo/issues/234/events","html_url":"https://github.com/jascam/CodePlexFoo/issues/234","id":267882197,"number":234,"title":"VB.Net Compile Error","user":{"login":"jascam","id":13953383,"avatar_url":"https://avatars0.githubusercontent.com/u/13953383?v=4","gravatar_id":"","url":"https://api.github.com/users/jascam","html_url":"https://github.com/jascam","followers_url":"https://api.github.com/users/jascam/followers","following_url":"https://api.github.com/users/jascam/following{/other_user}","gists_url":"https://api.github.com/users/jascam/gists{/gist_id}","starred_url":"https://api.github.com/users/jascam/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jascam/subscriptions","organizations_url":"https://api.github.com/users/jascam/orgs","repos_url":"https://api.github.com/users/jascam/repos","events_url":"https://api.github.com/users/jascam/events{/privacy}","received_events_url":"https://api.github.com/users/jascam/received_events","type":"User","site_admin":false},"labels":[{"id":728829720,"url":"https://api.github.com/repos/jascam/CodePlexFoo/labels/bug","name":"bug","color":"ee0701","default":true},{"id":728831101,"url":"https://api.github.com/repos/jascam/CodePlexFoo/labels/CodePlexMigrationInitiated","name":"CodePlexMigrationInitiated","color":"ededed","default":false},{"id":728839592,"url":"https://api.github.com/repos/jascam/CodePlexFoo/labels/impact:%20Low","name":"impact: Low","color":"ededed","default":false}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2017-10-24T03:05:45Z","updated_at":"2017-10-24T03:05:47Z","closed_at":null,"author_association":"OWNER","body":"My DB is sql Server 2000. Some Table Fields data converted to UNICODE. I want to filter a record from a DataSet. Codes are.........\n \n    Try\n        Dim findTheseVals(1) As Object\n        ' Set the values of the keys to find.\n        Dim myDAgn As New SqlDataAdapter\n\n \n        findTheseVals(0) = pDivisionno ' Parameter Value\n        findTheseVals(1) = pGNe ' Parameter Value\n\n \n        sqlCon.Open()\n\n \n        Dim myDSGN As New DataSet\n        myDAgn.SelectCommand = New SqlCommand(\"SELECT * FROM GNDivision\", sqlCon)\n        myDAgn.Fill(myDSGN, \"GNDivision\")\n\n \n        myPrimaryKey(0) = myDSGN.Tables(\"GNDivision\").Columns(\"DivisionNo\")\n        myPrimaryKey(1) = myDSGN.Tables(\"GNDivision\").Columns(\"GNDEng\") ' Non Unicode Field\n\n \n        myDSGN.Tables(\"GNDivision\").PrimaryKey = myPrimaryKey\n\n \n        Dim myRow As DataRow\n        myRow = myDSGN.Tables(\"GNDivision\").Rows.Find(findTheseVals)\n\n \n        '=====\n\n \n \n        myPrimaryKey1(0) = myDSGN.Tables(\"GNDivision\").Columns(\"DivisionNo\")\n        myPrimaryKey1(1) = myDSGN.Tables(\"GNDivision\").Columns(\"GNDSin\")  ' Unicode Data Filed\n\n \n \n        myDSGN.Tables(\"GNDivision\").PrimaryKey = myPrimaryKey1  'This is line has the error\n\n \n'================\nwhen compiling Following error erissed \"These columns don't currently have unique values\"\nbut \"GNDSin\" field have unique data. Before converted to UNICODE this code work well.\nPl, Help Me. How to search records from a Dataset  when Data is UNICODE\n'================\n        findTheseVals(0) = pDivisionno\n        findTheseVals(1) = pViSIn\n\n \n        Dim myRow1 As DataRow\n        myRow1 = myDSGN.Tables(\"GNDivision\").Rows.Find(findTheseVals)\n\n \n \n        If Not (myRow Is Nothing) Then\n            isExists = True\n            GNid = myRow.Item(\"GNID\")\n         ElseIf Not (myRow1 Is Nothing) Then\n            isExists = True\n            GNid = myRow1.Item(\"GNID\")\n        Else\n            isExists = False\n        End If\n        sqlCon.Close()\n    Catch ex As Exception\n        sqlCon.Close()\n        MsgBox(ex.Message)\n    End Try\n\n\r\n\r\n#### Migrated CodePlex Work Item Details\r\nCodePlex Work Item ID: '8192'\r\nVote count: '1'\r\n"},"comment":{"url":"https://api.github.com/repos/jascam/CodePlexFoo/issues/comments/338858746","html_url":"https://github.com/jascam/CodePlexFoo/issues/234#issuecomment-338858746","issue_url":"https://api.github.com/repos/jascam/CodePlexFoo/issues/234","id":338858746,"user":{"login":"jascam","id":13953383,"avatar_url":"https://avatars0.githubusercontent.com/u/13953383?v=4","gravatar_id":"","url":"https://api.github.com/users/jascam","html_url":"https://github.com/jascam","followers_url":"https://api.github.com/users/jascam/followers","following_url":"https://api.github.com/users/jascam/following{/other_user}","gists_url":"https://api.github.com/users/jascam/gists{/gist_id}","starred_url":"https://api.github.com/users/jascam/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jascam/subscriptions","organizations_url":"https://api.github.com/users/jascam/orgs","repos_url":"https://api.github.com/users/jascam/repos","events_url":"https://api.github.com/users/jascam/events{/privacy}","received_events_url":"https://api.github.com/users/jascam/received_events","type":"User","site_admin":false},"created_at":"2017-10-24T03:05:47Z","updated_at":"2017-10-24T03:05:47Z","author_association":"OWNER","body":"I am waiting for Instant Reply Pl.\r\n\r\n\r\nThis comment was posted by sisilchandana on 1/20/2011\r\n"}}
{"actor":{"display_login":"jascam"}}