I'm not sure if this is the right forum to ask. But I'm using ASP.net 3.5 & I've below code:
[Code]....
Now, I want to check how many elements are present in this distinct array & if the number of elements in this distinct array is more than 500, then I need to fetch only those first 500 elements. How can I achieve this?
Using C# I have
Queue N: 3, 4 9, 11
Queue A: 1, 2, 3, 4, 8, 9, 11, 12, 13
I want to remove all elements from Queue A that are present in Queue N And end up with Queue R: 1, 2, 8, 12, 13. How do I do this in C#. Trying to work with someones API and they offer a way to get the two queues and I need to filter based on one queue returned.
Updated Code Example: I am using a custom data type ModuleDetails
Queue<ModuleDetails> defaultQueue = apiCallDefault();
Queue<ModuleDetails> modQueue = apiCallAllModules();
I have LINQ result, and I have List.I want to do Where() on the LINQ and to REMOVE all the matching strings from the List.I get errors of:Local sequence cannot be used in LINQ to SQL implementations of query operators except the Contains operato
View 2 RepliesI want to get Array Elements by ForEach loop with Counter ..Â
whislist = dsddsds.Tables[0].Rows[0]["wishtlist_clg"].ToString().Split(',');
int i = 0;
foreach (string id in whislist) {
if (i != 0) {
tarsk.Value="1";
} else {
tarsk.Value="0";
}
whislist =525,1315,1331;
TARSK is an hidden field....
I want if whitelist is not in blank then 1 not equal to 0 is True other false but yet false condition is fire....
I have the following table structure:
[code]....
The following query returns the default recordset:
[code]....
I would like to select a distinct query based on three fields and display the rest of the fields. For example,
I have firstname, lastname, address, city, state and zip, but I only want to use the distinct on these fields first and last name. However when i use the distinct function I get a distinct on all the selected rows. I just want to distinct firstname and lastname and display the other fields. for example,
Mary Smith New York
Mary Smithy New York
Mary Smith Maine
I would like the result to be:
Mary Smith New York
Mary Smithy New York
I don't care about Mary Smith Maine, because i am only using the distinct for "Mary Smith" firstname and last name and showing the city.
my requirement is : am having a excel sheet with some values listed i want to pass each value present in any(specified) column to a text box present on a remote page (a site other than mine) as a input and capture the result displayed on the page and then store the input and reuslt side by side in db this should repeat till the end of the input values in the excel sheet.
View 2 RepliesI have...a dynamic populated select box several input boxes a submit button form fields are loaded initially using cookies several dynamic populated divs
I want... start loading the content of my DIVs after all FORM elements have been loaded completely (= filled with data, select boxes are populated)
Sample code:
[code]....
I have one table(tableName is getDetails and having three column ID, Name, City)
View 6 RepliesI need to know what would be the best choice of array to use given the following specifications. This array's size will be predermined upon the loading of the appication. All I want to do is be able to add values to this array and replace preexisting array items with new values without the array changing size. Someone suggested that I use a Dictionary Array Object? I would appreciate any suggestions.
View 3 RepliesI am developing web application using asp.net. Here i need to access two databases in which one is present on other server. I am able to connect to database present in same server but not with database present in other server.
I am using MS-access. I dont know the changes to be done and syntax for database connection.
Iam getting an array of list from database to client side(javascript array). Now my aim to place those values in a div one by one and that div should attach to the textbox similar to Autocomplete extender.
View 4 Repliesi have found out a way to find controls on content pages by using
var txt = $('input[id$=TextBox1]'). But how to access html elements like "<p>" tag and others in jquery when the html elements are in content page only.
how to pass a C# ASP.NET array to a Javascript array? Sample code will also be nice.
Let's say for simplicity that in my aspx.cs file I declare:
int [] numbers = new int[5];
now I want to pass "numbers" to the client side and use the data in the array within javascript. How would I do this?
Having some troubles selecting distinct rows.
[Code]....
This is not giving me the wanted results.
Two models:
[code]....
Each ContentVersion is linked to Content through the ContentID.
I want to select all "Content" where UserID = X, then for each selected "Content" I want the latest "ContentVersion".
The return type should be of type <IQueryable>ContentVersion.
I have tableone:
rowid pid gid dis
1 1222 aa dd
2 1222 bb cc
3 1222 cc dd
4 1331 vv cc
5 1331 cc zz
6 1414 zz cc
5 1414 xx zz
I need get distinct pid with rowid together. select * distince pid from tableone However, I get error: select rowid, distinct pid from tableone? Is any way to work out this one?
public static IEnumerable GetSollicitanten()
View 1 RepliesI am having difficulty in usint distinct with row filter, how to do this without using distinct.As i think distinct does not work with row filter.
Dim dsEName As DataSet = biz.GetEvent()
Dim dt As DataTable = dsEName.Tables(0)
Dim dv As New DataView(dsEName.Tables("dt"))
dv.RowFilter = "DISTINCT EventName "
Me.ddlEventName.DataSource = dv
Me.ddlEventName.DataTextField = "EventName"
Me.ddlEventName.DataValueField = "EventName"
Me.ddlEventName.DataBind()
1.Category:
CatID(Pkey),
CatName,
ParentCatId(Fkey)=> CatID is used as a ParentCatId
2.Comp_Cat:
CCID(Pkey),
CatID,(fkey),
CompID
In my stored Procedure I am passing PageNo,CompID.. My requirement is that One parent CatName is displayed Per page but only one time.
This is something I can easily do in SQL, but I'm pretty new to LINQ and haven't been able to find an answer online.
I need a LINQ query that returns two values; the first a distinct value and the second the count of the first value. This is filtered by a parameter. Here is my table:
[code]....
I am using C# + VSTS 2008 + .Net + ASP.Net + IIS 7.0 + ADO.Net + SQL Server 2008. I have a ADO.Net datatable object, and I want to filter out duplicate/similar records (in my specific rule to judge whether records are duplicate/similar -- if record/row has the same value for a string column, I will treat them as duplicate/similar records), and only keep one of such duplicate/similar records.
The output needs to be a datatable, may output the same datatable object if filter operation could be operated on the same datatable object.
What is the most efficient solution?
how to distinct arraylist value using c#?
View 10 RepliesHere's my current table data.
AccountNumber Product
00505871 Product1
00505871 Product2
00503297 Product3
00900004 Product4
00505871 Product3
00514884 Product3
00503297 Product2
00505871 Product1
How can I achieve following result.
AccountNumber ProductString
00505871 Product1,Product2,Product3,
00503297 Product2,Product3
00900004 Product4
00514884 Product3
I got a requirement from client that he wants to know distinct users information from sites and it sub sites those have access to site. There are separate groups for each subsite (contribute, approval and full access). From these all groups find distinct user information.
How can we do that using Object model?
I would like to get the distinct value form DataTabel using LINQ.
For example my sample table,
[code]....
1. How to get the distinct Country from Country you like column and the return records as Array or DataTable? (I want only India,USA,UK,Germany )
Is there any way to filter the record values using LINQ?