How to insert data into XML file?

Tags : Insert,Data,XML File,Asp.Net,C#.Net

Hi Friends,in this post i would like to explain how to insert data into XML file.

* Here in my example i am stored Name,Location,Email & Gender fields into XML file.For this i took 3 TextBoxes,DropDownList for Gender,Button & a label for displaying message.

* Added XML file with name(InsertData)
For this Go To SolutionExplorer-->Right Click on ApplicationName-->AddNewItem-->Select XML File-->Give Name as InsertData-->Click on Add button.


Design View :









Source Code :

Default.aspx.cs :

using System;
using System.Configuration;
using System.Data;
using System.Linq;
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.Xml;

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

}

protected void ButtonInsertXML_Click(object sender, EventArgs e)
{
   // Open the XML doc
   System.Xml.XmlDocument myXmlDocument = new System.Xml.XmlDocument();
   myXmlDocument.Load(Server.MapPath("InsertData.xml"));
   System.Xml.XmlNode myXmlNode = myXmlDocument.DocumentElement.FirstChild;

   // Create new XML element and populate its attributes
   System.Xml.XmlElement myXmlElement = myXmlDocument.CreateElement("entry");
   myXmlElement.SetAttribute("Name", Server.HtmlEncode(TextBoxName.Text));
   myXmlElement.SetAttribute("Location", Server.HtmlEncode(TextBoxLocation.Text));
   myXmlElement.SetAttribute("Email", Server.HtmlEncode(TextBoxEmail.Text));
   myXmlElement.SetAttribute("Gender", Server.HtmlEncode(DropDownListGender.SelectedItem.Text));


   // Insert data into the XML doc and save
   myXmlDocument.DocumentElement.InsertBefore(myXmlElement, myXmlNode);
   myXmlDocument.Save(Server.MapPath("InsertData.xml"));

   // Re-bind data since the doc has been added to
   BindData();

   LabelMessage.Text = "Record inserted Successfully Inside the XML File...";

   TextBoxName.Text = "";
   TextBoxLocation.Text = "";
   TextBoxEmail.Text = "";

}

void BindData()
{
   XmlTextReader myXmlReader = new XmlTextReader(Server.MapPath("InsertData.xml"));
   myXmlReader.Close();

}
}

* Then finally Build & Run the application & insert sample input data.It will automatically insert data into InsertData.xml file.


Thank You...

Readmore...

Example on Windows Service

Hi Friends,in this post i would like to explain windows service for displaying message box for every 3 seconds.

Step 1:

* Open windows service project with projectName WinService1
* Goto ToolBox-->General-->Right Click-->Select choose items-->Select Timer(Systems.Timers)
* Project-->AddReference-->System.Windows.Forms(Message Box is a part of above reference).
* Place a Timer(System.Timers) with interval-3000 & enabled-false.

Code:

{//timer1_Elapsed event.
System.Windows.Forms.MessageBox.Show("This message from Windows Service.");
}

Code for OnStart() event
{
timer1.Enabled=true;
}

Code for OnStop() event
{
timer1.Enabled=false;
}

Step 2:

* Open service1.cs[design]
Right Click
Add installer(Select).
Then 2 controls will be added to the form.
1)ServiceProcessInstaller-->Choose properties-->Account=LocalSystem.
2)ServiceInstaller-->Properties-->ServiceName=MessageBoxDisplay

* Build the project(Build-->Select Build solution)

Note:
* WinService1.exe is created under:
D:\WinService1\bin\debug folder with a service name called as "MessageBoxDisplay"

Step 3:

* open .Net Command prompt.
Start-->Programs-->MSVisualStudio2005-->VSTools-->.Net Command Prompt.
>installutil -i D:\WinService1\bin\debug\WinService1.exe (press enter)
>....
>....
>....
>transaction install has completed.

Step 4:

* Open service(Start-->run-->services.msc)
* MessageBoxDisplay-->RightClick-->Properties-->Logon-->Check "interact with desktop" checkBox-->OK
(Only service contains MessageBox otherwise above step is not required).
* MessageBoxDisplay-->rightClick-->Start.

Then service will be started & MessageBox with message(This message from Windows Service.) will be displayed for every 3 seconds.


Thank You...

Readmore...

Introduction to Windows Services.

Hi friends,in this post i would like to explain some basic things to know about windows services.

* A service which is under control of windows OS is called windows service.
* Windows services are used to develop automated background processes.
* Windows services contains only application logic but not GUI(Graphical User Interface).
* The controls which are not visible at runtime,can be placed in windows service projects.

For example:
Timer Control,Event log control,File system watcher control.

