C#

Abdul Rahman Hamidy wrote:

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=my.xlsx;Extended Properties="Excel 12.0 Xml;HDR=YES";

string pattern = ".+(\"http\\://screenshots\\.filesnetwork\\.com/68/potd/t_[0-9]+_[0-9]+\\.jpg\").+";

...

src="http://screenshots.filesnetwork.com/68/potd/t_1215615627_85.jpg" alt="Knights of the Old Republic 2" width="160" height="120"

...

Match m = re.Match(webSource);
richTextBox1.Text = m.Value;

http://screenshots.filesnetwork.com/68/potd/t_1215615627_85.jpg

kbalias wrote:

at the position of the cell and with the size of the cell

kbalias wrote:

Calendar in Microsoft Outlook

static Dictionary<Fields, Action<Record, string>> sLinks;
 
static void InitLinks()
{
  sLinks = new Dictionary<Fields, Action<Record, string>>();
  sLinks.Add( Fields.COMPANY, ( record, value ) => record.company = value );
  sLinks.Add( Fields.EMAIL, ( record, value ) => record.email = value );
  sLinks.Add( Fields.FAX, ( record, value ) => record.fax = value );
  sLinks.Add( Fields.FIRSTNAME, ( record, value ) => record.firstName = value );
  ...
}
 
char value;
foreach ( var link in sLinks )
{
  if ( fields.TryGetValue( ( int ) link.Key, out value ) )
    link.Value( record, grid[ 1, ( int ) value - 64 ].ToString() );
}

----------------------------------
Be excellent to each other

delegate void LinkDelegate( ref Record t, string v );
 
static Dictionary<Fields, LinkDelegate> sLinks;
 
static void InitLinks()
{
  sLinks = new Dictionary<Fields, LinkDelegate>();
 
  sLinks.Add( Fields.COMPANY, ( ref Record r, string v ) => r.company = v );
  sLinks.Add( Fields.EMAIL, ( ref Record r, string v ) => r.email = v );
  sLinks.Add( Fields.FAX, ( ref Record r, string v ) => r.fax = v );
  sLinks.Add( Fields.FIRSTNAME, ( ref Record r, string v ) => r.firstName = v );
  ...
}

char value;
foreach ( var link in sLinks )
{
  if ( fields.TryGetValue( ( int ) link.Key, out value ) )
    link.Value( ref record, grid[ 1, ( int ) value - 64 ].ToString() );
}

----------------------------------
Be excellent to each other

PIEBALDconsult wrote:

1) Why is the key type of the Dictionary int rather than Fields?
2) Why is the value type of the Dictionary char rather than int?
3) Why do you protect yourself against missing values in the dictionary?
4) What's with the -64 ?

PIEBALDconsult wrote:

The question is; how much control do you have over these details?
In fact, the grid would be more useful as object[][] rather than object[,].

MarkBrock wrote:

Your a bright man

Laji59 wrote:

I need your help immediately