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