C#

DataRelation dr = new DataRelation("BookBookName",
                ds.Tables["MBook"].Columns["BookId"],
                ds.Tables["Book"].Columns["BookId"]);

DataRelation dr1 = new DataRelation("BookAuthorName",
                ds.Tables["MBook"].Columns["AuthorId"],
                ds.Tables["AName"].Columns["AuthorId"]);

ds.Relations.Add(dr);
 ds.Relations.Add(dr1);
 ds.Relations.Add(dr2);

foreach (DataRow MBookRow in customerOrders.Tables["NBook"].Rows)
{
    Console.WriteLine(MBookRow["MBookId"].ToString());

    foreach (DataRow BNameRow in MBookRow.GetChildRows(dr1))
    {
        Console.WriteLine(BNameRow["BookId"].ToString() + " " + BNameRow["BookName"].ToString());
    }
}

Blubbo wrote:

Perhaps a better explaination of using "Interface"?

Blubbo wrote:

I've got 2 devices but only got 1 (crashes when doing the 2nd devices in SeekHidDevices method during ReadPort calling.

SqlCommand command = new SqlCommand();
command.Connection = ...//set to your connection 
command.CommandText = "sp_name";
command.Paramaters.Add("@paramName, System.Data.SqlTypes.SqlDecimal).Value = 0m; //use correct type param
using(SqlDataReader reader = command.ExecuteReader()){
    while(reader.Read()){
        //The reader contains the columns of each record
    }
}//end using

class ConvertDictionary
{
    Dictionary<string, int> _dictionary = new Dictionary<string, int>()
    {
        {"salmon", 5},
        {"tuna", 6},
        {"clam", 2},
        {"asparagus", 3}
    };

    public ConvertDictionary()
    {
        // Convert dictionary to string and save
        string s = GetLine(_dictionary);
        File.WriteAllText("dict.txt", s);
        // Get dictionary from that file
        Dictionary<string, int> d = GetDict("dict.txt");
    }

    string GetLine(Dictionary<string, int> d)
    {
        // Build up each line one-by-one and them trim the end
        StringBuilder builder = new StringBuilder();
        foreach (KeyValuePair<string, int> pair in d)
        {
            builder.Append(pair.Key).Append(":").Append(pair.Value).Append(',');
        }
        string result = builder.ToString();
        // Remove the final delimiter
        result = result.TrimEnd(',');
        return result;
    }

    Dictionary<string, int> GetDict(string f)
    {
        Dictionary<string, int> d = new Dictionary<string, int>();
        string s = File.ReadAllText(f);
        // Divide all pairs (remove empty strings)
        string[] tokens = s.Split(new char[] { ':', ',' },
            StringSplitOptions.RemoveEmptyEntries);
        // Walk through each item
        for (int i = 0; i < tokens.Length; i += 2)
        {
            string name = tokens[i];
            string freq = tokens[i + 1];

            // Parse the int (this can throw)
            int count = int.Parse(freq);
            // Fill the value in the sorted dictionary
            if (d.ContainsKey(name))
            {
                d[name] += count;
            }
            else
            {
                d.Add(name, count);
            }
        }
        return d;
    }
}

//Up arrow
if(ListBox1.SelectedIndex!=0)
             {
                 int i = ListBox1.SelectedIndex; 
                 string s = ListBox1.Items[i].Text;
                 string s1 = ListBox1.Items[i - 1].Text;                 
                 ListBox1.Items[i-1].Text = s;
                 ListBox1.Items[i].Text = s1;
             }

//Down Arrow
if(ListBox1.SelectedIndex!=ListBox1.Items.Count)
             {
                 int i = ListBox1.SelectedIndex; 
                 string s = ListBox1.Items[i].Text;
                 string s1 = ListBox1.Items[i + 1].Text;                 
                 ListBox1.Items[i+1].Text = s;
                 ListBox1.Items[i].Text = s1;
             }

myInstance.GetType().GetProperty(whichMember)