* To develop windows services .Net provided:
File-->NewProject-->VisualC#-->Windows-->WindowsServiceTemplate.
* Windows service project is avilable in VisualStudio .Net 2005 professional edition,but not available in Standard edition.
* To develop windows service .Net provided a name space:
System.ServiceProcess(NameSpace).
* All the windows services will be stored at:
Start-->Settings-->ControlPanel-->AdministrativeTools-->Services
OR
Start-->run-->Services.msc
* While a service is starting OnStart() event will be executed & while stoping OnStop() event will be executed.

Steps for developing Windows Service:

1)Open windows service project & wrie the required logic.
2)Add the installers & build the project to get an exe file as output.
3)Open .Net command prompt & install exefile with following syntax:
installutil -i exefile path //for installing the service.
installutil -u exefile path //for uninstalling the service.
4)Start the service.

Thank you...

Readmore...

Saving images to our application.

Hi Friends,in this post i would like to explain how to save images from our PC to application.

* For this i took one FileUpLoad control, Button control and a Label control for displaying message.

Add the following name space:
using System.IO;

Code for button click event():

protected void Button1_Click(object sender, EventArgs e)
{
try
{
string filePath = FileUpload1.PostedFile.FileName;

string filename = Path.GetFileName(filePath);

FileUpload1.PostedFile.SaveAs(@"F:\\Asp.Net\FileUpload\Images\" + filename);

Label1.Text = "Image uploaded successfully.";
}
catch
{
Label1.Text = "Failed to upload image.";
}
}

Note:
F:\\Asp.Net\FileUpload is the application path.
Created Images folder in my application and saving uploaded images into Images folder.

Thank you...

Readmore...

Unique Key on 2 columns in SQL Server.

Hi friends,in this post i would like to explain how to create Unique Key on 2 columns in SQL Server.

For Example:

Here i am created Unique Key for 2 columns(Name,SurName) on College table.

CREATE TABLE [dbo].[College] ADD CONSTRAINT [UK_College] UNIQUE NONCLUSTERED
(
[Name] ,
[SurName]
)
WITH (PAD_INDEX = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF) ON [PRIMARY]

Thank you...

Readmore...

Set Operators in SQL Server.

Hi Friends,in this post i would like to explain Set Operators in SQL Server.

*Set Operators are used to combined the data from multiple tables.

Set Operators:
1)UNION
2)UNION ALL
3)INTERSECT
4)EXCEPT

Syntax:
Select query1

Select query2

Select query3

......
......
......

1)UNION
*UNION can select only distinct/unique rows & rows can be arranged in ascending order.

2)UNION ALL
*UNION ALL is used to combine all rows from the given select queries.

3)INTERSECT
* UNION ALL is used to select only common rows from the given set of select queries.

4)EXCEPT
* EXCEPT is equalent to Minus operator in Oracle.To select all rows from the first query,except second query output.

Limitations:
* All queries should have equal number of columns.
* Corresponding column data types should be same.

Thank you...

Readmore...

Constraints in SQL Server.

Hi Friends, in this post I would like to explain Constraints in SQL Server.

* Constraint is a mechanism which can be activated automatically when the specified event is occurred.

* Constraint is a role it can be defined on the selected columns in order to prevent invalid data.

* It is one of the data integrity concepts to enforce integrity explicitly.

Different types of constraints:

1) Not Null: It does not allow null values in the specified column.

2) Check: It is used to validating user conditions.

3) Unique: It doesn’t allow duplicate values in the specified column & it allows only single NULL value.

4) Primary Key: It doesn’t allow duplicate & NULL values.

5) Foreign Key: This is for establishing relation between 2 tables. One table will act as Parent & another will act as Child. And it is associated with either Primary key (or) Unique Constraints.

* For establishing the relation between the tables should maintain at least one common column.

* Foreign key allows duplicate & Null values.

* Only one Primary Key allowed for table.

* Maximum 253 Foreign Keys allowed for table.

* We can define only Primary Key/Unique Key on a single column.

6) Default: It is for defining user default values instead of storing system default values.

Syntax for defining constraints:

Create table tableName

(Column1 datatype Constraint1 Constraint2 ....,

Column2 datatype Constraint1 Constraint2 ....,

.........)

For Example:

Create table Department

(DeptId int PrimaryKey,

DeptName varchar(20) Unique NotNull,

Location varchar(20) Default ‘Hyderabad’)

Thank You…

Readmore...

Java Script function for Printing Div content.

Hi Friends, in this post I would like to explain Java Script function for Printing Div content.

Here I took one Button control for printing the content.

JavaScript Function:

<script type ="text/javascript" language ="javascript">

function Print(elementId)

{

var printContent = document.getElementById(elementId);

var windowUrl = 'about:blank';

var uniqueName = new Date();

var windowName = 'Print' + uniqueName.getTime();

var printWindow = window.open(windowUrl, windowName, 'left=50000,top=50000,width=0,height=0');

printWindow.document.write(printContent.innerHTML);

printWindow.document.close();

printWindow.focus();

printWindow.print();

printWindow.close();

}

