Exporting GridView Data into Excel in Asp.Net

Add the Folllowing namespace:

using System.IO;

Write the following lines on the click of the Export button.
protected void btnExport_Click(object sender, EventArgs e)
{
Response.Clear();
Response.ContentType = "application/ms-excel";
Response.Charset = "";
Page.EnableViewState = false;
Response.AddHeader("Content-Disposition", "inline;filename=report.xls");
StringWriter tw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(tw);
//Here grid1 is the name of the GridView Control.
grid1.RenderControl(hw);
Response.Write(tw.ToString());
Response.End();
}

Enjoy Exporting data from GridView to Excel.

Calling Stored Procedure of Oracle in Asp.Net

Add Reference
System.Data.OracleClient;

After That Add the Following Code.

public void AddEmployee(int EmpId,string EmpName)
{
string strConn = "Data Source=Data Source;User ID=system;Password=pwd;";
OracleConnection con = new OracleConnection();
con.ConnectionString = strConn;
con.Open();
OracleCommand cmd = new OracleCommand();
//CommandText=Procedure Name.
cmd.CommandText = "InsertData";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = con;
//ID is the name of Parameter in SP.
cmd.Parameters.Add("ID", OracleType.Number).Value = EmpId;
//NAME is the name of parameter in SP
cmd.Parameters.Add("NAME", OracleType.VarChar).Value = EmpName;
try
{
cmd.ExecuteNonQuery();
}
catch(Exception ex)
{
throw ex;
}
}


Enjoy....

Using Oracle Connection To List data in Asp.Net

Add the Reference of System.Data.OracleClient.
and then ...
using System.Data.OracleClient;
using System.Data;

public void LoadData()
{
string strConn = "Data Source=Data Source Name;User ID=userId;Password=password;";
using (OracleConnection objConnection = new OracleConnection())
{
objConnection.ConnectionString = strConn;
try
{
objConnection.Open();
OracleCommand objCommand = new OracleCommand();
objCommand.Connection = objConnection;
objCommand.CommandText = "select ID,NAME from Employee";
objCommand.CommandType = System.Data.CommandType.Text;
OracleDataAdapter objAdapter = new OracleDataAdapter(objCommand);
DataTable objTable = new DataTable();
objAdapter.Fill(objTable);
grid1.DataSource = objTable;
grid1.DataBind();
objConnection.Close();
}
catch (Exception ex)
{
throw ex;
}
finally
{
objConnection.Close();
}
}
}

Enjoy....

Checking Whether you browser supports XMLHTTP or Not.

function GetXmlHttpObject() {
var xmlHttp = null;
try {
// Firefox, Opera 8.0+, Safari
xmlHttp = new XMLHttpRequest();
}
catch (e) {
// Internet Explorer
try {
xmlHttp = new ActiveXObject("Msxml2.XMLHTTP");
}
catch (e) {
xmlHttp = new ActiveXObject("Microsoft.XMLHTTP");
}
}
return xmlHttp;
}
function CheckBrowser() {
xmlHttp = GetXmlHttpObject();
if (xmlHttp == null) {
alert("Your browser does not support AJAX!");
return;
}
}

Validating Date Using JavaScript.

Date Should not be Character.
-------------------------------

