Using Textboxes And Dropdownboxes To Update Database Table

ASP 3.5 VB: Visual Studio 2008, 2005 Developer Server

I'm new to web development so my question may seem basic. I created a stored procedure:CREATE PROCEDURE [dbo].[CaseDataInsert]

@ReportType varchar(50),

@CreatedBy varchar(50),

@OpenDate smalldatetime,

@Territory varchar(10),

@Region varchar(10),

@StoreNumber varchar(10),

@StoreAddress varchar(200),

@TiplineID varchar(50),

@Status varchar(50),

@CaseType varchar(200),

@Offense varchar(200)

 

AS

BEGININSERT CaseData(ReportType, CreatedBy,OpenDate,Territory,Region,StoreNumber,StoreAddress,TiplineID,

Status,CaseType,Offense)

VALUES(@ReportType,@CreatedBy,@OpenDate,@Territory,@Region,@StoreNumber,@StoreAddress,@TiplineID,

@Status,@CaseType,@Offense)

END

 

I created textboxes and dropdownboxes on my asp page, and with a button put the following code behind it:Protected Sub Button1_Click(ByVal sender As Object, ByVal e As EventArgs) Handles Button1.Click

Dim cs As String = "Data Source=localhost;Initial Catalog=Database1.mdf;Integrated Security=True;"Using con As New System.Data.SqlClient.SqlConnection(cs)

con.Open()Dim cmd As New System.Data.SqlClient.SqlCommand

cmd.Connection = con

cmd.CommandType = CommandType.StoredProcedure

cmd.CommandText = "CaseDataInsert"cmd.Parameters.AddWithValue("@ReportType", DropDownList1.SelectedItem)

cmd.Parameters.AddWithValue("@CreatedBy", DropDownList2.SelectedItem)cmd.Parameters.AddWithValue("@OpenDate", TextBox1.Text)

cmd.Parameters.AddWithValue("@Territory", TextBox2.Text)cmd.Parameters.AddWithValue("@Region", DropDownList3.SelectedItem)

cmd.Parameters.AddWithValue("@StoreNumber", TextBox3.Text)cmd.Parameters.AddWithValue("@StoreAddress", TextBox4.Text)

cmd.Parameters.AddWithValue("@TiplineID", TextBox5.Text)cmd.Parameters.AddWithValue("@Status", DropDownList4.SelectedItem)

cmd.Parameters.AddWithValue("@CaseType", DropDownList5.SelectedItem)cmd.Parameters.AddWithValue("@Offense", DropDownList6.SelectedItem)

End Using

End Sub

On the web page I can enter the data, click the button, and no data is entered into the database?

I believe that I may have problems with the datasource?

Any help would be appreciated.

 

losssoc