I have a datatable with one column, I am trying to retrieve the values in the table into a string array using linq.
Dim dt As DataTable = DataAccessManager.ExecuteSelectQuery(selectStr).Tables(0)
Dim strArr() As String = (From dr As DataRow In dt.AsEnumerable.AsQueryable _
Select dr("MASTERID").ToString()).ToArray()
I get an error "Range variable cannot match name of a member of the 'Object' class"
I have a DataTable.Dim VoucherDT As New DataTable
[code]...
I could not assign a string value to integer or decimal column datatype. How can I convert the string value to dataColumn datatype?
I'm trying to learn Linq and can't seem to figure out what I'm doing wrong. the proper way to return a list of strings that contain the text "img" using linq? Here's my sample code:
[Code]....
Is there a way of merging (importing or whatver is the correct terminology is) the data from an Array in to a DataTable woithout looping. I already know how to loop through the array to populate the DataTable with new DataRow but I'm looking for something much faster if it exists. I've got a 1 dimensional String array i.e. 'String()' that I need to populate a DataTable with new DataRows.
View 4 RepliesI have a stored procedure in DBML and I try to pass the result to "sqlQryArray" as an array(1 dimensional array). But the bottom code causes error like below message. What else should be done?
Error 1 Value of type '1-dimensional array of aaaDatabase.stp_GetSomethingResult' cannot be converted to '1-dimensional array of String' because 'aaaDatabase.stp_GetSomethingResult' is not derived from 'String'.
The return result from stored procedure is a just list of first names of students(only one column)
Dim sqlQry = aaaLINQ.stp_GetSomething(bbb,ccc,ddd)
Dim sqlQryArray As String() = sqlQry.ToArray()
I have been trying to solve this with no luck. If i have an array Private _msg() As String = {"You have been successfully logged in.", "This message has been sent successfully.", "This message has been posted successfully."} And a string (page source) can LINQ try to find any of the Three elements in the array with out having to use a loop?
View 11 RepliesCan a LINQ or a LAMBDA expression be used to count the 1's in a binary string ?For example, if I convert a number to its BINARY using.>>
Dim binaryString As String = Convert.ToString( numberVariable, 2 )
1) Without using a loop such as a FOR NEXT loop, can I count the number of 1's in the STRING using LINQ or a LAMBDA expression?
2) Can I get the indexes of where the 1's are at in a collection such as a LIST using LINQ or a LAMBDA expression?I know the syntax of some LINQ expressions, however, I don't know which method may be suitable.
I am getting array of selected datarows from a datatable.select.I use the commands below to get that array or datarows
Dim foundRows() As DataRow
strExpression =
Here is what I tried.I have looked at examples by MS but they all just write to the screen and I have no interest in that.
For Each rowWork In foundRows
dtWork.Rows.Add(rowWork)
Next[code]....
"LineOfBusiness = 'CPP'"
foundRows = modXchange.pdtWork.Select(strExpression)
Now, I want to place the rows from foundrows into an empty data table.I did what I thought was the obvious but that only returns a bunch of rows with no data
I have a dataset and inside it a dataTable. How can I retrieve the data of the datatable?[code]...
View 4 RepliesWe are trying to store and retrieve datatable as blob (varbinary(max)). We convert the existing datatable into an xml file and store that xml file as a blob and while retrieving we get the blob as xml file and convert it back to datatble. It seems to be storing and retrieving the xml object but having issues while converting it back to the datatable ("End of stream - error").
View 2 RepliesI have a question for store data from vb.net
I want to store data a file without use any database engin and
Retrieve and save data from DataTable
In the rpt_RowDataBound sub, instead of using a FileInfo object, I need to use a database value ("statusupdate").
If month <> TryCast(e.Item.DataItem, FileInfo).CreationTime.Month OrElse year <> TryCast(e.Item.DataItem, FileInfo).CreationTime.Year Then
How can I replace the "FileInfo" in the above code line with datarow("statusupdate")
Code:
HTML:
<asp:Repeater ID="rpt" runat="server" OnItemDataBound="rpt_RowDataBound" Visible="true">
<ItemTemplate>
[Code].....
I'm using a LinqDataSource to populate a basic GridView in ASP.NET. The user has the ability to filter the results, so I use a few WhereParameters and the Where within the LinqDataSource.My client has requested an option to export the filtered results to a file. Easy enough to pipe the data into a file, but I would prefer not to rewrite all the where clauses in the codebehind. I would simply like to extract the full set of results, preferably by using the already configure LinqDataSource.When using LinqDataSource's OnSelect method, the e.Result has the data I'm after, but my GridView PageSize is set to 20, which means that the LinqDataSource (rightly so) only fetches the first 20 records.Is there anyway to get hold of the entire data set?
View 1 RepliesCan this be rewritten any better using LINQ? I'm a C#er trying to think in VB.NET for this current project. It's in an ASP.NET Web Forms .vb codebehind:
Public ReadOnly Property AllowedCategoryIds As Integer()
Get
Dim ids = New List(Of Integer)
[Code]....
I'm trying to convert DataTable to Linq using
DIm result = From r in dt.AsEnumerable()
Select new ( col1 = r.Field<integer>("id"), col2 = r.Field<string>("desc"))
But i get error near 'new (' saying type expected.
I found the following example on [URL] Unfortunately, I need it in VB and it's using some constructs that neither I nor the automated code converters reciognize. Anyone out there know how this should be written in VB.Net? (the problem spot is the "select new {...")
PeopleDataSet ds = new PeopleDataSet();
using (PeopleDataContext context = new PeopleDataContext())
{
[Code].....
I need help converting datatable to xml using Linq. I could do it with hardcoded column names as you can see in my code .. but i need it without hardcoding it ..Example datatable ..My linq query ..
Dim xmlDoc As New XDocument(
From row In dt.AsEnumerable()
From row In dt.AsEnumerable()[code]......
I'm completely dense here, but I'm trying to get some stats from a DataTable. One of the columns in the datatable is called "colour".I need to find out how many of each instance of "colour" are in the datatable.
I'm trying:
Dim q = From p In PGWorkingDataTable _
Group p By p("colour") Into Group _
[code].....
Why does the following code give an error?
[Code]...
If I change the code to remove the second field, as below, then the code does not give an error.
[Code]...
discovered the compact mode of this instructions vs usual code. I found sample code for selecting, etc. from a datatable, transforming a column in a list or array - all operations are "Select"s - readonly.I need to make an simple update on a certain rows (using LINQ) from a DISCONNECTED datatable for which now I'm using this
for each dr as datarow in dtable.Rows
dr("MyField") = 77
next
[code].....
I have two DataTables:
dt1 - personid, name
dt2 - personid
I want to create a third datatable to include records from dt1 when they are NOT in dt2 using LINQ. In this case, I can bind the third datatable to a dropdownlist.
Am new to the concept Linq.I created a var where i joined 3 tables to get the data and then bind it in a datatable and create a csv file. Now i want to use an additioanl table in the same variable to be bind with the datatable but my problem is i cant use join here since i dnt have any common col or primary col in this additional table.How do i add this extra table?
[Code]...
I'm writing a small web app in VB.NET and I would like to do paging for my DataTable in the following function :
Public Shared Function Testing(ByVal KeyWord As String, ByVal CurrentPage As Integer, ByVal PageSize As Integer) As DataTable
Dim db As New BibleDataClassesDataContext
[code].....
Currently, I am using a loop to find the row I want to update.
Public Sub pubsub_SetUserDGVColumnWidth(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewColumnEventArgs)
' update all user settings for the given column
[Code]....
Is there a VB.NET equivalent to the C# var keyword? I would like to use it to retrieve the result of a LINQ query.
View 4 RepliesI have a Dynamic DataTable Created at runtime. The Setup is like so
Id | Name | Age
-----------------
3 | Mike | 21
6 | John | 43
8 | Sara | 34
What I am trying to do is come up with a linq statement I could use to find and update specific rows.
Such as a statement to change AGE to '33' WHERE ID = '3'
My code So far is:
-[VB.NET]-
Dim MyRow As DataRow = From column In MyTable.Rows Where column("Id") = 3
MyRow(0)("Age") = 33
But this is not updating my DataTable entry.
I wish to output an IEnumerable type (dictionary(of T) would be perfect, otherwise a datatable would be acceptable) that provides an aggregation of the data within the datatable.In SQL I would write the query as such: select groupByColumn, sum(someNumber) from myTable group by groupByColumn
In VB.NET the closest I have got to this (achieved using information here) is: dt is a datatable containing two columns, referred to by index in p below Dim q = From p In dt Group p By p(0) Into Sum(p(1)) Select p(0), SumOfNumber = Sum
However I receive error: "Range variable name can be inferred only from a simple or qualified name with no arguments." on the p(0) element. Therefore my question is as follows:How can I resolve this error? How do I process the result (q) as an IEnumerable type? Life isn't made any easier because I'm using Linq in unfamiliar vb.net. Many examples are in C#, but I haven't really come across anything suitable even in C#.
i want to use linq to fetch data from datatable.I have 2 tables in Cache and i want to join these tables then get value from resultset.I pasted Original Sql query and my linq query here.My linq query returns nothing.Where do i miss?My original sql query returns 1 row,but q1 is nothing
[Code].....
I write the code below. I want to make short using linq count.
Dim query0 = From obj In dtAginglist _
Where (obj.Field(Of String)("CurrentStatus") = "Open" Or obj.Field(Of String)("CurrentStatus") = "Acknowledge") _
[Code]....
I try to use code below but it dosen't work with if source is datatable.
Dim orderCounts = From c In customers New With { _
c.CustomerID, Key .OrderCount = c.Orders.Count() }
syntax of the LINQ query to use GROUP something BY something and select some fields of the datatable. i am having a datatable filled with some rows, i am trying to fill the datagridview with the GROUP BY query output of some fields.
View 4 Replies