PDA

Click to See Complete Forum and Search --> : DataColumn and precision


cim3
Aug 21st, 2002, 05:41 AM
Does anyone have any idea how to set the precision of a column? The DataColumn object gives most properties, but precision. However using the server explorer you can get the precision details of a column in a table, as a property, so its got to be foalting around somewhere.

Cheers

jkw119
Aug 21st, 2002, 07:21 AM
Dim myDataColumn As DataColumn
Dim myDataRow As DataRow
Dim SampleTable As DataTable
Dim SampleDataSet as DataSet

myDataColumn = New DataColumn()
myDataColumn.ColumnName = "SampleTable"
SampleTable.Columns.Add(myDataColumn)
myDataColumn.ReadOnly = True
myDataColumn.DataType = System.Type.GetType("System.Double")

Me.DataGrid1.SetDataBinding(SampleDataSet, "SampleTable")