C#

/* Program Created by
 * Name: Sai Ayilavarapu
 * Form Description: To create and validate registration form
 * Things thats are mandatory: username, email, password, security question, security answer
 */

using System;
using System.Configuration;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.ApplicationServices;
using System.Data;
using System.Data.SqlClient;
using DataClass;


public partial class Account_Register : System.Web.UI.Page
{

    ConnectionClass newobj = new ConnectionClass();
    protected void Page_Load(object sender, EventArgs e)
    {
        //RegisterUser.ContinueDestinationPageUrl = Request.QueryString["ReturnUrl"];
    }
  
    protected void CreateUserButton_Click(object sender, EventArgs e)
    {
        
        string F_Name = txtFirstName.Text;
        string L_Name = txtLastName.Text;
        string Address = txtAddress.Text;
        string City = txtCity.Text;
        string State = txtState.Text;
        string Zip = txtZipCode.Text;
        string DOB = txtDOB.Text;
        string Phone = txtPhone.Text;
        string email = txtEmail.Text;
        string User_Name = txtUserName.Text;
        string Password = txtPassword.Text;
        string PasswordQuestion = txtPasswordQuestion.Text;
        string PasswordAnswer = txtPasswordAnswer.Text;


        MembershipCreateStatus createStatus;
        MembershipUser newUser = Membership.CreateUser(txtUserName.Text, txtPassword.Text, txtEmail.Text, txtPasswordQuestion.Text, txtPasswordAnswer.Text, true, out createStatus);
        switch (createStatus)
        {
            case MembershipCreateStatus.Success:
                string UserId = newUser.ProviderUserKey.ToString(); //create provider key?
                lblCreateAccount.Text = "The user account was successfully created!";
                break;
            case MembershipCreateStatus.DuplicateUserName:
                lblCreateAccount.Text = "There already exists a user with this username.";
                break;

            case MembershipCreateStatus.DuplicateEmail:
                lblCreateAccount.Text = "There already exists a user with this email address.";
                break;
            case MembershipCreateStatus.InvalidEmail:
                lblCreateAccount.Text = "There email address you provided in invalid.";
                break;
            case MembershipCreateStatus.InvalidAnswer:
                lblCreateAccount.Text = "There security answer was invalid.";
                break;
            case MembershipCreateStatus.InvalidPassword:
                lblCreateAccount.Text = "The password you provided is invalid. It must be seven characters long and have at least one non-alphanumeric character.";

                break;
            default:
                lblCreateAccount.Text = "There was an unknown error; the user account was NOT created.";
                break;

                
        }
        string userid;
        if (newUser != null)
                {
                        
             userid = newobj.ProviderUserKey.ToString(); // it shows the error here
             newobj.Insert(userid, F_Name, L_Name, Address, City, State, Zip, DOB, Phone,
              email, User_Name, Password, PasswordQuestion, PasswordAnswer);

                }


 
    }

}

using System;

using System.Data;

using System.Configuration;
using System.Collections.Specialized;
using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Web.UI.HtmlControls;

using System.Data.SqlClient;

namespace DataClass
{
    public class ConnectionClass
    {
        string connStr = ConfigurationManager.ConnectionStrings["aspnetdbConnectionString"].ToString();
        public ConnectionClass()
        {  
            // Add Constructor Logic
            
        }
        
        public int Insert (string U_ID, string F_Name, string L_Name, string Address, string City, string State, string Zip, string DOB, string Phone,
            string email, string User_Name, string Password, string PasswordQuestion, string PasswordAnswer)
        {

            SqlConnection con = new SqlConnection(connStr);
            con.Open();
            SqlCommand cmd = new SqlCommand("user_membership", con);
            cmd.CommandType = CommandType.StoredProcedure;
            try {
            
            cmd.Parameters.Add("@UserId", SqlDbType.UniqueIdentifier).Value = new Guid(U_ID);
            cmd.Parameters.AddWithValue("@F_Name", F_Name);
            cmd.Parameters.AddWithValue("@L_Name", L_Name);
            cmd.Parameters.AddWithValue("@Address", Address);
            cmd.Parameters.AddWithValue("@City", City);
            cmd.Parameters.AddWithValue("@State", State);
            cmd.Parameters.AddWithValue("@Zip", Zip);
            cmd.Parameters.AddWithValue("@DOB", DOB);
            cmd.Parameters.AddWithValue("@Phone", Phone);
            cmd.Parameters.AddWithValue("@email", email);
            cmd.Parameters.AddWithValue("@User_Name", User_Name);
            cmd.Parameters.AddWithValue("@Password", Password);
            cmd.Parameters.AddWithValue("@PasswordQuestion", PasswordQuestion);
            cmd.Parameters.AddWithValue("@PasswordAnswer", PasswordAnswer);
            return cmd.ExecuteNonQuery();

            }
            catch { throw; }
            finally 
            {
               
                con.Dispose();
                con.Close();
                cmd.Dispose();
            }
            

        }

