[RESOLVED] How to add more 2 columns to DataGrid ?

DataGrid came by default with two columns only (0, 1)
So, how can I add more than 2 columns to a DataGrid ?

DataGrid1.Columns.Add 2

Quote:

---

Originally Posted by jp26198926

DataGrid1.Columns.Add 2

---

I used it like the following code:

VB Code:

DataGrid1.Columns.Add 5
DataGrid1.Columns(0).Caption = "111"
DataGrid1.Columns(1).Caption = "222"
DataGrid1.Columns(2).Caption = "333"
DataGrid1.Columns(3).Caption = "444"
DataGrid1.Columns(4).Caption = "555"

I got this error messege:

Quote:

---

Runtime error '424':
Object required

---

try like this

Code:

---

For i = 0 To 4
    DataGrid1.Columns.Add(i).Caption = "Column " & i
Next

---

DataGrid.Columns(0).....

should be..
DataGrid1.Columns(0)....

Code:

---

Dim i As Integer

For i = 2 To 4
    DataGrid1.Columns.Add i
Next i

DataGrid1.Columns(0).Caption = "111"
DataGrid1.Columns(1).Caption = "222"
DataGrid1.Columns(2).Caption = "333"
DataGrid1.Columns(3).Caption = "444"
DataGrid1.Columns(4).Caption = "555"

---

This code will work correctly:

VB Code:

DataGrid1.ColumnHeaders = True
 
For i = 0 To 4
    DataGrid1.Columns.Add(i)
Next
 
DataGrid1.Columns(0).Caption = "Header-1"
DataGrid1.Columns(1).Caption = "Header-2"
DataGrid1.Columns(2).Caption = "Header-3"
DataGrid1.Columns(3).Caption = "Header-4"
DataGrid1.Columns(4).Caption = "Header-5"

I was use "DataGrid" not "DataGrid1".
Thanks for all.

The main problem now that "DataField" property does not work:

VB Code:

DataGrid1.Columns(0).DataField = "Field1"
DataGrid1.Columns(1).DataField = "Field2"
DataGrid1.Columns(2).DataField = "Field3"
DataGrid1.Columns(3).DataField = "Field4"
DataGrid1.Columns(4).DataField = "Field5"

I got now all columns in my query not only that five !

Can I customize the number of columns in design mode (not in runtime) ?

u can add columns in design time aslo, right click -> edit, again right click -> insert

Thank you, it's working.