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);
}
protected void FillParameters(SharpQueryParameterCollection parameters)
{
SharpQueryParameter par = null;
for (int i = 0; i < parameters.Count; i++)
{
par = parameters[i];
if (par.Type == ParameterDirection.ReturnValue)
{
i--;
parameters.Remove(par);
}
}
this.dataGrid.CaptionVisible = true;
this.dataGrid.DataSource = parameters;
this.dataGrid.DataMember = null;
this.dataGrid.AllowNavigation = false;
}
public SharpQueryNodeParameter(SharpQueryParameter sharpQueryParameter)
: base(sharpQueryParameter)
{
this.ImageIndex = 9;
this.SelectedImageIndex = 9;
}
