Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails
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 Descript…
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 qu…
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 SalesOrderType(M…
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 v…
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 a…
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. …
I have the following query working in my code and now want to move into a separate class as a method that I call with List<Logrecord>, but having trouble determining what TYPE I need to return from th…
I have below query. I want to filter items and do not want to add new salesOrders() where startDate is Empty.
If startDate is Empty I want to remove it.
req.sOrders = (from document in …
I have a linq query which is pulling data into my object model. Problem is that I'm getting an error because when I convert it it is an empty string. How can I convert it to a null if it is an empty…
If I have the below XML. I want to do 2 things.
First get everything between <key></key> so I can fill up my models in my .NET code.
Second Delete Key id 123 and everything between
How can I…
Is there a shorter way to write this so no looping is involved?
So, I have a model. I was using the below code. I'm adding data from a collection to another. It was replacing it but I need to add it.
I tried below
But I'm getting the below er…
I found this code and I am able to use it in another program with no problem. It gets me the total of the line items checked.
Now I need to change it but I haven't seen code written like this. Can…
I am using NewtonSoft to convert JSON to classes.
Below is the JSON response with array of inventory that incldues a single array of contacts.
I receive a JSON response in the following syntax, where it is returned as objects and not array. Is this right?
I am slowly getting a hang of JSON. At this point I am stuck with the issue of populating a datagrid in VB.NET from a JSON response. The JSON response is something like
I am querying a Sql database with LINQ and I listed to show it in view. The problem is the data which come from sql is pretty big like around 100000 rows and when it sends to the view it i…
I just want return class library - Domain.User
I assume I can use uTmp as class to return but I do not know how to do.
public Domain.User ReadCommonUserInfo(string userID)
I am using an XML file to keep track of files moved, no I want a function to return the files not in both table that match a file pattern.
Both xmaster and xsublist return elements with sub elemen…
SELECT Age FROM Testing WHERE(AgeUI = 'Selected')
SELECT BenefitAmount FROM Testing WHERE(BenefitAmountUI = 'Selected')
CREATE TABLE [dbo].[Testing](
[ID] [int] IDENTITY(1,1) NOT NULL,
I am using LINQ to loop through a List<List<string>>. The format of this collection looks like this:
QuoteNum, QuoteCoverage1, QuoteCoverage2, QuoteCoverage3, ...
1, Auto, Auto, Health…