smartcode: January 2014

Tuesday, January 7, 2014

Create New XML file using C#

I want to create xml file using c#. so i have to created like
XML File source file.

<Students>
    <Student>
      <Name>senthil</Name>
      <Subject1>50</Subject1>
      <Subject2>60</Subject2>
      <Subject3>70</Subject3>
      <Subject4>80</Subject4>
      <Image>
 <ImageOrigin>
  <X>1</X>
  <Y>10</Y>
 </ImageOrigin>

      </Image>
    </Student>
</Students>

Created xml using c# code.

XDocument document = new XDocument();
XElement rootElement = new XElement("Students");

foreach(Student student in StudentsCollection)
{
    XElement studentElement = new XElement("Student");
    
    studentElement.Add(new XElement("Name") { Value = student.Name });
    studentElement.Add(new XElement("Subject1") { Value = student.Subject1 });
    studentElement.Add(new XElement("Subject2") { Value = student.Subject2 });
    studentElement.Add(new XElement("Subject3") { Value = student.Subject3 });
    studentElement.Add(new XElement("Subject4") { Value = student.Subject4 });
    studentElement.Add(new XElement("Image"));

    XElement imageElement = studentElement.Element("Image");

    imageElement.Add(new XElement("ImageOrigin"));

    XElement imageOriginElement = imageElement.Element("ImageOrigin");

    imageOriginElement.Add(new XElement("X") { Value = "1" });
    imageOriginElement.Add(new XElement("Y") { Value = "10" });

    rootElement.Add(studentElement);
}

document.Add(rootElement);
document.Save("D:\Stduent.xml");

Remove the space in textbox using JavaScript

This code remove the space in form textbox value on onkeydown Event using .net form and JavaScript.

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Untitled Document</title>
<script type="text/javascript">
message = ("Sorry, you are not allowed to enter any spaces");
function nospaces(which) {
x = which.value
if (navigator.appName == "Netscape" ) {
if (e.which == 32) {
alert (message);
return false
}
}
if (navigator.appName == "Microsoft Internet Explorer") {
if (event.keyCode == 32) {
alert (message);
return false;
}
}
x = x.replace(/\s/g,""); // remove the unwanted space
document.myform.textbox.value = x;
}
</script>
</head>

<body>
<form name = "myform" action="#" method="post" >
<input type="text" name ="textbox" id="textbox" onkeydown="nospaces(this)">

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

Monday, January 6, 2014

Update query in Wordpress Option table cloumn "guid"

This query for wordpress option table quid cloumn url change.

UPDATE wp_options SET option_value = replace(option_value, 'http://www.oldurl', 'http://www.newurl') WHERE option_name = 'home' OR option_name = 'siteurl';

UPDATE wp_posts SET guid = replace(guid, 'http://www.oldurl','http://www.newurl');

UPDATE wp_posts SET post_content = replace(post_content, 'http://www.oldurl', 'http://www.newurl');

UPDATE wp_postmeta SET meta_value = replace(meta_value,'http://www.oldurl','http://www.newurl');

Pages

Tuesday, January 7, 2014

Create New XML file using C#

Remove the space in textbox using JavaScript

Monday, January 6, 2014

Update query in Wordpress Option table cloumn "guid"