function IsChar(sText) {
var ValidChars = "abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ. ";
var IsNumber = true;
var Char;


for (i = 0; i < sText.length && IsNumber == true; i++) { Char = sText.charAt(i); if (ValidChars.indexOf(Char) == -1) { IsNumber = false; } } return IsNumber; } Date Should Not Contains Special Characters. ---------------------------------------- function checkSpecialchar(objName) { var checkOK = "!@#$%^&*()_-+|\<>?.";
var checkStr = objName;

var allValid = true;
var allNum = "";
var ch;

for (i = 0; i < checkStr.length; i++) { ch = checkStr.charAt(i); for (j = 0; j < checkOK.length; j++) if (ch == checkOK.charAt(j)) break; if (j == checkOK.length) { allValid = false; break; } //if (ch != ",") //allNum += ch; } if (!allValid) { return (false); } else { return (true); } } Now we Start validating date. Here is the code for that. ------------------------------------------------ var startDate = document.forms[0].txtStartDate.value; var validDate = startDate.indexOf('/'); var fIndex = startDate.charAt(2); var lIndex = startDate.charAt(5); if (fIndex != '/') { alert("Please Use (Slash) /to Enter Date"); document.forms[0].txtStartDate.focus(); document.forms[0].txtStartDate.select(); return false; } if (lIndex != '/') { alert("Please Use (Slash) /to Enter Date"); document.forms[0].txtStartDate.focus(); document.forms[0].txtStartDate.select(); return false; } if (validDate == -1) { alert("Please Use (Slash) /to Enter Date"); document.forms[0].txtStartDate.focus(); document.forms[0].txtStartDate.select(); return false; } else if (CheckSpecialChar(startDate)) { alert("Special Characters are not allowed."); document.forms[0].txtStartDate.focus(); document.forms[0].txtStartDate.select(); return false; } else if (IsChar(startDate)) { alert("Date Should be Numeric."); document.forms[0].txtStartDate.focus(); document.forms[0].txtStartDate.select(); return false; } else { var txtDate = startDate.split('/'); var day = txtDate[0]; var month = txtDate[1]; var year = txtDate[2]; var dt = new Date(); var curYear = dt.getFullYear(); var curMonth = dt.getMonth() + 1; if (year < curYear) { alert("Year Should be Greater Than or Equal to Current Year."); document.forms[0].txtStartDate.focus(); document.forms[0].txtStartDate.select(); return false; } if (year == curYear) { if (month < curMonth) { alert("Month Should be greater than current month."); document.forms[0].txtStartDate.focus(); document.forms[0].txtStartDate.select(); return false; } } if (month > 12) {
alert("Please Enter date in DD/MM/YYYY Format.");
document.forms[0].txtStartDate.focus();
document.forms[0].txtStartDate.select();
return false;
}
if (month == 1 || month == 3 || month == 5 || month == 7 || month == 8 || month == 10 || month == 12) {
if (day > 31) {
alert("Day Should be less than or equal to 31 for the given month.");
document.forms[0].txtStartDate.focus();
document.forms[0].txtStartDate.select();
return false;
}
}
if (month == 2 && (year % 4 == 0 || year % 400 == 0)) {
if (day > 29) {
alert("Leap Year February day should be less than or equal to 29");
document.forms[0].txtStartDate.focus();
document.forms[0].txtStartDate.select();
return false;
}
}
if (month == 2 && (year % 4 != 0 || year % 400 != 0)) {
if (day > 28) {
alert("Not a Leap Year February day should be less than or equal to 28");
document.forms[0].txtStartDate.focus();
document.forms[0].txtStartDate.select();
return false;
}
}

=============================================================
Enjoy....

Validating Email Using JavaScript

=============================================
function isEmail(emailStr) {
var emailPat = /^(.+)@(.+)$/
var specialChars = "\\(\\)<>@,;:\\\\\\\"\\.\\[\\]"
var validChars = "\[^\\s" + specialChars + "\]"
var quotedUser = "(\"[^\"]*\")"
var ipDomainPat = /^\[(\d{1,3})\.(\d{1,3})\.(\d{1,3})\.(\d{1,3})\]$/
var atom = validChars + '+'
var word = "(" + atom + "|" + quotedUser + ")"
var userPat = new RegExp("^" + word + "(\\." + word + ")*$")
var domainPat = new RegExp("^" + atom + "(\\." + atom + ")*$")

var matchArray = emailStr.match(emailPat)

if (matchArray == null) {
return false
}

var user = matchArray[1]
var domain = matchArray[2]


if (user.match(userPat) == null) {
return false
}

var IPArray = domain.match(ipDomainPat)

if (IPArray != null) {
for (var i = 1; i <= 4; i++) { if (IPArray[i] > 255) {
return false
}
}
return true
}

var domainArray = domain.match(domainPat)

if (domainArray == null) {
return false
}

var atomPat = new RegExp(atom, "g")
var domArr = domain.match(atomPat)
var len = domArr.length

if (domArr[domArr.length - 1].length < 2 || domArr[domArr.length - 1].length > 3) {
return false
}

if (len < 2) {
var errStr = "Email ID is missing a Host Name!"
return false
}

return true;
}
=============================================

Setting Maxlength Of Textarea Using JavaScript

==================================

function SetMaxLength(Object, MaxLen) {
return (Object.value.length < MaxLen);
}
==================================
Here Object is the Id of Textarea and MaxLen is the maximum no of characters allowed.