Asp.net Developer Jeyaganesh

TNPSC Group 1,2 and 4 Syllabus, Study Materials 2013

2013-02-19T05:31:00.002-08:00

TNPSC Group 1 Syllabus- Tamil Nadu Public Service Commission releases various recruitments. Numbers of candidates apply for TNPSC recruitments. Applied candidates select on the basis of written exam and interview. Candidates who will attempt examination they must know which syllabus come in exam. Here in this section we are providing you TNPSC Group 1 Syllabus and Study Materials. Candidates must see below for getting details about TNPSC Group 1 syllabus and EBooks.

TNPSC Group 1 Preliminary Syllabus- TNPSC Group 1 Preliminary consists following subjects:

· General Science

· History OF India

· Geography OF India

· Economics And Commerce

· Indian Polity

· Indian National Movement

· Current Events (Current Affairs)

· Mental Ability Tests

TNPSC Group 1 Main Syllabus- TNPSC Group 1 Main Syllabus consists following subjects:

Ø TNPSC PAPER-1 Syllabus

Ø TNPSC PAPER-2 Syllabus

TNPSC PAPER-1 Syllabus-TNPSC Paper-1 covers following topics:

· Modern history of India and Indian culture

· Current events of national and international importance

· Statistical analysis, graphs and diagrams

· Social problems and other current sensitive issues

TNPSC PAPER-2 Syllabus- TNPSC Paper-2 covers following topics:

· Indian polity

· Indian economy and geography of India

· Role and impact of science and technology in the development of India

· Tamil language, Tamil society, its culture and heritage

· Tamil Nadu administration

You can get TNPSC Group I eligibility, pay scale through given link:

TNPSC Group 1 Recruitment 2012

TNPSC Group 1 study Material EBooks 2013

Text Books published by Tamil Nadu Text Books Society (Preparation Tips)

Science- 6, 7, 8, 9,10th Standard

Physics- 11,12^th Standard

Chemistry- 11,12^th Standard

Biology- 11, 12th Standard

Social Science-6, 7, 8, 9,10th Standard

History- 11, 12th Standard

Geography- 11, 12th Standard

Political Science-11, 12th Standard

Mathematic-7, 8, 9, 10^th Standard

Logic-12^th Standard (Old)

ALL Tamil nadu textbook available
www.textbooksonline.tn.nic.in/

Blogger Tutorial: Create a Contact Form for Blogger Using Google Docs

2012-11-08T22:26:00.002-08:00

How to create a SETUP file in .NET

2012-11-08T21:37:00.001-08:00

Enquiry / Contact Form with Javascript Validation Using Asp.net c#

2012-11-06T21:25:00.002-08:00

