~~~~~~~取数据集的问题!~~~~~~求救!!!!!
有表结构
(
id int,
matname varchar(50),
qckc_amount numeric(12,4),
qckc_money money,
bqgr_amount numeric(12,4),
bqgr_money money,
bqsy_amount numeric(12,4),
bqsy_money money,
bqzr_amount numeric(12,4),
bqzr_money money,
bqzc_amount numeric(12,4),
bqzc_money money,
qmkc_amount numeric(12,4),
qmkc_money money
)
存储过程调用此表内的数据
Dim dr As SqlDataReader = SqlHelper.ExecuteReader("mat_detail_p", Year(Now), Month(Now))
While (dr.Read())
Dim r As New TableRow
For i = 0 To 12
Dim row1col As New TableCell
If i = 1 Then
row1col.Controls.Add(New LiteralControl(dr.GetString(i).ToString))
Else
row1col.Controls.Add(New LiteralControl(dr.GetDecimal(i).ToString))
End If
r.Cells.Add(row1col)
Next
table1.Rows.Add(r)
End While
=======================================================================
现在的问题是
GetDecimal不对,不会要我每一列都判断是什么类型然后GetString,GetInt64,GetFloat……吧?我应该怎么处理呢?使用一个Get…得到列内容而不用考虑到底列是数据类型