vb7.0中的datagrid的绑定问题？

highzhi 2002-06-07 03:59:03

datagrid绑定sql数据库中的一部分字段。对应的英文字段在datagrid的head中显示为中文，且如字段为bit型，则datagrid中显示对应的复选框。请教？

...全文

39 2 打赏收藏转发到动态举报

写回复

用AI写文章

2 条回复

切换为时间正序

请发表友善的回复…

发表回复

yellowwee 2002-06-08

打赏
举报

例子：

<html>
<script language="VB" runat="server">
Function CreateDataSource() As ICollection
Dim dt As New DataTable()
Dim dr As DataRow

dt.Columns.Add(New DataColumn("IntegerValue", GetType(Int32)))
dt.Columns.Add(New DataColumn("StringValue", GetType(String)))
dt.Columns.Add(New DataColumn("CurrencyValue", GetType(Double)))

Dim i As Integer
For i = 0 To 8
dr = dt.NewRow()

dr(0) = i
dr(1) = "Item " + i.ToString()
dr(2) = 1.23 *(i + 1)

dt.Rows.Add(dr)
Next i

Dim dv As New DataView(dt)
Return dv
End Function 'CreateDataSource

Sub Page_Load(sender As Object, e As EventArgs)

If Not IsPostBack Then
' Load this data only once.
ItemsGrid.DataSource = CreateDataSource()
ItemsGrid.DataBind()
End If
End Sub 'Page_Load
</script>
<body>

<form runat=server>

<h3>BoundColumn Example</h3>

<b>Product List</b>

<asp:DataGrid id="ItemsGrid"
BorderColor="black"
BorderWidth="1"
CellPadding="3"
AutoGenerateColumns="false"
runat="server">

<HeaderStyle BackColor="#00aaaa">
</HeaderStyle>

<Columns>

<asp:BoundColumn
HeaderText="Number"
DataField="IntegerValue">
</asp:BoundColumn>

<asp:BoundColumn
HeaderText="Description"
DataField="StringValue">
</asp:BoundColumn>

<asp:BoundColumn
HeaderText="Price"
DataField="CurrencyValue"
DataFormatString="{0:c}">
</asp:BoundColumn>

</Columns>

</asp:DataGrid>

</form>

</body>
</html>

注意AutoGenerateColumns要设为false,<Columns>内的<BindColum>就是你想要显示的这部分字段！HeaderText中就是你想显示的中文！

mmkk 2002-06-07