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
the method should b like
[code]....
I am trying to write a simple search form for our site. Here is my delima... I am trying to figure out that if there is nothing to search for in one textbox then search in the next textbox. The problem is that I dont know how to format my search string: For Example:
[code]....
I have the following search query
// GET /Home/Results/
[AcceptVerbs(HttpVerbs.Post)]
public ActionResult Result(string searchtext)
{
var search = (from n in _db.NewsItemSet
where n.headline.Contains(searchtext)
orderby n.posted descending
select n);
return View(search);
}
}
The search works and displays a record if a record containing a keyword exists, I am struggling however to implement a feature where when the search is returned it says for example:
0 news items found
N news items match your search criteria: 'string'" displayed
Table1
Col1(varchar)
japan
taiwan
china
malaysia
singapore
japan
china
How to find the row index of "china" occuring first in the column. I need to get 3 as result for the query ?
How i can make the normal search string to sql server full text search parse, because when we are user enyer search text "how to run windows schedule in C#", in database we have article to to this, but data not returning and sometime is say error in key word and etc.
View 1 RepliesI need to count that sub string within string. How can i do that.
for example
string str=" this is an an an apple ";
i need to count substring "an" answer is 3;
I have an object, that has many properties but the only two to worry about are:
myobject.ID which is an int
myobject.Names which is a HashSet
Then I have a List of those objects that looks something similar to this:
List<myobject>
I use Linq to get a some of the data into a repeater, but I'm not sure how to get the list of Names and how often they show up.
Want to use Linq to avoid having to loop through the data.
As my tags should show, this is an ASP.NET solution using C#.
Some clarification:
Lets say I have just three items in my list:
Item 1 has John, Fred, Jack in its names.
Item 2 has John, Fred, Joe in its names.
Item 3 has John in its names.
I am trying to return the following:
John - 3
Fred - 2
Jack - 1
Joe - 1
Also, as a note I am familiar with having to write my own comparer for my object, I'm just missing the 'how to' for the overall solution in my thoughts.
if a string
(1)Hello
than output 0 space
(2)Hello
than 5 space found
C# code/form code -
When I submit my form than GenerateNewCID() is not increase continuously it repeat same ID every time as below -
16020001
16020001
16020001 ...
But is want it in the form of below -
16020001
16020002
16020003 ...
//code behind//
private string GenrateNewCId() {
string newCId = string.Empty;
string prefix = DateTime.Now.ToString("yyMM") + "0000";
string selectedIdPrefix = prefix.Substring(0, 4);
int curCId = Convert.ToInt32(prefix.Substring(4, 4));
[Code] ....
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.
[code]....
I tried so much working with this to get distinct Words and their count. I'm using ASP.NET 2.0. And i also googled so much.
1)Ex(String): The DOTNET is Very Cool! The Best.
2) Capture all the sequences like Space, FullStop, Question Mark, Exclamation, Apostrophe, New Line....(May be with RegEx?)
3)Split Words According to the above sequences
4)Get Distinct Words(Occurences) and their count based on the input string in 1st statement.
Desired O/P:
The - 2
DOTNET - 1
Is - 1
Very - 1
Cool - 1
Best - 1
This is my Sample Code for your Ref.
[Code]....
Say I have a table called "Visits", and I want to create a query that counts the visits per day. The way I would accomplish this would be to create a query as such:
SELECT Count(VisitId) as VisitCount, Convert(varchar(32), VisitDateTime, 101) as VisitDate
FROM Visits
WHERE VisitDateTime BETWEEN '10/1/2010' AND '10/5/2010'
GROUP BY VisitDate
The problem I am trying to overcome is that if there were no visits in a given day, that day does not show in my list. For example, if there were 3 visits on the 1st, 2 on the 2nd, none on the 3rd, and 5 on the 4th, my result set would look like:
3, 10/1/2010
2, 10/2/2010
4, 10/4/2010
How can I create my query so that I get all days in the date range listed in the result set regardless of whether the VisitCount is zero?
I have a list of ids properly stored in a List<>. I now need to Group list and get a count of the number of occurrences sorted descending.
Example:
List<string> aryIDs = new List<string>;
aryIDs.Add("1234");
aryIDs.Add("4321");
aryIDs.Add("3214");
aryIDs.Add("1234");
aryIDs.Add("4321");
aryIDs.Add("1234");
Would Produce:
"1234", 3
"4321", 2
"3214", 1
This would be easy in TSQL, but I would like to avoid the server roundtrip, unnecessary tables, etc. if possible.
Update: The VB.NET conversion for Ralph Shillington's answer below:
[code]....
I want to show visitor count along with online users . How i do this?
View 1 RepliesSay I have a table Comments with these columns: Id, Comment, Category, CreatedDate, CommenterIdI want to get the top 5 categories from the Comments table (based on the count of each category in that table). How can I do this in linq, to return either List or IQueryable?
View 2 RepliesI have string which came from the database,now i want to compare each charater of the string with the radiobuttonlist value and check box list value and select both radiobutton list and checkboxlist.
Here i write down some code but its just select 2 item of the each radiobuttonlist and checked all checkboxlist.
[Code]....
I need to get count down for a reason in vs.net 2005. in my vs i cant find timer controle in toolbox as well as in the component list.
i tried with any other pc i got that timer control on it on trhe other hand that timer_tick is not fired in that .
I have a string:
var names = "Brian,Joe,Chris";
Is there a way to convert this to a List<string> delimited by , in one line?
I have a string variable contain text that I would like to search for "Keyword" and replace it with new value.
For example:
Dim strValue = " col1 = "John" and col4 = "smith" or col7 <> "closed" or col9 > 1 and col5 = "passed" "
After the replace the strValue should be :
strValue = " col1 = "John" and ( col4 = "smith" or col7 <> "closed" or col9 > 1 ) and col5 = "passed" "
Site.Master contiains search form using code below. After pressing submit button entered search string is reset since whole page is re-loaded. How to persist search string so that search field contains enterread value after page is re-loaded ?
[Code]....
i would like to add a search module in my web application. I would like to use drop down list. I would like to know how to connect more than one drop down list in the same page to produce a result.
Example :
Holiday Type : Honeymoon,shopping (select in a drop down list)
Budget : 300-400, 400-500, 500-600 (select in a drop down list)
Result : a suggested holiday pakage (from database).
I'm new to asp.net. I think that 'if else' method can be used. Would be nice if anyone could share any related source codes.
I am trying to search a list box by adding a text box next to it.
in the textbox_textchanged I added below code
'Retrieve the item's listindex
Dim i
As Integer = List1.FindString(Text1.Text)
'highligting the matched ones
List1.SelectedIndex = i
But I am getting Below error
Error 1 'FindString' is not a member of 'System.Web.UI.WebControls.ListBox'
Using MVC2 and C#:
I have textbox that is going to be used for searching. I would like to access the data entered in this textbox in the Controller, so I can filter results in my list. I've found a couple ways to accomplich this, but haven't been successful with any. The way that I like the most is using action method parameters. Here's what I have setup; can someone tell me where I am going wrong or supply a simple example:
I have a SearchDetails view that is basically a textbox:
[Code]....
Here's the search details method from the controller:
[Code]....
Here's the search results method from the controller (where I'm trying to access the data from the textbox):
[Code]....
I added a break on the line with 'test' string and 'txtInvestigator' is null. I've also tried to make these methods GET requests and try to access the textbox value directly with Request.QueryString. It seems like I'm close, but must be missing something fairly obvious. As an aside, I already have a List() method in the controller that lists all the items from a table in my DB so I am making a little progress!
The instr function compares two strings and returns an integer specifying the place of the string found.
if I want to search "Quick brown fox" for any of the letters "A B C D", is there a function that can do this?
