Call JavaScript function Server Side button_onclick

You can easily call any javascript anywhere on page by this code simply....

ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Key", "script language='javascript'>alert("msg");script", false);

Sending sms from Asp.Net

I use the following two functions in my application to send sms from my asp.net application.
I use c# as programming language.
I provide some credential which I got from the sms API provider. we use www.smscountry.com API in application.
I call the setupSMS function to send sms from my application which requires mobileNumber and message as input parameter and returns the response of the message sent.


private string setupSMS(string mobileNumber, string message)
{
string strPostBody;
String strPostResponse;


//'Give The Respective Variable Values
string userName = "UserId"; //'Enter Your User Name provided by API Provider
string password = "Password";//'Enter Your Password provided by API Provider
string senderid = "senderId";//' Enter Your Senderid provided by API Provider


string messageType = "N";//' Enter Your Message Type As N for Normal Message, O for Other Laungauge Sms
Char deliveryReports = 'Y';//' if U want To Know Delivery Reports Enter Y it Gives JOBID Otherwise N


//'****If U R Behind The Proxy Server Uncomment And Give Below Details *****
//'objProxy = New WebProxy("Proxy Ip Adress", PortNumber)


//'Call sendSMS Method For Sending The Sms's

message = Server.UrlEncode(message);
strPostBody = "User=" + userName + "&passwd=" + password + "&mobilenumber=" + mobileNumber + "&message=" + message + "&sid=" + senderid + "&mtype=" + messageType + "&DR=" + deliveryReports;
strPostResponse = sendSMS(strPostBody);
return strPostResponse;
}


private string sendSMS(string stringPost)
{

HttpWebRequest objWebRequest = null;
HttpWebResponse objWebResponse;
StreamWriter objStreamWriter = null;
StreamReader objStreamReader = null;
try
{

string stringResult;

objWebRequest = (HttpWebRequest)(WebRequest.Create("http://www.smscountry.com/smscwebservice.asp"));

objWebRequest.Method = "POST";

if (objProxy != null)
{
objWebRequest.Proxy = objProxy;
}
objWebRequest.ContentLength = stringPost.Length;
objWebRequest.ContentType = "application/x-www-form-urlencoded";
objStreamWriter = new StreamWriter(objWebRequest.GetRequestStream());
objStreamWriter.Write(stringPost);
objStreamWriter.Flush();
objStreamWriter.Close();

objWebResponse = (HttpWebResponse)(objWebRequest.GetResponse());
objStreamReader = new StreamReader(objWebResponse.GetResponseStream());
stringResult = objStreamReader.ReadToEnd();
objStreamReader.Close();
return stringResult; //'jobid

}
catch (Exception ex)
{
return ex.ToString();
}
finally
{
if (objStreamWriter != null)
{
objStreamWriter.Close();
}
if (objStreamReader != null)
{
objStreamReader.Close();
}
objWebRequest = null;
objWebResponse = null;
objProxy = null;
}
}

Export datagrid to Excel in asp.net (Revised)

How to export datagrid data into excel
Utility Code: It is self explanatory

protected void btnExportToExcel_Click(object sender, EventArgs e)
{
DataTable dtOriginal = new DataTable();
dtOriginal = ReturnTable(); //Return Table consisting data

//Create Tempory Table
DataTable dtTemp = new DataTable();

//Creating Header Row
dtTemp.Columns.Add("Employee Name");
dtTemp.Columns.Add("Email");
dtTemp.Columns.Add("Join Date");
dtTemp.Columns.Add("Salary");
double dSalary;
DateTime dtDate;
DataRow drAddItem;
for (int i = 0; i < dtOriginal.Rows.Count; i++)
{
drAddItem = dtTemp.NewRow();
drAddItem[0] = dtOriginal.Rows[i][0].ToString();//Name
drAddItem[1] = dtOriginal.Rows[i][1].ToString();//Email

//Join Date
dtDate = Convert.ToDateTime(dtOriginal.Rows[i][2].ToString());
drAddItem[2] = dtDate.ToShortDateString();

//Salary
dSalary = Convert.ToDouble(dtOriginal.Rows[i][3].ToString());
drAddItem[3] = dSalary.ToString("C");

dtTemp.Rows.Add(drAddItem);
}

//Temp Grid
DataGrid dg = new DataGrid();
dg.DataSource = dtTemp;
dg.DataBind();
ExportToExcel("BudgeReport.xls", dg);
dg = null;
dg.Dispose();
}

private void ExportToExcel(string strFileName, DataGrid dg)
{
Response.ClearContent();
Response.AddHeader("content-disposition", "attachment; filename=" + strFileName);
Response.ContentType = "application/excel";
System.IO.StringWriter sw = new System.IO.StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
dg.RenderControl(htw);
Response.Write(sw.ToString());
Response.End();
}

Find All trigger Information in our Database In Sql

This is the Query by which one u can get the whole information about the trigger which are in our database or particular database.

SELECT Tables.Name TableName,
Triggers.name TriggerName,
Triggers.crdate TriggerCreatedDate,
Comments.Text TriggerText
FROM sysobjects Triggers
Inner Join sysobjects Tables On Triggers.parent_obj = Tables.id
Inner Join syscomments Comments On Triggers.id = Comments.id
WHERE Triggers.xtype = 'TR'
And Tables.xtype = 'U'
ORDER BY Tables.Name, Triggers.name

Rupee foridian font Applied on Repeater control

This is a new font of Indian rupees I found and Apply it on the Repeater control as like this.

asp:Label ID="lblFees" runat="server" Text='<%#Eval("SemFees","`{0}") %>' Font-Names="Rupee Foradian" asp:Label

Also check the link for how to apply and download rupee foridian font.
http://www.indianweb2.com/2010/07/how-to-type-indian-rupee-symbol-download-indian-rupee-font/

http://www.codeproject.com/KB/silverlight/NewIndianRupeeSymbolDemo.aspx

Validate Number by Javascript function

by this function simply call this function on onkeypress event and get mast functionality.
function isNumberKey(e) {
var charCode = (e.which) ? e.which : event.keyCode
if ((charCode > 31) && (charCode < 48 || charCode > 57)) {
return false;
}
}

//call on onkeypress event in textbox

asp:TextBox ID="txtbox1" runat="server" CssClass="input_big" MaxLength="15"
onkeypress="return isNumberKey(event)"/asp:TextBox

Find any Control in Repeater using Javascript

I used Javascript function to check count of checkboxes into repeater which are checked.And on that count I performed some action on it on my client side perfomance.
function checkAll(cb)
{
var ctrls = document.getElementsByTagName('input');
var count=0;
for (var i = 0; i < ctrls.length; i++)
{
var cbox = ctrls[i];
if (cbox.type == "checkbox")
{

if(cbox.checked)
{
count++;

}
//cbox.checked = cb.checked;
}
}
}

Call this function on aspx contol

asp:CheckBox ID="chkPaper" runat="server" onclick="return checkAll(this)"
enjoy coding...