public SharpQuerySchemaClassCollection GetSchemaProcedureParameters(ISchemaClass schema)
{
SharpQuerySchemaClassCollection list = new SharpQuerySchemaClassCollection();
DataTable record = null;
SharpQuerySchemaEnum schematype = SharpQuerySchemaEnum.ProcedureParameters;
object[] restrictions = new object[] { schema.CatalogName, schema.SchemaName, schema.InternalName, "" };
try
{
record = this.GetSchema(schematype, restrictions);
SharpQueryParameter par = null;
if (record != null)
{
foreach (DataRow row in record.Rows)
{
par = new SharpQueryParameter(this, schema.CatalogName, schema.SchemaName, schema.Name, row["PARAMETER_NAME"].ToString());
par.DataType = StringToDbType(row["DATA_TYPE"].ToString());
par.Type = StringToParamDirection(row["PARAMETER_TYPE"].ToString());
if (par.Type != ParameterDirection.ReturnValue)
{
list.Add(par);
}
}
}
}
catch (System.Exception)
{
list.Add(new SharpQueryNotSupported(this, "", "", "", "SharpQuerySchemaEnum.ProcedureParameters"));
}
return list;
}
public SharpQueryNodeParameter(SharpQueryParameter sharpQueryParameter)
: base(sharpQueryParameter)
{
this.ImageIndex = 9;
this.SelectedImageIndex = 9;
}