Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim sqla As New SqlClient.SqlDataAdapter
Dim sqlcmd As New SqlClient.SqlCommand
sqlcon = New SqlClient.SqlConnection("server=127.0.0.1;uid=sa;password=1026;database=northwind")
sqlcmd.Connection = sqlcon sqlcon.Open()
sqlcmd.CommandText = "select * from employees"
sqla.SelectCommand = sqlcmd
sqla.Fill(ds, "lftable") dg.DataSource = ds.Tables("lftable").DefaultView
dg.DataBind()
sqlcon.Close() End Sub
Private Sub dg_ItemCreated(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.DataGridItemEventArgs) Handles dg.ItemCreated e.Item.Cells(14).Width = Unit.Pixel(1000) End Sub
我的代码如上,是显示的northwind的一个表,但是格式在datagrid里显示的乱糟糟。
我在 dg_ItemCreated写 了e.Item.Cells(14).Width = Unit.Pixel(1000)
也不起作用,请大家指教,谢谢
Dim sqla As New SqlClient.SqlDataAdapter
Dim sqlcmd As New SqlClient.SqlCommand
sqlcon = New SqlClient.SqlConnection("server=127.0.0.1;uid=sa;password=1026;database=northwind")
sqlcmd.Connection = sqlcon sqlcon.Open()
sqlcmd.CommandText = "select * from employees"
sqla.SelectCommand = sqlcmd
sqla.Fill(ds, "lftable") dg.DataSource = ds.Tables("lftable").DefaultView
dg.DataBind()
sqlcon.Close() End Sub
Private Sub dg_ItemCreated(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.DataGridItemEventArgs) Handles dg.ItemCreated e.Item.Cells(14).Width = Unit.Pixel(1000) End Sub
我的代码如上,是显示的northwind的一个表,但是格式在datagrid里显示的乱糟糟。
我在 dg_ItemCreated写 了e.Item.Cells(14).Width = Unit.Pixel(1000)
也不起作用,请大家指教,谢谢
你最好把DATAGRID的宽度设置成每一列加起来的和,
我的datagrid是Sql出来的,不是固定的
而且我设置了一列,columus(0),但是怎么设,都没有变化,
运行在页面上还是那么宽,大家救命啊!!!