如何格式化数据表中的行 [英] How to format rows in datatable

问题描述

当我加载表单时，如何没有零显示

How do i not have the zeros show when i load my form

Public Class Form1
 Private Sub Form1_Load1(sender As Object, e As System.EventArgs) Handles Me.Load

myTable.Columns.Add("Shake /Cereal", GetType(Integer))
       myTable.Columns.Add("Entrees", GetType(Integer))
       myTable.Columns.Add("Bar", GetType(Integer))
       myTable.Columns.Add("Total", GetType(Integer))

       myTable.Columns("Shake /Cereal").DefaultValue = 0
       myTable.Columns("Entrees").DefaultValue = 0
       myTable.Columns("Bars").DefaultValue = 0

End Sub

Private Sub DataGridView1_CellEndEdit(ByVal sender As System.Object, ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles DataGridView1.CellEndEdit

        myTable.Columns("Total").Expression = "[Shake /Cereal] + Entrees + Bars"
End Sub

推荐答案

当用户想要输入数据时，您希望显示空文本框的默认值？

不要为数据表提供默认值，因为在数据绑定时它会被拾取。



如果必须设置数据源的默认值，然后您需要覆盖OnEdit事件以将空白放入文本框中。原油方式，但它的工作原理。



但是，如果你显示0会更好，因为它会给用户一个更好的想法，输入预期是一个整数，他们不会尝试输入字符串。

You want to show empty textbox for default values when user wants to enter data?
Don't supply default values to the datatable, as that will get picked up while databinding.

If you must set your datasource's defaults, then you need to override the OnEdit event to put blanks in the textboxes. Crude way, but it works.

However, it will be better if you show 0, since it will give a better idea to the users that the input expected is an integer and they will not try to enter a string.

这篇关于如何格式化数据表中的行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！