I am trying to save some records to a sql table. I am trying to save a string for the Market segment. But i get a problem, "Cannot set column 'Market Seg'. The value violates the MaxLength limit of this column."
The datatype set for that column is text, and the value trying to be stored in it is "Magazine - B2B". Im new to SQL, can someone point out what is going on?
Code:If saverow = 0 Then saverow2 = MainDBDataSet.Assesments.NewRow() saverow2.Item("Customer") = CustomerName saverow2.Item("Cust ID") = CustomerNum saverow2.Item("Title") = title saverow2.Item("Title ID") = title saverow2.Item("Market Seg") = marketSeg MainDBDataSet.Tables("assesments").Rows.Add(saverow2) AssesmentsTableAdapter.Update(MainDBDataSet.Assesments)




Reply With Quote