        public DataTable Load(string F_Name, string L_Name, string Address, string City, string State, string Zip, string DOB, string Phone,
            string email, string User_Name, string Password, string PasswordQuestion, string PasswordAnswer)
        {
            SqlConnection conn = new SqlConnection(connStr);

            SqlCommand cmd = new SqlCommand("user_membership", conn);
            SqlDataAdapter da = new SqlDataAdapter(cmd);
            da.SelectCommand.CommandType = CommandType.StoredProcedure;

            DataSet ds = new DataSet();
            try
            {
                // da.GetFillParameters();
                cmd.Parameters.AddWithValue("@F_Name", F_Name);
                cmd.Parameters.AddWithValue("@L_Name", L_Name);
                cmd.Parameters.AddWithValue("@Address", Address);
                cmd.Parameters.AddWithValue("@City", City);
                cmd.Parameters.AddWithValue("@State", State);
                cmd.Parameters.AddWithValue("@Zip", Zip);
                cmd.Parameters.AddWithValue("@DOB", DOB);
                cmd.Parameters.AddWithValue("@Phone", Phone);
                cmd.Parameters.AddWithValue("@email", email);
                cmd.Parameters.AddWithValue("@User_Name", User_Name);
                cmd.Parameters.AddWithValue("@Password", Password);
                cmd.Parameters.AddWithValue("@PasswordQuestion", PasswordQuestion);
                cmd.Parameters.AddWithValue("@PasswordAnswer", PasswordAnswer);
                da.Fill(ds);
                return ds.Tables[0];
            }
            catch
            {
                throw;
            }
            finally
            {
                ds.Dispose();
                da.Dispose();
                conn.Close();

                conn.Dispose();
            }
        }

    }
}

namespace TaxCalculator
{
    public class ProgressiveTax
    {
        //double amount = 0;
        readonly double limit1 = 0,//define the tax variables and their upper and lower limits
        limit2 = 10164, limit3 = 10165,
        limit4 = 19740, limit5 = 19741,
        limit6 = 29316, limit7 = 29317,
        limit8 = 38892;//, limit9 = 38893;

        private double taxedAmount = 0;//holdes the total amount that has been taxed

        private double ComputeTax(double grossPay)//accessible only within this class and not to outside components
        {
            //If amount >= limit1 And amount <= limit2 Then
            if ((grossPay >= limit1) && (grossPay <= limit2))//10% taxation
            {
                taxedAmount = grossPay * 0.1;
                return taxedAmount;
            }
            else if ((grossPay >= limit3) && (grossPay <= limit4))//15% taxation
            {
                //TheTax = TheTax(limit2) + ((amount - limit2) * 15 / 100)
                taxedAmount = ComputeTax(limit2) + ((grossPay - limit2) * 0.15);
                return taxedAmount;
            }
            else if ((grossPay >= limit5) && (grossPay <= limit6))//20% taxation
            {
                //TheTax = TheTax(limit4) + ((amount - limit4) * 20 / 100)
                taxedAmount = ComputeTax(limit4) + ((grossPay - limit4) * 0.2);
                return taxedAmount;
            }
            else if ((grossPay >= limit7) && (grossPay <= limit8))//25% taxation
            {
                //TheTax = TheTax(limit6) + ((amount - limit6) * 25 / 100)
                taxedAmount = ComputeTax(limit6) + ((grossPay - limit6) * 0.25);
                return taxedAmount;
            }
            else if ((grossPay > limit8))//anything above the 8 limit is taxed at 30%
            {
                //TheTax = TheTax(limit8) + ((amount - limit8) * 30 / 100)
                taxedAmount = ComputeTax(limit8) + ((grossPay - limit8) * 0.3);
                return taxedAmount;
            }
            return 0;
        }

        public double ComputeNet(double netSalary = 0)
        {
            netSalary = netSalary - ComputeTax(netSalary);//get the differfence between the gross salary and the taxed amount
            return netSalary;
        }

        public double GetTax(double salaryAmount)
        {
            salaryAmount = ComputeTax(salaryAmount);
            return salaryAmount;
        }
    }
}

Hi,
I have a requirement to render the contents from excel to word. With a condition that the content after rendering to word should look like they way it is displayed in print preview mode of excel. Can anybody help me on this?
To give additional information, I need the properites set in excel also to be rentered while rendering to word.
For example: If the mode is set to landscape in excel I want the same mode to be set in word after rendering. Similar with boarders, margins, print area and scalings.

 string[] files = Directory.GetFiles(C:\temp\09_20_2012\CUSTOMER1, "*summ.xls",SearchOption.AllDirectories);
 
string[] files = Directory.GetFiles("C:\\temp", "*summ.xls", SearchOption.AllDirectories);

Thus for like the statement,
 "string[] files = Directory.GetFiles("C:\\temp", "*summ.xls", SearchOption.AllDirectories);",