C#

			string line = "";
			List<int> values = new List<int>();

			using(FileStream stream = File.OpenRead("textfile.txt"))
			using(StreamReader reader = new StreamReader(stream))
			{
				while ((line = reader.ReadLine()) != null)
				{
					// adjust the search pattern here
				//	Match match = Regex.Match(line, @"^\w+\s+(\d+)$");
					Match match = Regex.Match(line, @"^aaabb\s+(\d+)$");
					if (match.Success)
						values.Add(Int32.Parse(match.Groups[1].Value));
				}
			}
</int></int>

duta wrote:

I'm very new to C# but I have some experience in C++. There a struct array was an alternative but I don't know how to do that in C#.

// create dictionary
Dictionary<string, List<int>> items = new Dictionary<string, List<int>>();
// populate it with data from the file
foreach (string line in File.ReadAllLines(pathName)) {
   string[] data = line.Split('\t');
   List<int> list;
   if (!items.TryGetValue(data[0], out list) {
      list = new List<int>();
      items.Add(data[0], list);
   }
   list.Add(int.Parse(data[2]));
}
// get the list for a specific string
List<int> aaabb = items["aaabb"];
// sort the list
aaabb.Sort();

Vuyiswa Maseko wrote:

My SP Returns "0", if there is no Role Found.

if(System.Convert.IsDBNull(cmdselect.Parameters["@Role"].Value))
{
     Results = 0;
}
else
{
     Results = (int) cmdselect.Parameters["@Role"].Value;
}

Christian Graus wrote:

We don't do homework. Because, if we did, you would not learn and then we'd have to teach you on the job some day, or just do your work to meet our deadlines.