Dim NewColumn As New DataColumn()
With NewColumn
.DataType = System.Type.GetType("System.Decimal")
.ColumnName = "NewColumn"
.Expression = "sum(..)"
End With
ds.tables("ddd").Columns.Add(NewColumn) '增加列
datagrid.DataSource = ds.Tables("ee").DefaultView
datagrid.databind()
With NewColumn
.DataType = System.Type.GetType("System.Decimal")
.ColumnName = "NewColumn"
.Expression = "sum(..)"
End With
ds.tables("ddd").Columns.Add(NewColumn) '增加列
datagrid.DataSource = ds.Tables("ee").DefaultView
datagrid.databind()
解决方案 »
- SQL
- 求c#的熟悉xml的高手指教,小弟第一次接触
- C#端如何得到JavaScript动态生成的CheckBox值
- UltraGrid的表头样式问题
- sqldatasource
- datatable中查询第6-10条数据
- visual studio 2008的严重问题,高手指点一下!
- button客户端到服务端的转化
- writeXml 的 diffgram 是什么东西,用户自定义控件和 自定义服务器控件 区别?
- 缓存求助!
- 怎样让事件触发后弹出一个没有“前进””后退“之类的页面,类似于网站的广告样子
- 请问各位这 两句话分别是什么意思?Dim i as int32 Dim tmpStr as String
BoundColumn bc1 = new BoundColumn();
bc1.DataField = "product_nm";
bc1.HeaderText = "Name";
bc1.ItemStyle.Width = Unit.Pixel(250);
myDataGrid.Columns.Add(bc1);2. add a column to your DataTable3. in ItemDataBound event handlerTableCell tc = new TableCell();
tc.Text = DataBinder.Eval(e.Item.DataItem,"SomeDataColumn").ToString();
e.Item.Cells.Add(tc);
我曾經用的是你所說的第一種方法,但是顯示不了。
VB代碼如下:
Dim newCol As New BoundColumn()
newCol.DataField = "Status"
newCol.ReadOnly = True
newCol.HeaderText = "S"
newCol.SortExpression = "Status"
newCol.Visible = True
GridInfo.Columns.Add(newCol)
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<script language="VB" runat="Server">
Sub Page_Load(o As Object, e as EventArgs)
if Not IsPostBack then Dim newCol As New BoundColumn()
newCol.DataField = "au_fname"
newCol.HeaderText = "First Name"
DataGrid1.Columns.Add(newCol) dim da as SqlDataAdapter = new SqlDataAdapter("select * from authors", _
"server=localhost;database=pubs;uid=sa;pwd=;") dim ds as New DataSet()
da.Fill(ds,"authors")
DataGrid1.DataSource = ds.Tables("authors").DefaultView
DataGrid1.DataBind()
end if
End Sub
</script>
<form runat="Server">
<asp:DataGrid id="DataGrid1" runat="Server" AutoGenerateColumns="false">
<Columns>
<asp:BoundColumn DataField="au_lname" HeaderText="Last Name" />
</Columns>
</asp:DataGrid>
</form>
你是用DataGrid.Columns.Add(newCol)的方法嗎?
<%@ Import Namespace="System.Data.SqlClient" %>
<script language="VB" runat="Server">
Sub Page_Load(o As Object, e as EventArgs)
if Not IsPostBack then DataGrid1.AutoGenerateColumns = false Dim newCol As New BoundColumn()
newCol.DataField = "au_fname"
newCol.HeaderText = "First Name"
DataGrid1.Columns.Add(newCol) newCol = New BoundColumn()
newCol.DataField = "au_lname"
newCol.HeaderText = "Last Name"
DataGrid1.Columns.Add(newCol) dim da as SqlDataAdapter = new SqlDataAdapter("select * from authors", _
"server=localhost;database=pubs;uid=sa;pwd=;") dim ds as New DataSet()
da.Fill(ds,"authors")
DataGrid1.DataSource = ds.Tables("authors").DefaultView
DataGrid1.DataBind()
end if
End Sub
</script>
<form runat="Server">
<asp:DataGrid id="DataGrid1" runat="Server"/>
</form>
我終於解決問題了,放在Page_Load裡是不行的,必須放在Page_Init