Working with the Wizard Control Using Visual Studio 2005
page 4 of 5
by ERIC ARTHER
Feedback
Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 32258/ 155

Step 3 – Adding the Wizard Control and Modifying the Code

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.

 


View Entire Article

Article Feedback

Title:  
Name:  
Url: ( Optional )
Comment:  
Please add 5 and 5 and type the answer here:

User Comments

Title: Solve My Problem - - - Keep it Up   
Name: Faheem Ahmad
Date: 12/24/2007 6:31:32 AM
Comment:
It is an excellent article for beginners like me. Thanks aspalliance.
Title: Good   
Name: Althaf
Date: 6/4/2007 8:20:26 AM
Comment:
Thanks!!!!

Excellant assitance..

Keep going..
Title: Feedback 4 Wizard Control VS 2005   
Name: Mahesh Sharma
Date: 5/30/2007 2:21:21 PM
Comment:
hi,
to all.
this is very nice article. i will get 100% assistence. and not need to look anywhere.
Title: Working with the Wizard Control Using Visual Studio 2005   
Name: Princess
Date: 8/24/2006 12:25:45 PM
Comment:
Thank you..
Title: Perfect!   
Name: Tori Martinez
Date: 5/21/2006 12:15:12 PM
Comment:
This is exactly what I was looking for. Thanks Eric!!!
Title: VB Code   
Name: Riceee
Date: 5/16/2006 6:07:22 AM
Comment:
Heres the VB code for all of you that wanted it...

Public Sub insertDataIntoDB(ByVal fname As String, ByVal lname As String, ByVal email As String, ByVal tel As String)
Dim conn As String = System.Configuration.ConfigurationManager.ConnectionStrings("dbConnectionString").ConnectionString
Dim myConnection As System.Data.SqlClient.SqlConnection = New System.Data.SqlClient.SqlConnection(conn)
Dim MySQL As String = "sp_results"
Dim cmd As System.Data.SqlClient.SqlCommand = 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()
End Sub


Protected Sub Wizard1_FinishButtonClick(ByVal sender As Object, ByVal e As WizardNavigationEventArgs)
insertDataIntoDB(TextBox1.Text.ToString().Trim(), TextBox2.Text.ToString().Trim(), TextBox3.Text.ToString().Trim(), TextBox4.Text.ToString().Trim())
End Sub
Title: NIce Post   
Name: Rob
Date: 5/10/2006 2:27:25 PM
Comment:
Nice Job! It was just what I was looking for (along time)! I was able to port the cs to vb with one of the many on-line cool tools.
Rob
Title: VB   
Name: Mystical
Date: 5/5/2006 5:32:50 AM
Comment:
hi..

I need the code in VB too
Title: Working with the Wizard Control Using Visual Studio 2005   
Name: Shawn
Date: 4/19/2006 4:22:18 AM
Comment:
Hi,

Can I have the codes in VB.

Thank you
Shawn






Community Advice: ASP | SQL | XML | Regular Expressions | Windows


©Copyright 1998-2009 ASPAlliance.com  |  Page Processed at 11/8/2009 1:15:56 AM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search