C#

  1  class Program 
  2  {
  3      // I have list of classes (say class Person with FirstName and LastName as property).
  4      class Person 
  5      {
  6          public string FirstName { get; set; }
  7          public string LastName { get; set; } 
  8      } 
  9  
 10      static void Main(string[] args)
 11      {
 12          using (var f = new Form())
 13          {
 14              // I have combobox that is dynamically populated 
 15              // whose items are the class's properties 
 16              // (in this case FirstName and LastName).
 17              var cmb = new ComboBox() 
 18              { 
 19                  Dock = DockStyle.Top, 
 20                  DataSource = typeof(Person)
 21                                  .GetProperties()
 22                                  .Select(p => p.Name)
 23                                  .ToArray()
 24              };
 25  
 26              // I want to filter the list whose property selected 
 27              // in the combobox contains the text written in the textbox.
 28              var theTextBox = new TextBox()
 29              {
 30                  Dock = DockStyle.Top
 31              };
 32  
 33              // ..think, think - you want IntelliSense!
 34              theTextBox.TextChanged += delegate
 35              {
 36                  string zeTextDatWeNeed = theTextBox.Text;
 37                  cmb.DataSource = typeof(Person)
 38                      .GetProperties()
 39                      .Select(p => p.Name)
 40                      .Where(p => p.Contains(zeTextDatWeNeed))
 41                      .ToArray();
 42              };
 43   
 44              f.Controls.AddRange(new Control[]{ theTextBox, cmb });
 45              f.ShowDialog();
 46          }

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

emma.sun.sts wrote:

And is there anything like definite non-null or non-zero object that I can possibly use in place of cellName?

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

rng = ws.get_Range("A1", "A5");  // A1:A5
/* Excel returns a 2 dimensional array of the values even if you
 * only want to retrieve a range that represents a single row or
 * single column.
 *
 * The array is returned as a System.Object type, so casting is necessary.
 * Using an array of objects allows you can deal with multiple data types
 * and null values.
 *
 * If the range contains multiple areas (i.e.  A1:C4, F5:J20), only the first
 * area (A1:C4) will be returned.
 *
 * Excel works with one (1) based indexing not zero(0) based.  So the
 * lower bound of each array index will be one(1) not zero(0).
 *
 * The 1st Array Index corresponds to the row, and the second index to the
 * column. [R,C]
*/
object[,] retrievedarray = (object[,])rng.get_Value(Excel.XlRangeValueDataType.xlRangeValueDefault);

// Iterate over the array.  This is written to allow for a multicolumn Range.
for (Int32 col = retrievedarray.GetLowerBound(1); col <= retrievedarray.GetUpperBound(1); col++)
{
    for (Int32 row = retrievedarray.GetLowerBound(0); row <= retrievedarray.GetUpperBound(0); row++)
    {
        if (retrievedarray[row, col] is double)
        {
            double value = (double)retrievedarray[row, col];
            // do something with the value
            System.Diagnostics.Debug.WriteLine(value.ToString());
        }
        else if (retrievedarray[row, col] == null)
        {
            System.Diagnostics.Debug.WriteLine("null");
        }
    }
}

ahmed_one wrote:

I've created DAL class for data access ofcourse, purpose of which is to provide Database connection and execute Sql commands or stored proc.

ahmed_one wrote:

Now the problem: How should I save OrderDetails...which is in DataGridView name dgGrd, dgGrd is also bind to DataTable.

ahmed_one wrote:

How should I call SaveData method within Order class?

ahmed_one wrote:

I will be very much appreciate if you could help me to line up my coding

ahmed_one wrote:

perhaps if you could provide a sample?

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

ahmed_one wrote:

Now it works for Saving Order with order Details

ahmed_one wrote:

Now I need to move one step further to use classes for search the orders by OrderID or OrderDate options

ahmed_one wrote:

I hope if I will stuck in future I will get help from here

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

Dave Kreskowiak wrote:

You've come to the wrong forum website. This is not the place to post your "jobs".