script>

Div content:

<div id="printDivContent" >

Here we can place any content like controls,text……

div>

Calling div from the Button control:

<asp:Button ID="btnPrint" runat="server" onclientclick="javascript:Print('printDivContent');" Text="Print"

Width="50px" />

Thank You…

Readmore...

Java Script function for entering only Integers values in Textbox.

Hi Friends, in this post I would like to explain Java Script function for entering only Integers values in Textbox.

JavaScript Function:

<script type="text/javascript" language="javascript">

function isNumberKey()

{

if(!(((event.keyCode>=48&&event.keyCode<=57) || (event.keyCode>=96&&event.keyCode<=105))||(event.keyCode==8) || (event.keyCode==9) || (event.keyCode==37) || (event.keyCode==39) || (event.keyCode==46) || (event.keyCode==190)))

event.returnValue=false;

}

script>

Calling the above function from Textbox control:

<asp:TextBox ID="txtNumericValue" runat="server" Width="120px" onkeydown="isNumberKey();">asp:TextBox>

So that we can enter only Integer Values in the TextBox.

Thank You…

Readmore...

Windows application for converting Text into Speech.

Hi Friends, in this post I would like to explain how to convert Text into Speech.

· Open windows application.

· Place a TextBox & a Button control on to the form.

· Goto ProjectMenu---> Add Reference---> COM---> MicrosoftSpeechObjectLibrary (Add this reference).

· Add the following namespace: using SpeechLib;

Please go through the code under button click event:

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Text;

using System.Windows.Forms;

using SpeechLib;

namespace TextToSpeech

{

public partial class Form1 : Form

{

public Form1()

{

InitializeComponent();

}

private void btnClick_Click(object sender, EventArgs e)

{

SpVoice voice = new SpVoice();//Where SpVoice is the Speakers Voice.

voice.Speak(textBox1.Text,SpeechVoiceSpeakFlags.SVSFDefault);

}

}

}

Thank You...

Readmore...

Deleting files from the system in ASP.Net.

Hi Friends, in this post I would like to explain how to delete the file existing on the system.

For this I took 1 FileUpload, 1 Button & 1 label control on to the page.

Please find the source code below:

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default"%>

<!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>Untitled Page</title>

</head>

<body>

<form id="form1" runat="server">

<div>

<table width="300px">

<tr>

<td>

<asp:FileUpload ID="fuLoad" runat="server" />

</td>

<td>

<asp:Button ID="btnDelete" runat="server" Text="Delete File"

onclick="btnDelete_Click" />

</td>

</tr>

<tr>

<td colspan="2">

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

</td>

</tr>

</table>

</div>

</form>

</body>

</html>

Then please find the Code for deleting the file:

using System;

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.IO;

public partial class _Default : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

}

protected void btnDelete_Click(object sender, EventArgs e)

{

string filePath = fuLoad.PostedFile.FileName;

if (File.Exists(filePath.Trim()))

{

File.Delete(filePath.Trim());

lblDisplayMessage.Text="File Deleted Successfully";

}

else

{

lblDisplayMessage.Text = "File does not exist.";

}

}

}

Thank You...

Readmore...

Creating dynamic controls in asp.net web application.

Hi Friends,In this example i would like to explain how to create controls(Label,TextBox,DropDownList) dynamically.


For this i took 1 button(Access) & place holder control on the form.

Code under page load:

protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{

}
else
{
createDynamicControls();
}
}

Code for method createDynamicControls():

protected void createDynamicControls()
{

Label lblCompanyName = new Label();
lblCompanyName.ID="lblCName1";
lblCompanyName.Style.Add("left", "15px");
lblCompanyName.Text = "Company Name:";
pholder1.Controls.Add(lblCompanyName);

TextBox txtCompanyName = new TextBox();
txtCompanyName.ID = "txtCName1";
txtCompanyName.Style.Add("left", "60px");
pholder1.Controls.Add(txtCompanyName);
Label lblCountry= new Label();
lblCountry.ID="lblCountry1";
lblCountry.Style.Add("left", "495px");
lblCountry.Text = "Country:";
pholder1.Controls.Add(lblCountry);


DropDownList ddlCountry= new DropDownList();
ddlCountry.ID = "ddlCountry1";
ddlCountry.Style.Add("left", "540px");
ddlCountry.Style.Add("width", "120px");
ddlCountry.Items.Add("Select");
ddlCountry.Items.Add("India");
ddlCountry.Items.Add("Srilanka");
ddlCountry.Items.Add("Bangladesh");
pholder1.Controls.Add(ddlCountry);

}


Code under AccessButton click event:

