Get IT Done: How connection pooling can boost ADO.NET performance - TechRepublic: "Does the connection string match the desired connection string exactly?
Does the transaction context of the thread match the desired transaction context exactly?"

All The Contactz

Export to Excel

SQL Server information @ Narayana Vyas Kondreddi's website: A good resource for all your SQL Server needs!

Value formatting in DataGrid By Niladri


<%# DataBinder.Eval(Container.DataItem, "DateOfCreation","{0:d}")%>
<%# DataBinder.Eval(Container.DataItem, "number","{0:#,#####}")%>

Handle dynamic image loading errors

HTML Editor Code function doBold(item)
{
var obj = document.getElementById(item);
obj.focus();
document.execCommand('Bold', false, null);

}

function doItalic(item)
{
var obj = document.getElementById(item);
obj.focus();
document.execCommand('italic', false, null);
}

function doUnderline(item)
{
var obj = document.getElementById(item);
obj.focus();
document.execCommand('underline', false, null);
}

function doLeft(item)
{
var obj = document.getElementById(item);
obj.focus();
document.execCommand('justifyleft', false, null);
}

function doCenter(item)
{
var obj = document.getElementById(item);
obj.focus();
document.execCommand('justifycenter', false, null);
}

function doRight(item)
{
var obj = document.getElementById(item);
obj.focus();
document.execCommand('justifyright', false, null);
}

function doFont(item)
{
var fName = item.options[item.selectedIndex].value;
if(fName != '')
item.document.execCommand('FontName', false, fName);
}

function FormatTypeFace(item)
{
var obj = document.getElementById(item);
obj.focus();
var oSource = window.event.srcElement;
document.execCommand("FontName", false, oSource.options[oSource.selectedIndex].value);
}

function doSize(item1,item2)
{
var obj = document.getElementById(item2);
obj.focus();
var fSize = item1.options[item1.selectedIndex].value;
if( fSize != '' )
item.document.execCommand('FontSize', false, fSize);
}


//The HTML code to call
//Here in the Div by making it contentEditable= true u can make the div act like a TextBox

How to Perform SQL Server Row-by-Row Operations Without Cursors

ASP.Net samples, Asp.Net tutorials, download samples and examples

OLAP Definitions

Public Function ParseGeneral(ByVal strInput As String)
Dim mstrfilePath As String = Server.MapPath("../../GeneralNameList.xml")
Dim Ds As DataSet = GetDataset(mstrfilePath)
dtReplaceGeneralWordList = Ds.Tables(0)

'Dim str1 As String = "BellSouth Inc Ltd. "
'Dim str2 As String = "Bell South Inc Ltd. "
Dim arrInitial As New ArrayList()
Dim arr As New ArrayList()
'arrInitial.Add(str1)
'arrInitial.Add(str2)
arrInitial.Add(strInput)

Dim strSentence As String = ""
Dim i As Integer

Dim dr As DataRow

For i = 0 To arrInitial.Count - 1
strSentence = arrInitial(i).ToString()

For Each dr In dtReplaceGeneralWordList.Rows

If strSentence.IndexOf((" " + dr(1).ToString().ToUpper() + " ")) > -1 Then

Dim index As String = dr(0).ToString()

Dim dr1 As DataRow
For Each dr1 In dtReplaceGeneralWordList.Rows

If dr1(0).ToString() = index Then

Dim strTemp As String = strSentence.Replace(" " + dr(1).ToString().ToUpper() + " ", " " + dr1(1).ToString().ToUpper() + " ")

arr.Add(strTemp)
End If
Next dr1
End If
Next dr
Next i

For Each dr In dtReplaceGeneralWordList.Rows

For i = 0 To arr.Count - 1

Dim str As String = arr(i).ToString()
If str.IndexOf((" " + dr(1).ToString().ToUpper() + " ")) > -1 Then

Dim index As String = dr(0).ToString()

Dim dr1 As DataRow
For Each dr1 In dtReplaceGeneralWordList.Rows

If dr1(0).ToString() = index Then

Dim strTemp As String = str.Replace(" " + dr(1).ToString().ToUpper() + " ", " " + dr1(1).ToString().ToUpper() + " ")

If Not arrFinal.Contains(strTemp.Trim()) Then
arrFinal.Add(strTemp.Trim())
End If
End If
Next dr1
End If
Next i
Next dr

End Function

Public Function ParseGeneral(ByVal strInput As String)
Dim mstrfilePath As String = Server.MapPath("../../GeneralNameList.xml")
Dim Ds As DataSet = GetDataset(mstrfilePath)
dtReplaceGeneralWordList = Ds.Tables(0)

'Dim str1 As String = "BellSouth Inc Ltd. "
'Dim str2 As String = "Bell South Inc Ltd. "
Dim arrInitial As New ArrayList()
Dim arr As New ArrayList()
'arrInitial.Add(str1)
'arrInitial.Add(str2)
arrInitial.Add(strInput)

Dim strSentence As String = ""
Dim i As Integer

Dim dr As DataRow

For i = 0 To arrInitial.Count - 1
strSentence = arrInitial(i).ToString()

For Each dr In dtReplaceGeneralWordList.Rows

If strSentence.IndexOf((" " + dr(1).ToString().ToUpper() + " ")) > -1 Then

Dim index As String = dr(0).ToString()

Dim dr1 As DataRow
For Each dr1 In dtReplaceGeneralWordList.Rows

If dr1(0).ToString() = index Then

Dim strTemp As String = strSentence.Replace(" " + dr(1).ToString().ToUpper() + " ", " " + dr1(1).ToString().ToUpper() + " ")

arr.Add(strTemp)
End If
Next dr1
End If
Next dr
Next i

For Each dr In dtReplaceGeneralWordList.Rows

For i = 0 To arr.Count - 1

Dim str As String = arr(i).ToString()
If str.IndexOf((" " + dr(1).ToString().ToUpper() + " ")) > -1 Then

Dim index As String = dr(0).ToString()

Dim dr1 As DataRow
For Each dr1 In dtReplaceGeneralWordList.Rows

If dr1(0).ToString() = index Then

Dim strTemp As String = str.Replace(" " + dr(1).ToString().ToUpper() + " ", " " + dr1(1).ToString().ToUpper() + " ")

If Not arrFinal.Contains(strTemp.Trim()) Then
arrFinal.Add(strTemp.Trim())
End If
End If
Next dr1
End If
Next i
Next dr

End Function

Google Search: asp.net viewstate vs session

dBforums - How to check to see if #Temp table exists?

ASP.NET Web: The Official Microsoft ASP.NET Site : Home Page

ONDotnet.com: Programming ASP.NET: Custom and User Controls, Part 2 [Apr. 08, 2002]

Understanding Crystal Reports Viewer

String formatting in C#

316549 - HOW TO: Debug Stored Procedures in Visual Studio .NET

The Code Project - Crystal Reports PUSH method using ASP.NET - ASP.NET: "report viewer control "