1) Drag and drop the "Wizard" control from the toolbox onto the default.aspx web form.
2) Add additional text boxes to the Wizard as shown in the code for the wizard control below in Listing 3. Looking at the code you will find that two textboxes have been added in Step 1, and two in Step 2. The last wizard step is left blank.
Listing 3 - Default.aspx Code for the Wizard control
<asp:Wizard ID="Wizard1" runat="server" ActiveStepIndex="2" OnFinishButtonClick = "Wizard1_FinishButtonClick"> <WizardSteps> <asp:WizardStep ID="WizardStep1" runat="server" Title="Step 1"> First Name<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox> Last Name<asp:TextBox ID="TextBox2" runat="server"></asp:TextBox> </asp:WizardStep> <asp:WizardStep ID="WizardStep2" runat="server" Title="Step 2"> Email<asp:TextBox ID="TextBox3" runat="server"></asp:TextBox> Tel<asp:TextBox ID="TextBox4" runat="server"></asp:TextBox> </asp:WizardStep> <asp:WizardStep ID="WizardStep3" runat="server" StepType="Finish" Title="Overview"> </asp:WizardStep> </WizardSteps> </asp:Wizard>
3) When the user clicks Finish in the last Overview step, we capture that click by setting a value for the OnFinishButtonClick event. The code in Wizard1_FinishButtonClick will be called to handle the event. In the corresponding code behind seen in Listing 4, the insertDataIntoDB function is called and it executes the stored procedure, which saves the data into Table1.
Listing 4 - Default.aspx.cs
protected void Page_Load(object sender, EventArgs e) { } public void insertDataIntoDB(string fname, string lname, string email, string tel) { string conn = System.Configuration.ConfigurationManager.ConnectionStrings["dbConnectionString"].ConnectionString; System.Data.SqlClient.SqlConnection myConnection = new System.Data.SqlClient.SqlConnection(conn); string MySQL = "StoredProcedure1"; System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand(MySQL, myConnection); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Fname", fname)); cmd.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Lname", lname)); cmd.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Email", email)); cmd.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Tel", tel)); myConnection.Open(); cmd.ExecuteNonQuery(); myConnection.Close(); } protected void Wizard1_FinishButtonClick(object sender, WizardNavigationEventArgs e) { insertDataIntoDB(TextBox1.Text.ToString().Trim(), TextBox2.Text.ToString().Trim(), TextBox3.Text.ToString().Trim(), TextBox4.Text.ToString().Trim()); }
4) As a last step to make the form beautiful, right-click the Wizard control in the design mode of the Visual Studio 2005 IDE, choose AutoFormat, and select your favorite design.
5) Run the application.
6) Once you come to the final step and click Finish, the form information will be saved in Table1.
User Comments