Hopefully someone can help me with this problem.
I create in runtime an datatable and i want to save it to my Access database.
The code i got at this moment is:
Private Sub MainForm_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
_dtDatum = Now
Try
_oDt = New DataTable("t" & _
_dtDatum.Year & _
_dtDatum.Month.ToString("d2") & _
_dtDatum.Day.ToString("d2"))
_oDt.Columns.Add(New DataColumn("Kolom_1", Type.GetType("System.String")))
_oDt.Columns.Add(New DataColumn("Kolom_2", Type.GetType("System.String")))
_oDt.Columns.Add(New DataColumn("Kolom_3", Type.GetType("System.String")))
For i As Integer = 0 To 5 Step 1
_Odr = _oDt.NewRow
_Odr("Kolom_1") = "Kolom " & i.ToString
_Odr("Kolom_2") = "Kolom " & (i + 1).ToString
_Odr("Kolom_3") = DateTime.Now
_oDt.Rows.Add(_Odr)
Next
For Each o As DataColumn In _oDt.Columns
clbColums.Items.Add(o.ToString)
Next
Catch ex As Exception
MsgBox(ex.Message)
Finally
End Try
End Sub
But i can't find a way to save this to the database.
Thanks for helping.
Posted Oct 23, 2009, 5:14 AM
BoratPosted Apr 11, 2009, 1:55 PM
Hi.
Thanks for your advice but i can't get to the info because i'll have to pay for it.
I don't have a creditcard.
Is there any other way you can send me the info and i can get further with my problem.
Thanks.
Borat.
Vijaya KadiyalaPosted Apr 11, 2009, 1:17 PM
Hi
Check out the below link
http://www.experts-exchange.com/Programming/Languages/.NET/Visual_Basic.NET/Q_23288320.html
Thanks -- Vijaya Kaidyala
www.DotNetVJ.com