Im looking for a sql solution for counting records in a bridge table. I want to select all in table1 and add a column with count of each author's titles. Ive tried
SELCET Table1(*), COUNT(DISTINCT table.au_id) AS Titles
I am fairly new to C# programming and I am stuck on my little ASP.NET project.
My website currently examines Twitter statuses for URLs and then adds those URLs to an array, all via a regular expression pattern matching procedure. Clearly more than one person will update a with a specific URL so I do not want to list duplicates, and I want to count the number of times a particular URL is mentioned in, say, 100 tweets.
Now I have a List<String> which I can sort so that all duplicate URLs are next to each other. I was under the impression that I could compare list[i] with list[i+1] and if they match, for a counter to be added to (count++), and if they don't match, then for the URL and the count value to be added to a new array, assuming that this is the end of the duplicates.
This would remove duplicates and give me a count of the number of occurrences for each URL. At the moment, what I have is not working, and I do not know why (like I say, I am not very experienced with it all).
With the code below, assume that a JSON feed has been searched for using a keyword into srchResponse.results. The results with URLs in them get added to sList, a string List type, which contains only the URLs, not the message as a whole.
I want to put one of each URL (no duplicates), a count integer (to string) for the number of occurrences of a URL, and the username, message, and user image URL all into my jagged array called 'urls[100][]'. I have made the array 100 rows long to make sure everything can fit but generally, this is too big. Each 'row' will have 5 elements in them.
The debugger gets stuck on the line: if (sList[i] == sList[i + 1]) which is the crux of my idea, so clearly the logic is not working.
Here is sample code:
var sList = new ArrayList(); string[][] urls = new string[100][]; int ctr = 0; int j = 1; foreach (Result res in srchResponse.results) { string content = res.text; string pattern = @"((https?|ftp|gopher|telnet|file|notes|ms-help):((//)|(\\))+[wd:#@%/;$()~_?+-=\.&]*)"; MatchCollection matches = Regex.Matches(content, pattern); foreach (Match match in matches) { GroupCollection groups = match.Groups; sList.Add(groups[0].Value.ToString()); } } sList.Sort(); foreach (Result res in srchResponse.results) { for (int i = 0; i < 100; i++) { if (sList[i] == sList[i + 1]) { j++; } else { urls[ctr][0] = sList[i].ToString(); urls[ctr][1] = j.ToString(); urls[ctr][2] = res.text; urls[ctr][3] = res.from_user; urls[ctr][4] = res.profile_image_url; ctr++; j = 1; } } }
The code then goes on to add each result into a StringBuilder method with the HTML.Is now edite
At debug time I would like to see what are the keys in my InitParams collection - I can't seem to be able to list them.
EDIT:As Jon suggests below, this might be a bug within the Silverlight debugger. To reproduce, just create a new Silverlight Application within Visual Studio 2010 and just edit code
{ public partial class MainPage : UserControl { [code]...
It has multiple Series and each series has Several Data points.I want to find the count ( not sum but number of datapoints ) of Data points in all the series using LINQ.Currently i do
var count = from s in Chart1.Series select new int[] { s.Points.Count };
And then for each thorough count and find the sum. Is there a better way to do this
I have an sql resultset which is retrieved after searching through the database using the LIKE keyword. I want to display the result on a page but without showing the whole text. Just the paragraph where the result was found. Maybe even put that particular word in bold. how best I can implement this?
I ve a list of string List<string> that have more than 100000 records. Now i want to search a particular string and their occurence it list. Is there is any buit in method that can perform dis job???
List has BinarySearch method but it retrun the index...
can anyone writing efficient algo of searching n counting no Occurrence in List of string
I have a several count stored procedures that are binding to gridview nicely for individual items. I now want a ful count of row so I use a stored procedure with:
[Code]....
Which works fine when testing in the DB and returns results like it should. My problem is that for the life me I cannot work how to display the results to a Label.Text or how to do it when my calendar has posted back thats where @LogDate comes from).
I would like to know if someone can give me a good example of counting how many times each word is occuring in a string and then show the results
I have one example and I thought it worked well ......but as soon as a word appear more then twice it thows an error....so this code is not really working then
below is the code I have anyway...maybe someone can tweak it for me if possible.
I have a class, let's say class Sample. Sample has unknown properties but inherits an interface ISample. Said interface includes one method which I'm trying to create. This interface has a method called getPropertyValue(object o, string PropertyName).
It returns the value of the o.PropertyName using generics (unless you have a better suggestion). How do I write it? In other words, I want to be able to pass the name (as a string) of a property and return its value. Samples in C# preferrable but VB ok and any comments or suggestions are welcome.
I am having a problem understanding how polymorphism works when using generics. As an example, I have defined the following program:
public interface IMyInterface { void MyMethod(); }.....
So, at least I haven't completely misunderstood that. I am unsure exactly how I am to write a method that accepts a generic collection of classes that conform to the same interface.
I have a plan to completely hack around this problem if need be, but I would really prefer to do it properly.
I'm working with some XML representations of data instances. I'm deserializing the objects using .NET serialization but something in my soul is disturbed by having to write classes to represent the XML... Below is what I'd LOVE to do but I don't know if the syntax or if it is even possible:Consider the following:
dim xmlObject = SomeXMLFunction() 'where some function returns an object/string representation of xml... xmlObject.SomePropertyDefinedInTheXML = SomeFunction()
I know that in ASP.NET (talking about 2.0 here primarily) one can set a property on an object that takes a collection of things (an enumerable type I'm guessing is the trigger) and then reference it declaritivly. For example:
It is the <asp:Parameter /> part which is the root of my question. Say I wanted a simpler collection on a type. Say a List<String> or if generics are out, an IntegerCollection or StringCollection. How would I use that declaratively? Is <string value=''> allowed, or can I put raw values into it like <StringCollection>string, string, string</StringCollection> or what?
EDIT:
I feel like I was not clear enough in my question. I understand that ObjectDataSource implements its SelectParameters property as a ParametersCollection, and that one can use that property declaratively (in an ASPX page) to set up Parameter types within that collection. What I'm wondering is if I made something like StringCollection as a property on another control, is there a syntax (in ASPX) for adding strings to that collection? Or would I have to define a wrapping class like how DropDownList takes ListItems to fill its collection?