Source Guru

What is an application object and where we use application object in asp.net | application object sample using asp.net

2011-10-29T07:42:00.000-07:00

What is an application object?

Application object is used to store the information and access variables from any page in application. Application object is same as session object only the difference is session object is used to maintain the session for particular user. If one user enters in to the application then session id will create for that particular user if he leaves from the application then the session id will deleted. they will get different session id but application object is same for all users once application object is created that application object is used throughout the application regardless of user. The information stored in application object accessed throughout all the pages in application (like database connection information) and we can change the application object in one place those changes automatically reflected in all the pages.

How to Make by pressing Enter Key ASP Button fires Click Event using JQUERY

2010-04-29T03:23:00.000-07:00

<div class="headerSearch formPanel" formButtonId="<%=SearchButton1.ClientID %>">

<label for="txtSearch">
Product Search:</label>
<input type="text" id="TextBox1" class="text" value="Enter Keyword" runat="server"
onfocus="clearText(this.id)" />
<div class="button buttonBlack">
<asp:LinkButton ID="SearchButton1" runat="server" OnClientClick="return ProductSearch();"
OnClick="SearchButton1_Click" Text="<span></span>Go" />
</div>
</div >

Include this JQUERY in your ASPX page

$(function(){
$("div.formPanel").each(function()
{
if($(this).attr("formButtonId"))
{
$(this).bind("keypress", function(e){
if (e.keyCode == 13)
{
e.returnValue = false;
e.cancel = true;
var button = $("#" + $(this).attr("formButtonId"));

var retValue = button.triggerHandler("click");
if(retValue == undefined || retValue == true)
eval(button.attr("href"));

return false;
}
});
}
});
});

Creating Log File

2010-03-02T03:39:00.000-08:00

actually keep this piece of code in a class called util. so I'm just going to paste the function and also the setting in the config file.

Setting in Config File

<add key="FilePath" value="D:\logFile.txt"/>

public static void function in util.cs

public static void writeToLogFile(string logMessage)
{
string strLogMessage = string.Empty;
string strLogFile = System.Configuration.ConfigurationManager.AppSettings["logFilePath"].ToString();
StreamWriter swLog;

strLogMessage = string.Format("{0}: {1}", DateTime.Now, logMessage);

if (!File.Exists(strLogFile))
{
swLog = new StreamWriter(strLogFile);
}
else
{
swLog = File.AppendText(strLogFile);
}

swLog.WriteLine(strLogMessage);
swLog.WriteLine();

swLog.Close();

}

2010-02-24T04:24:00.001-08:00

Introduction

OOPS or Object Oriented Programming Concepts but some of the concepts have been always used in one or the other programming languages. For example you must have used structs in C which is a good example of encapsulation. There are four major pillar of OOPS. Let’s try to understand each one of them by taking some examples also:-
1.) Encapsulation
2.) Abstraction
3.) Polymorphism
4.) Inheritance

Encapsulation:-

Interview Definition:- Binding data and member functions together inside a single unit.
How to Encapsulate:- By creating types e.g Classes and Struct
Bu using encapsulation we can create out own custom types by reusing the existing or primitive types.

Abstraction:-

Abstraction defines way to abstract or hide your data and members from outside world. Simply speaking Abstraction is hiding the complexities of your class or struct or in a generic term Type from outer world. This is achieved by means of access specifiers.
Interview Definition: - Hiding the complexities of your type from outside world.

How to Abstract: - By using Access Specifiers
.Net has five access specifiers:-
Public -- Accessible outside the class through object reference.
Private -- Accessible inside the class only through member functions.
Protected -- Just like private but Accessible in derived classes also through member functions.
Internal -- Visible inside the assembly. Accessible through objects.
Protected Internal -- Visible inside the assembly through objects and in derived classes outside the assembly through member functions.
Let’s try to understand by a practical example:-
Interview Tip:-
The default access specifier for a class in internal. Mind it I mean class not class’s data members.

public class Class1
{
int i; //No Access specifier means private
public int j; // Public
protected int k; //Protected data
internal int m; // Internal means visible inside assembly
protected internal int n; //inside assembly as well as to derived classes outside assembly
static int x; // This is also private
public static int y; //Static means shared across objects
[DllImport("MyDll.dll")]
public static extern int MyFoo(); //extern means declared in this assembly defined in some other assembly
public void myFoo2()
{
//Within a class if you create an object of same class then you can access all data members through object reference even private data too
Class1 obj = new Class1();
obj.i =10; //Error can’t access private data through object.But here it is accessible.:)
obj.j =10;
obj.k=10;
obj.m=10;
obj.n=10;
// obj.s =10; //Errror Static data can be accessed by class names only
Class1.x = 10;
// obj.y = 10; //Errror Static data can be accessed by class names only
Class1.y = 10;
}
}

