Code Less Sleep More With ASP.Net, SQL Server & Javascript

How To Get Query-String Values From Javascript ?

2008-10-24T14:40:00.004+05:30

script type="text/javascript">
function GetQueryStringValueFor(key)
{
var valueToReturn="";
var query = window.location.search.substring(1);
var parms = query.split('&');
for(var i=0 to parms.length)

{ var pos = parms[i].indexOf('=');
if (pos > 0)
{
if(key==parms[i].substring(0,pos))
{
valueToReturn = parms[i].substring(pos+1);
}
}
}
return valueToReturn;
}

script>

-
ShriKrishna Bhardwaj , With ASP.Net, SQL Server, Javascript

How to get last day of the last month with asp.net

2008-10-13T15:23:00.008+05:30

///

/// Returns the last date of the previous month in yyyy-MMM-dd format...
///
/// Date to get the last date of its previous month

///

public string GetLastDate(DateTime dt_now)
{
string str_Last = "";
DateTime dt_Last = new DateTime();
int _Day = 0;
_Day = dt_now.Day;
TimeSpan ts = new TimeSpan(_Day, 0, 0, 0, 0);
dt_Last = dt_now.Subtract(ts);
str_Last = dt_Last.ToString("yyyy-MMM-dd");
return str_Last;
}

-
ShriKrishna Bhardwaj , With ASP.Net, SQL Server, Javascript

How to download PDF on Button click using asp.net

2008-10-08T16:23:00.005+05:30

// html part ...

DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<title>Download Filestitle>

head>

<body>

<div>

<asp:Button ID="Button_Download" runat="server" Text="Download" OnClick="Button_Download_Click" />

div>

form>

body>

html>

// code part ...

protected void Button_Download_Click(object sender, EventArgs e)

{

string str_FilePath = Server.MapPath(".") + @"\UploadedItems\Docs\CV.pdf";

System.IO.StreamReader sr = new System.IO.StreamReader(str_FilePath);

Response.BufferOutput = true;

Response.AppendHeader("content-disposition", "attachment; filename=v.pdf");

Response.ContentType = "application/pdf";

Response.TransmitFile(str_FilePath);

}

-
ShriKrishna Bhardwaj , With ASP.Net, SQL Server, Javascript

Post your ideas in the blog, when they are fresh and alive

2008-10-06T10:50:00.006+05:30

Earlier in the last article, we have discussed a few topics about writing a good blog. So now we'll be discussing about those points being told in that article.
Its quiet important to note that we should write the ideas when they are fresh, that is, they just came to your mind.
Because as you open your mind you feel like as if you are in heaven, and then great ideas will definitely come to your mind. It doesn't matter whether you need to medicate yourself to open your mind. It can be done while meeting someone, or may be when you are dining in a restaurant, or may be when you are traveling around.
So always try to put your maximum effort to visualize more and write accordingly.

-
ShriKrishna Bhardwaj , With ASP.Net, SQL Server, Javascript

All about a good blog writing, to come up in search engines

2008-10-04T17:58:00.009+05:30

For writing a good blog, we should note a few points ...

Post your ideas in the blog, when they are fresh and alive
Write with passion, as if you are in the blog
Stay on the same topic on which you are blogging
Be informative and descriptive in your blog
Be clear, simple and user-friendly while blogging
Stick to a schedule
Don't use old news in the blog
Make world know your opinion
Don't try to show perfectionism in the topic, stay grounded
Mantain your flow of writing in the blog
Write the blog in points
Be consistent in your blogging style
Post with specific keywords in the blog
Do make use of the sub-headings in the blog
Show genuine interest of the topic in your blog
Post the blog with specific keywords
Try to use the simplest structure possible for your blog
Your frequency of blogging
Wite the blog with a feel-good factor
The blog content should be syntactically correct, i.e check the spellings
Make the blog popular among your circle, i.e advertise your blog
Provide RSS and XML feeds of your blog
Most importantly, link your blog like crazy

This is just a list of Do's & Don'ts which I've gone through, and you will see your blog getting higher positions in the search engine's result.

All these points I'll be discussing in the coming days, so as to provide a good knowledge of blogging to the youngsters ...

-
ShriKrishna Bhardwaj , Code Less With ASP.Net, SQL Server, Javascript

Upcoming Microsoft Visual Studio 2010, Rosario

2008-09-30T17:42:00.009+05:30

While reading to some article yesterday ...
I came across the new version of the Visual Studio of Microsoft, the Visual Studio Team System (VSTS) 2010, code-named Rosario.

The VSTS 2010 is expected to be equipped with .Net framework 4.0, and jQuery.

Microsoft plans to focus on five areas: riding the next-generation platform wave, inspiring developer delight, powering breakthrough departmental applications, enabling emerging trends such as cloud computing, and the Application Lifecycle Management (ALM).

Additionally, Microsoft also announced that VSTS 2010 will provide a unified VSTS Development and Database product. Any customer with Visual Studio Team System 2008 Development Edition or Visual Studio Team System 2008 Database Edition and a service contract will be able to get a free upgrade to Visual Studio Team System 2008 Development Edition or Database Edition.

You can find more on : http://msdn.microsoft.com/en-us/vstudio/bb725993.aspx

-
ShriKrishna Bhardwaj , With ASP.Net, SQL Server, Javascript

