
December 17th, 2005, 07:28 PM
|
 |
Contributing User
|
|
Join Date: Jun 2004
Location: Phx. AZ
Posts: 221
  
Time spent in forums: 1 Day 19 h 12 m 21 sec
Reputation Power: 6
|
|
|
Getting a 'System.ArgumentException' error
I am get this error when trying to insert data into a database
Quote:
An unhandled exception of type 'System.ArgumentException' occurred in system.data.dll
Additional information: System.InvalidCastException: Specified cast is not valid.
at System.Convert.ToInt32(Object value)
at System.Data.Common.Int32Storage.Set(Int32 record, Object value)
at System.Data.DataColumn.set_Item(Int32 record, Object value)Couldn't store <> in ID Column. Expected type is Int32. |
Here is my code for the sub routine
Code:
Dim newRow(5) As Object
Dim dcIdColumn As DataColumn
dcIdColumn = New DataColumn
dcIdColumn.AllowDBNull = True
Dim intX As Integer
Me.dlgOpen.Filter = "MP3 file (*.mp3)|*.mp3|WMA Files (*.wma)|*.wma|All Files (*.*)|*.*"
Me.dlgOpen.InitialDirectory = Application.StartupPath
Me.dlgOpen.FilterIndex = 1
Me.dlgOpen.Title = "Open Music File"
'open dialog and accept user input
If Me.dlgOpen.ShowDialog() = DialogResult.OK Then
strCurrentFile = Me.dlgOpen.FileName
Dim objReader As StreamReader = New StreamReader(strCurrentFile)
objReader.Close()
objReader = Nothing
' Set the values of the array.
newRow(0) = dcIdColumn
newRow(1) = InputBox("Enter Title")
newRow(2) = InputBox("Enter Artist Name")
newRow(3) = InputBox("Enter Notes, (i.e. genre)")
newRow(4) = InputBox("Enter File Type")
newRow(5) = strCurrentFile
' Add the new row to the rows collection
Dim drNewSong As DataRow
dtMusic.BeginLoadData()
drNewSong = dtMusic.LoadDataRow(newRow, True)
dtMusic.EndLoadData()
MessageBox.Show("File added to database", "Save Complete")
'Add to List Boxes
Me.lstTitle.Items.Add(newRow(1))
Me.lstArtist.Items.Add(newRow(2))
Me.lstNote.Items.Add(newRow(3))
Me.lstType.Items.Add(newRow(4))
Me.lstFileName.Items.Add(newRow(5))
End If
This is my first attempt to insert data into VB 2003. Please let me know if it is wrong. Thanks
|