Programmatically Updating Databases using ASP.NET 2.0 SqlDataSource - Completing the Code Example
(Page 4 of 4 )
We have explained the code of the InsertRow() method so let's continue explaining the rest of the code. Each time the page initializes we add the SqlDataSource control to the page through the Controls.Add() method and assign its ConnectionString property to a valid value that connects the control to the Northwind database as shown in the Page_Init() event handler method.
protected void Page_Init(object sender, EventArgs e)
{
this.Controls.Add(SqlDataSource1);
SqlDataSource1.ConnectionString = "Data Source=(local);Initial
Catalog=Northwind;Integrated Security=True";
}
In the Page_Load() event handler method we determine the action that we want to take. If the page is loading for the first time we simply call the InitializeDataSource() method to create the HtmlTable control. This control, in turn, contains the data we have returned from the database through the SqlDataSource control. If the page is posted back to the server, which means that the user has clicked on the button control and needs to insert a record in the database table, we call the InsertRow() method to insert a record into the Employees table based on the T-SQL INSERT statement assigned to the SqlDataSource.InsertCommand property, and also based on the values that are entered into the TextBoxes.
The InsertRow() method returns a value that indicates how many rows have been inserted into the database. We test the return value and if it is equal to 1 we print out a simple message to the user through the Response.Write() method. After that we call the InitializeDataSource(), again, to get the data from the database table.
protected void Page_Load(object sender, EventArgs e)
{
try
{
if (!IsPostBack)
{
InitializeDataSource();
}
else
{
int rowsAffected = InsertRow();
if (rowsAffected == 1)
{
Response.Write("A New Row has been inserted into the Employees Table");
}
InitializeDataSource();
}
}
catch
{
Response.Write("An Error has occured");
}
}
We have placed our code inside a try/catch block to catch any exceptions. In the next article, we are going to talk about updating operations using the SqlDataSource.
| DISCLAIMER: The content provided in this article is not warranted or guaranteed by Developer Shed, Inc. The content provided is intended for entertainment and/or educational purposes in order to introduce to the reader key ideas, concepts, and/or product reviews. As such it is incumbent upon the reader to employ real-world tactics for security and implementation of best practices. We are not liable for any negative consequences that may result from implementing any information covered in our articles or tutorials. If this is a hardware review, it is not recommended to open and/or modify your hardware. |
/ 9 