Calling Server-Side(ASP.Net) Method from Client-Side(Javascript)

2008-09-25T18:19:00.005+05:30

.ASPX Code ...

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="test_ClientToServerPostback.aspx.cs"

Inherits="test_ClientToServerPostback" %>

DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>Calling Server-Side Method from Client-Side Javascript.title>
<script type="text/javascript">
function LookUp()
{
var lbl = document.getElementById("TextBox1");
CallServerMethod(lbl.value, "");
}

function ReturnedServerData(retValue)
{
document.getElementById("Label1").innerHTML = retValue;
}
script>
head>
<body>
<form id="form1" runat="server">
<div>
Try Writing : accept/reject <br/> and see the result.<br />
<asp:TextBox ID="TextBox1" runat="server">asp:TextBox><br />
<a href="#" onclick="LookUp();">ClickMea><br />
<br />
<asp:Label ID="Label1" runat="server">asp:Label>
div>
form>
body>
html>

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

.CS Code ...

using System;
using System.Web.UI;

public partial class test_ClientToServerPostback : System.Web.UI.Page, ICallbackEventHandler
{
protected String returnValue;
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
String cbReference = Page.ClientScript.GetCallbackEventReference(this, "arg", "ReturnedServerData", "context");
String callbackScript = "function CallServerMethod(arg, context)" + "{ " + cbReference + ";}";
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "CallServerMethod", callbackScript, true);
}
}

public void RaiseCallbackEvent(String eventArgument)
{
if (eventArgument.Trim() == String.Empty)
{
returnValue = "Sorry, please write somthing in textbox.";
}
else
{
if (eventArgument == "accept")
{
returnValue = "Congrats, for accepting!";
}
else if (eventArgument == "reject")
{
returnValue = "You have succesfully rejected !";
}
else
{
returnValue = "You have entered : " + eventArgument + ".";
}
}
}

public String GetCallbackResult()
{
return returnValue;
}
}

-
ShriKrishna Bhardwaj , With ASP.Net, SQL Server, Javascript

Populating Second DropDownList With Another DropDownList !

2008-09-16T18:39:00.003+05:30

DropDownList2.DataSource = dt;
DropDownList2.DataValueField = dt.Columns["property_type"].ToString();
DropDownList2.DataTextField = dt.Columns["property_type"].ToString();
DropDownList2.DataBind();

-
ShriKrishna Bhardwaj , With ASP.Net, SQL Server, Javascript

Textbox Keyboard Enter Press Execution in ASP.Net

2008-08-19T15:13:00.006+05:30

// Client Function Execution By Hitting Enter-Key of Keyboard ...

TextBox_Search.Attributes.Add("onkeydown", "if(event.which || event.keyCode){if ((event.which == 13) || (event.keyCode == 13)) {document.getElementById('" + Button_Search.ClientId + "').click();return false;}} else {return true}; ");

-
ShriKrishna Bhardwaj , With ASP.Net, SQL Server, Javascript

Loading Gmap from serverside

2008-08-07T16:28:00.004+05:30

string lat = "",lat = "";

private void loadmap()
{

HtmlGenericControl Body = this.Master.FindControl("myBody") as HtmlGenericControl;
try
{
if (Body != null)
{
string loadString = "mapload('" + lat + "','" + lng + "','NameOfLocation','./Image/Image.jpg')";
Body.Attributes.Add("onLoad", loadString);
Body.Attributes.Add("onunload", "GUnload()");
}
}
catch (Exception ex)
{
Response.Write("Error:" + ex.ToString());
}
}

-
ShriKrishna Bhardwaj , With ASP.Net, SQL Server, Javascript

Setting Homepage Using JavaScript

2008-05-19T10:52:00.005+05:30

function setasHome()
{
document.body.style.behavior='url(#default#homepage)';
document.body.setHomePage('www.url.com');
}

-
ShriKrishna Bhardwaj , With ASP.Net, SQL Server, Javascript

Adding a bookmark in browser using JavaScript

2008-05-19T10:46:00.006+05:30

function CreateBookmarkLink() {
title = "TitleForBookmark";
url = "www.url.com'';
if (window.sidebar) {
// Mozilla Firefox Bookmark
window.sidebar.addPanel(title, url,"");
} else if( window.external ) {
// IE Favorite
window.external.AddFavorite( url, title);
}
else if(window.opera && window.print) {
// Opera Hotlist
return true; }
}

-
ShriKrishna Bhardwaj , With ASP.Net, SQL Server, Javascript

JavaScript Object Notation

2008-03-12T15:28:00.007+05:30

JSON (JavaScript Object Notation)

Reference: http://www.json.org/

JSON is a lightweight data-interchange format. It is easy for humans to read and write. It is easy for machines to parse and generate. It is based on a subset of the JavaScript Programming Language, Standard ECMA-262 3rd Edition - December 1999. JSON is a text format that is completely language independent but uses conventions that are familiar to programmers of the C-family of languages, including C, C++, C#, Java, JavaScript, Perl, Python, and many others. These properties make JSON an ideal data-interchange language.

JSON is built on two structures:

A collection of name/value pairs. In various languages, this is realized as an object, record, struct, dictionary, hash table, keyed list, or associative array.
An ordered list of values. In most languages, this is realized as an array, vector, list, or sequence.

