public static DataTable ConvertArrayToStructuredType(MultiValueParamType paramType, object[] objectParams)
{
DataTable paramTable = GetParamTable(paramType);
foreach (object param in objectParams)
{
if (param == null)
{
continue;
}
if (paramType == MultiValueParamType.Int)
{
paramTable.Rows.Add(Convert.ToInt32(param));
}
else if (paramType == MultiValueParamType.String)
{
paramTable.Rows.Add(Convert.ToString(param));
}
else
{
throw new ArgumentOutOfRangeException("paramType");
}
}
return(paramTable);
}
private static DataTable GetParamTable(MultiValueParamType paramType)
{
DataTable paramTable = new DataTable("MultiValueParam");
switch (paramType)
{
case MultiValueParamType.Int:
paramTable.Columns.Add(new DataColumn("INT_PARAM"));
break;
case MultiValueParamType.String:
paramTable.Columns.Add(new DataColumn("VARCHAR_PARAM"));
break;
default: throw new ArgumentOutOfRangeException("paramType");
}
return(paramTable);
}
public static DataTable ConvertArrayToStructuredType(MultiValueParamType paramType, object[] objectParams)
{
DataTable paramTable = GetParamTable(paramType);
foreach (object param in objectParams)
{
if (param == null)
{
continue;
}
if (paramType == MultiValueParamType.Int)
{
paramTable.Rows.Add(Convert.ToInt32(param));
}
else if (paramType == MultiValueParamType.String)
{
paramTable.Rows.Add(Convert.ToString(param));
}
else
{
throw new ArgumentOutOfRangeException("paramType");
}
}
return paramTable;
}
private static DataTable GetParamTable(MultiValueParamType paramType)
{
DataTable paramTable = new DataTable("MultiValueParam");
switch (paramType)
{
case MultiValueParamType.Int:
paramTable.Columns.Add(new DataColumn("INT_PARAM"));
break;
case MultiValueParamType.String:
paramTable.Columns.Add(new DataColumn("VARCHAR_PARAM"));
break;
default: throw new ArgumentOutOfRangeException("paramType");
}
return paramTable;
}
