Copy SQL to Excel Missing Rows

Issue:

When you try to copy rows from SQL server and paste into Excel but experience missing rows either by right clicking and coping with headers or saving as a CSV.

Solution:

The problem is double quotes "

Excel will skip all rows in between the start and end of a double quotes.

1) Either trim off the quotes in SQL

or

2) Right click and save as text, tab delimited, from SQL and then open in Excel using the default workflow selections during import.

Ajax Control Toolkit - Programmatically expand CollapsiblePanelExtender

Issue:
Expand a collapsible panel programmatically with use of a button or linkbutton other than the already assigned ExpandControlID control.



Solution: 

protected void expandCollapsiblePanelButton_Click(object sender, EventArgs e)

{

    // expand

    testCollapsiblePanelExtender.Collapsed = false;

    testCollapsiblePanelExtender.ClientState = "false";

}