C#

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".