"String or binary data would be truncated.
The statement has been terminated."
....... I'm glad it's telling my it would be truncated if I procede... but, um... why in the world does it throw that error... I set the length of the columns in the table to 500 characters
It throws it on the line of code that updates my table. ( I showed my add row too... I think it may be having issues with the new row)
"My.Forms.Data.Reflex_DatabaseDataSet.Test_table.Rows.Add(newRow)
My.Forms.Data.Test_tableTableAdapter.Update(My.Forms.Data.Reflex_DatabaseDataSet)"
my entire setup looks like this:PS: I'm going to cut down the giant array thing (there are 40 there) and make a small loop.Code:newRow = My.Forms.Data.Reflex_DatabaseDataSet.Test_table.NewTest_tableRow If My.Forms.Info.TextBox1.Text = "Name (Optional)" Then Else newRow.Name = My.Forms.Info.TextBox1.Text End If If My.Forms.Info.RadioButton1.Checked = True Then newRow.Gender = "Male" ElseIf My.Forms.Info.RadioButton1.Checked = True Then newRow.Gender = "Female" End If newRow.Grade = My.Forms.Info.ComboBox1.Text newRow.Age = My.Forms.Info.ComboBox2.Text newRow.Time = DateTime.Now newRow._Date = Date.Today newRow._1_1 = pausetimearray(0) newRow._1_2 = timerecordarray(0) newRow._2_1 = pausetimearray(1) newRow._2_2 = timerecordarray(1) newRow._3_1 = pausetimearray(2) newRow._3_2 = timerecordarray(2) newRow._4_1 = pausetimearray(3) newRow._4_2 = timerecordarray(3) newRow._5_1 = pausetimearray(4) newRow._5_2 = timerecordarray(4) newRow._6_1 = pausetimearray(5) newRow._6_2 = timerecordarray(5) newRow._7_1 = pausetimearray(6) newRow._7_2 = timerecordarray(6) newRow._8_1 = pausetimearray(7) newRow._8_2 = timerecordarray(7) newRow._9_1 = pausetimearray(8) newRow._9_2 = timerecordarray(8) newRow._10_1 = pausetimearray(9) newRow._10_2 = timerecordarray(9) newRow._11_1 = pausetimearray(10) newRow._11_2 = timerecordarray(10) newRow._12_1 = pausetimearray(11) newRow._12_2 = timerecordarray(11) newRow._13_1 = pausetimearray(12) newRow._13_2 = timerecordarray(12) newRow._14_1 = pausetimearray(13) newRow._14_2 = timerecordarray(13) newRow._15_1 = pausetimearray(14) newRow._15_2 = timerecordarray(14) newRow._16_1 = pausetimearray(15) newRow._16_2 = timerecordarray(15) newRow._17_1 = pausetimearray(16) newRow._17_2 = timerecordarray(16) newRow._18_1 = pausetimearray(17) newRow._18_2 = timerecordarray(17) newRow._19_1 = pausetimearray(18) newRow._19_2 = timerecordarray(18) newRow._20_1 = pausetimearray(19) newRow._20_2 = timerecordarray(19) My.Forms.Data.Reflex_DatabaseDataSet.Test_table.Rows.Add(newRow) My.Forms.Data.Test_tableTableAdapter.Update(My.Forms.Data.Reflex_DatabaseDataSet)
PSS: The arrays are both integer values... is that the problem? There is also a date/time and some text ones. I'm starting to think that I need to cstr() the integers




... but, um... why in the world does it throw that error... I set the length of the columns in the table to 500 characters 
Reply With Quote