Hi i want equivalent code in c# dvColumns = New DataView(schemaColumnsTable) dvColumns.Sort = "ORDINAL_POSITION" DT.Columns.Add("COLUMN_NAME") DT.Columns.Add("DATA_TYPE") DT.Columns.Add("Length") For i = 0 To schemaColumnsTable.Rows.Count - 1 drow = DT.NewRow drow("COLUMN_NAME") = dvColumns.Item(i)("COLUMN_NAME") If CType(dvColumns.Item(i)("COLUMN_NAME"), String) = "Quantity" Or CType(dvColumns.Item(i)("COLUMN_NAME"), String) = "Cost" Then drow("DATA_TYPE") = "Float" Else drow("DATA_TYPE") = "Varchar" End If ' drow("DATA_TYPE") = "Varchar" drow("Length") = "255" DT.Rows.Add(drow) Next
Copyright © 2024 QA.XPDF.PUB - All rights reserved.
Answers & Comments
Hi i want equivalent code in c#
dvColumns = New DataView(schemaColumnsTable)
dvColumns.Sort = "ORDINAL_POSITION"
DT.Columns.Add("COLUMN_NAME")
DT.Columns.Add("DATA_TYPE")
DT.Columns.Add("Length")
For i = 0 To schemaColumnsTable.Rows.Count - 1
drow = DT.NewRow
drow("COLUMN_NAME") = dvColumns.Item(i)("COLUMN_NAME")
If CType(dvColumns.Item(i)("COLUMN_NAME"), String) = "Quantity" Or CType(dvColumns.Item(i)("COLUMN_NAME"), String) = "Cost" Then
drow("DATA_TYPE") = "Float"
Else
drow("DATA_TYPE") = "Varchar"
End If
' drow("DATA_TYPE") = "Varchar"
drow("Length") = "255"
DT.Rows.Add(drow)
Next