Msdn Article On Getting @Identity Question

the msdn article explains how to input new data to a databse and return the primary key of the inputted row. It works perfectly. However, it explains how to insert a value, but there is a problem. It seems to set the value to be submitted in the VB code, instead of having the value be the user's input in the textbox. Look for the following line in the code below: newRow("ClientFileNumber") = "ClientFileNumber" It inputs "clientfilenumber" instead of what is actually inputted in the texbox. Does anyone know how to bypass this, to not have the words "clientfilenumber" inputted?Dim sqlconn As SqlConnection = New SqlConnection("Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|Client.mdf;Integrated Security=True;User Instance=True")

 Dim catDA As SqlDataAdapter = New SqlDataAdapter("SELECT * FROM Orders", sqlconn)

 catDA.InsertCommand = New SqlCommand("JobInsert", sqlconn)

catDA.InsertCommand.CommandType = CommandType.StoredProcedure

 catDA.InsertCommand.Parameters.Add("@ClientFileNumber", SqlDbType.VarChar, 50, "ClientFileNumber")Dim NewJobNumber As SqlParameter = catDA.InsertCommand.Parameters.Add("@Identity", SqlDbType.Int, 0, "OrdersID")

NewJobNumber.Direction = ParameterDirection.Output

 

sqlconn.Open()

 Dim catDS As DataSet = New DataSetcatDA.Fill(catDS, "Orders")

 

Dim newRow As DataRow = catDS.Tables("Orders").NewRow()

newRow("ClientFileNumber") = ""catDS.Tables("Orders").Rows.Add(newRow)

 catDA.Update(catDS, "Orders")

 

sqlconn.Close()

 

Response.Redirect("control_page_copy.aspx?NewJobNumber=" + NewJobNumber.Value.ToString())