private void gvProcedures_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex == -1)
return;
var procedureName = gvProcedures.Rows[e.RowIndex].Cells["Name"] as DataGridViewTextBoxCell;
StoreProcedure = procMetaReader.StoreProcedures.First(x => x.Name == procedureName.Value.ToString());
ParameterCollection = procMetaReader.GetParameterCollectionByProcedure(procedureName.Value.ToString());
IsCanGenerateFile = CheckIntegrity();
if (IsCanGenerateFile)
SaveSettings();
procMetaReader.FillParameter(StoreProcedure);
InitialGvProcedureParameters();
}
public void FillParameter(StoreProcedure sp)
{
List<SpColumn> columns = new List<SpColumn>();
SqlParameterCollection collection = GetParameterCollectionByProcedure(sp.Name);
for (int j = 0; j < collection.Count; j++)
{
SpColumn spColumn = new SpColumn();
spColumn.CName = collection[j].ParameterName;
spColumn.IsNullable = collection[j].IsNullable;
spColumn.CType = DataTypeMapper.MapFromDBType(collection[j].SqlDbType.ToString());
columns.Add(spColumn);
}
sp.Parameters = columns;
}
