file and configSource attribute in web.config

1. file attribute will take both inline keys of web.config + keys of external file
2. configSource attribute - we have to move entire section to external file

javascript alert from UpdatePanel

ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "clientScript", "alert('Record Successfully Saved')", true);

The last true is to add javascript tags

javascript alert from ASP.NET codebehind

string scriptString = "LT..script language="JavaScript"..GT javascript:alert('Record Saved');window.opener.location.reload();window.close();";
scriptString += "LT";
scriptString += "/";
scriptString += "script..GT";
if (!ClientScript.IsClientScriptBlockRegistered("clientScript"))
ClientScript.RegisterClientScriptBlock(this.GetType(), "clientScript", scriptString);

UpdateProgress Panel is always in new line

UpdateProgress Panel is always placed in a new line. To avoid the page flips when updateprogress is called -- use it in a new td tag inside table html

Website FileManager

http://www.binaryintellect.net/products/displayproductdetails.aspx?productid=8

DataSet.Merge or DataSet.Relations

1. For rows - columns merge - use DataSet.Merge
2. For Master-Detail (Primary key - foreign key) table relations - use DataSet.Relations
3. If you want to join two datatables based on some condition and display columns from both the tables, you have to manually find the key value by "for" loop and then create a new dataset..

For example if you take employee table from sql database and department from oracle database and you want to display empno, empname, deptid, deptname in one single table...manual binding is easier way.

SoapException for Webservices

public class Common
{
public enum FaultCode
{
Client=0, Server=1
}
#region Soap Exception
///

/// To raise Soap Exception
public static SoapException RaiseException(string uri, string webServiceNamespace, string errorMessage, string errorNumber, string errorSource, FaultCode code)
{
XmlQualifiedName faultCodeLocation = null;
//Identify the location of the FaultCode
switch (code)
{
case FaultCode.Client:
faultCodeLocation = SoapException.ClientFaultCode;
break;
case FaultCode.Server:
faultCodeLocation = SoapException.ServerFaultCode;
break;
}
XmlDocument xmlDoc = new XmlDocument();
//Create the Detail node
XmlNode rootNode = xmlDoc.CreateNode(XmlNodeType.Element,
SoapException.DetailElementName.Name,
SoapException.DetailElementName.Namespace);
//Build specific details for the SoapException
//Add first child of detail XML element.
XmlNode errorNode = xmlDoc.CreateNode(XmlNodeType.Element, "Error",
webServiceNamespace);
//Create and set the value for the ErrorNumber node
XmlNode errorNumberNode =
xmlDoc.CreateNode(XmlNodeType.Element, "ErrorNumber",
webServiceNamespace);
errorNumberNode.InnerText = errorNumber;
//Create and set the value for the ErrorMessage node
XmlNode errorMessageNode = xmlDoc.CreateNode(XmlNodeType.Element,
"ErrorMessage",
webServiceNamespace);
errorMessageNode.InnerText = errorMessage;
//Create and set the value for the ErrorSource node
XmlNode errorSourceNode =
xmlDoc.CreateNode(XmlNodeType.Element, "ErrorSource",
webServiceNamespace);
errorSourceNode.InnerText = errorSource;
//Append the Error child element nodes to the root detail node.
errorNode.AppendChild(errorNumberNode);
errorNode.AppendChild(errorMessageNode);
errorNode.AppendChild(errorSourceNode);
//Append the Detail node to the root node
rootNode.AppendChild(errorNode);
//Construct the exception
SoapException soapEx = new SoapException(errorMessage,
faultCodeLocation, uri,
rootNode);
//Raise the exception back to the caller
return soapEx;
}
#endregion
}

Crystal Report & Crystal Enterprise

Crystal Report
---------------
private void BindReport()
{
this.crReportDocument = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
crReportDocument.Load(Server.MapPath("users.rpt"));
DataSet ds = new DataSet();
ds = ListUsers(0, 0);
crReportDocument.SetDataSource(ds.Tables[0]);
CrystalReportViewer1.ReportSource = crReportDocument;
CrystalReportViewer1.DataBind();
}
------------------------------------------------------------------------------------------------
Crystal Enterprise

private void BindReport()
{
crReportDocument.EnterpriseLogonInfo.CmsServer = "..";
crReportDocument.EnterpriseLogonInfo.Password = "..";
crReportDocument.EnterpriseLogonInfo.Username = "..";
crReportDocument.FileName = "..";
crReportDocument.UriIsUserEditable = false;
CrystalReportViewer1.ReportSource = crReportDocument;
CrystalReportViewer1.DataBind();
}

Separate config file reference in web.config

WSDL.exe

wsdl.exe /out:myref.cs http://localhost/WebSvc/WebPage.asmx will create proxy class

to_date in Oracle

select * from TableName where startDt>=to_date('1/1/1900', 'mm/dd/yyyy')

to_char in Oracle

select to_char(Start_Date,'Mon dd, yyyy') as StartDt from table

DataView.Find

DataView dv=new DataView();

dv=ds.Tables[0].DefaultView;
dv.Sort=ID or Value;
string result=dv[dv.Find(ID or Value)]["ColumnName"].ToString()

