Not sure of all the types of the fields but try this string query2 = "select sum(amount) AS Total from pur_inv_dtl where inv_id = '" + IdTxt.Text + "'";

System.Collections.Generic.HashSet

I did but still can't reproduce. Using Excel 2010.

Made some changes in the Button_Click event and could not reproduce the issue. //Range objRange = null; string cell1 = string.Empty, cell2 = string.Empty; string[] chars = { "A", "B", "C", "D", "E", "F", "G", "H", "I", "J", "K", "L", "M", "N", "O", "P", "Q", "R", "S", "T" }; for (int row = 1; row < 1000; row++) { for (int column = 0; column < 20; column++) { cell1 = chars[column] + row.ToString(); //objRange = _objWorkSheet.get_Range(cell1, cell1); _objWorkSheet.get_Range(cell1, cell1).Value2 = cell1; } } //System.Runtime.InteropServices.Marshal.ReleaseComObject(objRange); //objRange = null; SaveExcel();

Perhaps something like this: string inputText = "+{}^%"; // This is the search string Regex regex = new Regex("[\\%\\{\\}\\^\\+]",RegexOptions.Compiled); // This is the replacement string string regexReplace = "{$&}"; // Replace the matched text in the InputText using the replacement pattern string result = regex.Replace(inputText,regexReplace);

//Assuming you did not select the cell yourself rng2.get_characters(1,1).Font.Color = System.Drawing.ColorTranslator.ToOle(System.Drawing.Color.Red);

Not sure if this is what you mean but try this: string strLong = String.Format(CultureInfo.InvariantCulture, "{0:00000.0000}", Double.Parse("455.66", CultureInfo.InvariantCulture));

string initialText = "this_is_a test|XXmoretexthere";
string searchString = "|XX";
int lastIndexFound = initialText.LastIndexOf(searchString);
if (lastIndexFound > 0)
{
MessageBox.Show(initialText.Substring(lastIndexFound + searchString.Length));
}
else
{
MessageBox.Show("Patternt not found");
}

• Not sure if this is fast enough...
• Not sure if the search is case sensitive otherwise....

Why not using a ConvertEventHandler delegate ?

Something like this: this.listView1.Clear(); this.listView1.Items.Add("Item 2"); this.listView1.Items.Add("Item 1"); this.listView1.Sorting = SortOrder.Ascending; this.listView1.Sort(); this.listView1.Sorting = SortOrder.None; this.listView1.Items.Add("Temp1"); this.listView1.Items.Add("Temp2");

Why not use the Leave or Validated event for this ?