protected void AccessButton_Click(object sender, EventArgs e)
{

TextBox txtCompany = pholder1.FindControl("txtCName1") as TextBox;

DropDownList ddlCountry = pholder1.FindControl("ddlCountry1") as DropDownList;
}
Note:

* We can't access controls directly.For this we can add controls to PlaceHolder.From this PlaceHolder we can access controls.


Thank You...

Readmore...

Sending email with attachments in ASP.Net.

Hi friends,in this post I would like to explain how to send email with attachments in Asp.Net.

For this I am taking 3 TextBoxes(For ToAddress,Subject & Body),FileUpload control,label for displaying message and a Button control.

For working with emails you need to add the following namespace:

using System.Net.Mail;

Then code under Send Button Click Event:

protected void btnSendEmail_Click(object sender, EventArgs e)

{

MailMessage mssg = newMailMessage();

mssg.From = new MailAddress("yourgmailid@gmail.com");

mssg.To.Add(txtToAddtess.Text);

mssg.Subject = txtSubject.Text;

mssg.IsBodyHtml = true;

mssg.Body = txtBody.Text;

mssg.Priority = MailPriority.High;

string strFName = null;

strFName = Path.GetFileName(fulAttach.PostedFile.FileName);

fulAttach.PostedFile.SaveAs(Server.MapPath(strFName ));

Attachment attach = new Attachment(Server.MapPath(strFName ));

mssg.Attachments.Add(attach);

System.Net.Mail.SmtpClient client = new system.Net.Mail.SmtpClient();

client.UseDefaultCredentials = false;

client.Credentials = new System.Net.NetworkCredential("yourgmailid@gmail.com", "yourgmailpassword");

client.Port = 587;

client.Host = "smtp.gmail.com";

client.EnableSsl = true;

object userstate = mssg;

client.Send(mssg);

lblDisplayMessage.Text = "Mail Sent Successfully.";

}

Note: where fulAttach is file upload control ID.

Then it will send email along with attachment.


Thank You...

Readmore...

DDL Statements in SQL Server.

Hi friends,in this post i would like to explain DDL commands in SQL Server.

There are 3 types of DDL commands exist:

1)CREATE 2)ALTER 3)DROP

1)CREATE : For creating databases & database objects.

Syntax for creating database:

CREATE DATABASE DataBaseName

For Ex:

Create DataBase College


Syntax for creating Table:

CREATE TABLE TableName
(Column1 datatype,
Column2 datatype,
.......
.......)

For Ex:

Create Table Employee
(EmpId int,EmpName varchar(50),Salary money)


2)ALTER : For altering the exsisting tables.

Syntax for adding columns:

Alter Table TableName Add Column1 datatype,Column2 datatype,.....

For Ex:

Alter Table Employee Add DateOfJoin datetime,Address varchar(300)

Syntax for changing column datatype:

Alter Table TableName Alter Column ColumnName NewDataType

For Ex:

Alter Table Employee Alter Column EmpId BigInt

Syntax For Droping Columns:

Alter Table TableName Drop Column Column1,Column2,.....

For Ex:

Alter Table Employee Drop Column DateOfJoin,Address


3)DROP : is used for droping database & database objects.

Syntax for droping Tables:

Drop Table table1,table2,...

For Ex:

Drop Table Employee

Syntax for droping databases:

Drop DataBase database1,database2,...

For Ex:

Drop DataBase College

Note:

* We can't drop current(working) database.
* We can't drop system databases(i.e Master,Model,Msdb,Tempdb).



Thank You...

Readmore...

Sending email in ASP.Net.

Hi friends,in this post I would like to explain how to send email in Asp.Net.

For this I am taking 3 TextBoxes(For ToAddress,Subject & Body) and a Button control.


For working with emails you need to add the following namespace:
using System.Net.Mail;
Then code under Send Button Click Event:


protected void btnSendEmail_Click(object sender, EventArgs e) {
MailMessage mssg = newMailMessage(); mssg.From = new MailAddress("yourgmailid@gmail.com"); mssg.To.Add(txtToAddtess.Text); mssg.Subject = txtSubject.Text; mssg.IsBodyHtml = true; mssg.Body = txtBody.Text; mssg.Priority = MailPriority.High; System.Net.Mail.SmtpClient client = new system.Net.Mail.SmtpClient(); client.UseDefaultCredentials = false; client.Credentials = new System.Net.NetworkCredential("yourgmailid@gmail.com", "yourgmailpassword"); client.Port = 587; client.Host = "smtp.gmail.com"; client.EnableSsl = true; object userstate = mssg; client.Send(mssg); lblDisplayMessage.Text = "Mail Sent Successfully.";//label for displaying message. }
Then email will be sent to destination person



Thank You...

Readmore...