Some Datagrid Problems

[MarkItZero]

Hello,

I will admit that I am a lousy VB.Net programmer, but when the boss says get it done, it seems I dont have much choice.

 

I am creating a windows program using data from an Access database. I thought my best bet would be to use datagrids on my form for inserting, editing and deleting data from the tables. When I used the datagrid wizard to create my form I expected I would find a lot of the same functionality that I would find if I just opened the table in Access. Sadly this is not the case.

 

I especially wanted to be able to copy and paste rows just like I would in Access or Excel. But I have no idea where to start.

 

I also need to find a way to add combo boxes to my datagrid.

 

Lastly, I have added a checkbox column to the datagrid, but it is behaving strangely. Sometimes when I click the box, nothing happens. Other times I will click the box and a dim grey check mark will appear instead of the usual bold black mark.

 

This is the code that I used to set my datagrid properties everything else on the form was generated by the wizard...

 

  'Set Datagrid Properties
       'New Table Style
       Dim TSeditEquip As New DataGridTableStyle
       'Table Style Properties
       With TSeditEquip
           .MappingName = "Equipment"
       End With

       'Declare Each Column of DG
       Dim col1 As New DataGridTextBoxColumn
       Dim col2 As New DataGridTextBoxColumn
       Dim col3 As New DataGridTextBoxColumn
       Dim col4 As New DataGridBoolColumn

       'Column Properties
       With col1
           .HeaderText = "Equip Code"
           .MappingName = "EquipCode"
           .Width = 100
           .TextBox.MaxLength = 15
           .NullText = String.Empty
       End With
       With col2
           .HeaderText = "Type"
           .MappingName = "EquipType"
           .Width = 150
       End With
       With col3
           .HeaderText = "Description"
           .MappingName = "Description"
           .Width = 250
           .TextBox.MaxLength = 25
           .NullText = String.Empty
       End With
       With col4
           .HeaderText = "Inactive"
           .MappingName = "Inactive"
           .Width = 60
       End With

       'Add Columns to DataStyle
       TSeditEquip.GridColumnStyles.AddRange(New DataGridColumnStyle() {col1, col2, col3, col4})
       'Add DataStyle to DG
       grdEquipment.TableStyles.Add(TSeditEquip)

 

Any suggestions for any of my problems would be greatly appreciated.

 

Thanks!

[AlexCode]

Who doesn't have problems wit DataGrid???

 

First - If you have budget and/or the project really worths it and/or you have more projects where you need a grid implementation, buy a third party one, I usually sugest XtraGrid from http://www.devexpress.com.

 

Next - Copy/Paste rows isn't an embeded featuro on grids.

Databound grids can display alot complex data structures that the just can't automaticly "know" how to duplicate.

What you can, and must, do is to implement the feature on the datasource, reflecting the changes on the presentation layer, in this case, on the datagrid.

An idea is to add some buttons, i.e. Copy, Paste, PasteTo, MoveTo... as desired, manipulate the data on the datasource, i.e. a DataTable, and reflect the changes on the datagrid (if they just don't reflect themselves automaticly).

 

Alex :p