spot7.org logo
Home PHP C# C++ Android Java Javascript Python IOS SQL HTML Categories

Editing DataTable based on Query Result


If I follow the requirements in your question, then your code should be like this.

.....
string[] words = message.Split(' ');

// Execute the loop ONLY for the required words
(the ones that starts with #)
foreach (string word in words.Where(x =>
x.StartsWith("#")))
{
    // Search if the table contains a row with the
current word in the Hashtag column
    DataRow[] selection = hashtags.Select("Hashtag
= '" + word + "'");
    if(selection.Length > 0)
    {
        // We have a row with that term. Increment
the counter
        // Notice that selection is an array of
DataRows (albeit with just one element)
        // so we need to select the first row [0],
second column [1] for the value to update
        int count =
Convert.ToInt32(selection[0][1]) + 1;
        selection[0][1] = count;
    }
    else
    {
        row = hashtags.NewRow();
        row["Hashtag"] = word;
        row["Count"] = "1";
        hashtags.Rows.Add(row);
    }

}

Notice that if you want to Select on a string field then your need to use quotes around the search term and you don't need to use == like in C#


Categories : C#

Related to : Editing DataTable based on Query Result
VB.Net Linq-to-datatable How to create a datatable based on an existing datable with filter
Based upon what you wrote in your comments, although I'm very confused as to why you would want it this way and think you should rather look at your code a bit more and see if there's a nicer / neater solution (for example, using DataViews that automatically allow for filtering). The way I would do this would look as follows: Dim ReturnedTables As New List(Of DataTable) Dim strings = From row In

Categories : Vb.Net
Calculating datatable input text value and showing result in a outputtextbox
If I get it right, you want to display the sum of the values of all <h:inputText>-Fields. At the moment, there is no JSF-action in your code (no form, no submit, no ajax). You may do it with Javascript and jQuery, or you try this: <h:form> <p:dataTable> ... <p:column headerText="Allot No. of Candidates" > <h:inputText value="#{issueAdmitCardBean.venueNam

Categories : Jquery
select query with contain condition in datatable using c#
try this DataRow[] resultss = dt.AsEnumerable().Where(row => row.Field<string>("DocumentElementText").Contains("Enter Your String Here")).Select(row => row).ToArray<DataRow>();

Categories : C#
jquery datatable adding removed rocords to datatable again when add new data
Try adding "bDestroy" : true in your datatable object init or alternatively you can $('yourtable').dataTable().fnDestroy(); and then recreate it.

Categories : Jquery
Multiple on clause from DataTable to DataTable via LINQ
Instead of the LoadDataRow + CopyToDataTable approach i would always prefer a simple foreach where i add those rows in the query. Thats much more clear and doesn't rely on side-effects. You can join on the string and put both rows in an anonymous type: var query = from r1 in dt1.AsEnumerable() join r2 in dt2.AsEnumerable() on r1.Field<string>("TEST2") eq

Categories : C#
Recently Add
Get Existing Outlook Addin Information from External C# Application
What's the best way to share an instance of an object across many objects?
Searching a enum description containing a slash
C# how to properly make a http web GET request
Get ComboBox selected value form Form1 to another Form2
Pixel Format conversion
Why does my download queue break when called faster after each other?
How to define XML namespaces to be incuded in the header of XML request which will be send via invoke of a Web Service call?
eventlog source - string/message table lookup failed
What is the idea behind IIdentity and IPrincipal in .NET
How can the Wix Installer distinguish target builds?
Verifying if method was called with Moq
Send json data to SQL Server 2008
Cannot validate in MVC 5 authentication with both UserName and Email
Unioning two LINQ queries
How to block a number in Twilio
Pass object attribute to controller
C# nHibernate programatically set db password
How to add node at mouse click location on canvas?
Register boolean in Container
ASP MVC or/and Networking issues
Managing Single Quotes while calling on a Stored Procedure
Connection String to connect a SQL Server using another windows account
DynamicTableEntity PartitionKey and RowKey
The property content is set more than once.. WPF
How to change asp:ListView DataPager page from codebehind (c#)
Case-insensitive "contains" in Linq
Bootstrap Button_Click Event Not Firing
catch OnVisibilityChanged events
In C#, SQL connection is printing: 'System.Data.SqlClient.SqlDataReader'
© Copyright 2017 spot7.org Publishing Limited. All rights reserved.