datagrid entry with no db components

[mhmtzdmr]

Hi,

How can I insert an entry to datagrid without using db components? For
example, I have a textbox and I would like to press OK button and
insert the text in textbox to datagrid.

Regards.

[Peter Proost]

Hi you need a datatable for that,
for example:

Dim dt As New DataTable("MyTa ble")
dt.Columns.Add( "Name")
dt.Columns.Add( "Country")
Datagrid1.DataS ource = dt.DefaultView

you then can add rows with a datarow object or with

dt.LoadDataRow( New Object() _
{"Peter", "Belgium"}, True)
dt.LoadDataRow( New Object() _
{"Cor", "The Netherlands"}, True)
dt.LoadDataRow( New Object() _
{"Ken", "USA"}, True)
dt.LoadDataRow( New Object() _
{"You", Textbox1.Text}, True)

Hope this helps

Greetz Peter
--
Programming today is a race between software engineers striving to build
bigger and better idiot-proof programs, and the Universe trying to produce
bigger and better idiots. So far, the Universe is winning. (Rich Cook)

<mh******@gmail .com> schreef in bericht
news:11******** **************@ g14g2000cwa.goo glegroups.com.. .

Hi,

How can I insert an entry to datagrid without using db components? For
example, I have a textbox and I would like to press OK button and
insert the text in textbox to datagrid.

Regards.

[mhmtzdmr]

Many thanks.

[mhmtzdmr]

In addition how can I change the width of this columns I added?

Regards.

[Peter Proost]

Hi, you can use a DataGridTableSt yle and DataGridTextBox Column for that (see
code below)

Hope this helps

Greetz Peter

Dim dt As New DataTable("MyTa ble")
dt.Columns.Add( "Name")
dt.Columns.Add( "Country")
Dim ts1 As New DataGridTableSt yle
ts1.MappingName = "MyTable" 'Has to be the same as the table name
Dim TextCol As DataGridTextBox Column
For i As Integer = 0 To dt.Columns.Coun t - 1
TextCol = New DataGridTextBox Column
Select Case i
Case 0
TextCol.Width = 50
TextCol.Alignme nt = HorizontalAlign ment.Center
TextCol.HeaderT ext = dt.Columns(i).C olumnName
Case 1
TextCol.Width = 100
TextCol.Alignme nt = HorizontalAlign ment.Center
TextCol.HeaderT ext = dt.Columns(i).C olumnName
TextCol.NullTex t = ""
End Select

TextCol.NullTex t = ""
TextCol.Mapping Name = dt.Columns(i).C olumnName
ts1.AllowSortin g = False
ts1.GridColumnS tyles.Add(TextC ol)
Next

DataGrid1.Table Styles.Clear()
DataGrid1.Table Styles.Add(ts1)

DataGrid1.DataS ource = dt.DefaultView

dt.LoadDataRow( New Object() _
{"Peter", "Belgium"}, True)
dt.LoadDataRow( New Object() _
{"Cor", "The Netherlands"}, True)
dt.LoadDataRow( New Object() _
{"Ken", "USA"}, True)
dt.LoadDataRow( New Object() _
{"You", "Your Country"}, True)

[mhmtzdmr]

Hi Peter,

Thanks for your time and helps.

Last question: Is it possible to use combobox on datagrid? For example
I want to add the values to be selected from the combobox manually.

Best Regards.

[Peter Proost]

Hi have a look at these

http://www.vb-tips.com/default.aspx?...d-faf92f41f563

http://www.vb-tips.com/default.aspx?...9-3866d4936de0

Greetz Peter

--
Programming today is a race between software engineers striving to build
bigger and better idiot-proof programs, and the Universe trying to produce
bigger and better idiots. So far, the Universe is winning. (Rich Cook)

<mh******@gmail .com> schreef in bericht
news:11******** **************@ g14g2000cwa.goo glegroups.com.. .

Hi Peter,

Thanks for your time and helps.

Last question: Is it possible to use combobox on datagrid? For example
I want to add the values to be selected from the combobox manually.

Best Regards.