Contact.aspx
-------------------

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>::Contact / Enquiry Page with JavaScript Form Validation:: Jeyaganesh asp.net Developer</title>
<script language="javascript" type="text/javascript">
function validate() {
if (document.getElementById("<%=TextBox1.ClientID%>").value == "") {
alert("Name Feild can not be blank");
document.getElementById("<%=TextBox1.ClientID%>").focus();
return false;
}

if (document.getElementById("<%=TextBox2.ClientID %>").value == "") {
alert("Email id Feild can not be blank");
document.getElementById("<%=TextBox2.ClientID %>").focus();
return false;
}

if (document.getElementById("<%=TextBox3.ClientID %>").value == "") {
alert("Mobile No Feild can not be blank");
document.getElementById("<%=TextBox3.ClientID %>").focus();
return false;
}
if (document.getElementById("<%=TextBox4.ClientID %>").value == "") {
alert("Feedback Feild can not be blank");
document.getElementById("<%=TextBox3.ClientID %>").focus();
return false;
}
var emailPat = /^(\".*\"|[A-Za-z]\w*)@(\[\d{1,3}(\.\d{1,3}){3}]|[A-Za-z]\w*(\.[A-Za-z]\w*)+)$/;
var emailid = document.getElementById("<%=TextBox2.ClientID %>").value;
var matchArray = emailid.match(emailPat);
if (matchArray == null) {
alert("Your Email Address Seems Incorrect. Please try again.");
document.getElementById("<%=TextBox2.ClientID %>").focus();
return false;
}

return true;
}
</script>
</head>
<body>
<form id="form1" action="" runat="server">
<table width="500" border="0" style="text-align:left; font-size:16px; color:#C6913D; font-weight:bold;">
<tr>
<td align="left">Enquiry Form</td>
<td></td>
</tr>
<tr>
<td>Name</td>
<td>
<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox></td>
</tr>
<tr>
<td>Email Id</td>
<td><asp:TextBox ID="TextBox2" runat="server"></asp:TextBox></td>
</tr>
<tr>
<td>Mobile No</td>
<td><asp:TextBox ID="TextBox3" runat="server"></asp:TextBox></td>
</tr>
<tr>
<td>Comments</td>
<td><asp:TextBox ID="TextBox4" runat="server" TextMode="MultiLine" Width="300px" Height="150px"></asp:TextBox></td>
</tr>

<tr>
<td></td>
<td><br/>
<asp:Button ID="Button1" runat="server" Text="Submit" class="learn-more"
OnClientClick="return validate()" onclick="Button1_Click"/>
<%--<a title="Submit" class="learn-more" href="#">Submit</a>--%></td>
</tr>
</table>
</form>
</body>
</html>

Contact.aspx.cs
------------------

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Net.Mail;
using System.Net;
using System.Threading;
using System.IO;
using System.Text;
using System.Data.SqlClient;

public partial class Contact : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{

}
protected void Button1_Click(object sender, EventArgs e)
{
try
{

MailMessage mail1 = new MailMessage();
mail1.To.Add("to mailid");
mail1.From = new MailAddress("fromemailid@hotmail.com");
mail1.Subject = "Feed Back On " + DateTime.Now.ToString();
mail1.IsBodyHtml = true;
string Body1;

Body1 = "<html><head><meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\" />";
Body1 += "<title></title>"

+ "</head>"
+ "<body>"

+ "<table align=\"center\" style=\"width: 650px; height: 377px;\">"
+ "<tr>"
+ "<td>"
+ "Name"
+ "</td>"
+ "<td align=\"center\">:</td>"
+ "<td>"
+ TextBox1.Text
+ "</td>"
+ "</tr>"
+ "<tr>"
+ "<td>"
+ "</td>"
+ "<td align=\"center\"></td>"
+ "<td>"
+ "</td>"
+ "</tr>"

+ "<tr>"
+ "<td>"
+ "</td>"
+ "<td align=\"center\"></td>"
+ "<td>"
+ "</td>"
+ "</tr>"

+ "<tr>"
+ "<td>"
+ "Email Id</td>"
+ "<td align=\"center\">:</td>"
+ "<td>"
+ TextBox2.Text + "</td>"
+ "</tr>"

+ "<tr>"
+ "<td>"
+ "</td>"
+ "<td align=\"center\"></td>"
+ "<td>"
+ "</td>"
+ "</tr>"
+ "<tr>"
+ "<td>"
+ "</td>"
+ "<td align=\"center\"></td>"
+ "<td>"
+ "</td>"
+ "</tr>"

+ "<tr>"
+ "<td>"
+ "Mobile No</td>"
+ "<td align=\"center\">:</td>"
+ "<td>"
+ TextBox3.Text + "</td>"
+ "</tr>"

+ "<tr>"
+ "<td>"
+ "</td>"
+ "<td align=\"center\"></td>"
+ "<td>"
+ "</td>"
+ "</tr>"
+ "<tr>"
+ "<td>"
+ "</td>"
+ "<td align=\"center\"></td>"
+ "<td>"
+ "</td>"
+ "</tr>"

+ "<tr>"
+ "<td>"
+ "Feedback</td>"
+ "<td align=\"center\">:</td>"
+ "<td>"
+ TextBox4.Text + "</td>"
+ "</tr>"

+ "</table>"
+ "</body>"
+ "</html>";

mail1.Body = Body1;
// mail.Body += Body.ToString();
mail1.IsBodyHtml = true;

mail1.Priority = MailPriority.Normal;
SmtpClient smtp1 = new SmtpClient();
smtp1.Port = 25;
smtp1.Host = "smtp.live.com";
smtp1.Credentials = new System.Net.NetworkCredential("fromemailid@hotmail.com", "password");
smtp1.EnableSsl = true;
smtp1.Send(mail1);

ClientScript.RegisterStartupScript(this.GetType(), "Alert", "<script>alert('Your Information Sending Successfully');</script>");

}
catch (Exception ex)
{
ClientScript.RegisterStartupScript(this.GetType(), "Alert", "<script>alert('Email Not Sent');</script>");
}
}
}

You can set your own domain mailid and Password:

SET Port No:25

SET Smtp host: mail.yourdomain.com or webmail.yourdomain.com (EX:mail.ganesh.com)

SET EnableSsl=false

JAVASCRIPT FORM VALIDATION FOR ASP.NET WEB FORM

2012-11-06T20:48:00.001-08:00

