RadMenu hide menu item from server side

RadMenu1.FindItemByText("RadMenuItem1").Visible = false;

determine whether radscheduler is in edit mode or insert mode

Edit Mode:
"if"(!RadScheduler1.StartEditingInAdvancedForm)

Insert Mode:
"if"(!RadScheduler1.StartInsertingInAdvancedForm)

asp.net export to txt file receive error in IE when hosted in IIS6

code:

"Response".Clear();
"Response".AddHeader("content-disposition", "attachment;filename=" + FileName + ".txt");
"Response".Charset = "";
Response.Cache.SetCacheability(HttpCacheability.NoCache);
"Response".ContentType = "application/vnd.text";
"StringWriter" stringWrite = new StringWriter();
"HtmlTextWriter" htmlWrite = new HtmlTextWriter(stringWrite);
"Response".Write(strTXTFileBuilder.ToString());
"Response".End();

Error:
Internet Explorer cannot download file from .
Internet Explorer was not able to open this Internet site. The requested site is either unavailable or cannot be found. Please try again later.

My Solution:
Take out the line ""Response".Cache.SetCacheability(HttpCacheability.NoCache);"

sql check existance before insert

'if' not 'exists' (select .... from .... where ....)
Begin
'Insert' Into ....... (..., ..., ...) values (..., ..., ...,)
END

rebind parent page control on radwindow close

in the Parent page add into the radwinow aspx code:

sas"<"telerik:radwindow id="rwpopup111" title="popup111" runat="server" behaviors="Close" onclientclose="OnClientClose" navigateurl="popup111.aspx">

also add javascript:

function OnClientClose(oWnd)
{
//place your code to execute, see below for my examples, in this example I rebind a grid:
var hf111 = document.getElementById("");


var masterTable1 = $find("").get_masterTableView();
masterTable1.rebind();

var masterTable = $find("").get_masterTableView();
masterTable.rebind();
//after radwindow close you may lose title of the parent page, if that is the case reset it here:
document.title="abc";

}

RadWindow set size and more behaviors from code behind

rw.Width = Unit.Pixel(800);
rw.Height = Unit.Pixel(600);
rw.Behaviors = WindowBehaviors.Move & WindowBehaviors.Maximize & WindowBehaviors.Close;

SQL Server Reporting Services » how to add brackets around a value

question:

1. add brackets around a value

2. display or hide a string depending on a value. e.g. show "IDExists" in a textbox if Fields!ID != null, otherwise hide it

solution:

1. ="MemberID: (" & Fields!ID.Value &")"

2. =IIF (IsNothing(Fields!Id.Value), "","IdExist")

radwindow close window from code behind

http://www.telerik.com/help/aspnet/window/postbackandcloseonreload.html

cater for sql apostrophe select condition in C#

Filter.Value = "LastName LIKE '" + tbLastNameFilter.Text.Trim().Replace("'", "''") + "%'";

How to remove duplicate rows from a table in SQL Server

http://support.microsoft.com/kb/139444

The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine

http://blog.crowe.co.nz/archive/2007/04/16/728.aspx

http://geekswithblogs.net/wpeck/archive/2009/04/30/quotthe-microsoft.jet.oledb.4.0-provider-is-not-registered-on-the-local-machine.quot.aspx


http://www.telerik.com/support/kb/aspnet-ajax/general/error-on-64-bit-windows-machines-the-microsoft-jet-oledb-4-0-provider-is-not-registered-on-the-local-machine.aspx

Turn Off “Saving Auto Recovery information” in Microsoft SQL Server Management Studio 2008

http://blog-mstechnology.blogspot.com/2009/06/turn-off-saving-auto-recovery.html

All Sample Connection String for All database using C#.Net and VB.Net

found this one useful

http://www.dotnetspider.com/resources/28823-All-Sample-Connection-String-for-All-database.aspx

Visual Studio 2008 windows form making datagridview resizable runtime within a form

set the Anchor to (Top, Bottom)

datagridview checkbox column unable to fetch current row check status

need to use "datagridview1.EndEdit()" in "datagridview1_CellContentClick" event to finalize the editing of current row so that the changes made to the current row (in this case the change of check status) is submitted

oledbconnection problem "Unrecognized escape sequence....."

cn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\ temp\\abc.mdb;User Id=admin;Password=;");
or
cn = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\temp\ abc.mdb;User Id=admin;Password=;");

Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine --------- dev error on vista x64 machine

this is because the driver is not x64. Solution: in project properties --> Build, select x86 in Platform Target

what's the status of a form after form1.show() and form1.hide() - Visual Studio 2008 Windows Form Application

in windows form application you can use Application.OpenForms collection to find the forms opened

TSQL check if a view exists before create it

IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = 'vw_abc')
DROP VIEW [dbo].[vw_abc]

Make a great PowerPoint presentation