Friday, 10 August 2012

jave script key code

When we use keyboard keys in your JavaScript function then the following codes will be useful to write condition statement in your function.
For Example:
We have one textbox and button for login for that you type your username in textbox then instead of clicking Login button if you click on enter key in your keyboard then it has to be login.
For  that the following function will work in onkeypress event.
The enter key value is 13.
<input type="text" id="txtSearch" onkeypress="searchKeyPress(event);" />
    <input type="button" id="btnSearch" Value="Search" onclick="anyfunction();" />

    <script>
    function searchKeyPress(e)
    {
        if (typeof e == 'undefined' && window.event) { e = window.event; }
        if (e.keyCode == 13)
        {
            document.getElementById('btnSearch').click();
        }
    }
    </script>
The following are Java script   Key Codes for Keyboard Characters :
backspace
8
tab
9
 enter
13
shift
16
ctrl
17
alt
18
pause/break
19
caps lock
20
escape
27
page up
33
page down
34
end
35
home
36
left arrow
37
up arrow
38
right arrow
39
down arrow
40
insert
45
delete
46
0
48
1
49
2
50
3
51
4
52
5
53
6
54
7
55
8
56
9
57
a
65
b
66
c
67
d
68
      e
     69
      f
     70
      g
     71
      h 
     72
      i
     73
      j 
     74
      k
     75
      l 
     76
      m
     77
      n
     78
      o 
     79
      p
     80
      q
     81
      r
     82
      s
     83
     T
     84
     U
     85
     V
     86
     W
     87
     X
     88
     y
     89
     z
     90
  Left window key
     91
  Right window key
     92
  Select key
     93
  numpad 0
     96
  numpad 1
     97
  numpad 2
     98
  numpad 3
     99
  numpad 4
    100
  numpad 5 
    101
  numpad 6
    102
  numpad 7
    103
  numpad 8 
    104
  numpad 9
    105
  multiply
    106
  add
    107
  subtract
    109
  decimal point
    110
  divide
    111
  f1
    112
  f2
    113
  f3
    114
  f4
    115
  f5
    116
  f6
    117
  f7
    118
  f8
    119
  f9
    120
  f10
    121
  f11
    122
  f12 
    123
  num lock
    144
  scroll lock
    145
  semi-colon
    186
  equal sign
    187
  comma
    188
  dash
    189
  period
    190
  forward slash
    191
  grave accent 
    192
  open bracket
    219
  back slash
    220
  close braket
    221
  single quote
    222

xml data insert update

This article is shows about insert data into XML file instead of using SqlServer database.
For that first Design your form as per your requirements.
In this am adding daily expenses of a person for that am taking fields as Date,  Amount, Purpose, Source  Bank and one Save button like below:
For accessing XML file add the following namespace in top of your code:
                         using System.Xml;
Write the following code in your Save button Click:
private void btnsave_Click(object sender, EventArgs e)
        {
            string path = "Expences.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");
                doc.AppendChild(declaration);
                doc.AppendChild(comment);
            }
            else //If there is already a file
            {
                //    //Load the XML File
                doc.Load(path);
            }
            //Get the root element
            XmlElement root = doc.DocumentElement;
            XmlElement Subroot = doc.CreateElement("Expences");
            XmlElement Date = doc.CreateElement("Date");
            XmlElement Amount = doc.CreateElement("Amount");
            XmlElement Purpose = doc.CreateElement("purpose");
            XmlElement Source = doc.CreateElement("Source");
            XmlElement Bank = doc.CreateElement("Bank");
            //Add the values for each nodes
            Date.InnerText = Convert.ToDateTime(dateTimePicker1.Text).ToShortDateString();
            Amount.InnerText = txtAmount.Text;
            Purpose.InnerText = txtPurpose.Text;
            if (radioButton1.Checked)
            {
                Source.InnerText = "Cash";
                Bank.InnerText = " ";
            }
            else
            {
                Source.InnerText = "Bank";
                Bank.InnerText = comboBox1.SelectedItem.ToString();
            }
           
            Subroot.AppendChild(Date);
            Subroot.AppendChild(Amount);
            Subroot.AppendChild(Purpose);
            Subroot.AppendChild(Source);
            Subroot.AppendChild(Bank);
            root.AppendChild(Subroot);
            doc.AppendChild(root);
            //Save the document
            doc.Save(path);
            //Show confirmation message
            MessageBox.Show("Details  added Successfully");
            //Reset text fields for new input
            txtPurpose.Text = String.Empty;
            txtAmount.Text = String.Empty;
        }
       
      Then run your application and see output like below:
To see your saving data in XML file do the following steps:
Select your solution from Solution Explorer
Right click and Select Open Folder in Windows Explorer
Then your application folder will open in that double click on bin folder  then double click debug folder
Then you will see your Expenses XML document file à double click on it then you will see your Saving Data in your browser like below:
Retrieve data from XML file and show in DataGridview :
For showing these saving data into DataGridview, am taking one Show button and DataGridview Control in the form:
Write the following code in show button click:
     private void btnShow_Click(object sender, EventArgs e)
        {
                XmlReader xmlFile;
                xmlFile = XmlReader.Create("Expences.xml"new XmlReaderSettings());
                DataSet ds = new DataSet();
                ds.ReadXml(xmlFile);
                dataGridView1.DataSource = ds.Tables[0];
            }
Then you will see your data binding to DataGridview like below: