• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 359
  • Last Modified:

Dataset

Using a datagrid to show dataset. I'd like to add a column to my table. I've looked into the code already present, and the only way i've found so far was to play into the Windows Form Designer generated code


Any better idea ? some quick editing tips to add a column. Coze adding it this way can be long.
0
TheSonics
Asked:
TheSonics
  • 5
  • 2
  • 2
  • +1
1 Solution
 
ZeonFlashCommented:
Dim dsDataset As New DataSet

dsDataset.Tables(0).Columns.Add("NewColumn")
dsDataset.Tables(0).Columns("NewColumn").DataType = GetType(Integer)
dsDataset.Tables(0).Columns("NewColumn").ColumnName = "MyNewColumn"

0
 
pradeepsudharsanCommented:
just reconfigure data adapter
0
 
TheSonicsAuthor Commented:
Pretty nice, i want that row to be a checkbox. Increased point :P
0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
TheSonicsAuthor Commented:
i meant column, to be checkbox.
0
 
ZeonFlashCommented:
For a checkbox, you simply need to change the Datatype of the column.  A checkbox can have values of True/False, which is a Boolean, so:

 dsDataset.Tables(0).Columns("NewColumn").DataType = GetType(Boolean)
0
 
TheSonicsAuthor Commented:
Here how is it working:

I have a column named "Resp" using :
    Friend WithEvents dsHistoricRespCol As System.Data.DataColumn
and
    Friend WithEvents dgtbHistoricRespColStyle As System.Windows.Forms.DataGridTextBoxColumn

When I do resizing or similaire stuff, i do the modifications on the datagridtextboxcolumn.


So far i have added the column via the .NET interface and it creates a datacolumn. But how do I set a style via the interface ?


        Me.dgtbMeasLimitMaxColStyle.Format = ""
        Me.dgtbMeasLimitMaxColStyle.FormatInfo = Nothing
        Me.dgtbMeasLimitMaxColStyle.HeaderText = resources.GetString("dgtbMeasLimitMaxColStyle.HeaderText")
        Me.dgtbMeasLimitMaxColStyle.MappingName = resources.GetString("dgtbMeasLimitMaxColStyle.MappingName")
        Me.dgtbMeasLimitMaxColStyle.NullText = resources.GetString("dgtbMeasLimitMaxColStyle.NullText")
        Me.dgtbMeasLimitMaxColStyle.Width = CType(resources.GetObject("dgtbMeasLimitMaxColStyle.Width"), Integer)
 

Knowing the defenition of the style column, it is using the resources files, so it gotta be created via some "tools". I dont think its efficient to edit all this stuff manually.
0
 
TheSonicsAuthor Commented:
any suggestions ?
0
 
Bob LearnedCommented:
Are you looking to display a column using check boxes, using the a column style?

Bob
0
 
Bob LearnedCommented:
Through the interface, you can define a DataGridBoolColumn by pulling down the drop-down list:

https://filedb.experts-exchange.com/incoming/ee-stuff/222-DataGridColumnStyle-Collection-E.png 

Bob
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 5
  • 2
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now