<!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>::JavaScript Form Validation:: Jeyaganesh asp.net Developer</title>
<script language="javascript" type="text/javascript">
function validate() {
if (document.getElementById("<%=TextBox1.ClientID%>").value == "") {
alert("Name Feild can not be blank");
document.getElementById("<%=TextBox1.ClientID%>").focus();
return false;
}

if (document.getElementById("<%=TextBox2.ClientID %>").value == "") {
alert("Email id Feild can not be blank");
document.getElementById("<%=TextBox2.ClientID %>").focus();
return false;
}

if (document.getElementById("<%=TextBox3.ClientID %>").value == "") {
alert("Mobile No Feild can not be blank");
document.getElementById("<%=TextBox3.ClientID %>").focus();
return false;
}
if (document.getElementById("<%=TextBox4.ClientID %>").value == "") {
alert("Feedback Feild can not be blank");
document.getElementById("<%=TextBox3.ClientID %>").focus();
return false;
}
var emailPat = /^(\".*\"|[A-Za-z]\w*)@(\[\d{1,3}(\.\d{1,3}){3}]|[A-Za-z]\w*(\.[A-Za-z]\w*)+)$/;
var emailid = document.getElementById("<%=TextBox2.ClientID %>").value;
var matchArray = emailid.match(emailPat);
if (matchArray == null) {
alert("Your Email Address Seems Incorrect. Please try again.");
document.getElementById("<%=TextBox2.ClientID %>").focus();
return false;
}

return true;
}
</script>
</head>
<body>
<form id="form1" action="" runat="server">
<table width="500" border="0" style="text-align:left; font-size:16px; color:#C6913D; font-weight:bold;">
<tr>
<td align="left">Enquiry Form</td>
<td></td>
</tr>
<tr>
<td>Name</td>
<td>
<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox></td>
</tr>
<tr>
<td>Email Id</td>
<td><asp:TextBox ID="TextBox2" runat="server"></asp:TextBox></td>
</tr>
<tr>
<td>Mobile No</td>
<td><asp:TextBox ID="TextBox3" runat="server"></asp:TextBox></td>
</tr>
<tr>
<td>Comments</td>
<td><asp:TextBox ID="TextBox4" runat="server" TextMode="MultiLine" Width="300px" Height="150px"></asp:TextBox></td>
</tr>

<tr>
<td></td>
<td><br/>
<asp:Button ID="Button1" runat="server" Text="Submit"
OnClientClick="return validate()"/>
</td>
</tr>
</table>
</form>
</body>
</html>

Jeyaganesh Developer: how to import Contacts from GMAIL using ASP.NET and C# | ASP.NET,C#.NET,SQL Server, Ajax Samples and Tutorials

2012-10-25T23:43:00.001-07:00

Jeyaganesh Developer: how to import Contacts from GMAIL using ASP.NET and C# | ASP.NET,C#.NET,SQL Server, Ajax Samples and Tutorials

2012-10-22T04:25:00.000-07:00

Jquery validation end date should be greater than start date using datepicker

To implement this one first open Visual Studio and create new website after that write following code in your aspx page

<head>

<title>jQuery UI Datepicker - Select a Date Range</title>

$(function() {

var dates = $("#txtFrom, #txtTo").datepicker({

minDate: '0',

maxDate: '+7D',

onSelect: function(selectedDate) {

var option = this.id == "txtFrom" ? "minDate" : "maxDate",

instance = $(this).data("datepicker"),

date = $.datepicker.parseDate(

instance.settings.dateFormat ||

$.datepicker._defaults.dateFormat,

selectedDate, instance.settings);

dates.not(this).datepicker("option", option, date);

}

});

</script>

.ui-datepicker { font-size:8pt !important}

</style>

</head>

<body>

<asp:TextBox ID="txtFrom" runat="server"/>

<asp:TextBox ID="txtTo" runat="server"/>

</div>

</form>

</body>

</html>

If you observe above code in header section I added some of script files and css classes by using those files we will display calendar control with beautiful css style. You can get those files by downloading attached sample.

If you observe script in header section

$(function() {

var dates = $("#txtFrom, #txtTo").datepicker({

minDate: '0',

maxDate: '+7D',

minDate: I set it as 0 means it won’t allow us to select before today date

maxDate: Here I set as '+7D' means it will allow us to select upto maximum 7 days.

If we want to set to 15 days or 1 Month range then we will use '+15D' or '+1M'

After completion of aspx page design and your code modifications just run your application and check your calendar control that would be like below demo

Demo

DOWNLOAD

2012-10-22T04:19:00.001-07:00

jQuery Countdown

The Final Countdown is plugin that let's you in control where and how you will display the countdown, this mean that the plugin doesn't make any assumption on how the html will be displayed and it's up to you to do it, with the help of our beloved jQuery selectors.

SHARE THIS LINK:

http://static.hilios.com.br/jquery-countdown/examples/basic.html

DEMO:

2012-10-22T03:23:00.001-07:00

Ajax AsyncFileUpload control example in asp.net to upload files to server

First create one new website after that right click on it add new folder and give name as ‘Files’ after that add AjaxControlToolkit reference to your application and add following line in your aspx page

<%@ Register Namespace="AjaxControlToolkit" Assembly="AjaxControlToolkit" tagPrefix="ajax" %>

Once add above references design your aspx page will be likes this

<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="ajax" %>

<title>Untitled Page</title>

// This function will execute after file uploaded successfully

function uploadComplete() {

document.getElementById('<%=lblMsg.ClientID %>').innerHTML = "File Uploaded Successfully";

}

// This function will execute if file upload fails

function uploadError() {

document.getElementById('<%=lblMsg.ClientID %>').innerHTML = "File upload Failed.";

}

</script>

</head>

<body>

<ajax:ToolkitScriptManager ID="scriptManager1" runat="server"/>

<div>

<ajax:AsyncFileUpload ID="fileUpload1" OnClientUploadComplete="uploadComplete" OnClientUploadError="uploadError"

CompleteBackColor="White" Width="350px" runat="server" UploaderStyle="Modern" UploadingBackColor="#CCFFFF"

ThrobberID="imgLoad" OnUploadedComplete="fileUploadComplete" /><br />

<asp:Image ID="imgLoad" runat="server" ImageUrl="loading.gif" />

<br />

<asp:Label ID="lblMsg" runat="server" Text=""></asp:Label>

</div>

</form>

</body>

</html>

If you observe above code I define lot of properties to ajax:AsyncFileUpload now I will explain all the properties of Ajax fileupload control

OnClientUploadComplete – This property is used to execute the client side JavaScript function after file successfully uploaded.

OnClientUploadError – This property is used to execute the client side JavaScript function if file uploading failed.

OnClientUploadStarted – This property is used to execute the client side JavaScript function whenver file uploading start.

CompleteBackColor – This property is used to set fileupload control background after file upload complete its default value ‘Lime’.

ErrorBackColor – This property is used to set fileupload control background if file upload failed its default value ‘Red’.

UploadingBackColor – This property is the id of the control which is seen during upload file.

UploaderStyle – This property is used to set fileupload control appearance style either Modern or Traditional. By default its value "Traditional".

ThrobberID – ID of control that is shown while the file is uploading.

Width – This property is used to set width of the control. By default its value ‘355px’

Now in code behind add following namespaces

C# Code

using System;

using System.Web.UI;

using AjaxControlToolkit;

After completion of adding namespaces write following code in code behind

protected void fileUploadComplete(object sender, AsyncFileUploadEventArgs e)

{

string filename = System.IO.Path.GetFileName(fileUpload1.FileName);

fileUpload1.SaveAs(Server.MapPath("Files/") + filename);

}

VB Code

Imports System.Web.UI

Imports AjaxControlToolkit

Partial Class Default

Inherits System.Web.UI.Page

Protected Sub fileUploadComplete(ByVal sender As Object, ByVal e As AsyncFileUploadEventArgs)

Dim filename As String = System.IO.Path.GetFileName(fileUpload1.FileName)

fileUpload1.SaveAs(Server.MapPath("Files/") & filename)

End Sub

End Class

Demo

Download sample code attached

DOWNLOAD

how to insert images into database and how to retrieve and bind images to gridview using asp.net (or) save and Retrieve images from database using asp.net

2012-06-19T22:44:00.000-07:00

Introduction

Here I will explain how insert and retrieve images from database and how to bind images to gridview using asp.net
TableName : image_upload

Column Name	Data Type	Allow Nulls
Id	Int	Yes
images	image	Yes

After that Design your aspx page like this

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
    Image
        <asp:FileUpload ID="FileUpload1" runat="server" /><br />
        <asp:Button ID="Button1" runat="server" Text="Button" onclick="Button1_Click" />
    </div>

<div>

<asp:GridView ID="gvImages" CssClass="Gridview" runat="server" AutoGenerateColumns="False"

HeaderStyle-BackColor="#7779AF" HeaderStyle-ForeColor="white">

<asp:BoundField HeaderText = "id" DataField="id" />

<asp:TemplateField HeaderText="Image Id">

<asp:Image ID="Image1" runat="server" ImageUrl='<%# "ImageHandler.ashx?ImID="+ Eval("id") %>' Height="150px" Width="150px"/>

</ItemTemplate>

</asp:TemplateField>

</Columns>

</asp:GridView>

</div>

    </form>
</body>
</html>

web.config
------------

<connectionStrings>
        <add name="mmConnectionString" connectionString="server=SAMSUNG\SQLEXPRESS;Integrated Security=true;database=sample;" providerName="System.Data.SqlClient"/>
    </connectionStrings>

default.aspx.cs
---------------

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
namespace WebApplication4
{

    public partial class _Default : System.Web.UI.Page
    {
        string strcon = ConfigurationManager.ConnectionStrings["mmConnectionString"].ConnectionString;
        protected void Page_Load(object sender, EventArgs e)
        {

if (!IsPostBack)

{

BindGridData();

}

private void BindGridData()

{

SqlConnection connection = new SqlConnection(strcon);

SqlCommand command = new SqlCommand("SELECT images,ID from [Image]", connection);

SqlDataAdapter daimages = new SqlDataAdapter(command);

DataTable dt = new DataTable();

daimages.Fill(dt);

gvImages.DataSource = dt;

gvImages.DataBind();

gvImages.Attributes.Add("bordercolor", "black");

}

        protected void Button1_Click(object sender, EventArgs e)
        {
            if (FileUpload1.HasFile)
            {
                int image_length = FileUpload1.PostedFile.ContentLength;
                byte[] imgtype=new byte[image_length];
                HttpPostedFile img = FileUpload1.PostedFile;
                img.InputStream.Read(imgtype, 0, image_length);
                SqlConnection con = new SqlConnection(strcon);
                con.Open();
                SqlCommand cmd = new SqlCommand();
                cmd.CommandText = "insert into image_upload values(1,'"+imgtype+"')";
                cmd.CommandType = CommandType.Text;
                cmd.Connection = con;
                int count = cmd.ExecuteNonQuery();
                con.Close();
                if (count == 1)
                {
                     BindGridData();
                    ScriptManager.RegisterStartupScript(this, this.GetType(), "alertmessage", "alert('image inserted successfully')", true);
                }
            }
        }
    }
}

handler.ashx.cs
---------------

string strcon = ConfigurationManager.AppSettings["mmConnectionString"].ToString();

public void ProcessRequest(HttpContext context)

{

string imageid = context.Request.QueryString["ImID"];

SqlConnection connection = new SqlConnection(strcon);

connection.Open();

SqlCommand command = new SqlCommand("select Images from image_upload where ID=" + imageid, connection);

SqlDataReader dr = command.ExecuteReader();

dr.Read();

context.Response.BinaryWrite((Byte[])dr[0]);

connection.Close();

context.Response.End();

}

Bind XML saving data to DataGridView with Delete and Edit Options in Windows forms applicatons using C# || Insert,Edit,Delete data into XML with DataGridView in Windows forms using C#

2012-06-19T22:19:00.001-07:00

n this article am showing following steps:

Save data into XML file .
Retrieve data from XML file and bind that data to DataGridview.
Add two EDIT and DELETE columns to DataGridView.
Write edit,delete coding in dataGridView1_CellContentDoubleClick.

Save data into XML file:

For using XML add the following namespace:

using System.Xml;

Write the following code in Save button Click:

private void btnSave_Click(object sender, EventArgs e)

{

string path = "AccountDetails.xml";

XmlDocument doc = new XmlDocument();

////If there is no current file, then create a new one

if (!System.IO.File.Exists(path))

{

//Create neccessary nodes

XmlDeclaration declaration = doc.CreateXmlDeclaration("1.0", "UTF-8", "yes");

XmlComment comment = doc.CreateComment("This is an XML Generated File");

}

else //If there is already a file

{

// //Load the XML File

doc.Load(path);

}

//Get the root element

XmlElement root = doc.CreateElement("BankAccount_Details");

XmlElement Subroot = doc.CreateElement("BankAccount");

XmlElement BankName = doc.CreateElement("BankName");

XmlElement AccountNumber = doc.CreateElement("AccountNumber");

XmlElement BankType = doc.CreateElement("BankType");

XmlElement Balance = doc.CreateElement("Balance");

//Add the values for each nodes

BankName.InnerText = comboBox1.SelectedItem.ToString();

AccountNumber.InnerText = txtAccNumber.Text;

if (rbtnCurrent.Checked)

BankType.InnerText = rbtnCurrent.Text;

else if (rbtnSaving.Checked)

BankType.InnerText = rbtnSaving.Text;

else

BankType.InnerText = rbtnOther.Text;

Balance.InnerText = txtBalance.Text;

//Construct the document

doc.AppendChild(declaration);

doc.AppendChild(comment);

doc.AppendChild(root);

root.AppendChild(Subroot);

Subroot.AppendChild(BankName);

Subroot.AppendChild(AccountNumber);

Subroot.AppendChild(BankType);

Subroot.AppendChild(Balance);

doc.Save(path);

//Show message

MessageBox.Show("Records added Successfully");

//Reset text fields for new input

txtBalance.Text = String.Empty;

txtAccNumber.Text = String.Empty;

comboBox1.SelectedIndex = 0;

//To show added record in Gridview call LoadGrid() method which I show below

LoadGrid();

}

Retrieve data from XML file and bind to DataGridview:

For retrieve XML data and bind to Gridview call the following method:

protected void LoadGrid()

{

DataSet xmlds = new DataSet();

string path = "AccountDetails.xml";

if (System.IO.File.Exists(path))

{

xmlds.ReadXml(path);

if (xmlds.Tables.Count > 0)

{

dataGridView1.DataSource = xmlds.Tables[0].DefaultView;

}

Call the above method in form page load also

private void Account_Details_Load(object sender, EventArgs e)

{

LoadGrid();

}

Add EDIT and DELETE columns to DataGridView:

For Editing and Deleting add two columns to DataGridView with Suitable Images. I am adding Delete Image in 1^st column and Edit in 2^nd column.

For deleting and editing am taking account number as a parameter.

write the following code in dataGridView1_CellContentDoubleClick event:

private void dataGridView1_CellContentDoubleClick(object sender, DataGridViewCellEventArgs e)

{

if (e.RowIndex != -1)

{

//For Deleting following code

if (e.ColumnIndex == 0)

{

DataGridViewRow row = dataGridView1.Rows[e.RowIndex];

string acnum = row.Cells[3].Value.ToString();

string path = "AccountDetails.xml";

XmlDocument doc = new XmlDocument();

doc.Load(path);

XmlNode node = doc.SelectSingleNode("/BankAccount_Details/BankAccount[AccountNumber='" + acnum + "']");

node.ParentNode.RemoveChild(node);

doc.Save(path);

MessageBox.Show("Selected Record Deleted Successfully");

}

//For Editing following code

if (e.ColumnIndex == 1)

{

DataGridViewRow row = dataGridView1.Rows[e.RowIndex];

int acnum = Convert.ToInt32(row.Cells[3].Value);

string path = "AccountDetails.xml";

XmlDocument doc = new XmlDocument();

doc.Load(path);

XmlNode node = doc.SelectSingleNode("/BankAccount_Details/BankAccount[AccountNumber='" + acnum + "']");

node.ParentNode.RemoveChild(node);

doc.Save(path);

////If there is no current file, then create a new one

if (!System.IO.File.Exists(path))

{

//Create neccessary nodes

XmlDeclaration declaration = doc.CreateXmlDeclaration("1.0", "UTF-8", "yes");

XmlComment comment = doc.CreateComment("This is an XML Generated File");

doc.AppendChild(declaration);

doc.AppendChild(comment);

}

//If there is already a file

else

{

// //Load the XML File

doc.Load(path);

}

XmlElement root = doc.CreateElement("BankAccount_Details");

XmlElement Subroot = doc.CreateElement("BankAccount");

XmlElement BankName = doc.CreateElement("BankName");

XmlElement AccountNumber = doc.CreateElement("AccountNumber");

XmlElement BankType = doc.CreateElement("BankType");

XmlElement Balance = doc.CreateElement("Balance");

//Add the values for each nodes

BankName.InnerText = row.Cells[2].ToString();

AccountNumber.InnerText = row.Cells[3].ToString();

BankType.InnerText = row.Cells[4].ToString();

Balance.InnerText = row.Cells[5].ToString();

//Construct the document

doc.AppendChild(root);

root.AppendChild(Subroot);

Subroot.AppendChild(BankName);

Subroot.AppendChild(AccountNumber);

Subroot.AppendChild(BankType);

Subroot.AppendChild(Balance);

doc.Save(path);

MessageBox.Show("Selected Record Edited Successfully");

}

LoadGrid();

}

Then run your application and see output :

Open/Close or Show/Hide Ajax Modalpopupextender using JavaScript in asp.net

2012-06-16T08:27:00.000-07:00

In previous posts I explained some of the samples relating to Ajax modalpopupextender. During the time whenever I worked on to prepare samples for Ajax modalpopupextender I got requirement like close the modalpopupextender whenever I click on close icon for that more check this example Ajax Confirmation box. Generally in Ajax modalpopupextender we will set two properties TargetControlID and CancelControlID like Ex: TargetControlID="btnShowPopup" CancelControlID="btnNo" Here whenever we click on btnShowPopup button control modalpopupextender will show popup and when we click on btnNo button it will close the popup. Now I want to open popup and close popup whenever click on other button controls also in that case what we can do? By using JavaScript $find() function we can show or hide modalpopupextender easily. JavaScript Functions will be like this Here 'ModalPopupExtender1' is our modalpopupextender id. Our Sample Page will be like this Untitled Page

how to import Contacts from GMAIL using ASP.NET and C# | ASP.NET,C#.NET,SQL Server, Ajax Samples and Tutorials

2012-03-22T00:50:00.001-07:00

how to import Contacts from GMAIL using ASP.NET and C# | ASP.NET,C#.NET,SQL Server, Ajax Samples and Tutorials

what are the Difference between ASP.NET 2.0 and ASP.NET 3.5 | Multi Targeting in asp.net | what are the Asp.net 3.5 features | ASP.NET,C#.NET,SQL Server, Ajax Samples and Tutorials

2012-03-22T00:49:00.001-07:00

what are the Difference between ASP.NET 2.0 and ASP.NET 3.5 | Multi Targeting in asp.net | what are the Asp.net 3.5 features | ASP.NET,C#.NET,SQL Server, Ajax Samples and Tutorials

Interview Questions Part-1 | What is Normalization | What is De Normalization | What is a Stored Procedure | What is a Trigger in SQL Server | ASP.NET,C#.NET,SQL Server, Ajax Samples and Tutorials

2012-03-22T00:48:00.001-07:00

how to show the confirmationbox using javascript in asp.net | ASP.NET,C#.NET,SQL Server, Ajax Samples and Tutorials

2012-03-22T00:45:00.001-07:00

how to show the confirmationbox using javascript in asp.net | ASP.NET,C#.NET,SQL Server, Ajax Samples and Tutorials

how to insert data into XML and how to retrieve data from XML or how to bind data to DataList using asp.net. | ASP.NET,C#.NET,SQL Server, Ajax Samples and Tutorials

2012-03-22T00:44:00.001-07:00

how to insert data into XML and how to retrieve data from XML or how to bind data to DataList using asp.net. | ASP.NET,C#.NET,SQL Server, Ajax Samples and Tutorials

Wcf Concepts

2011-12-18T21:29:00.000-08:00

Wcf Architecture
---------------------------------------------------------------------------------------------------------

For Details contact: http://www.codeproject.com/KB/WCF/WCF_Basics.aspx

C# Questions And Answers

2011-12-16T03:40:00.000-08:00

C# Questions And Answers

--------------------------------------

What’s the difference between private and shared assembly?
Private assembly is used inside an application only and does not have to be identified by a strong name. Shared assembly can be used by multiple applications and has to have a strong name.

What’s a strong name?
A strong name includes the name of the assembly, version number, culture identity, and a public key token.

Where are shared assemblies stored?
Global assembly cache.

What is a satellite assembly?
When you write a multilingual or multi-cultural application in .NET, and want to distribute the core application separately from the localized modules, the localized assemblies that modify the core application are called satellite assemblies.

What namespaces are necessary to create a localized application?
System.Globalization, System.Resources.

Which one is trusted and which one is untrusted?
Windows Authentication is trusted because the username and password are checked with the Active Directory, the SQL Server authentication is untrusted, since SQL Server is the only verifier participating in the transaction

Difference between value and reference type. what are value types and reference types?
Value type - bool, byte, chat, decimal, double, enum , float, int, long, sbyte, short, strut, uint, ulong, ushort
Value types are stored in the Stack
Reference type - class, delegate, interface, object, string
Reference types are stored in the Heap

What are the two kinds of properties.
Two types of properties in .Net: Get and Set

Which controls do not have events?
Timer control.

What is the maximum size of the textbox?

65536.

Which property of the textbox cannot be changed at runtime?
Locked Property.

Does C# support multiple-inheritance?
No.uses Interface

What’s the top .NET class that everything is derived from?
System.Object.

What is the .NET datatype that allows the retrieval of data by a unique key?
HashTable.

What is a delegate?
A delegate is a type safe function pointer. Using delegates you can pass methods as parameters. To pass a method as a parameter, to a delegate, the signature of the method must match the signature of the delegate. This is why, delegates are called type safe function pointers.
What is the main use of delegates in C#?
Delegates are mainly used to define call back methods.

What do you mean by chaining delegates?
Or
What is a multicast delegate?
The capability of calling multiple methods on a single event is called as chaining delegates. Let me give you an example to understand this further.
1. Create a new asp.net web application
2. Drag and drop a button control and leave the ID as Button1.
3. On the code behind file, add the code shown below.

When you click the Button now, both Method1 and Method2 will be executed. So, this capability of calling multiple methods on a single event is called as chaining delegates. In the example, we are using EventHandler delegate, to hook up Method1 and Method2 to the click event of the button control. Since, the EventHandler delegate is now pointing to multiple methods, it is also called as multicast delegate.

Will the following code compile?

No, the code does not compile. For the code to compile, the signature of Method1 should match the signature of SampleDelegate.

---------------------------------------------------------------------------------------

It is very important to keep the following points in mind when creating partial classes.
1. All the parts must use the partial keyword.
2. All the parts must be available at compile time to form the final class.
3. All the parts must have the same access modifiers - public, private, protected etc.
4. Any class members declared in a partial definition are available to all the other parts.
5. The final class is the combination of all the parts at compile time.

What are the advantages of using partial classes?
1. When working on large projects, spreading a class over separate files enables multiple programmers to work on it at the same time.

2. When working with automatically generated source, code can be added to the class without having to recreate the source file. Visual Studio uses this approach when it creates Windows Forms, Web service wrapper code, and so on. You can create code that uses these classes without having to modify the file created by Visual Studio.

Is it possible to create partial structs, interfaces and methods?
Yes, it is possible to create partial structs, interfaces and methods. We can create partial structs, interfaces and methods the same way as we create partial classes.

Diff between System.Array.CopyTo() and System.Array.Clone()

2011-12-16T02:43:00.000-08:00

Diff between System.Array.CopyTo() and System.Array.Clone()
------------------------------------------------------------------

System.Array.CopyTo()-Copy the structure and value of the array

System.Array.Clone()-Only Copy the structure of the array

Stored Procedures

2011-11-23T22:36:00.001-08:00

Stored procedures are a powerful part of SQL Server. They can assist programmers and administrators greatly in working with the database configuration and its data.
A stored procedure is a precompiled group of Transact-SQL statements, and is saved to the database (under the "Stored Procedures" node). Programmers and administrators can execute stored procedures either from the SQL Server Management Studio or from within an application as required.
Transact-SQL, which is based on SQL (Structured Query Language), is the programming language used to interface between applications and their databases. Transact-SQL is a relatively easy language to learn and I highly recommend becoming familiar with it.

Benefits of Stored Procedures

Here are some key benefits in using stored procedures:

Benefit	Explanation of benefit
Modular programming	You can write a stored procedure once, then call it from multiple places in your application.
Performance	Stored procedures provide faster code execution and reduce network traffic. Faster execution: Stored procedures are parsed and optimized as soon as they are created and the stored procedure is stored in memory. This means that it will execute a lot faster than sending many lines of SQL code from your application to the SQL Server. Doing that requires SQL Server to compile and optimze your SQL code every time it runs. Reduced network traffic: If you send many lines of SQL code over the network to your SQL Server, this will impact on network performance. This is especially true if you have hundreds of lines of SQL code and/or you have lots of activity on your application. Running the code on the SQL Server (as a stored procedure) eliminates the need to send this code over the network. The only network traffic will be the parameters supplied and the results of any query.
Security	Users can execute a stored procedure without needing to execute any of the statements directly. Therefore, a stored procedure can provide advanced database functionality for users who wouldn't normally have access to these tasks, but this functionality is made available in a tightly controlled way.

Creating a Stored Procedure

You create stored procedures in the SQL Server Management Studio using the CREATE PROCEDURE statement, followed by the code that makes up the stored procedure.

CREATE PROCEDURE StoredProcedureName AS
...

The following code creates a stored procedure called "MyStoredProcedure":

CREATE PROCEDURE MyStoredProcedure AS
SET ROWCOUNT 10
SELECT Products.ProductName AS TenMostExpensiveProducts, Products.UnitPrice
FROM Products
ORDER BY Products.UnitPrice DESC

Please refer:http://www.quackit.com/sql_server/sql_server_2008/tutorial/sql_server_stored_procedures.cfm

ASP.NET MVC

2011-11-23T22:05:00.001-08:00

Introduction

Well, this is my eleventh article. This time, I have tried a new idea about the HTML 5 controls for ASP.NET MVC.

What is ASP.NET MVC?

ASP.NET MVC is a part of the ASP.NET Web application framework. It is one of the two different programming models you can use to create ASP.NET Web applications, the other being ASP.NET Web Forms.
An MVC Application is designed and implemented using the following three attributes:

Model: The model contains the core information for an application. This includes the data and validation rules as well as data access and aggregation logic.
View: The view encapsulates the presentation of the application, and in ASP.NET this is typically the HTML markup.
Controller: The controller contains the control-flow logic. It interacts with the Model and Views to control the flow of information and execution of the application.

This separation of entity allows you to have nimbleness and flexibility in building and maintaining your application. For example, by separating the views, you can iterate on the appearance of your application without touching on any of the core business logic. You can also separate work by role, so that, for example designers can work on the views, while developers work on the model.
ASP.NET MVC brings the power of this development paradigm to ASP.NET development, allowing you to use your .NET development skills to build MVC applications.
It:

gives you complete control over your HTML Markup
enables rich AJAX and jQuery integration
allows you to create SEO-friendly URLs for your site
makes Test Driven Development (TDD) easy

Sample Code For Asp.net

2011-08-12T04:24:00.000-07:00

===== Inline code =====
<source lang="csharp">
<%@ Page Language="C#" %>
<!DOCTYPE html PUBLIC "---//W3C//DTD XHTML 1.0 //EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<script runat="server">
protected void Page_Load(object sender, EventArgs e)
{
// Assign the datetime to label control
lbl1.Text = DateTime.Now.ToLongTimeString();

}
</script>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>Sample page</title>
</head>
<body>
<form id="form1" runat="server">
<div>
The current time is: <asp:Label runat="server" id="lbl1" />
</div>
</form>
</body>
</html>
</source>
The above page renders with the Text "The current time is: " and the <asp:Label> Text is set with the current time, upon render.