Is that possible to get current Enumerator (...or iterator? Don't know which tern is the correct one) in a LINQ query ? For example, I try to create a XML output (via LINQ to XML) of all currently loaded assemblies. [code] is it possible to somehow get current "index" (counter?) from LINQ's Selects? I would like to use it in XML. [code]
View 1 RepliesUsing For Each, can I get the current position (without an incrementing int)?[code]....
View 6 Repliesim using for each row in ...
next
just asking, how will i know the current row index?
I am trying to figure out how I can get the Index of the Current Object in Object that Implements IEnumerable / IEnumerator. I am not real familiar with the IEnumerator / IEnumerable interfaces so a coe example would be helpful. I looked here [URL] But I am lost. I see something on GetHashCode for the Current Object but have no idea - as I am not familiar with hashcodes either.
View 4 RepliesI would like to get the index of the current row at the PreRender event.
Protected Sub GridView1_PreRender(sender As Object, e As System.EventArgs) Handles GridView1.PreRender
Dim idx as integer =...
End Sub
I have following link in a.aspx file:
<a href="a.htm" target="iframe">A</a>
I want to set link from a.aspx.vb page according to what person is viewing the page. How can i change this so that if user clicks on link it will replace current frameset contained in current window with a url provided according to user?
Or in another way:
How will i replace href code in aspx page by giving it value from aspx.vb page?
I am having a problem using ADO 2.8 and SQL Server 2000.Im using the SQLOLEDB Provider and when Im trying to set the Index by using the code below i receive the ffg error...Error 3251 : Current Provider does not support the necessary interface for Index functionality..I have to use SQL Server as our Access databases are quite large...Does the index and seek function even work with ADO and SQL Server 2000?...I am migrating from DAO to ADO to use SQL Server and Im trying not to change the existing code so I need to use the Index and Seek functionality as it has been used everywhere...There are no links between any tables so I am accessing the table directly.
Dim Db as new ADODB.Connection
Dim rs as new ADODB.Recordset
Db.Provider = "SQLOLEDB.1"
[code]....
I am using VS 2008, VB.NET and Windows XP r3.I am trying to use LINQ to DataSet in my app. In my test app, I can get it to work find. My test form has an OleDbDataAdapter, an OleDbConnection and a DataSet. It also has a DataGridView bound to the one table in the DataSet, a BindingSource and a Button.[code]
View 7 RepliesI have a datagridview having 3 columns (qty,scraft factor,actuall qty). What I want is if the user encode 50 in qty and 2 in scraf factor, actuall qty will automatically computed based on qty multiply by 2. I was using keyup event. Now I am using endedit to get the current value of the current row and column, now the problem is if the amount to be encoded is more than one digit it will not accept because of endedit. What event do I have to used? or any solution with this scenario.
[Code]...
What I want to do is take the full contents of the address bar and see if everything after the site path (i.e. everything after the question mark), contains a certain string, and if it does then return a path using the site URL and that string. An example and some code to make things understandable:
[Code]...
I'm using the Details View control of VWD asp.net 2008
I have a users database table. One of the columns contain the "uniqueidentifier" user's profile ID, created by VWD (from the automatic profiles table).
From my table, I would like to select only the data pertaining to the logged in user.
How do I get the current unique user profileID in general and then how do I use that for my query?
In the configure data source option of the control, I select the check box for "Return Only Unique IDs" and the WHERE option. In this new window I select the Column to the profile userID ... "=" and then assumed I should select Source: "Profile".
Now what should the parameter properties or value be to select only the current logged userID?
OR how can I do this just in C#? There doesn't seem to be any code behind after instering a DB with the VWD controls?
If I use a LINQ query over some type of collection, is there any way to know the initial index of an element of the result?
Purpose: I make a query to set as source of a DataGridView, and on a (button)cellclick event I want to a call a method that needs to reference the collection at the correct index.
I'd normally do this in C# but since I've got to get this code in this particular assembly which is a vb.net one, I'm stuck.
Here's my linq query:
Dim i As Integer = 0
Dim oldAndCurrentIntersectionOnNames = From currentApplicant In currentApplicants _
Group Join oldApplicant In oldApplicants _
[CODE]...
You'll see the .Index = i+=1
This was my attempt to do what I'd quite happily do in C# (i.e. Index = i++) in VB. Unfortunately the VB compiler doesn't like that. how I'd do this in VB.
How do I force users to save the current record (if current record has changed) and not let user go to the next record unless the save button is pressed?
View 5 RepliesI'm trying the fetch only the date within the current and return how many rows Dim dc as new dataclassesdatacontext dim q=from p in dc.worktime where p.name.equals(session("name") and p.date ).count what I should I put after "p.date" ? And if I want to search for the record which there are record that are insert five days earlier, how to do that ? use (datetime.now - 5) ?
View 3 RepliesI'm trying to create two arrays filled with a set of strings from two tables in a database and then compare them. For example:
array1[0]="1101" and
array2[0]="0110"
If both respective characters equals 1 then perform an action. But when I run this code I receive the error: Index was outside the bounds of the array. System.IndexOutOfRangeException.
For some reason I believe the problem area is with the following two statements:
comparestringa = userintarray(x) and
comparestringb = eventintarray(x)
When I comment them out, the error doesn't show.
myconnect = New SqlConnection("xxxx")
Dim Table1 As New SqlCommand("SELECT * FROM Table1", myconnect)
Dim Table2 As New SqlCommand("SELECT * FROM Table2", myconnect)
Dim array1 As New ArrayList
Dim array2 As New ArrayList
Table1.Connection.Open()
[Code] .....
For
Each
Item As
DataRowView In
lbOrdersNeedToBeVoided.Items
[code]....
The below code will fill User Records in "users".
Dim users= From p In oDbUser.USERs Where p.STATE= "MI" And p.STATUS = 1
how can i use a foreaach loop in the result and take each indidual row items ?
I know that LINQ queries are deferred and only executed when the query is enumerated, but I'm having trouble figuring out exactly when that happens.Certainly in a For Each loop, the query would be enumerated.What's the rule of thumb to follow? I don't want to accidentally enumerate over my query twice if it's a huge result.
For example, does System.Linq.Enumerable.First enumerate over the whole query? I ask for performance reasons. I want to pass a LINQ result set to an ASP.NET MVC view, and I also want to pass the First element separately. Enumerating over the results twice would be painful.It would be great to turn on some kind of flag that alerts me each time a LINQ query is enumerated. That way I could catch scenarios when I accidentally enumerate twice.
in my prev question i was suggested with LINQ solution. It was great and simple. I tried to solve next similar but a bit diff problem with similar approach but i failed.
how can i make the below code better
For Each Item As ListViewItem In RoomsListView.Items
For Each Item1 As Room In myBookedRooms
If Item1.UIN = Item.SubItems(1).Text Then
[Code]....
I have an array of approximately 1000 classes. All of these classes must have one of their properties changed to the same value. I need this to be as optimized and fast as possible.
Would LINQ be faster than a for-loop? Any other ideas for faster execution?
given this function:
Public Function Search(ByVal StartIndex As Integer, _
ByVal MaxResults As Integer, _
ByVal AccountNumber As String, _
ByVal LastName As String, _
[Code]....
instead of what I expected:
Select count(*) from remitline where lastname = "smith"
What am I doing wrong building up the where clause? I'm using Castle ActiveRecord 2.1
if there is that much of a performance gain in running a LINQ stored procedure versus a LINQ query?
View 1 RepliesHow can I get the current row value?
Private Sub PatientUpdate()
Dim dr As DataRow
dr = pa.Tables(0).Rows(intcurrentindex)
[Code]....
I would like intcurrentindex to be the value of the selected row of the datagridview. I have tried this in place of intcurrentindex however this fails to work:
DataGridView1.SelectedRows(0).Selected
I have to join two main tables, and I need to filter the results by elements in an ASP.NET web form. These filters are created on the fly so I have to use a lot of where extensions to filter the query. I want to execute the query with as optimized SQL as possible.
I am first doing a simple join between TW_Sites and TW_Investigators. Then there are two sub-tables that are involved. TW_InvestigatorToArea and TW_InvestigatorToDisease. While most of the where clauses are working fine, I have found a performance issue that won't be an issue right now, but will be an issue as the table gets bigger.
The arrays DiseaseCategories and DiseaseAreas would be the results of a CheckBoxList result.
Protected Sub LoadResults()
'Get Dictionary of Filters
Dim FilterDictionary As OrderedDictionary = Session.Item("InvestigatorFilterDictionary")
' Initialize LinqToSql
[code]....
I'm developing new cafe software in VB.Net and I need to get the url from the web browser.How can I get the current url from any web browser using VB.Net only? (Not ASP.NET)
View 3 RepliesThis is kind of a silly question, but is it possible to get the name of the method that is currently being executed from within that method?
Public Sub SomeMethod()
Dim methodName as String = System.Reflection.[function to get the current method name here?]
End Sub
My program runs and after running creates some data in datagridview. I export the data to an excel file. Till now all things are okay, but I want to have the excel file open and export the second iterations data to the same file but different sheet. I have done everything but it gave me an error. Here is the pieces of code related to exporting. [code]...
View 1 RepliesI have an ACCESS database containing VBA code residing on a USB drive in a directory called 'collect'. When the application runs the code uses a DLL that is in the same directory as the application. The code in the DLL is VB.NET.
The DLL is declared :
Private Declare Function Collect Lib "x:collectwcolv332.dll" (ByRef Str As Any)
This works fine but it only works when the USB drive is mapped to x:
The follwoing which I expected to work does not
Private Declare Function Collect Lib "wcolv332.dll" (ByRef Str As Any)
and neither does
Private Declare Function Collect Lib "collectwcolv332.dll" (ByRef Str As Any)
Is there a way to programmatically find out if the OS an application is running from is one that has UAC?
View 14 Replies