use of double quotes as string

Question

I am developing in vb.net

Dim dtDetails As DataTable = Utility.GetDetailsTable()
Dim resource_id As String = ""

Dim dtrow = dtDetails.Select("id='" & user_id & "'")
If dtrow.Length > 0 Then
    For i As Integer = 0 To dtrow.Length - 1
       If i > 0 Then
          resource_id += ","
       End If
       resource_id += Convert.ToString(dtrow(i)("instance_id"))
    Next

but when I use resource_id further, it is not working, Docs returns as empty

Dim resource_ids = New BsonValue() {resource_id}
Dim querys = Query.And(
    Query.EQ("user_id", user_id),
    Query.In("resource_id", resource_ids)
)

Dim Docs = ceilometer.GetCollection("meter").Find(querys)

because I need it in this format BsonValue(){"resource_id1","resource_id2"}. Please help me to solve this

[this might be of help](http://stackoverflow.com/a/24145158/1070452) hard to tell from the question — Ňɏssa Pøngjǣrdenlarp, Mar 30 '15 at 17:09

score 1 · Accepted Answer · edited May 23 '17 at 11:51

1

From how I understood your question, I believe you need to add the dynamic ids to the BsonValue array. Using an extension from this answer:

<Extension()> _
Public Sub Add(Of T)(ByRef arr As T(), item As T)
    Array.Resize(arr, arr.Length + 1)
    arr(arr.Length - 1) = item
End Sub

Which you can then use in your code as:

Dim dtDetails As DataTable = Utility.GetDetailsTable()
Dim resource_ids As new BsonArray

Dim dtrow = dtDetails.Select("id='" & user_id & "'")
If dtrow.Length > 0 Then
    For i As Integer = 0 To dtrow.Length - 1
       resource_ids.Add(Convert.ToString(dtrow(i)("instance_id")))
    Next
End If

Dim queries = Query.And(
    Query.EQ("user_id", user_id),
    Query.In("resource_id", resource_ids)
)

Dim Docs = ceilometer.GetCollection("meter").Find(queries)

edited May 23 '17 at 11:51

Community

1
1

answered Mar 30 '15 at 18:28

chridam

100,957
23
236
235

It shows error "add is not a member of system.array" in resource_ids.Add(Convert.ToString(dtrow(i)("instance_id"))) – Syed Md. Kamruzzaman Mar 31 '15 at 02:57
Did you add the extension? – chridam Mar 31 '15 at 06:58
which extension? I add MongoDB.Bson, Driver, Driver.Builders – Syed Md. Kamruzzaman Mar 31 '15 at 07:06
it works if I replace Dim resource_ids As new BsonArray, Please edit the answer so I can mark it as answer. – Syed Md. Kamruzzaman Mar 31 '15 at 07:07
another query is i want to add sql like operator such as resource_ids like "%chridam%" or resource_ids like "%zaman%", please help – Syed Md. Kamruzzaman Mar 31 '15 at 07:10
Hi @SyedMd.Kamruzzaman, I have edited the answer to include the working part, thanks for taking note. About the other issue, once again I would encourage you to open/create a new question, that way you can get wider help from the community or better answers as I may not be able to be of help always. – chridam Mar 31 '15 at 07:23
Thanks a lot for help, as an expert MongoDb user, if possible, help me otherwise I will seek. Thanks a lot again for answer – Syed Md. Kamruzzaman Mar 31 '15 at 08:21
Let us [continue this discussion in chat](http://chat.stackoverflow.com/rooms/74174/discussion-between-syed-md-kamruzzaman-and-chridam). – Syed Md. Kamruzzaman Mar 31 '15 at 08:22
Unfortunately I can't enable chat at the moment due to my internet policy. Let me know when you have created the new question and I will try my best to help. – chridam Mar 31 '15 at 08:31
thanks. questions link: http://stackoverflow.com/questions/29364100/use-of-like-operator-in-mongodb – Syed Md. Kamruzzaman Mar 31 '15 at 08:34

use of double quotes as string

1 Answers1

Linked