How can I change the column name of the datagrid? Since the datagrid is bound to the database, the column name automatically shows whatever field name is in the database. In addition, how do I change the width of a certain cell in the datagrid. Ex: the email field in the datagrid has to be wider! I would really appreciate it if you can provide me some codes in the vb.net language b/c all the resource I've found has been in C# and I haven't been successful in converting it into VB.net.
CBClay Burch Syncfusion Team June 3, 2002 01:39 AM
If you have created a dataset from a datacomnnection and dataadapter dropped on a form, then code such as listed below should allow you to get at the columnstyles where you can set up properties like columnwidth and headertext.
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'add a datasource to the grid
Me.DataGrid1.DataSource = Nothing
Me.DataGrid1.DataSource = Me.DataSet11.Tables("FAQEntries")
'create a tablestyle based on the current contents
Dim myCurrencyManager As CurrencyManager
myCurrencyManager = CType(BindingContext(Me.DataSet11, "FAQEntries"), CurrencyManager)
Dim ts As DataGridTableStyle
ts = New DataGridTableStyle(myCurrencyManager)
'add the tablestyle to grid
'modify particular columnstyles in the tablestyle
ts.GridColumnStyles(1).Alignment = HorizontalAlignment.Right
ts.GridColumnStyles(2).Width = 30
ts.GridColumnStyles(4).HeaderText = "test"
JOjollyJune 3, 2002 04:10 AM
What is the CurrencyManager?
CBClay Burch Syncfusion Team June 3, 2002 08:35 AM
It is a class in the .NET Framework. It keeps track of what item is 'current', and allows you to get its position, value, count etc. Take a look at the help.
You do not actually have to use the currencymanager in the above code. But by using using it, you avoid having to loop through and creating/adding columnstyles yourself.