I have table in sql database with column that gives random number when you insert new row.
Now I built MVC application that going to insert new rows to this table and the only column …
I have a Linq query that runs a search in 2 tables (through a "Join"):
First table is tblProducts where master data for any product is saved (Name, Barcode, ItemCode, EnglishName, SpanishName,…
i have a data from database which includes some columns. one of them is ExpiryDate. it has SAP datetime format : MM/dd/YYYY nn:mm:ss AM
i wanna convert it from MM/dd/YYYY hh:mm:ss AM to …
hi there ,
when the form is load i load all the data to the customer entity class
var cust = EF.GetCustmoer(long cid);
now i have all the data in the cust object
when the form closed i want to …
I'm new to LINQ. I've create some test code using simple LINQ syntax in VB.NET. So, is this all there is to LINQ - A query-type syntax that is part of the VB.NET and C#.NET? Do other languages …
What does AsEnumerable() do in the code below? The code works with or without it.
Dim results = From car In cars.AsEnumerable()
Select car.make, car.model, car.color
I'm new to LINQ. Below I created some simple code. I want to now have the data source be XML. Is there a way to use the exact same LINQ SELECT/QUERY code (i.e., Dim results = ) again XML data? …
i have the following C# data object: image attached.
1. I want to write a C# LINQ query to group by Model ID and Sum of Stock QTY
Output Should be :
i want to convert the below Queries from C# to VB.Net:
var results = from p in objStock
group p by p.Model into g
I have a product class and it contains an array of categories.
How can I use linq to query by a provided category?
I am not an experience in LINQ so far, and is having the following error:
New transaction is not allowed because there are other threads running in the session
How do I can combine the results in this LINQ query?
c.field == 1 below generates results and c.field == 3 generates results but how can I show the list of both results together. …
I have this statement that returns ISBN and Price. How can I look up values on this result?
I am having some difficulties with getting the correct statement in lambda or linq.
select count(me.schools_id) as numOfStudent, schools_name, members_exams_examdate
I have a collection of Product IEnumerable<Product> products.
How can i filter this collection with an IList<string> items using linq.
I am accessing a jSon response using LINQ query. Attached is the Json response, the class I have declared with the fields and my LINQ query.
I have to group the items if they have the same …
I am working on the attached jSon response. I need to read the sub-array named "details" and populate a datagrid.
I am using VB.NET.
Attached is how I declared the classes to be used in my LINQ …
I added a new employee to SQL table.
Add(3, "Issy", "Holm");
And I added this to the List.
Then, check this in the sql db.
I have a DataTable called dt. Now here is what I want …
I had question on this Refactor C# code (https://www.experts-excha
How do I query this if we have more than Single record for …
I have the following method and its a linq statement.
I would like this method to update the database.
If there is any failure I want it to return false..
So I can use that …
I would like to get the percentage of a "type" of questions within an exam. I am able to get the total number each "type" of question and I am able to get the total number of questions in an exam. I…
I have a .net winform with a text box for file types.
A user would key in the text box a list of file types separated by a comma.
I would store that string in a variable like so below.
I have a data object that I pass to my gridview user control as a generic list and I would like to just use the fields/properties that I am returning from the stored proc I am running. My object has …
Figured out how to update most of the XML elements. I'm having issues with two. I want to updated the Attribute and another value as shown below. I want to update everything that has 123 with ABC. …