C#

 protected void btnUpdate_Click(object sender, EventArgs e)
    {
<big>//this is my problem//</big>
 

        if (Request.QueryString["id"] != null)
        {
            
                        
                 //Declare the connection object
                 SqlConnection Conn = new SqlConnection(ConfigurationManager.ConnectionStrings["MyLocal"].ConnectionString);
 
                 //Make the connection 
                 Conn.Open();
 
                 //Define you query
              
              
                 string sql = "UPDATE [Customer] SET [FirstName] = @FirstName,  [LastName] = @LastName, [Email] = @Email, [Password] = @Password, [Address1] = @Address1, [Address2] = @Address2, [City] = @City, [State] = @State, [zip] = @zip, [Phone] = @Phone, [Fax] = @Fax  WHERE CustomerID=@CustomerID";
                
                 
                 
                 //Declare the Command
                 SqlCommand cmd = new SqlCommand(sql, Conn);
 
                 //Add the parameters needed for the SQL query
                  cmd.Parameters.AddWithValue("@CustomerID", CustomerID);
                   cmd.Parameters.AddWithValue("@FirstName", txtFirstName.Text);
                  cmd.Parameters.AddWithValue("@LastName", txtLastName.Text);
                  cmd.Parameters.AddWithValue("@Email", txtEmailA.Text);
                  cmd.Parameters.AddWithValue("@Password", txtPasswordA.Text);
                  cmd.Parameters.AddWithValue("@Address1", txtAddress1.Text);
                  cmd.Parameters.AddWithValue("@Address2", txtAddress2.Text);
                   cmd.Parameters.AddWithValue("@City", txtCity.Text);
                  cmd.Parameters.AddWithValue("@State", txtState.Text);
                   cmd.Parameters.AddWithValue("@Zip", txtZip.Text);
                  cmd.Parameters.AddWithValue("@Phone", txtPhone.Text);
                   cmd.Parameters.AddWithValue("@Fax", txtFax.Text);
 

 
                 //Execute the query
 
                 cmd.ExecuteNonQuery();
 
                 Conn.Close();
                 Response.Redirect("Customers.aspx");
             
         
 
        }

hi there again guys as usual i have a problem which i would like some help with
i have a website with a textbox and a click button
also it has 2 check boxes

my plan is to enter a weblink into the textbox untick 2 check boxes and click submit button all in c# so i want my app to load page and enter details programatically , enter weblink , untick boxes , press submit button and allow page to load in c# webbrowser control with _self

please help guys thanks

the source code for the submit buttin is

input type="image" src="data:image/gif;base64,R0lGODdhHgAOAHcAACwAAAAAHgAOAIcAAACAAAAAgACAgAAAAICAAIAAgIDAwMDA3MCmyvBHRkNHRmJmRkNmRmJmZUNHRoJHZaFHhMBmo+CERkOjZUPChEPChGLgo2KEhIKEwf+j4P//wYL/4KHC/+DC/////8Dg/////+D///9wAtIAAAAAAAAAAAAAAAAFAAJwAtIAAAAAAAAXC7AAAAAAAAwAAAAAAAMqCuAWbFgWbXAT7XAXDJgAAAAS7xQAAAAS8Egy4O34Lrj///42L+c2LoIAAAAaxTAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAS8BhHNEwAAAAAAAAAAAAAAAAS8NwS8NwAAoES8Nw6ajQAAoES8CBBzNE4CrRC1IFC1Ik6ajQ4CtRHMMcS8EhHMN5HMOYS8PRHMPAAAAAS8NwAAoEAAAA6ajQS8GBCY+4AAoEAAAEAAA8AAAAS8IzIxOcUBNoAAoEAAAEAAA8AAoG6q80AAAAS8NwAAoES8JwS8LjNmNgAAAcS8dwAAAcAAAA6ajRIxCE6ajRI0J06ajQS8mRHBP8S8vAS8mQ6ajT////IxZDIxkEAAAAAAAEAAAAAAAAS8KgaqYQS9NzNYpsS8RjHuxMUBNoAAAcZAdwAAAAS8STIzZDNmNgAAEAS8WDHu7zHu4e6hxUAAAAS8dwAAAcAAAEAAAAS8TB6BMgS8fTNYptvzeX///7Hu4fIxOcUBNoAAAcZAdwAAAAAAAe6q80AAAAS8dwAAAcS8ZwS8bjNmNjHu4cS8gTIxkHIxf66hHEAAAdAewQS9DgAACQAAAEAAAAAAAAAAHD////////IxZDIxkES8ngAAAEAAAAAAAAS8agBD8QS9AjNYptgsH3///7Ixf7IGzEAAABAewQUBNoAAAcZAdwAAAcS82QAsCkAAAA6ajQS8lTKK+5AewQUBNoAAAcZAdwAAAAAAAES87hHNTBAewQUBNoAAAcZAdwS9AhHQT5HQUY6ajSgoKSAgID/AAAA/wD//wAAAP//AP8A//////+Yd0sImABFCBxIsKDBgwgTKkSYQYHDDQI1WFg4UCJBDQsugIAw4YOHBxUoivgYsmLGgRsdUgghwaGCCyMfOFjgUsFKgR9fDiQpQkMDDiIidPzYMWZJkwqK8hTYUAEDDkuXFmz5lCfGjhGqgsS59WDDDTwlPA06tKtUES0hioW6Ne1HrSXPBnUJc+6EDhAcYlAAtqvdDyIDCx5MWHBAADs=" title="Go!" alt="Start surfing" class="button" autofocus/>



form action="/includes/process.php?action=update" enctype="multipart/form-data"

onkeypress="return handleEnter(this, event)"

method="post" onsubmit="return updateLocation(this);" class="form">

the source for the check boxes are
input id="jsOnOff" name="js" type="hidden" value="0"/>

input type="checkbox" name="allowCookies" id="allowCookies" checked="checked">

label for="allowCookies" class="tooltip" onmouseover="tooltip('')" onmouseout="exit();">Allow Cookies</label>

<input type="checkbox" name="stripJS" id="stripJS" checked="checked">

label for="stripJS" class="tooltip" onmouseover="tooltip('')" onmouseout="exit();">Remove Scripts</label>

<input type="checkbox" name="stripObjects" id="stripObjects">

label for="stripObjects" class="tooltip" onmouseover="tooltip('')" onmouseout="exit();">Remove Objects</label>



and the source for the textbox is




input id="address_box" type="text" name="u" value="http://" size="42" onfocus="this.select()"/>

using System;
using System.Web;
using System.Web.Services;
using System.Web.Services.Protocols;
using System.Data;
using System.Data.SqlClient;
 
[WebService(Namespace = "http://tempuri.org/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
public class Service : System.Web.Services.WebService
{
 
    private const string connectionString ="Server=MARK\\SQLEXPRESS2005;Database=SampleDatabase;Trusted_Connection=True;";
    
    string sqlQuery;
    DataSet dataSet;
    bool isConnectionFailed;
    SqlConnection sqlConnection;    
    
    public Service () {
        //Uncomment the following line if using designed components 
        //InitializeComponent(); 
    }
 
    [WebMethod]
    public void connectToDatabase(){
        sqlConnection = new SqlConnection(connectionString);
        try {
            sqlConnection.Open();
            isConnectionFailed = false;
        }
        catch (Exception exception) {
            isConnectionFailed = true;
        }
        finally {  }
        
    }//end connectToDatabase()

 
    [WebMethod]
    public string getConnectionMessage() {
        string message="";
        if (isConnectionFailed)
            message = "Error while connecting to Microsoft SQL Server.";
        else
            message = "Connection SUCCESSFUL!!!";
 
        return message;
    }    
}//end class 

using System;
using System.Data;
using System.Configuration;
using System.Collections;
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;
 
namespace WebProject
{
    public partial class _Default : System.Web.UI.Page
    {
        
WebServiceDatabase.Service service = new WebProject.WebServiceDatabase.Service();//My Web Service

        protected void Page_Load(object sender, EventArgs e)
        {
            service.connectToDatabase();
            lblConnectionMessage.Text = service.getConnectionMessage();
        }
    }
}