private DataTable ConvertToTable(string sVal)
{
DataTable dt = new DataTable();
if (sVal.Length > 0)
{
string[] asVal = sVal.Replace(Environment.NewLine, "\n").Split('\n');
foreach (string sVC in asVal[0].Split(','))
dt.Columns.Add(sVC);
for (int i = 1; i < asVal.Length; i++)
{
string[] asVV = asVal[i].Split(',');
object[] aobj = new object[asVV.Length];
for (int j = 0; j < asVV.Length; j++)
aobj[j] = asVV[j];
dt.LoadDataRow(aobj, true);
}
}
return dt;
}
- Aug 23 Tue 2011 14:27
Convert string to DataTable with header
close
全站熱搜
留言列表