[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 221
  • Last Modified:

How do I Format Data in a Datagridview

I Have an App (VB.Net) where data is extracted from a DB and presented in a DataGridView as a dataset.

I would like to format the column titled "Split" in the format as 0.23, 0.25 etc.

I am new to programing and having a tough time figuring thing out.

Thanks

Public Class Agents
 
    
    Private Sub Agents_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        'TODO: This line of code loads data into the 'AgentsDataSet.Agents' table. You can move, or remove it, as needed.
        Me.AgentsTableAdapter.Fill(Me.AgentsDataSet.Agents)
        'Change the sort order
 
    End Sub
 
    Private Sub AgentsBindingNavigatorSaveItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles AgentsBindingNavigatorSaveItem.Click
        Me.Validate()
        Me.AgentsBindingSource.EndEdit()
        Me.TableAdapterManager.UpdateAll(Me.AgentsDataSet)
        Me.Close()
    End Sub
 
    
End Class

Open in new window

0
Max1565
Asked:
Max1565
1 Solution
 
EspavoCommented:
You haven't dropped the DataGrid here... so I don't see your "Split" column...
The way to do it would be to change your <%# Bind("Split") %> to <%# Format(Eval("Split"), "0.00") %>
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now