removing a column during runtime

06-01-2006, 07:45 AM
I have a datagrid on my web app ( 2003 used to make it) connected to an MS SQL Server

I populate my datagrid like this:

Public Sub CheckForInvAdj()
intRASNum = Request.QueryString("RAS")
Me.ViewState("RAS") = intRASNum
Dim myConnectionIT As New System.Data.SqlClient.SqlConnection(myITConnString)
'Populate datagrid with all inventory adjustments for this RAS
Dim dgrSQL As String = "SELECT InvAdj_id, System_id, SKU_id "
' There are some more fields, but I dont want the page to wrap
dgrSQL += "FROM MyTable "
dgrSQL += "WHERE Incident_id = '" & intRASNum & "' ORDER BY InvAdj_id"

Dim myCommand As New System.Data.SqlClient.SqlCommand(dgrSQL, myConnectionIT)
Dim myReader As System.Data.SqlClient.SqlDataReader = myCommand.ExecuteReader()
Dim rowCnt As Integer = 0
If myReader.HasRows Then
Do While myReader.Read()
rowCnt += 1
End If
dgrAllCom.VirtualItemCount = rowCnt

If dgrAllCom.VirtualItemCount = 0 Then
' If there are no records, hide the datagrid
dgrAllCom.VirtualItemCount = False
Exit Sub
End If

'at least one record was found
Dim ds As New DataSet
Dim da As New System.Data.SqlClient.SqlDataAdapter(dgrSQL, myConnectionIT)
da.Fill(ds, dgrAllCom.CurrentPageIndex * dgrAllCom.PageSize, dgrAllCom.PageSize, "IT_Incident_InvAdj")
dgrAllCom.Visible = True
dgrAllCom.DataSource = ds.Tables("MyTable")
dgrAllCom.DataKeyField = "InvAdj_id"
End Sub

What I want to do though, is drop the first column, which is a link to Edit each individual record.

I thought maybe the .Columns.Remove but I cant seem to get it working
any help would be appreciated


06-01-2006, 07:56 AM
Remove takes a parameter, so you would have to tell it which column to remove.
RemoveAt takes an index so it's easier to pick the first column.

Just make sure you do it before you call DataBind. If you do it after, it won't have an affect...

dgrAllCom.Visible = True
dgrAllCom.DataSource = ds.Tables("MyTable")
dgrAllCom.DataKeyField = "InvAdj_id"

06-01-2006, 08:26 AM
Thanks wayne, yet again you've saved me from beating my head against the wall! :)

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum