Set currency in dynamic column in DataGridView in Windows Application

vishalka...

SOLVED CLOSED ACTIVE ANSWERED
User: vishalkal
Posted: on Aug 22, 2018 11:38 PM
Forum: Windows Basics
Answer: 1
Views: 8562
Sample Code: Download

how to set dynamically added column format as curreny in datagridview

        public void LoadForm()
        {
            string command = "select * from Cashflowproject where ProjectCode='" + ProjectCode.Text + "' union all select * from Cashflowpaymentreceived where ProjectCode='" + ProjectCode.Text + "' union all select * from Cashflowpaymentvendorpayment where ProjectCode='" + ProjectCode.Text + "' union all select * from CashflowIOU where ProjectCode='" + ProjectCode.Text + "' union all select * from CashflowExpense where ProjectCode='" + ProjectCode.Text + "' order by Date";
            dt1 = Class1.GetData(command, DialogResult);
            dgv.AutoGenerateColumns = false;

            if (dt1.Rows.Count > 0)
            {
                dt1.Columns.Add("Cumulative Amount");
                dt1.Rows[0][5] = dt1.Rows[0][3];
                for (int i = 1; i < dt1.Rows.Count; i++)
                {
                    string abc = dt1.Rows[i][4].ToString();
                    string ch = abc.Substring(0, 1);
                    if (dt1.Rows[i][4].ToString() != "")
                    {
                        switch (ch)
                        {
                            case "R":
                               dt1.Rows[i][5] = Convert.ToInt32(dt1.Rows[i - 1][5]) + Convert.ToInt32(dt1.Rows[i][3]);
                               break;
                            case "A":
                                dt1.Rows[i][5] = Convert.ToInt32(dt1.Rows[i - 1][5]) + Convert.ToInt32(dt1.Rows[i][3]);
                                break;
                            case "P":
                                dt1.Rows[i][5] = Convert.ToInt32(dt1.Rows[i - 1][5]) - Convert.ToInt32(dt1.Rows[i][3]);
                                break;
                            case "E":
                                dt1.Rows[i][5] = Convert.ToInt32(dt1.Rows[i - 1][5]) - Convert.ToInt32(dt1.Rows[i][3]);
                                break;
                            case "I":
                                dt1.Rows[i][5] = Convert.ToInt32(dt1.Rows[i - 1][5]) - Convert.ToInt32(dt1.Rows[i][3]);
                                break;
                        }
                    }
                    else
                    {
                        dt1.Rows[i][5] = dt1.Rows[i-1][5];
                    }

                }
                if (dt1.Rows.Count == 1)
                {
                    rowno = 0;
                }

                dgv.Columns[0].DataPropertyName = dt1.Columns[0].Caption;
                dgv.Columns[1].DataPropertyName = dt1.Columns[1].Caption;
                dgv.Columns[2].DataPropertyName = dt1.Columns[2].Caption;
                dgv.Columns[3].DataPropertyName = dt1.Columns[3].Caption;
                dgv.Columns[4].DataPropertyName = dt1.Columns[4].Caption;
                dgv.Columns[5].DataPropertyName = dt1.Columns[5].Caption;
                dgv.DataSource = dt1;

                for (int i = 0; i < dgv.Rows.Count-1; i++)
                {
                    string abc = dt1.Rows[i][4].ToString();
                    string ch = abc.Substring(0, 1);
                    string sign = "+";
                    string sign1 = "-";

                    double a = Convert.ToDouble(dgv.Rows[i].Cells[3].Value);
                    if (ch == "P")
                    {
                        string value = sign1 + a;
                        dgv.Rows[i].Cells[3].Value = value;
                    }
                    if (ch == "I")
                    {
                        string value = sign1 + a;
                        dgv.Rows[i].Cells[3].Value = value;
                    }
                    if (ch == "E")
                    {
                        string value = sign1 + a;
                        dgv.Rows[i].Cells[3].Value = value;
                    }
                    if (ch == "A")
                    {
                        dgv.Rows[i].DefaultCellStyle.BackColor = Color.SkyBlue;
                        string value = sign + a;
                        dgv.Rows[i].Cells[3].Value = value;
                    }
                    if (ch == "R")
                    {
                        dgv.Rows[i].DefaultCellStyle.BackColor = Color.SkyBlue;
                        string value = sign + a;
                        dgv.Rows[i].Cells[3].Value = value;
                    }

                }

                //dgv.Columns[3].DefaultCellStyle.Format = "c2";
                //dgv.Columns[1].DefaultCellStyle.Format = "dd/MM/yyyy";
                //dgv.Columns[3].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
                //dgv.Columns[5].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
                //dgv.Columns[0].Visible = false;

                dgv.Rows[rowno].Selected = true;
                lblcount.Text = dgv.Rows.Count.ToString();
                dgv_CellClick(dgv, new DataGridViewCellEventArgs(0, 0));
            }
        }

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

