In asp.net I'm inserting array values into a database but array elements are not inserted properly. Instead of that, System.String[] is inserted.
Add a comment
|
2 Answers
SQL does not do arrays well. You have mostly likely just done a .ToString() on the array of strings.
Try using string.Join( ", ", mystrings).
As mentioned in the comments, this is not third normal form. Search wikipedia for a good synopsis.
6 Comments
user2016882
Is it not possible using .Tostring()?
Richard Schneider
No, ToString() on an array of strings uses Object.ToString() which just returns the class name.
ta.speot.is
Joining the strings together will work, but it's fragile (what if you have two strings ", " and ", " -- they look like the delimiter). You should structure your database better, so that any one field does not hold multiple values.
Richard Schneider
I agree. The correct way is to have a table for the array of strings and insert a new row for each string in the array. However, this answers OP's question.
user2016882
i already have a string seperated with comma stored in database,i m splitting that string as string[] strResult = strObj.Split(','); and now I have to insert the result returned by strResult in database column...
|
System.String[] in the database implies that you are passing the string array directly to your database insert method.
Instead, you'll need to loop through the array and insert the strings as individual rows:
foreach(string s in stringArray)
{
database.Insert(s);
}
Alternatively, you can flatten the array and insert into a single row like this:
database.Insert(String.Join(",", stringArray))
This would insert the array as a comma-delimited list.
2 Comments
Richard Schneider
Seems like you copied my mistake on String.Join
user2016882
foreach(string s in stringArray) { database.Insert(s); } this is well for insertion but when I m using same loop for updation it doesn't work?Can you tell why so?