Datagrid code not working!!

[Angelina]

Hi,

Im trying to format my datagrid via some code to make one
column readonly while the other can be edited.
I also tried to change the column header. The problem is
that the code does not seem to be taking effect.

Here is my code. Can anyone please offer me some help?

da = New SqlDataAdapter("SELECT Equipment_Desc, 0 as
Quantity FROM Equipment_Details", Cn)

ds = New DataSet("Equipment")
da.Fill(ds)

DataGridEquip.DataSource = ds.Tables(0)

Dim TSEquip As New DataGridTableStyle()
TSEquip.MappingName = "Equipment"

Dim TCEquipName As New DataGridTextBoxColumn()
TCEquipName.MappingName = "Equipment_Desc"
TCEquipName.HeaderText = "Equipment Name"
TCEquipName.Width = 110
TCEquipName.ReadOnly = True
TSEquip.GridColumnStyles.Add(TCEquipName)

Dim TCQuantity As New DataGridTextBoxColumn()
TCQuantity.MappingName = "Quantity"
TCQuantity.HeaderText = "Quantity"
TCQuantity.Width = 90
TCQuantity.ReadOnly = False
TSEquip.GridColumnStyles.Add(TCQuantity)
DataGridEquip.TableStyles.Add(TSEquip)

[Rob Oldfield]

I'm no expert, but I think the mapping name for the grid needs to be same as
the table that the data is coming from. Try changing to...

TSEquip.MappingName = "Equipment_Details"
--
For real reply address, lose the cash
www.realuk.co.uk
"Angelina" <an*******@discussions.microsoft.com> wrote in message
news:1d****************************@phx.gbl...

Hi,

Im trying to format my datagrid via some code to make one
column readonly while the other can be edited.
I also tried to change the column header. The problem is
that the code does not seem to be taking effect.

Here is my code. Can anyone please offer me some help?

da = New SqlDataAdapter("SELECT Equipment_Desc, 0 as
Quantity FROM Equipment_Details", Cn)

ds = New DataSet("Equipment")
da.Fill(ds)

DataGridEquip.DataSource = ds.Tables(0)

Dim TSEquip As New DataGridTableStyle()
TSEquip.MappingName = "Equipment"

Dim TCEquipName As New DataGridTextBoxColumn()
TCEquipName.MappingName = "Equipment_Desc"
TCEquipName.HeaderText = "Equipment Name"
TCEquipName.Width = 110
TCEquipName.ReadOnly = True
TSEquip.GridColumnStyles.Add(TCEquipName)

Dim TCQuantity As New DataGridTextBoxColumn()
TCQuantity.MappingName = "Quantity"
TCQuantity.HeaderText = "Quantity"
TCQuantity.Width = 90
TCQuantity.ReadOnly = False
TSEquip.GridColumnStyles.Add(TCQuantity)
DataGridEquip.TableStyles.Add(TSEquip)

[Rob Oldfield]

I'm no expert, but I think the mapping name for the grid needs to be same as
the table that the data is coming from. Try changing to...

TSEquip.MappingName = "Equipment_Details"
--
For real reply address, lose the cash
www.realuk.co.uk
"Angelina" <an*******@discussions.microsoft.com> wrote in message
news:1d****************************@phx.gbl...

Hi,

Im trying to format my datagrid via some code to make one
column readonly while the other can be edited.
I also tried to change the column header. The problem is
that the code does not seem to be taking effect.

Here is my code. Can anyone please offer me some help?

da = New SqlDataAdapter("SELECT Equipment_Desc, 0 as
Quantity FROM Equipment_Details", Cn)

ds = New DataSet("Equipment")
da.Fill(ds)

DataGridEquip.DataSource = ds.Tables(0)

Dim TSEquip As New DataGridTableStyle()
TSEquip.MappingName = "Equipment"

Dim TCEquipName As New DataGridTextBoxColumn()
TCEquipName.MappingName = "Equipment_Desc"
TCEquipName.HeaderText = "Equipment Name"
TCEquipName.Width = 110
TCEquipName.ReadOnly = True
TSEquip.GridColumnStyles.Add(TCEquipName)

Dim TCQuantity As New DataGridTextBoxColumn()
TCQuantity.MappingName = "Quantity"
TCQuantity.HeaderText = "Quantity"
TCQuantity.Width = 90
TCQuantity.ReadOnly = False
TSEquip.GridColumnStyles.Add(TCQuantity)
DataGridEquip.TableStyles.Add(TSEquip)

[Angelina]

Hi Rob,

Thx for your input. I just tried this but i still cant
see any of the formatting i am coding in the datagrid at
runtime!! :o(

Does anyone have any other suggestions?

-----Original Message-----
I'm no expert, but I think the mapping name for the grid needs to be same asthe table that the data is coming from. Try changing to...
TSEquip.MappingName = "Equipment_Details"
--
For real reply address, lose the cash
www.realuk.co.uk
"Angelina" <an*******@discussions.microsoft.com> wrote in messagenews:1d****************************@phx.gbl...

Hi,

Im trying to format my datagrid via some code to make one column readonly while the other can be edited.
I also tried to change the column header. The problem is that the code does not seem to be taking effect.

Here is my code. Can anyone please offer me some help?

da = New SqlDataAdapter("SELECT Equipment_Desc, 0 as
Quantity FROM Equipment_Details", Cn)

ds = New DataSet("Equipment")
da.Fill(ds)

DataGridEquip.DataSource = ds.Tables(0)

Dim TSEquip As New DataGridTableStyle()
TSEquip.MappingName = "Equipment"

Dim TCEquipName As New DataGridTextBoxColumn()
TCEquipName.MappingName = "Equipment_Desc"
TCEquipName.HeaderText = "Equipment Name"
TCEquipName.Width = 110
TCEquipName.ReadOnly = True
TSEquip.GridColumnStyles.Add(TCEquipName)

Dim TCQuantity As New DataGridTextBoxColumn()
TCQuantity.MappingName = "Quantity"
TCQuantity.HeaderText = "Quantity"
TCQuantity.Width = 90
TCQuantity.ReadOnly = False
TSEquip.GridColumnStyles.Add(TCQuantity)
DataGridEquip.TableStyles.Add(TSEquip)

.

[Angelina]

Hi Rob,

Thx for your input. I just tried this but i still cant
see any of the formatting i am coding in the datagrid at
runtime!! :o(

Does anyone have any other suggestions?

-----Original Message-----
I'm no expert, but I think the mapping name for the grid needs to be same asthe table that the data is coming from. Try changing to...
TSEquip.MappingName = "Equipment_Details"
--
For real reply address, lose the cash
www.realuk.co.uk
"Angelina" <an*******@discussions.microsoft.com> wrote in messagenews:1d****************************@phx.gbl...

Hi,

Im trying to format my datagrid via some code to make one column readonly while the other can be edited.
I also tried to change the column header. The problem is that the code does not seem to be taking effect.

Here is my code. Can anyone please offer me some help?

da = New SqlDataAdapter("SELECT Equipment_Desc, 0 as
Quantity FROM Equipment_Details", Cn)

ds = New DataSet("Equipment")
da.Fill(ds)

DataGridEquip.DataSource = ds.Tables(0)

Dim TSEquip As New DataGridTableStyle()
TSEquip.MappingName = "Equipment"

Dim TCEquipName As New DataGridTextBoxColumn()
TCEquipName.MappingName = "Equipment_Desc"
TCEquipName.HeaderText = "Equipment Name"
TCEquipName.Width = 110
TCEquipName.ReadOnly = True
TSEquip.GridColumnStyles.Add(TCEquipName)

Dim TCQuantity As New DataGridTextBoxColumn()
TCQuantity.MappingName = "Quantity"
TCQuantity.HeaderText = "Quantity"
TCQuantity.Width = 90
TCQuantity.ReadOnly = False
TSEquip.GridColumnStyles.Add(TCQuantity)
DataGridEquip.TableStyles.Add(TSEquip)

.

[Tim Anderson]

"Angelina" <an*******@discussions.microsoft.com> wrote in message
news:1d****************************@phx.gbl...

Here is my code. Can anyone please offer me some help? da.Fill(ds)
When you fill the dataset give it a tablename:

da.Fill(ds,"mytable")
TSEquip.MappingName = "Equipment"

Use the name here:
TsEquip.MappingName="mytable"

Tim
Investigating dotnet: http://www.itwriting.com/dotnet1.php

[Tim Anderson]

"Angelina" <an*******@discussions.microsoft.com> wrote in message
news:1d****************************@phx.gbl...

Here is my code. Can anyone please offer me some help? da.Fill(ds)
When you fill the dataset give it a tablename:

da.Fill(ds,"mytable")
TSEquip.MappingName = "Equipment"

Use the name here:
TsEquip.MappingName="mytable"

Tim
Investigating dotnet: http://www.itwriting.com/dotnet1.php