pandeyis...

0 2

Reply
ANSWER
User: pandeyism
Replied: on Aug 23, 2018 01:26 AM
Modified: on Aug 24, 2018 04:59 AM
Report

Hi vishalkal,

Please refer below sample.

According to your requiremet modified code taking reference to the below code.

Namespaces

using System.Data;
using System.Windows.Forms;
using System.Globalization;

VB.Net

Imports System.Globalization

Code

private void BindGrid()
{
    dataGridView1.AutoGenerateColumns = false;
    DataTable dt = new DataTable();
    dt.Columns.AddRange(new DataColumn[] { new DataColumn("Id", typeof(string)), 
                                    new DataColumn("Ammount", typeof(int)) ,
                                    new DataColumn("Item", typeof(string))});
    dt.Rows.Add("1", 11, "Mango");
    dt.Rows.Add("2", 20, "Banana");
    dt.Rows.Add("3", 32, "Grapes");
    dataGridView1.AutoGenerateColumns = false;
    dataGridView1.ColumnCount = 3;
    dataGridView1.Columns[0].Name = "Id";
    dataGridView1.Columns[0].HeaderText = "Id";
    dataGridView1.Columns[0].DataPropertyName = "Id";

    dataGridView1.Columns[1].HeaderText = "Ammount";
    dataGridView1.Columns[1].Name = "Ammount";
    dataGridView1.Columns[1].DataPropertyName = "Ammount";

    dataGridView1.Columns[2].Name = "Item";
    dataGridView1.Columns[2].HeaderText = "Item";
    dataGridView1.Columns[2].DataPropertyName = "Item";
    dataGridView1.DataSource = dt;
}

private void dataGridView1_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
    if (e.ColumnIndex == 1 && e.RowIndex != this.dataGridView1.NewRowIndex)
    {
        int a = Convert.ToInt16(e.Value);
        e.Value = a.ToString("C2", CultureInfo.CurrentCulture);
    }
}

private void Form1_Load(object sender, EventArgs e)
{
    this.BindGrid();
}

VB.Net

Private Sub BindGrid()
    dataGridView1.AutoGenerateColumns = False
    Dim dt As DataTable = New DataTable()
    dt.Columns.AddRange(New DataColumn() {New DataColumn("Id", GetType(String)), New DataColumn("Ammount", GetType(Integer)), New DataColumn("Item", GetType(String))})
    dt.Rows.Add("1", 11, "Mango")
    dt.Rows.Add("2", 20, "Banana")
    dt.Rows.Add("3", 32, "Grapes")
    dataGridView1.AutoGenerateColumns = False
    dataGridView1.ColumnCount = 3
    dataGridView1.Columns(0).Name = "Id"
    dataGridView1.Columns(0).HeaderText = "Id"
    dataGridView1.Columns(0).DataPropertyName = "Id"
    dataGridView1.Columns(1).HeaderText = "Ammount"
    dataGridView1.Columns(1).Name = "Ammount"
    dataGridView1.Columns(1).DataPropertyName = "Ammount"
    dataGridView1.Columns(2).Name = "Item"
    dataGridView1.Columns(2).HeaderText = "Item"
    dataGridView1.Columns(2).DataPropertyName = "Item"
    dataGridView1.DataSource = dt
End Sub

Private Sub dataGridView1_CellFormatting(ByVal sender As Object, ByVal e As DataGridViewCellFormattingEventArgs)
    If e.ColumnIndex = 1 AndAlso e.RowIndex <> Me.dataGridView1.NewRowIndex Then
        Dim a As Integer = Convert.ToInt16(e.Value)
        e.Value = a.ToString("C2", CultureInfo.CurrentCulture)
    End If
End Sub

Private Sub Form1_Load(ByVal sender As Object, ByVal e As EventArgs)
    Me.BindGrid()
End Sub

Screenshot

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

Set currency in dynamic column in DataGridView in Windows Application

Company

Explore

Follow us

Contact Us