Problems Inserting And Updating Data Into Sql Database

i am creating a database driven website and i am using a sql database. I have a database called company with fields in it to do with a company, I have created a company.cs file which sets the variables, properties and methods and so on. These work fine. I have also stored procedures and they are right as far as i know. i also have coding behind the buttons of my page when i try and update or insert to the database. I am having the problem of when i enter data into the text boxes and click update, nothing gets inserted or updated and whats worst of all no error message appears. The table is used for storing profile data about a user, when a user logs on they enter their profile data, if i manually enter this data and input the username of a user into the username field within the database then the data appears fine in the textboxes of the update info page but the data will not insert or update. i have checked all the little things and i am stressing out cos i am running out of time and cannot find the problem...........please could someone help me!!!!! thanks

 

Heres my coding to some of my pages to help you....

the code behind the button

using System;

using System.Data;

using System.Configuration;

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 FYPtestsite.Classes;

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

{protected void Page_Load(object sender, EventArgs e)

{if (!Roles.IsUserInRole(ConfigurationManager.AppSettings["employerrole"]))

{Response.Redirect("~/Error1.aspx");

}Company objCompany = Company.GetCompany(Profile.UserName);if (objCompany != null)

{

 

txtCompanyname.Text = objCompany.Companyname;

txtAddress1.Text = objCompany.Address1;

txtAddress2.Text = objCompany.Address2;

txtPostcode.Text = objCompany.Postcode;

txtCity.Text = objCompany.City;

txtPhone.Text = objCompany.Phone;

txtFax.Text = objCompany.Fax;

txtEmail.Text = objCompany.Email;

txtURL.Text = objCompany.URL;

txtProfile.Text = objCompany.Profile;

}

}protected void Button2_Click(object sender, EventArgs e)

{Response.Redirect("~/homepage.aspx");

}protected void Button3_Click(object sender, EventArgs e)

{Company objCompany = new Company();

objCompany.UserName = Profile.UserName;

objCompany.Companyname = txtCompanyname.Text;

objCompany.Address1 = txtAddress1.Text;

objCompany.Address2 = txtAddress2.Text;

objCompany.Postcode = txtPostcode.Text;

objCompany.City = txtCity.Text;

objCompany.Phone = txtPhone.Text;

objCompany.Fax = txtFax.Text;

objCompany.Email = txtEmail.Text;

objCompany.URL = txtURL.Text;

objCompany.Profile = txtProfile.Text;

 if (Profile.Employer.CompanyID != -1)

{objCompany.CompanyID = (int)Profile.Employer.CompanyID;Company.Update(objCompany);

}

else

{int i = Company.Insert(objCompany);

Profile.Employer.CompanyID = i;

}labelstatus.Text = "Your profile has been successfully updated";

}

}

 

 

Any help would be greatly greatly appreciated!!!!!!