splitting a string

Question

Hi I have a doubt.If i insert a value like this '1112|1314|1516' it should save in the database table as follows id value1 value2 1 11 12 2 13 14 3 15 16 how to achieve this please help me Thanks in advance

siva sakthi · Answer

try this chunk of code to split the string into dtatable that you want.... string strTable = 12|34|56; DataTable dt = new DataTable(); dt.Columns.Add(id); dt.Columns.Add(Value1); dt.Columns.Add(Value2); int i = 1; foreach (string item in strTable.Split('|')) { string[] rowValues=item.Split(''); dt.Rows.Add(irowValues[0] rowValues[1]); i++; }