These are universal data structures. Virtually all modern programming languages support them in one form or another. It makes sense that a data format that is interchangeable with programming languages also be based on these structures.

In JSON, they take on these forms:

An object is an unordered set of name/value pairs. An object begins with {(left brace) and ends with} (right brace). Each name is followed by: (colon) and the name/value pairs are separated by, (comma).

An array is an ordered collection of values. An array begins with [(left bracket) and ends with] (right bracket). Values are separated by, (comma).

A value can be a string in double quotes, or a number, or true or false or null, or an object or an array. These structures can be nested.

A string is a collection of zero or more Unicode characters, wrapped in double quotes, using backslash escapes. A character is represented as a single character string. A string is very much like a C or Java string.

A number is very much like a C or Java number, except that the octal and hexadecimal formats are not used.

Whitespace can be inserted between any pair of tokens. Excepting a few encoding details, which completely describe the language.

JSON is a subset of the object literal notation of JavaScript. Since JSON is a subset of JavaScript, it can be used in the language with no muss or fuss.

var myJSONObject = {"bindings":

[

{"ircEvent": "PRIVMSG", "method": "newURI", "regex": "^http://.*"},

{"ircEvent": "PRIVMSG", "method": "deleteURI", "regex": "^delete.*"},

{"ircEvent": "PRIVMSG", "method": "randomURI", "regex": "^random.*"}

]

};

In this example, an object is created containing a single member "bindings", which contains an array containing three objects, each containing "ircEvent", "method", and "regex" members.

Members can be retrieved using dot or subscript operators.

myJSONObject.bindings[0].method // "newURI"

To convert a JSON text into an object, use the eval() function. eval() invokes the JavaScript compiler. Since JSON is a proper subset of JavaScript, the compiler will correctly parse the text and produce an object structure.

var myObject = eval('(' + myJSONtext + ')');

The eval() function is very fast. However, it can compile and execute any JavaScript program, so there can be security issues. The use of eval() is indicated when the source is trusted and competent. This is commonly the case in web applications when a web server is providing both the base page and the JSON data. There are cases where the source is not trusted. In particular, clients should never be trusted.

When security is a concern it is better to use a JSON parser. A JSON parser will recognize only JSON text and so is much safer:

var myObject = JSON.parse(myJSONtext, filter);

The optional filter parameter is a function that will be called for every key and value at every level of the final result. Each value will be replaced by the result of the filter() function. This can be used to reform generic objects into instances of classes, or to transform date strings into Date objects.

myData = JSON.parse(

text, function (key, value) {return key.indexOf('date') >= 0 ? new Date(value) : value; });

A JSON stringifier goes in the opposite direction, converting JavaScript data structures into JSON text. JSON does not support cyclic data structures, so be careful to not give cyclical structures to the JSON stringifier.

var myJSONText = JSON.stringify(myObject);

If the stringify() method sees an object that contains a toJSON() method, it calls the method, and stringifies the value returned. This allows an object to determine its own JSON representation.

The stringify() method can take an optional array of strings. These strings are used to select the properties that will be included in the JSON text. Otherwise, all of the properties of the object will be included. In any case, values that do not have a representation in JSON (such as functions and undefined) are excluded.

-
ShriKrishna Bhardwaj , With ASP.Net, SQL Server, Javascript

Adding a New Item To a DropDownList

2008-03-10T17:17:00.003+05:30

DropDownList_Pages.Items.Insert(0, new ListItem("Select Page", "0"));

-
ShriKrishna Bhardwaj , With ASP.Net, SQL Server, Javascript

Javascript Client Side Page Validation

2008-02-22T13:31:00.007+05:30

// In .cs file …

btn_register.Attributes.Add("onclick", "javascript:return ValidateForm()");

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

// In .aspx file in script …

function ValidateForm()

