Bind ListView in C# Windows Application

Hai To All.

There is a one simple function written below.

Copy and paste the given below query in your code, and call this function on Event where it required

Private void BindListView()
{

  DataTable dt = new DataTable();

  dt.Columns.AddRange(new DataColumn[3] { new DataColumn("Id"), new         DataColumn("Name"), new DataColumn("Country") });

  dt.Rows.Add(1, "Raja Durai", "United States");

  dt.Rows.Add(2, "Raja", "United States");

  dt.Rows.Add(3, "Durai", "India");

  dt.Rows.Add(4, "S.Raja Durai", "India");

  lsvDetails.View = View.SmallIcon;

  lsvDetails.Columns.Clear();

  lsvDetails.Columns.Add("users_id", 0);

  lsvDetails.View = View.Details;

  lsvDetails.Columns.Add("User Name ", 150);

  lsvDetails.Columns.Add("Country", 200);

       

  lsvDetails.Items.Clear();

  if (dt == null || dt.Rows.Count == 0) ;

  else

   foreach (DataRow dr in dt.Rows)

     {

        ListViewItem lvItem = new ListViewItem(dr[0].ToString());

        lvItem.SubItems.AddRange(new String[] { dr[1].ToString(), dr[2].ToString});

        lsvDetails.Items.Add(lvItem);

     }
}

Could not load file or assembly crdb_adoplus.dll in WinApplication

when you received this kind of error:

"Could not load file or assembly 'file:///C:\Program Files\SAP BusinessObjects\Crystal Reports for .NET Framework 4.0\Common\SAP BusinessObjects Enterprise XI 4.0\win32_x86\dotnet1\crdb_adoplus.dll' or one of its dependencies. The system cannot find the file specified."

Try to add this to your .config file (usually app.config)

< startup useLegacyV2RuntimeActivationPolicy="true">

< supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.0"/>

< /startup>

Implement Animated cursor using C# Winforms

First you must add three namespaces like below.

using System.ComponentModel;

using System.Reflection;

using System.Runtime.InteropServices;

Then write a method (LoadCustomCursor) like given below.

 

public static Cursor LoadCustomCursor(string path)

        {

            IntPtr hCurs = LoadCursorFromFile(path);

            if (hCurs == IntPtr.Zero) throw new Win32Exception();

            var curs = new Cursor(hCurs);

            // Note: force the cursor to own the handle so it gets released properly

            var fi = typeof(Cursor).GetField("ownHandle", BindingFlags.NonPublic | BindingFlags.Instance);

            fi.SetValue(curs, true);

            return curs;

        }

        [DllImport("user32.dll", SetLastError = true, CharSet = CharSet.Auto)]

        private static extern IntPtr LoadCursorFromFile(string path);

Sample usage:

private void btnSave_Click(object sender, EventArgs e)

{ 

this.Cursor = LoadCustomCursor(Application.StartupPath + "\\images\\Black and Blue Working in Background.ani");

//Enter your C# Code here

this.Cursor = Cursors.Default;

}

How to calculate the sum of the datatable column in asp.net?

To calculate the sum of a column in a DataTable use the DataTable.Compute method.

Example of usage

object sumObject = dtPayment.Compute("Sum(Amount)", "");

Display the result in your Total Amount Label like so:

lblTotalAmount.Text = sumObject.ToString();