Cannot Update Database Using Sql Statement... Help Please

Hi All,

 I have watched one of the video tutorials under SQL Server section called "Connecting your web application to SQL server 2005 express edition" (number 8).

It was about creating a database with single table and then updating it by inserting new records in a text box an clicking on submit button. In code section there is a sql insert statement and connection string is via configurationManager (name of the connection string is taken from web.config and is spelled properly)

Anyway, my problem is that updating that database by filling the textbox and clicking submit button is not working.

I have no error message (nothing happens) - database is not updated.

If I add to the page a data grid view with updating and inserting selected then it all works. I was trying to use debbuging with break point setup but couldn't find any errors.I have done everything the same way as on the video.... I am beginner in C# so your help will be much appreciated.

Here is the code:

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;public partial class _Default : System.Web.UI.Page

{protected void Page_Load(object sender, EventArgs e)

{

}protected void Submitbutton_Click(object sender, EventArgs e)

{

 

 SqlDataSource dashDataSource = new SqlDataSource();dashDataSource.ConnectionString = ConfigurationManager.ConnectionStrings["dashConnectionString1"].ToString();

 

dashDataSource.InsertCommandType = SqlDataSourceCommandType.Text;dashDataSource.InsertCommand = "INSERT INTO Email(EmailAddress, IPAddress, DateTimeStamp) VALUES (@EmailAddress, @IPAddress, @DateTimeStamp)";

dashDataSource.InsertParameters.Add("EmailAddress", EmailAddressTextBox.Text);dashDataSource.InsertParameters.Add("IPAddress", Request.UserHostAddress.ToString());

dashDataSource.InsertParameters.Add("DateTimeStamp", DateTime.Now.ToString());int rowsaffected = 0;

try

{

rowsaffected = dashDataSource.Insert();

}catch (Exception ex)

{Server.Transfer("Newsletter_problem.aspx");

}

finally

{dashDataSource = null;

}if (rowsaffected != 1)

{Server.Transfer("Newsletter_problem.aspx");

}

else

{Server.Transfer("Newsletter_confirm.aspx");

}

 

 

}

}