//Now lets try to copy the same code inside Main method and try to compile
[STAThread]
static void Main()
{
//Access specifiers comes into picture only when you create object of class outside the class
Class1 obj = new Class1();
// obj.i =10; //Error can’t access private data through object.
obj.j =10;
// obj.k=10; //Error can’t access protected data through object.
obj.m=10;
obj.n=10;
// obj.s =10; //Errror Static data can be accessed by class names only
Class1.x = 10; //Error can’t access private data outside class
// obj.y = 10; //Errror Static data can be accessed by class names only
Class1.y = 10;
}
//What if Main is inside another assembly
[STAThread]
static void Main()
{
//Access specifiers comes into picture only when you create object of class outside the class
Class1 obj = new Class1();
// obj.i =10; //Error can’t access private data through object.
obj.j =10;
// obj.k=10; //Error can’t access protected data through object.
// obj.m=10; // Error can’t access internal data outside assembly
// obj.n=10; // Error can’t access internal data outside assembly

// obj.s =10; //Errror Static data can be accessed by class names only
Class1.x = 10; //Error can’t access private data outside class
// obj.y = 10; //Errror Static data can be accessed by class names only
Class1.y = 10;
}

Difference between postback and callback

2010-02-09T02:37:00.000-08:00

Postback

Call back

Page Refresh Problem

2010-02-04T20:42:00.000-08:00

A common problem that Web Application developers encounter is how to stop the user from refreshing the page. The problem arises, if the previous request to the server was a PostBack, which, for example, inserts the WebForm's data into a database. This will result in the addition of duplicate rows in the database. But we have a constraint that we can't stop the user by refreshing the page. So, what to do? Although we can't stop the user from refreshing the page, but we can determine if this event has already occurred and then take appropriate action.

My strategy will make use of the ViewState feature. As we are using ViewState, it would seem logical to perform the operation in the LoadViewState and SaveViewState methods. Using these two methods, instead of the OnLoad method, has more benefits in that it eliminates the potential problems of sub-classes implementing Page_Load. methods follows:

public class Refresh : System.Web.UI.Page

{
private bool _refreshState;
private bool _isRefresh;
public bool IsRefresh

{

get

{

return _isRefresh;

}

}

protected override void LoadViewState(object savedState)

{

object[] allStates = (object[])savedState;

base.LoadViewState(allStates[0]);

_refreshState = (bool)allStates[1];

_isRefresh = _refreshState == (bool)Session["__ISREFRESH"];

}

protected override object SaveViewState()

{

Session["__ISREFRESH"] = _refreshState;

object[] allStates = new object[2];

allStates[0] = base.SaveViewState();

allStates[1] = !_refreshState;

return allStates;

}

}

Reverse Data Table

2009-09-24T07:43:00.000-07:00

This Method is used the Reverse the given input DataTable

For Eample,

Input Data Table has the following Records,

NAME TITLE DEV_IN SCOST DCOST SOLD
-------- -------------------- -------- ---------- ---------- ----------
RAMESH HOTEL MANAGEMENT DBASE 12000 35000 4
RAMESH DEAD LEE PASCAL 99.95 4500 73

public static DataTable ReverseDataTable(DataTable dataTable)
{
DataTable table = new DataTable();
DataRow[] rowArray = dataTable.Select();
table = dataTable.Clone();
for (int i = rowArray.Length - 1; i >= 0; i--)
{
table.ImportRow(rowArray[i]);
}
return table;
}

OutPut

NAME TITLE DEV_IN SCOST DCOST SOLD
-------- -------------------- -------- ---------- ---------- ----------
RAMESH DEAD LEE PASCAL 99.95 4500 73
RAMESH HOTEL MANAGEMENT DBASE 12000 35000 4

Filter DataTable and Sort

2009-09-23T03:32:00.000-07:00

public static DataTable FilterDataTable(DataTable dataTable, string filterQuery, string sortQuery)
{
DataTable table = new DataTable();
try
{
DataRow[] rowArray = dataTable.Select(filterQuery, sortQuery);
table = dataTable.Clone();
foreach (DataRow row in rowArray)
{
table.ImportRow(row);
}
}
catch
{
table = dataTable.Clone();
}
return table;
}

Create Excel File

2009-09-23T03:13:00.000-07:00

