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; }