{

//debugger

var p = document.getElementById( "ctl00_ContentPlaceHolder1_txt_phone").value;

var q = document.getElementById ("ctl00_ContentPlaceHolder1_Check_accept");

var fname = document.getElementById ("ctl00_ContentPlaceHolder1_txt_firstname");

var email = document.getElementById ("ctl00_ContentPlaceHolder1_txt_email_id");

var pwd = document.getElementById ("ctl00_ContentPlaceHolder1_txt_password");

if(fname.value=="")

{

alert("Please Enter First Name.")

return false

}

else if(email.value=="")

{

alert("Please Enter Email-ID.")

return false

}

else if(pwd.value=="")

{

alert("Please Enter Password.")

return false

}

else if(!q.checked)

{

alert("You Must Agree Terms \& Conditions To Get Registered.")

return false

}

else if ( document.getElementById (" ctl00_ContentPlaceHolder1_txt_phone" )!="")

{

var num=" ";

chkD = 0

if(p > "")

{

num = p;

}

for (var i = 0; i <>

{

var oneChar = num.charAt(i)

if (oneChar == "." && chkD == 0)

{

chkD = 1

continue

}

if (oneChar < "0" || oneChar > "9")

{

alert("Please Enter Some Valid Phone Numbers.")

return false

}

-
ShriKrishna Bhardwaj , With ASP.Net, SQL Server, Javascript

Opening a Pop-Up Window

2008-02-01T10:13:00.003+05:30

//Add this to the Page_Load() ...

Button_ToOpenPopupWindow.Attributes.Add ("onclick", "window.open ('PopUp_WindowToOpen.aspx', null, 'height=600, width=460, status= yes, resizable= no, scrollbars=no, toolbar=no, location=no, menubar=no, minimize=no '); ");

-
ShriKrishna Bhardwaj , With ASP.Net, SQL Server, Javascript

Mouse Events in JavaScript

2008-01-29T14:22:00.003+05:30

//WRITE THESE FUNCTIONS IN JAVASCRIPT ...

function sname_focus()

{

if( window.document.all.sendmsg.SenderName.style.fontStyle == "italic")

{

window.document.all.sendmsg.SenderName.value = "";

window.document.all.sendmsg.SenderName.style.fontStyle = "normal";

}

function sname_blur()

{

if( window.document.all.sendmsg.SenderName.value == "")

{

window.document.all.sendmsg.SenderName.value = "Name of Contact";

window.document.all.sendmsg.SenderName.style.fontStyle = "italic";

}

function scompany_focus()

{

if( window.document.all.sendmsg.SenderCompany.style.fontStyle == "italic")

{

window.document.all.sendmsg.SenderCompany.value = "";

window.document.all.sendmsg.SenderCompany.style.fontStyle = "normal";

}

function scompany_blur()

{

if( window.document.all.sendmsg.SenderCompany.value == "")

{

window.document.all.sendmsg.SenderCompany.value = "Company Name";

window.document.all.sendmsg.SenderCompany.style.fontStyle = "italic";

}

function semail_focus()

{

if( window.document.all.sendmsg.SenderEmail.style.fontStyle == "italic")

{

window.document.all.sendmsg.SenderEmail.value = "";

window.document.all.sendmsg.SenderEmail.style.fontStyle = "normal";

}

function semail_blur()

{

if( window.document.all.sendmsg.SenderEmail.value == "")

{

window.document.all.sendmsg.SenderEmail.value = "Email Address";

window.document.all.sendmsg.SenderEmail.style.fontStyle = "italic";

}

function sphone_focus()

{

if( window.document.all.sendmsg.SenderPhone.style.fontStyle == "italic")

{

window.document.all.sendmsg.SenderPhone.value = "";

window.document.all.sendmsg.SenderPhone.style.fontStyle = "normal";

}

function sphone_blur()

{

if( window.document.all.sendmsg.SenderPhone.value == "")

{

window.document.all.sendmsg.SenderPhone.value = "Phone Number";

window.document.all.sendmsg.SenderPhone.style.fontStyle = "italic";

}

function smessage_focus()

{

if( window.document.all.sendmsg.SenderMessage.style.fontStyle == "italic")

{

window.document.all.sendmsg.SenderMessage.value = "";

window.document.all.sendmsg.SenderMessage.style.fontStyle = "normal";

}

function smessage_blur()

{

if( window.document.all.sendmsg.SenderMessage.value == "")

{

window.document.all.sendmsg.SenderMessage.value = "Message to Send";

window.document.all.sendmsg.SenderMessage.style.fontStyle = "italic";

}

function setboxstyles()

{

window.document.all.sendmsg.SenderName.style.fontStyle = "italic";

window.document.all.sendmsg.SenderCompany.style.fontStyle = "italic";

window.document.all.sendmsg.SenderEmail.style.fontStyle = "italic";

window.document.all.sendmsg.SenderPhone.style.fontStyle = "italic";

window.document.all.sendmsg.SenderMessage.style.fontStyle = "italic";

}

========================================================
//If you want to toggle the textbox values, if the mouse is clickes in it ...

input name="SenderName" type="text" value="Name of Contact" id="SenderName" onFocus="sname_focus()" onBlur="sname_blur()" class=contactsendmsg style="font-style:italic" />

// If you want to make a mouse-over events on buttons, etc ...

td width=90 valign=middle align=center style="cursor:pointer" onclick="window.location=('aboutus.htm')" id=aboutdiv class=mainmenutd onmouseover="changelayer_color('aboutdiv','maincolorover');" onmouseout="changelayer_color('aboutdiv','maincolorout');"><font class=mainmenutext>About Usfont>td>

-
ShriKrishna Bhardwaj , With ASP.Net, SQL Server, Javascript

Automatic Redirection To Index.aspx After 5 Seconds

2008-01-28T17:12:00.003+05:30

Place this line of code on page load ...

-
ShriKrishna Bhardwaj , With ASP.Net, SQL Server, Javascript

Toggle DIV Visibility In .aspx File

2008-01-28T16:47:00.003+05:30

<span style="font-family: Arial; font-weight:bold">Open Insertion span>DIV>

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

function ShowHideImageUploader()

{

if(document.getElementById('tblyes').style.display=='none')

{

document.getElementById('tblyes').style.display='block';

}

else

{

document.getElementById('tblyes').style.display='none';

}

-
ShriKrishna Bhardwaj , With ASP.Net, SQL Server, Javascript

Alerting A Multiline Text In ASP.Net 2.0

2008-01-25T18:14:00.003+05:30

script type="text/javascript">
function disp_alert()
{
alert("First line" + '\n' + "second line");
}

input onclick="disp_alert()" value="Display alert box" type="button"

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

Code for ".cs" file ...

string str_msg = "Thank you for your feedback.\\n We will be reverting back to you soon.";

ClientScript.RegisterStartupScript (this.GetType(), "script", "script language = 'javascript'> alert('" + str_msg + "'); ");

-
ShriKrishna Bhardwaj , With ASP.Net, SQL Server, Javascript

Inserting Values in Parent Page from a Pop-Up Wndow

2008-01-25T13:41:00.003+05:30

function parent_location()

{

var firstname ,lastname ;

//store value in variables using getelementbyid

firstname = document.getElementById("txtFname").value;

lastname = document.getElementById("txtLname").value;

//value send in parent form

window.opener.document.getElementById( "ctl00_ContentPlaceHolder1_TextBox_FName").value = firstname;

window.opener.document.getElementById( "ctl00_ContentPlaceHolder1_TextBox_LName").value = lastname;

//closing the PopUp window

window.close();

}

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

Add this Code on Page_Load ...

Button2.Attributes.Add("onclick", "javascript:return parent_location()");

-
ShriKrishna Bhardwaj , With ASP.Net, SQL Server, Javascript

Opening A New Window

2008-01-25T13:35:00.003+05:30

<a style="text-align:right" href="#" onclick="window.open ('../DisplayImage.aspx?Id= <%#DataBinder.Eval(Container.DataItem,"Photo_Id")%> ', null, 'height=700, width=700, status=yes, toolbar=no, menubar=no, location=no, scrollbars=1') ">

-
ShriKrishna Bhardwaj , With ASP.Net, SQL Server, Javascript

Setting Some Value of a Control in Master Page

2008-01-25T13:28:00.003+05:30

((Label)this.Master.FindControl("Label_Heading")).Text = "Hello !";

-
ShriKrishna Bhardwaj , With ASP.Net, SQL Server, Javascript

Displaying Alert Without Postback

2008-01-25T13:25:00.004+05:30

ClientScript.RegisterStartupScript( this.GetType(), "script", "script language="'javascript'"> alert('This is the alert message !'); " );

-
ShriKrishna Bhardwaj , With ASP.Net, SQL Server, Javascript

Creating An XML File in ASP.Net 2.0

2008-01-25T13:21:00.004+05:30

//function for creting mapdat file in particular location

void CreateMapDataXML(int city,int selectedindx)

{

//declare variable

//string path;

SqlConnection sqlcon = new SqlConnection( System.Configuration.ConfigurationManager.AppSettings ["Con"]);

SqlCommand sqlcmd;

try

{

sqlcon.Open();

sqlcmd = new SqlCommand("proc_bankmarker", sqlcon);

sqlcmd.CommandType = CommandType.StoredProcedure;

sqlcmd.Parameters.AddWithValue("@cityid", city);

sqlcmd.Parameters.AddWithValue("@index", selectedindx);

SqlDataAdapter sqladp = new SqlDataAdapter(sqlcmd);

DataSet ds = new DataSet();

ds.Clear();

sqladp.Fill(ds);

//function for genral

if (city >= 0 && selectedindx >= 0)

{

//map server data file from mapdata folder

path = Server.MapPath("..") + @"\MapData\MapData_" + selectedindx + city +".xml";

}

XmlTextWriter writer = new XmlTextWriter(path, System.Text.Encoding.UTF8);

writer.WriteStartDocument();

writer.WriteStartElement("Banks");

for (int i = 0; i <= ds.Tables[0].Rows.Count - 1; i++)

{

writer.WriteStartElement("Bank");

writer.WriteAttributeString("Name", ds.Tables[0].Rows[i]["bank_name"].ToString());

writer.WriteAttributeString("Contact", ds.Tables[0].Rows[i]["Contact_No"].ToString());

writer.WriteAttributeString("lat", ds.Tables[0].Rows[i]["lat"].ToString());

writer.WriteAttributeString("lng", ds.Tables[0].Rows[i]["lng"].ToString());

writer.WriteAttributeString("address", ds.Tables[0].Rows[i]["address"].ToString());

writer.WriteAttributeString("BankOrATM", ds.Tables[0].Rows[i]["bankoratm"].ToString());

writer.WriteEndElement();

}

writer.WriteEndElement();

writer.WriteEndDocument();

writer.Close();

}

catch (Exception ex)

{

Response.Write(ex.ToString());

}

-
ShriKrishna Bhardwaj , With ASP.Net, SQL Server, Javascript

Generate META Tags Dynamically in ASP.Net 2.0 ...

2008-01-25T13:17:00.003+05:30

This method should be called on Page_Load() ...

//Dynamically Generates the META tags consecutively for page ...

private void GenerateMetatags()

{

try

{

string str_country;

//If the there is no selected country OR the user clicks on select, then the default country that is set in Title is India ...

if (DropDownList_Country.SelectedItem == null || DropDownList_Country.SelectedItem.Text == "Select")

{

str_country = "India";

}

else

{

str_country = DropDownList_Country.SelectedItem.Text;

}

HtmlMeta hmKeyWords = new HtmlMeta();

HtmlHead head = (HtmlHead)Page.Header;

hmKeyWords.Name = "Keywords";

hmKeyWords.Content = "Home Loans - in " + str_country + ";

head.Controls.Add(hmKeyWords);

HtmlMeta hmDescription = new HtmlMeta();

hmDescription.Name = "Description";

hmDescription.Content = "Your Description ... about the site.";

head.Controls.Add(hmDescription);

HtmlTitle ht = new HtmlTitle();

ht.Text = "Home Loans in " + str_country + "";

head.Controls.Add(ht);

HtmlMeta httpequiv = new HtmlMeta();

httpequiv.HttpEquiv = "Content-Type";

httpequiv.Content = "text/html; charset=iso-8859-1";

head.Controls.Add(httpequiv);

}

catch (Exception ex)

{

Response.Write(ex.ToString());

}

-
ShriKrishna Bhardwaj , With ASP.Net, SQL Server, Javascript

Binding GridView Controls By Database

2008-01-25T13:06:00.003+05:30

<%@ Register Assembly="MagicAjax" Namespace="MagicAjax.UI.Controls" TagPrefix="ajax" %>

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" BackColor="White"

BorderColor="White" BorderStyle="Ridge" BorderWidth="3px" CellPadding="3" CellSpacing="1" OnRowCommand="GridView1_RowCommand" OnRowCreated="GridView1_RowCreated"

GridLines="None" Style="position: static" AllowPaging="True" AllowSorting="True" OnPageIndexChanging="GridView1_PageIndexChanging" OnSelectedIndexChanging="GridView1_SelectedIndexChanging" OnSorting="GridView1_Sorting">

<asp:TemplateField HeaderText="Bank ATM Locations">

<asp:Label ID="Label_Bank" runat="server" Font-Names="Arial" Font-Size="8pt" Style="position: static"

Text='<%# Eval("Branch_Name") %>' Visible="False">asp:Label><ajax:AjaxPanel ID="AjaxPanel1" runat="server">

<asp:LinkButton ID="LinkButton_Location" runat="server" Style="position: static" Text='<%# Eval("Branch_Name") %>'>asp:LinkButton>ajax:AjaxPanel>

<asp:Label ID="Label_Latitude" runat="server"

Style="position: static" Visible="False" Text='<%# Eval("LatiTude") %>'>asp:Label> <asp:Label ID="Label_Longitude"

runat="server" Style="position: static" Visible="False" Text='<%# Eval("Longitude") %>'>asp:Label>

ItemTemplate>

asp:TemplateField>

<asp:TemplateField HeaderText="Bank ATM Address">

<asp:Label ID="Label_ROIfl" runat="server" Style="position: static" Text='<%# Eval("Address") %>'>asp:Label>

ItemTemplate>

asp:TemplateField>

Columns>

<HeaderStyle BackColor="#004040" Font-Bold="True" Font-Size="8pt" ForeColor="#E7E7FF"

Wrap="False" />

asp:GridView>

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

Now Add This Code in ".cs" file in some event ...

//Fill the DataList dynamically on user's choice of banks ...

private void FillGridView(string SelectedBankIds)

{

string str = "SELECT Bank_Name, Website FROM Bank_List WHERE (Bank_Id IN (" + SelectedBankIds + "))";

// DataSet dt = new DataSet();

DataTable dt = new DataTable();

SqlDataAdapter da = new SqlDataAdapter(str, sqlcon);

da.Fill(dt);

if (dt.Rows.Count == 0)

{

// Remove contraints so an empty row can be added...

dt.Constraints.Clear();

foreach (DataColumn dc in dt.Columns)

dc.AllowDBNull = true;

// Add a blank row to the dataset...

dt.Columns[0].AllowDBNull = true;

dt.Rows.Add(dt.NewRow());

// Bind the DataSet to the GridView...

GridView1.Visible = true;

GridView1.DataSource = dt;

GridView1.DataBind();

// Get the number of columns to know what the Column Span should be...

int columnCount = GridView1.Rows[0].Cells.Count;

// Call the clear method to clear out any controls that you use in the columns. I use a dropdown list in one of the column so this was necessary....

GridView1.Rows[0].Cells.Clear();

GridView1.Rows[0].Cells.Add(new TableCell());

GridView1.Rows[0].Cells[0].ColumnSpan = columnCount;

GridView1.Rows[0].Cells[0].Text ="No Bank Selected!";

}

else

{

//Clear the databinding ...

GridView1.DataSource = null;

GridView1.DataBind();

//Rebind with the database ...

GridView1.DataSource = dt;

GridView1.DataBind();

}

-
ShriKrishna Bhardwaj , With ASP.Net, SQL Server, Javascript

Delete Selected Rows in GridView in ASP.Net 2.0

2008-01-25T12:47:00.003+05:30

protected void Button_DelProp_Click(object sender, EventArgs e)

{

Select_CheckBox();

if (_newId == "")

{

ClientScript.RegisterStartupScript( this.GetType(), "script", "");

}

else

{

string strcmd = "DELETE FROM Registered_Properties WHERE (Property_Id IN (" + _newId + ") )";

SqlCommand cmd = new SqlCommand(strcmd, con);

con.Open();

cmd.ExecuteNonQuery();

con.Close();

Response.Redirect(Session["Page"].ToString());

}

private void Select_CheckBox()

{

string Id = "";

for (int i = 0; i <>

{

bool chkSelect = (((CheckBox) GridView1.Rows[i].FindControl ("Chkselect")).Checked);

if (chkSelect)

{

Label lblPId = new Label();

lblPId = (Label)GridView1.Rows[i].FindControl("Label_PId");

Id += "," + lblPId.Text.ToString();

}

_newId = Id.Trim(',');

}

-
ShriKrishna Bhardwaj , With ASP.Net, SQL Server, Javascript

Creating A Unique Registration Code in ASP.Net 2.0

2008-01-25T12:16:00.002+05:30

public string RegistrationCode()

{

string str = System.Guid.NewGuid().ToString();

str = str.Replace("-", "");

return str;

}

-
ShriKrishna Bhardwaj , With ASP.Net, SQL Server, Javascript

Uploading Images in ASP.Net 2.0

2008-01-25T11:59:00.003+05:30

string DefaultImageName = System.IO.Path.GetExtension ( System.IO.Path.GetFileName( FileUpload_CompanyLogo.FileName));

string DefaultImagePath = Server.MapPath(".") + "/Agent_Logos/"+ Session["SellerID"] +"_Logo"+ DefaultImageName;

SaveAgentLogo(DefaultImagePath);

//Method to save the agent logo ...

private void SaveAgentLogo(string DefaultImagePath)

{

// Create and store the default image and its thumbnail.

FileUpload_CompanyLogo.PostedFile.SaveAs(DefaultImagePath);

string fileName = System.IO.Path.GetFileName(DefaultImagePath);

string strThumbnailPath = Server.MapPath(".") + @"/Agent_Logos/Thumbnails/" + fileName;

ThumbImage.C_Thumbnails(50, DefaultImagePath, strThumbnailPath);

}

-
ShriKrishna Bhardwaj , With ASP.Net, SQL Server, Javascript

Syntax for Connection String in Web.Config

2008-01-25T11:44:00.002+05:30

connectionStrings>

======================================================
Now Add the Code Line Below in the ".aspx.cs" file at class level

using System.Data.SqlClient;

protected SqlConnection con = new SqlConnection( System.Configuration.ConfigurationManager.AppSettings ["CON"] );

-
ShriKrishna Bhardwaj , With ASP.Net, SQL Server, Javascript

Calculate distance between two points on Google Maps

2008-01-25T11:32:00.002+05:30

public double CalculateDistance(double Lat1, double Long1, double Lat2, double Long2)
{
double dDistance = Double.MinValue;
double dLat1InRad = Lat1 * (Math.PI / 180.0);
double dLong1InRad = Long1 * (Math.PI / 180.0);
double dLat2InRad = Lat2 * (Math.PI / 180.0);
double dLong2InRad = Long2 * (Math.PI / 180.0);

double dLongitude = dLong2InRad - dLong1InRad;
double dLatitude = dLat2InRad - dLat1InRad;

// Intermediate result a.
double a = Math.Pow(Math.Sin(dLatitude / 2.0), 2.0) +
Math.Cos(dLat1InRad) * Math.Cos(dLat2InRad) *
Math.Pow(Math.Sin(dLongitude / 2.0), 2.0);

// Intermediate result c (great circle distance in Radians).
double c = 2.0 * Math.Atan2(Math.Sqrt(a), Math.Sqrt(1.0 - a));

// Distance.
// const Double kEarthRadiusMiles = 3956.0;
const Double kEarthRadiusKms = 6376.5;
dDistance = kEarthRadiusKms * c;

return(dDistance);
}

-
ShriKrishna Bhardwaj , With ASP.Net, SQL Server, Javascript

Sending E-Mails in ASP.Net

2008-01-25T11:22:00.004+05:30

using System.Net.Mail;

public void SendPageErrorMailToAdmin(string ErrorPageName, string ExceptionMessage)
{

string _to = System.Configuration.ConfigurationManager.AppSettings ["SiteMasterEmail"];
string _from = System.Configuration.ConfigurationManager.AppSettings ["AdminEmail"];
//string _to = System.Configuration.ConfigurationManager.AppSettings ["ContactEmail"];

MailAddress from = new MailAddress( _from, "My Website Admin");
MailAddress to = new MailAddress( _to, "My SiteMaster");
MailMessage msg = new MailMessage( from, to);

msg.Body = "Dear SiteMaster, An Exception Has Been Found !" + Environment.NewLine;
msg.Body += "=============================================" + Environment.NewLine;
msg.Body += Environment.NewLine;

//=====Testing Lines, Not To Be Included in the Main Site.
//msg.Body += "//=====Testing Line, Not To Be Included in the Main Site." + Environment.NewLine;
//msg.Body += "(From " + _from + " To " + _to + ")" + Environment.NewLine;

msg.Body += Environment.NewLine;
msg.Body += "ExceptionPage : " + ErrorPageName + "." + Environment.NewLine;
msg.Body += Environment.NewLine;
msg.Body += Environment.NewLine;
msg.Body += "Exception : " + Environment.NewLine;
msg.Body += ExceptionMessage + ".";
msg.Body += Environment.NewLine;
msg.Body += Environment.NewLine;
msg.Body += Environment.NewLine;
msg.Body += "Needs To Be Corrected Immediately." + Environment.NewLine;
msg.Body += "Thanks" + Environment.NewLine;

msg.BodyEncoding = System.Text.Encoding.UTF8;
msg.Subject = "An Exception on " + ErrorPageName + " page.";
msg.Priority = MailPriority.High;
SmtpClient smtpObj = new SmtpClient("127.0.0.1");
smtpObj.Send(msg);
}

-
ShriKrishna Bhardwaj , With ASP.Net, SQL Server, Javascript

Binding the Header of GridView even if there is no result in datatable

2008-01-24T11:53:00.002+05:30

//Fill the GridView dynamically ...
private void FillGridView(string Ids)
{
string str = "SQL Query";

DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(str, sqlcon);
da.Fill(dt);

if (dt.Rows.Count == 0)
{
// Remove contraints so an empty row can be added...
dt.Constraints.Clear();
foreach (DataColumn dc in dt.Columns)
dc.AllowDBNull = true;

// Add a blank row to the dataset...
dt.Columns[0].AllowDBNull = true;
dt.Rows.Add(dt.NewRow());

// Bind the DataSet to the GridView...
GridView1.Visible = true;
GridView1.DataSource = dt;
GridView1.DataBind();

// Get the number of columns to know what the Column Span should be...
int columnCount = GridView1.Rows[0].Cells.Count;

// Call the clear method to clear out any controls that you use in the columns. I use a dropdown list in one of the column so this was necessary....
GridView1.Rows[0].Cells.Clear();
GridView1.Rows[0].Cells.Add(new TableCell());
GridView1.Rows[0].Cells[0].ColumnSpan = columnCount;
GridView1.Rows[0].Cells[0].Text ="Nothing Selected!";
}
else
{
//Clear the databinding ...
GridView1.DataSource = null;
GridView1.DataBind();

//Rebind with the database ...
GridView1.DataSource = dt;
GridView1.DataBind();
}

}

-
ShriKrishna Bhardwaj , With ASP.Net, SQL Server, Javascript

Upload Videos in ASP.Net

2008-01-22T15:35:00.003+05:30

protected void btnUpload_Click(object sender, EventArgs e)

{

string Venu = Request.QueryString["Venu"];

if (!( UVideo.PostedFile.ContentType == "video/x-ms-wmv" || UVideo.PostedFile.ContentType == "video/mpg" || UVideo.PostedFile.ContentType == "video/mpeg" || UVideo.PostedFile.ContentType == "video/divx" || UVideo.PostedFile.ContentType == "video/div" || UVideo.PostedFile.ContentType == "video/tix" || UVideo.PostedFile.ContentType == "video/mp4" || UVideo.PostedFile.ContentType == "video/qt" || UVideo.PostedFile.ContentType == "video/mov" || UVideo.PostedFile.ContentType == "video/avi" || UVideo.PostedFile.ContentType == "video/mp3" || UVideo.PostedFile.ContentType == "video/mpa" || UVideo.PostedFile.ContentType == "video/mpe" || UVideo.PostedFile.ContentType == "video/mp2" || UVideo.PostedFile.ContentType == "video/m1v" ))

{

pnlRight.Visible = false;

pnlWrong.Visible = true;

lblError.Text = "Video Extension Not Match";

return;

}

string file = System.IO.Path.GetFileName( System.IO.Path.GetExtension( UVideo.PostedFile.FileName ));

string loc = Server.MapPath("..")+ @"\"+ Venu + @"\Videos\" + ViewState["Id"].ToString() + file;

UVideo.PostedFile.SaveAs(loc);

SqlConnection sqlcon;

SqlCommand sqlcmd;

sqlcon = new SqlConnection ( System.Configuration.ConfigurationManager.AppSettings ["ConStr"] );

try

{

sqlcon.Open();

sqlcmd = new SqlCommand("updt_Video", sqlcon);

sqlcmd.CommandType = CommandType.StoredProcedure;

sqlcmd.Parameters.AddWithValue("@Vid", ViewState["Id"]);

sqlcmd.Parameters.AddWithValue("@VTitle", txtTitle.Text);

sqlcmd.Parameters.AddWithValue("@VPath", ViewState["Id"] + file);

sqlcmd.ExecuteNonQuery();

sqlcon.Close();

pnlRight.Visible = true;

pnlWrong.Visible = false;

lblRight.Text = "Video Uploaded Sucessfully";

}

catch (Exception ex)

{

sqlcon.Close();

Response.Write(ex.ToString());

}

finally

{

sqlcon.Close();

}

-
ShriKrishna Bhardwaj , With ASP.Net, SQL Server, Javascript

Creating Thumbnails in ASP.Net

2008-01-22T15:25:00.003+05:30

// Keep this method in Utility.cs

public static void C_Thumbnails(int size, string FilePath, string ThumbPath)

{

// create an image object, using the filename we just retrieved

System.Drawing.Image image = System.Drawing.Image.FromFile(FilePath);

try

{

int thumbHeight, thumbWidth;

decimal h = image.Height;

decimal w = image.Width;

if (image.Height > image.Width)

{

thumbHeight = size;

decimal tWidth = (w / h) * thumbHeight;

thumbWidth = Convert.ToInt32(tWidth);

}

else

{

thumbWidth = size;

decimal tHeight = (h / w) * thumbWidth;

thumbHeight = Convert.ToInt32(tHeight);

}

// create the actual thumbnail image

System.Drawing.Image thumbnailImage = image.GetThumbnailImage(thumbWidth, thumbHeight, null, IntPtr.Zero);

image.Dispose();

// put the image into the memory stream

thumbnailImage.Save(ThumbPath, System.Drawing.Imaging.ImageFormat.Jpeg);

}

catch (Exception ex)

{

image.Dispose();

throw ex;

}

}

-
ShriKrishna Bhardwaj , With ASP.Net, SQL Server, Javascript