public static bool CreateExcelFile(DataTable dataTable, string fileName)
{
try
{
string str = "";
string str2 = "

";
string str3 = "";
string str4 = string.Empty;
StringBuilder builder = new StringBuilder();
foreach (DataColumn column in dataTable.Columns)
{
str3 = str3 + "" + column.ColumnName + "";
}
str3 = str3 + "";
foreach (DataRow row in dataTable.Rows)
{
builder.Append("");
for (int i = 0; i < dataTable.Columns.Count; i++)
{
str4 = " ";
if (!string.IsNullOrEmpty(row[i].ToString()))
{
str4 = row[i].ToString();
}
builder.Append("" + str4 + "");
}
builder.Append("");
}
string s = str + str3 + builder.ToString() + str2;
HttpContext.Current.Response.Clear();
HttpContext.Current.Response.AddHeader("content-disposition", "attachment;filename=" + fileName);
HttpContext.Current.Response.Charset = "";
HttpContext.Current.Response.ContentType = "application/vnd.xls";
HttpContext.Current.Response.Write(s);
HttpContext.Current.Response.Flush();
return true;
}
catch
{
return false;
}
}

Build DataTable

2009-09-22T23:06:00.000-07:00

public static DataTable BuildDataTable(Dictionary columns)
{
DataTable table = new DataTable();
foreach (KeyValuePair pair in columns)
{
if (!table.Columns.Contains(pair.Key))
{
table.Columns.Add(pair.Key, pair.Value);
}
}
return table;
}

Add Row Number to DataTable

2009-09-22T23:05:00.001-07:00

public static DataTable AddRowNumber(DataTable dataTable)
{
dataTable.Columns.Add("RowNumber", typeof(int));
for (int i = 0; i < dataTable.Rows.Count; i++)
{
dataTable.Rows[i]["RowNumber"] = i;
}
dataTable.AcceptChanges();
return dataTable;
}

Set DropDownt Selected Values

2009-09-22T22:04:00.002-07:00

public static string SetSelectedValues(DropDownList ddlList, string selectedValues)
{
string selectedValue = string.Empty;

foreach (string selValue in selectedValues.Split(','))
{
ListItem listItem = ddlList.Items.FindByValue(selValue);
if (listItem != null)
{
listItem.Selected = true;
selectedValue += listItem.Value + ",";
}
}

return selectedValue.Trim(',');
}

Set CheckBox Selected Values

2009-09-22T22:04:00.001-07:00

public static string SetSelectedValues(CheckBoxList chkBoxList, string selectedValues)
{
string selectedValue = string.Empty;

foreach (string selValue in selectedValues.Split(','))
{
ListItem listItem = chkBoxList.Items.FindByValue(selValue);
if (listItem != null)
{
listItem.Selected = true;
selectedValue += listItem.Value + ",";
}
}

return selectedValue.Trim(',');
}

Get Check Box Selected Values

2009-09-22T22:03:00.000-07:00

public static string GetSelectedValues(CheckBoxList chkBoxList)
{
string selectedValue = string.Empty;

foreach (ListItem listItem in chkBoxList.Items)
{
if (listItem.Selected)
selectedValue += listItem.Value + ",";
}

return selectedValue.Trim(',');
}

Read CSV File and covert to DataTable

2009-09-22T21:46:00.000-07:00

public static DataTable ReadCSV(string filePath, DataTable csvTable)

