My Tech Blog

 DayOfWeek ------------------ Returns the weekday index for date (1 = Sunday, 2 = Monday, …, 7 = Saturday). These index values correspond to the ODBC standard. Weekday ------------ 0 =  Monday , 1 = Tuesday, 2 = Wednesday, ...... Sunday = 6). DayName ------------ Weekday name of the date.

  DataRow[] filesWithAA = dt.Select("Column_name LIKE '%KS%'");  dt.DefaultView.RowFilter = "[Column_name] LIKE '%(KS)%'";  DataTable dtOutput = dt.DefaultView.ToTable();

SELECT `id` FROM table GROUP BY id HAVING COUNT(*) = 1 id  column1 column2 -------------------------- 1    value1 value2 1   value1 value2 2 value1 value2 Executing the above query will get a result id --- 2 while occurence of the id = 2 is only once

I have been wonderinghow to do this , microsoft ist currently not encouraging people to use DataSource property. Evenif its existing its not enabled.  #############################################################  BindingSource bs = new BindingSource();  Dictionary<int, String> dicKeyValue = new Dictionary<int, String>(); // Add key, values to the dictionary   while (Reader.Read())             {                           dicKeyValue.Add(Convert.ToInt32(Reader["id"]), Convert.ToInt32(Reader["name"]));                             } // Set the datasource of BindingSource   bs.DataSource = dicKeyValue;  cListBox.DataSource = bs...

We need Windows RangeBar chart for our project. Since we need to use small blocks of data & label above these blocks . But i am having trouble setting the labelstyle ( 'BarLabelStyle' exactly) of these data blocks or points. I am trying to have the  data labels somehow on top of each blocks , but its not working **Tried setting BarLabelStyle** but in vain .(Series > Points > Custom property of a point >BarLabelStyle on the bottom) **Tried Smart labels** which would be too good if it worked , but found out that smart labels wont  work for RangeBar charts :( Ref: http://msdn.microsoft.com/en-us/library/dd456628%28v=vs.100%29.aspx **CustomLabels for Y-Axis** (for Range Bar chart X & Y axis are reverse) also didnt do the trick, since its showing on bottom line. Is not helpful for my purpose. After 2 days of Googling was not able to find an effective solution. Any suggestion or workaround to this problem is welcome :)

MsgBox Sheets("sheet1").UsedRange.Rows.Count .UsedRange.Columns.Count