Posts

Donate

WPF How To Set Color Value Using Hexademical Value

Here's a snippet that passes a hexa color and set a wpf control object's background/foreground property. BrushConverter bc = new BrushConverter(); Brush brush; brush = (Brush)bc.ConvertFrom( "#003F87" ); notes.SetValue(TextBlock.BackgroundProperty, brush); Original Source:  http://jammer.biz/blog2/?p=169 Greg

Access Datagrid Row In WPF Through Index

Image
Hi All, This is just a repost from this site: Accessing DataGridRow on how to get or access the WPF Datagrid row through index. DataGridRow dgr = (DataGridRow)dataGrid1.ItemContainerGenerator.ContainerFromIndex(nRowIndex); if (dgr == null ) // row might be invisible (top / bottom). So, scroll into the view and get it { dataGrid1.UpdateLayout(); dataGrid1.ScrollIntoView(dataGrid1.Items[nRowIndex]); dgr = (DataGridRow)dataGrid1.ItemContainerGenerator.ContainerFromIndex(nRowIndex); } Thanks for the original contributor, this helped me a lot.

Loop Through Datagrid In WPF (ItemSource Is Type Observable Collection)

Hello, Assuming the databinding source of WPF Datagrid is of type ObservableCollection, the code below will loop through the WPF DataGrid. var row = GetDataGridRows(dgScripts); foreach (DataGridRow r in row) { CScriptsInfo info = (CScriptsInfo)r.Item; if (info.prog_name.ToString().Contains(txtScriptName.Text.Trim().ToUpper())) { r.IsSelected = true ; } }

Count Record In Every Hour Of A Given Day In (MySQL Database

Here is a query to count records gathered in every hour of a given day. The date_visited is a 24 hour time format which is of timestamp data type. The idea came from a fellow developer.. select hour(time(date_visited)) as hour_of_day_24_hour_format, count (hour(time(date_visited))) as count_per_hour from tblpropsale_v2 where date(date_visited) = '2012-05-07' and web_id = 642 and is_visited = 1 group by hour(time(date_visited)) order by hour(time(date_visited)) asc ;

Regular Expression In html List Tag Not Working In Multiline String In C#

I have this string: < li class="MsoNormal" style="color:white;mso-themecolor:background1; mso-margin-top-alt:mso-list:l1 level1 lfo1;tab-stops:list 36.0pt"> and the regex has a lazy quantifier to replace the string above to < li>. Using a simple regex pattern, it won't change the string above to ordinary < li>. The solution would be to add a regex to replace new line characters. Since the string has newline characters. Regex.Replace(source, @"\n" , string .Empty, RegexOptions.IgnoreCase);

How To Set Background Color Of Excel Cell Using C#

Image
Good evening! Here's how to set MS Excel cell or cells background color using C# Excel.Range class in two different solutions. chartRange = sheet.Cells[ 1 , i + 1 ]; chartRange.Interior.Color = Color.LightBlue; or using get_Range() function and ColorTranslator.ToOle() to set the background color. Excel.Range chartRange; chartRange = xlWorkSheet.get_Range( "b1" , "b3" ); chartRange.Interior.Color = ColorTranslator.ToOle(Color.Red); Where chartRange is a RangeObject.

Clear Checkboxes Inside GroupBox Not Working In C# Windows Forms

In a project that i am working with, I have 18 checkboxes. Normally the code below should clear all 18 checkboxes in the groupbox. private void ClearChecklist(GroupBox control) { foreach (Control checklist in control.Controls) { if (checklist is CheckBox) { ((CheckBox)checklist).Checked = false ; } } } However only 14 checkboxes are deselected. So I modified the code to this: private void ClearChecklist(GroupBox control) { if (visited_recursion &lt;= 1) { foreach (Control checklist in control.Controls) { if (checklist is CheckBox) { ((CheckBox)checklist).Checked = false ; } } visited_recursion++; ClearChecklist(grpActiveSiteCategories); } } I applied a recursion only once to prevent infinite loop/exception.

Method's type signature is not Interop compatible. [Copying DataGridValues to excel cell object]]

I have this original snippet which copies datagridview values into the microsoft excel sheet: for ( int i = 0; i < dataGridViewObjects[gcount].Columns.Count; i++) { sheet.Cells[1, i + 1] = dataGridViewObjects[gcount].Columns[i].Name; for ( int row = 0; row < dataGridViewObjects[gcount].Rows.Count; row++) { for ( int column = 0; column < dataGridViewObjects[gcount].Columns.Count; column++) { sheet.Cells[row + 2, column + 1] =dataGridViewObjects[gcount].Rows[row].Cells[column].Value; } } } The code above throws an exception of method type signature is not interop compatible. I was debugging and checking MSDN classes on Workbook. When I debugged at adding cell values, i did catch the exception. The solution is simple. Just add ToString() after the value, since value is of type object. sheet.Cells[row + 2, column + 1] = dataGridViewObjects[gcount].Rows[row].Cells[column].Value.ToString();

MySQL Subquery Result As Aliased Table Name

Here's a query that has a subquery in which the result is aliased as inner table and then the outer query compares the result from the subquery against the field in the outer query. SELECT id,w_id, start , f_count, count_percent FROM tblLogs, ( select max (id) as max_id from tblLogs where w_id = 92 and categ = 'bike' and date( start ) = '2012-01-24' ) as inner_table WHERE DATE( start ) = '2012-01-24' AND w_id =92 AND categ = 'bike' and err = 'none' and remark = '' and inner_table.max_id = tblLogs.id;

Equi-Join In MySQL Example

Here's an example of equi join select distinct site_scripts._id, crw_site.site, crw_subcategory.subcategory from site_scripts, crw_site , crw_subcategory where site_scripts.subcategory_id = 8 and crw_site._id = site_scripts._id and crw_subcategory.subcategory_id = site_scripts.subcategory_id and crw_scripts.country_id = 1 and crw_site._active = 1 order by crw_site.site; Note: The concept can be used as an alternate to inner join...

Donate