Aspx code MembershipUser muser MembershipGetUser DataTable dt new DataTable dtColumnsAdd34SenderUser34 dtColumnsAdd34RcvUser34 dtColumnsAdd34Message34 foreach ListItem li in lstUsersItems if liSelected DataRow dr dtNewRow dr34SenderUser34 Session34UName34ToString dr34Message34 txtMsgTex

Please refer this codeC CodeNamespacesusing SystemDataCprotected void PageLoadobject sender EventArgs e if thisIsPostBack DataTable dt new DataTable dtColumnsAddRangenew DataColumn3 new DataColumn34Item34 new DataColumn34Price34 new DataColumn34Total34 dtRowsAdd34Shirt34 200 0 dtRowsAdd34Football34 30 0 dtRowsAdd34Bat34 225 0 dtRowsAdd34Ring34 25 0 dtRowsAdd34Band34 77 0 dtRowsAdd34Glass34 57 0 This will create the DataTable definition Data will not be copied just DataTable definition DataTable dt3 dtClone for int i 0 i lt2 i DataRow dr dtRowsi dt3ImportRowdr VB CodeNamespaceImports SystemDataVBNetProtected Sub PageLoadsender As Object e As EventArgs Handles M

Fetch Top N records from DataTable or DataSet in .Net Framework 2.0

Richa

SOLVED CLOSED ACTIVE ANSWERED
User: Richa
Posted: on Nov 19, 2014 05:24 AM
Forum: Data Controls
Answer: 1
Views: 3751

Aspx code:

MembershipUser m_user = Membership.GetUser();

        DataTable dt = new DataTable();
        dt.Columns.Add("SenderUser");
        dt.Columns.Add("RcvUser");
        dt.Columns.Add("Message");        

        foreach (ListItem li in lst_Users.Items)
        {
            if (li.Selected)
            {
                DataRow dr = dt.NewRow();
                dr["SenderUser"] = Session["UName"].ToString();
                dr["Message"] = txtMsg.Text;
                dr["RcvUser"] = li.Value;
               
                dt.Rows.Add(dr);
            }
        }
                
        Application["Message"] = dt;

I am calling "Application object" from above aspx page into web service page as below:

[WebMethod(EnableSession = true)]
    [ScriptMethod(ResponseFormat = ResponseFormat.Json)]
    public string WebMessage()
    {
        List<string> list = new List<string>();
        DataTable dt = ((DataTable)HttpContext.Current.Application["Message"]);

        if (dt != null)
        {
           string loggedinUser = Session["UName"].ToString();
           DataRow[] dr = dt.Select("RcvUser=" + loggedinUser);
          
           //code to fetch top 5 Messages from above Datatable
           int i = 0;
           foreach (DataRow row in dr)
           {
               if(i < 5)
               {
                   string msg = dt.Rows[0][2].ToString();
                   list.Add(msg);
                   //i++;
               }
           }
           return list[0].ToString(); //return top 5 messages 
        }
        else
        {
            return null;
        } 
    }

want to know that the approach im using in Web service page to fetch top 5 messages from Datatable is correct or not?

If not then please suggest how to do that without using LINQ as I am using framework 2.0

Please reply

Download FREE API for Word, Excel and PDF in ASP.Net

Azim

0 2

Reply
ANSWER
User: Azim
Replied: on Nov 19, 2014 08:52 AM
Modified: on Nov 20, 2014 01:55 AM
Report

Please refer this code

C# Code

Namespaces

using System.Data;

protected void Page_Load(object sender, EventArgs e)
{
    if (!this.IsPostBack)
    {
        DataTable dt = new DataTable();
        dt.Columns.AddRange(new DataColumn[3] { new DataColumn("Item"), new DataColumn("Price"), new DataColumn("Total") });
        dt.Rows.Add("Shirt", 200, 0);
        dt.Rows.Add("Football", 30, 0);
        dt.Rows.Add("Bat", 22.5, 0);
        dt.Rows.Add("Ring", 25, 0);
        dt.Rows.Add("Band", 77, 0);
        dt.Rows.Add("Glass", 57, 0);
        //This will create the DataTable definition
        //Data will not be copied just DataTable definition
        DataTable dt3 = dt.Clone();            
        for (int i = 0; i <=2; i++)
        {            
            DataRow dr = dt.Rows[i];
            dt3.ImportRow(dr);
        }
    }
}

VB Code

Namespace

Imports System.Data

VB.Net

Protected Sub Page_Load(sender As Object, e As EventArgs) Handles Me.Load
    If Not Me.IsPostBack Then
        Dim dt As New DataTable()
        dt.Columns.AddRange(New DataColumn(2) {New DataColumn("Item"), New DataColumn("Price"), New DataColumn("Total")})
        dt.Rows.Add("Shirt", 200, 0)
        dt.Rows.Add("Football", 30, 0)
        dt.Rows.Add("Bat", 22.5, 0)
        dt.Rows.Add("Ring", 25, 0)
        dt.Rows.Add("Band", 77, 0)
        dt.Rows.Add("Glass", 57, 0)
        'This will create the DataTable definition
        'Data will not be copied just DataTable definition
        Dim dt3 As DataTable = dt.Clone()
        For i As Integer = 0 To 2            
            Dim dr As DataRow = dt.Rows(i)
            dt3.ImportRow(dr)
        Next
    End If
End Sub

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Fetch Top N records from DataTable or DataSet in .Net Framework 2.0

Company

Explore

Follow us

Contact Us