C#

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Net.Mail;
using System.Net;


namespace Mail_Send
{
    public partial class Form4 : Form
    {
        SmtpClient obj_SMTPClient;
        MailMessage Obj_MailMsg;
        Attachment obj_Attachment;
        //string pBar;
       
        
        public Form4()

        {
            InitializeComponent();            
        }
        
        private void Form4_Load(object sender, EventArgs e)
        {

        }

        private void button1_Click(object sender, EventArgs e)
        {
            OpenFileDialog open = new OpenFileDialog();
            if (open.ShowDialog() == DialogResult.OK)
            {
                label3.Text = open.FileName;
            }
        }

        private void button3_Click(object sender, EventArgs e)
        {
            this.Close();
        }

        private void SendMail_Click(object sender, EventArgs e)
        {
            if (textBox1.Text == "" || textBox2.Text == "" || textBox3.Text == "")
            {
                MessageBox.Show("please fill, don't let a column blank!!!");
            }
            else
                try
                {
                    obj_SMTPClient = new SmtpClient("smtp.gmail.com");
                    Obj_MailMsg = new MailMessage();
                    obj_Attachment = new System.Net.Mail.Attachment(label3.Text);
                    Obj_MailMsg.From = new MailAddress(textBox1.Text);
                    Obj_MailMsg.To.Add(textBox3.Text);
                    Obj_MailMsg.Body = textBox5.Text;
                    Obj_MailMsg.Attachments.Add(obj_Attachment);
                    Obj_MailMsg.Subject = textBox4.Text;
                    SmtpClient smtps = new SmtpClient("smtp.gmail.com", 587);
                    obj_SMTPClient.Credentials = new NetworkCredential();
                    obj_SMTPClient.Port = 587;
                    obj_SMTPClient.Credentials = new System.Net.NetworkCredential(textBox1.Text, textBox2.Text);
                    obj_SMTPClient.EnableSsl = true;
                    obj_SMTPClient.Send(Obj_MailMsg);

                    obj_SMTPClient.EnableSsl = true;
                    obj_SMTPClient.Send(Obj_MailMsg);
                    MessageBox.Show("Message Successful sent!!!");
                }
                catch
                {
                    MessageBox.Show("Sorry, Request TimeOut!!!");
                }
        } 

        private void button4_Click(object sender, EventArgs e)
        {
                
        }     
     
         
    

        private void button8_Click(object sender, EventArgs e)
        {
            foreach (Control sayre in this.Controls)
            {
                if (sayre is TextBox)
                {
                    (sayre as TextBox).Clear();
                }
            } 
        }

        private void button6_Click(object sender, EventArgs e)
        {
           
        }

        private void button5_Click(object sender, EventArgs e)
        {
           
        }

        private void button4_Click_1(object sender, EventArgs e)
        {
            foreach (Control sayre in this.Controls)
            {
                if (sayre is TextBox)
                {
                    (sayre as TextBox).Clear();
                }
            }  
        }       
        
        
        }
    }  

<FunctionImport Name="GetAllBlogsAndPosts"> 
  <ReturnType EntitySet="Blogs" Type="Collection(BlogModel.Blog)" /> 
  <ReturnType EntitySet="Posts" Type="Collection(BlogModel.Post)" /> 
</FunctionImport>

using (var db = new MyEntities())
            {
                using (IDbConnection oaConnection = db.Database.Connection)
                {
                    // 3. Create a new instance of the OACommand class.
                    using (IDbCommand oaCommand = oaConnection.CreateCommand())
                    {
                        // 4. Set the CommandType property.
                        oaCommand.CommandType = CommandType.StoredProcedure;

                        // 5. Set the CommandText property.
                        oaCommand.CommandText = "gsp_get_emp_details";
                        oaCommand.Parameters.Add(empInput.EmployeeId);
                        oaCommand.Parameters.Add(empInput.UserId);
                        oaCommand.Parameters.Add(empInput.RoleList);

                        // 6. Execute the command and materialize the car entities
                        using (IDataReader dataReader = oaCommand.ExecuteReader())
                        {
                            EmployeeData empData = db.Translate<EmployeeData>(dataReader as DbDataReader);
}
}
}
}

using System.Data.Objects;

DataTabel.ReadXml(XMLFilename)

public string GetKeyValue(string key)
       {
           System.Xml.XmlDocument xd = new System.Xml.XmlDocument();
           xd.Load(_XMLFileName);
           System.Xml.XmlNode Node = xd.DocumentElement.SelectSingleNode("/REPORTTABLE/REPORTTABLEDETAILS/PARTNUM add[@key=\"" + key + "\"]");

           if ((Node != null))
           {
               return Node.Attributes.GetNamedItem("value").Value;
           }
           else
           {
               return null;
           }
       }

<?xml version="1.0" encoding="Shift_JIS" ?>
<?xml:stylesheet type="text/xsl" href="../Bin/KITSCHREPFLEXA.xsl" ?>
<DOCUMENT>
<REPORTHEADER>
<REPORTTIME>2014/07/11 13:36:44</REPORTTIME>
<CREATEBY>Fujiuser</CREATEBY>
<SCHEDULENAME>Week_23_2014</SCHEDULENAME>
</REPORTHEADER>
<REPORTTABLE>
<REPORTTABLEDETAILS>
<JOBNAMES><JOBNAME>260-C536000-PACE - Top_TLine 1 / Line 1 / Top / 1</JOBNAME></JOBNAMES>
<JOBNAMES><JOBNAME>260-C536000-PACE - Top_BLine 2 / VEK Line 2 / Bottom / 1</JOBNAME></JOBNAMES>
<DATANUM>38</DATANUM>
<PARTBARCODE>938-1030507</PARTBARCODE><ORIGINALPARTBARCODE>938-1030507</ORIGINALPARTBARCODE><PARTNUM>938-1030507</PARTNUM>
<SUPPLYNUM>2</SUPPLYNUM>
<ACTUALNUM>2</ACTUALNUM>
<REMAINSNUM>0</REMAINSNUM>
<QTYSUPPLYNUM>4</QTYSUPPLYNUM>
<QTYACTUALNUM>6249</QTYACTUALNUM>
<QTYREMAINSNUM>6245</QTYREMAINSNUM>
</REPORTTABLEDETAILS>
<REPORTTABLEDETAILS>
<DATANUM></DATANUM>
<PARTBARCODE>948-1025627</PARTBARCODE><ORIGINALPARTBARCODE>948-1025627</ORIGINALPARTBARCODE><PARTNUM>948-1025627</PARTNUM>
<SUPPLYNUM>2</SUPPLYNUM>
<ACTUALNUM>1</ACTUALNUM>
<REMAINSNUM>-1</REMAINSNUM>
<QTYSUPPLYNUM>40</QTYSUPPLYNUM>
<QTYACTUALNUM>6720</QTYACTUALNUM>
<QTYREMAINSNUM>6680</QTYREMAINSNUM>
</REPORTTABLEDETAILS>