C#

gaurav2325 wrote:

using OOPS.

Text file
   Custom content
   Flat - line based
   XML
   CSV
Binary file
Database
   SQL Server
   MySql
   SqLite
   SQLCE
   Access
   Oracle
   ...
Excel
Application config file
Binary Serializer
XML Serializer
...

1. Handle the text changed event of the text box.
   
2. Use the current text to repopulate the combobox.
   

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