SubString in SQL Server for comma separated

CREATE PROCEDURE dbo.usp_UpdateCountryUser
(@UserID int , @CountryIds varchar(1000))
AS

BEGIN

DECLARE @intPos INT, @SubStr varchar(1000)

SET @CountryIDs=REPLACE(@CountryIDs,' ','')
SET @intPos=CHARINDEX(',',@CountryIDs)

WHILE @intPos >0
BEGIN

SET @SubStr=SubString(@CountryIDs,0,@intPos)

--delete, insert, update sql statement here

SET @CountryIDs=SUBSTRING(@CountryIDs, LEN(@SubStr) + 2, LEN(@CountryIDs) - LEN(@SubStr) + 1)

SET @IntPos = CHARINDEX(',', @CountryIDs)

END

END

Response Time of Major Shopping sites

http://www.optimizationweek.com/reviews/shopping/

I was searching to find out industrial standard response time of a web application and finally landed up to this. More than 20 secs, optimize the page

Crystal Report - Cleaning the Temp Files

CrystalImageCleaner.Start() and Stop() methods.

Crystal Report - Redirecting the temp file location

http://forums.asp.net/p/1087989/1623975.aspx

http://anewdevelopment.blogspot.com/2006/11/crystal-reports-access-is-denied.html

Creating Custom Configuration Sections in web.config

1. http://aspnet.4guysfromrolla.com/articles/032807-1.aspx

ASP.NET 2.0 Treeview Checkboxes - Check All

1. http://geekswithblogs.net/ranganh/archive/2006/03/25/73300.aspx

2. http://forums.asp.net/t/976122.aspx?PageIndex=1

Good stuff

Direct tnsNames.ora style ConnectionString for Oracle from .NET

1. tnsping (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=)(PORT=))(CONNECT_DATA=(SERVICE_NAME=)))

2. if step 1 is successful, then
ConnectionString="Server=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=)(PORT=))(CONNECT_DATA=(SERVICE_NAME=)));uid=;pwd=;"

3. Location for tnsNames.ora file C:\oracle\ora817\network\ADMIN

Export to Excel from GridView

http://gridviewguy.com/ArticleDetails.aspx?articleID=197

Sys.WebForms.PageRequestManagerParserErrorException

http://weblogs.asp.net/leftslipper/archive/2007/02/26/sys-webforms-pagerequestmanagerparsererrorexception-what-it-is-and-how-to-avoid-it.aspx

Scheduling of DTS in SQL Server

You can use windows scheduler, or you can use dtsrunui.exe. SQL Server Agent has to run for running the job in SQL Server

Build Google IG like Ajax Start Page in 7 days using ASP.NET Ajax and .NET 3.0

http://www.codeproject.com/Ajax/MakingGoogleIG.asp

very good stuff here

Context Menus in ASP.AJAX.NET

There is a sample using AJAX.ASP.NET

http://www.binaryintellect.net/products/displayproductdetails.aspx?productid=8

returning output parameter values of Stored Procedure from DAAB of Ent. Library

Database db = GetDbConnection(0);
DbCommand dbCmd = db.GetStoredProcCommand("spName");
db.AddInParameter(dbCmd, "@ProductID", DbType.Int32, 1);
db.AddOutParameter(dbCmd, "@SubmID", DbType.Int32, 0);
queryOut = db.ExecuteNonQuery(dbCmd);
return Convert.ToInt32(db.GetParameterValue(dbCmd, "@SubmID"));

DataSet.Merge will merge rows or columns?

Yes. it will merge rows and columns of two datasets. For rows merge, Table Name and Column Names in both datasets should be the same. For columns merge, Column Names should be different, then new column will be added to the merged dataset.

http://forums.asp.net/thread/1693004.aspx

accessing different SQL Server in stored procedures

Issue: If you have another database in the same server, you can write "select * from secondDB.dbo.TableName". But if you want to access another database which is in separate server, then what should we do?

Resolution: I have used "EXEC sp_addlinkedserver with OpenQuery" of SQL Server 2000. I don't know any other better method.

Intellisense in web.config is not working

remove this from configuration tag.

xmlns=http://schemas.microsoft.com/.NetConfiguration/v2.0

http://weblogs.asp.net/scottgu/archive/2005/12/02/432077.aspx

Element 'UpdatePanel' is not a known element. This can occur if there is a compilation error in the Web site

This is the issue with Visual Studio 2005. Install SP1. Else do this as per this link.
http://weblogs.asp.net/scottgu/archive/2006/11/16/gotcha-lost-html-intellisense-within-asp-net-ajax-controls.aspx

I use the first method. Sometimes I have to open Master file, sometimes I have to close the master file from VS.NET, then only all the intellisenses are working.

Changing web.config to ajax tag, required me to change in every place, so I dont prefer this web.config solution.

Server Events for the controls inside Modal Popup Panel

If you have Ok button inside Modal Pop up Panel, How to post back to the server on OK_Click? By default popup does not post back. You have to use UseSubmitBehaviour=false in Ok Button