{

//DataTable csvTable = new DataTable();

// open the file "data.csv" which is a CSV file with headers

using (CsvReader csv = new CsvReader(new StreamReader(filePath), true))

{

// missing fields will not throw an exception,

// but will instead be treated as if there was a null value

csv.MissingFieldAction = MissingFieldAction.ReplaceByNull;

// to replace by "" instead, then use the following action:

//csv.MissingFieldAction = MissingFieldAction.ReplaceByEmpty;

int fieldCount = csvTable.Columns.Count;

// this bit could be modified to fine-tune the columns

while (csv.ReadNextRecord())

{

DataRow newRow = csvTable.NewRow();

for (int i = 0; i < fieldCount; i++)

newRow[i] = csv[i] == null ? "MISSING" : csv[i];

csvTable.Rows.Add(newRow);

}

return csvTable;

}

Convert DataSet to Array List

2009-09-13T23:38:00.001-07:00

public static ArrayList DataSetToArrayList(string Columns, DataTable dataTable)

{

ArrayList output = new ArrayList();

string[] columnName = Columns.Split(',');

foreach (DataColumn row in dataTable.Columns)

{

foreach (string column in columnName)

{

if (column == row.ColumnName)

output.Add(column);

}

return output;

}

Join Two Data Tables

2009-09-13T23:34:00.001-07:00

public static DataTable JoinTable(DataTable firstTable, DataTable secondTable, string firstTableKey, string secondTableKey)

{

DataTable dtResults = secondTable.Clone();

foreach (DataColumn dataColumn in firstTable.Columns)

{

if (!dtResults.Columns.Contains(dataColumn.ColumnName))

dtResults.Columns.Add(dataColumn.ColumnName, typeof(string));

}

foreach (DataRow dataRow in firstTable.Rows)

{

DataRow dtRow = dtResults.NewRow();

foreach (DataColumn dataColumn in firstTable.Columns)

{

dtRow[dataColumn.ColumnName] = dataRow[dataColumn.ColumnName].ToString();

}

foreach (DataRow finalRow in secondTable.Select("[" + secondTableKey + "] = '" + dataRow[firstTableKey].ToString() + "'"))

{

foreach (DataColumn dataColumn in secondTable.Columns)

{

dtRow[dataColumn.ColumnName] = finalRow[dataColumn.ColumnName].ToString();

}

break;

}

dtResults.Rows.Add(dtRow);

}

return dtResults;

}

Checking/Validation the Proper Email

2009-09-09T01:54:00.001-07:00

private static bool isEmail(string inputEmail)

{

string strRegex = @"^([a-zA-Z0-9_\-\.]+)@((\[[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.)|(([a-zA-Z0-9\-]+\.)+))([a-zA-Z]{2,4}|[0-9]{1,3})(\]?)$";

Regex re = new Regex(strRegex);

if (re.IsMatch(inputEmail))

return (true);

else

return (false);

}

Sort the Data Table by Column

2009-09-09T01:53:00.003-07:00

public DataTable SortDataTableByColumn(DataTable dataTable, string sortColumnName, string sortOrder)

{

DataRow[] filteredRows;

if (!string.IsNullOrEmpty(sortColumnName))

{

if (string.IsNullOrEmpty(sortOrder))

sortOrder = "ASC";

filteredRows = dataTable.Select(string.Empty, sortColumnName + " " + sortOrder);

DataTable filteredDataTable = dataTable.Clone();

foreach (DataRow dataRow in filteredRows)

{

filteredDataTable.ImportRow(dataRow);

}

return filteredDataTable;

}

else

{

return dataTable;

}

Stripping the Text

2009-09-09T01:53:00.001-07:00

public static string StripText(object textObj, int maxLength)

{

string text = string.Empty;

if (textObj != null && !string.IsNullOrEmpty(textObj.ToString()))

{

text = textObj.ToString();

if (text.Length > maxLength)

{

text = text.Remove(maxLength);

}

return text;

}

Format Date

2009-09-09T01:52:00.002-07:00

public static string FormatDate(object date, string format)

{

string formattedDate = string.Empty;

if (date != null && Utility.IsDate(date.ToString()))

{

formattedDate = Convert.ToDateTime(date).ToString(format);

}

return formattedDate;

}

Trim Table

2009-09-09T01:52:00.000-07:00

public static DataTable TrimDataTable(DataTable dataTable, int noOfRows)

{

DataRow[] dataRows = dataTable.Select();

DataTable filteredDataTable = dataTable.Clone();

for (int i = 0; i < dataRows.Length; i++)

{

filteredDataTable.ImportRow(dataRows[i]);

if (i >= noOfRows - 1)

break;

}

return filteredDataTable;

}

Read Cookie using Java Script

2009-09-09T01:48:00.003-07:00

function ReadCookie(cookieName)

{

var theCookie = "" + document.cookie;

var ind = theCookie.indexOf(cookieName);

if (ind == -1 || cookieName == "")

return "";

var ind1 = theCookie.indexOf(';', ind);

if (ind1 == -1)

ind1 = theCookie.length;

var val = unescape(theCookie.substring(ind+cookieName.length+1,ind1));

val = ReplaceAll(val, cookieName + "=" , "");

val = ReplaceAll(val, ";" , "");

return val;

}

function ReplaceAll(str, pcFrom, pcTo)

{

var i = str.indexOf(pcFrom);

var c = str;

while (i > -1)

{

c = c.replace(pcFrom, pcTo);

i = c.indexOf(pcFrom);

}

return c;

}

Remove Duplicate Rows in Data Table

2009-09-09T01:48:00.001-07:00

public static DataTable RemoveDuplicateRows(DataTable dTable, string colName)

{

Hashtable hTable = new Hashtable();

ArrayList duplicateList = new ArrayList();

//Add list of all the unique item value to hashtable, which stores combination of key, value pair.

//And add duplicate item value in arraylist.

foreach (DataRow drow in dTable.Rows)

{

if (hTable.Contains(drow[colName]))

duplicateList.Add(drow);

else

hTable.Add(drow[colName], string.Empty);

}

//Removing a list of duplicate items from datatable.

foreach (DataRow dRow in duplicateList)

dTable.Rows.Remove(dRow);

//Datatable which contains unique records will be return as output.

return dTable;

}

How to Create Event Log Entry Using C#

2009-09-09T01:47:00.001-07:00

public static void CreateEventlogEntry(EventLogSource eventLogSource, string message)

{

EventLog eventLog = new EventLog();

try

{

string eventLogName = eventLogSource.ToString();

try

{

if (!EventLog.SourceExists(eventLogName))

{

EventLog.CreateEventSource(eventLogName, "Application");

}

catch { }

eventLog.Source = eventLogName;

eventLog.WriteEntry(message, EventLogEntryType.Error);

}

catch { }

}