My Tech Blog

Posts

Es werden Posts vom 2013 angezeigt.

searching a text in a Datatable

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

Select the rows depending upon the occurence

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

Binding Checked List Key, Value pairs !!!

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

MS Chart Control

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 :)

VBA- How to find the user rows & columns count

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

Floating Webbrowser control Images

foreach (HtmlElement im in webBrowser1.Document.Images) { im.Style="FLOAT:left;"; }

How to - Web browser Control

Creating a simple HTML Editor using Web brower control Create a basic Winform Appln. Drag a Webbrowser( end in the list ) from Toolbox. To create buttons drag a Toolstrip control (near webbrowser ctrl in the list 'Commoncontrols' ) from Toolbox. You can add buttons, text box, progressbar etc by clicking. c To make the Web browser control editable you have to write the following code while initializing. InitializeComponent(); webBrowser1.DocumentText = "<HTML><BODY contentEditable='true'></BODY></HTML>"; toolStripComboFontSize.SelectedIndex = 2; Double click on buttons to generate events. Variable possibilities are there . Some are given below, 1. Change text color if (colorDialog1.ShowDialog() == DialogResult.OK) ...

How to Install IIS in Windows Vista

Look into your C drive if you dont have a wwwroot there that means IIS is not installed in your computer. http://www.howtogeek.com/howto/windows-vista/how-to-install-iis-on-windows-vista/

Stored Procedure Returns GUID

This stored procedure returns GUID (GUIDColname) as output. Use databasename; Go CREATE PROCEDURE dbo.procname @Col1image, @Col2 varchar(50), @Col3varchar(5) AS INSERT INTO dbo.tblname (Col1, Col2, Col3) OUTPUT inserted.GUIDColname values (@Col1,@Col2,@Col3) GO & the query looks like INSERT INTO dbo.tblname (Col1, Col2, Col3) OUTPUT inserted.GUIDColname values (null,null,null)