Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p><code>IndexOf</code> searches for exact match. To customize the matching criteria, you can use the <code>FindIndex</code> method:</p> <pre><code>// Finds first element of the array that contains `inputString` Array.FindIndex(arr, Function(s) s.Contains(inputString)) // Finds first element of the array that begins with `inputString` Array.FindIndex(arr, Function(s) s.StartsWith(inputString)) </code></pre> <p><strong>Edit to clarify <code>Function(s)</code> and lambdas:</strong> </p> <p><code>Array.FindIndex</code> takes two arguments, the first of which is an array you want to work on, the latter is a <code>Delegate</code> representing the predicate to check.</p> <p><code>FindIndex</code> does not have any idea about what kind of element you want. It gives you the flexibility to specify it. You tell it by passing in a function that takes an array element and returns a boolean indicating whether you want it or not. It essentially calls that function with every element of the array and returns the index of the first element for which that function returns true.</p> <p>Instead of writing a whole function and passing it using <code>AddressOf MyPredicate</code>, we can easily use the <code>Function(s) s.Contains(inputString)</code>. It's equivalent to:</p> <pre><code>Function MyPredicate(s As String) As Boolean Return s.Contains(inputString) End Function Array.FindIndex(arr, AddressOf MyPredicate) </code></pre> <p>Of course if we did that, we had to store <code>inputString</code> somewhere accessible to that method. It's a lot of dirty code. A lambda expression reduces all these hassles.</p> <p><strong>Edit 2:</strong></p> <p>I can verify this code prints "1":</p> <pre><code>Module Module1 Sub Main() Dim arr() As String = {"ravi", "somu", "arul"} Console.WriteLine(Array.FindIndex(arr, Function(s) s.Contains("so"))) End Sub End Module </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POSearch Array in vb.net
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USMehrdad Afshari
    1. USMehrdad Afshari
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COhai what is this Function(s).
      singulars
      1. PO
      1. USsomu
    2. COFunction(s) declares a lambda (inline function). Essentialy `Function(s) s.Contains(inputString)` means a function that gets `s` and returns `s.Contains(inputString)`. Instead of cluttering up the code and declaring a big function, you just write it inline and pass it to the method.
      singulars
      1. PO
      1. USMehrdad Afshari
    3. COok sir i understood. but i pass "so" that function return 0 i want 1 because somu include "So" okay . thanks you
      singulars
      1. PO
      1. USsomu
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload