C#

Member 10263519 wrote:

property:hi

Member 10263519 wrote:

how to get the location of that folder in c# program.

System.IO.Path.GetDirectoryName( 
      System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase);

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

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");
        }
    }
}