Creating an Asynchronous Connection in asp.net vb

I have a form built in asp.net vb.  I am connecting to an SQL Server 2005 database through asp.net vb and having issues with adding information to a table.  I keep getting an error stating that I need to create an Asynchronous Connection.  I cannot figure a way to do this with my code below.I have attached the code that I need assistance with.  Thanks.
Private Sub Process_Information()        
        Reg_Ip = Request.ServerVariables("HTTP_XFORWARDED_FOR")
        If Reg_Ip = "" Then Reg_Ip = Request.ServerVariables("REMOTE_ADDR")
        Dim sqlConnection As New System.Data.SqlClient.SqlConnection
        sqlConnection.ConnectionString = "conn String here"
        Dim sqlCmd As New System.Data.SqlClient.SqlCommand
        sqlCmd.CommandType = Data.CommandType.Text
        sqlCmd.Connection = sqlConnection
        sqlCmd.CommandText = "INSERT INTO dbo_users " _
        & "(Reg_Date, Reg_Ip, Prefix, User_Name, Password, Password_Hint_Question, Password_Hint, First_Name, Middle_Initial, Last_Name) " _
        & "VALUES (@Reg_Date,@Reg_Ip,@Prefix,@User_Name,@Password,@Password_Hint_Question,@Password_Hint,@First_Name,@Middle,@Last_Name)"
        sqlCmd.Parameters.AddWithValue("@Reg_Date", Today())
        sqlCmd.Parameters.AddWithValue("@Reg_Ip", Reg_Ip)
        sqlCmd.Parameters.AddWithValue("@Prefix", dd_Prefix.SelectedValue)
        sqlCmd.Parameters.AddWithValue("@User_Name", tbx_Email.Text)
        sqlCmd.Parameters.AddWithValue("@Password", tbx_Password.Text)
        sqlCmd.Parameters.AddWithValue("@Password_Hint_Question", dd_Password_Hint_Question.SelectedValue)
        sqlCmd.Parameters.AddWithValue("@Password_Hint", tbx_Password_Hint.Text)
        sqlCmd.Parameters.AddWithValue("@First_Name", tbx_First_Name.Text)
        sqlCmd.Parameters.AddWithValue("@Middle", tbx_Middle_Initial.Text)
        sqlCmd.Parameters.AddWithValue("@Last_Name", tbx_Last_Name)
        sqlCmd.Connection.Open()
        sqlCmd.BeginExecuteNonQuery()
        sqlCmd.Connection.Close()
 
    End Sub

Open in new window

OB1CanobieAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Bobaran98Commented:
I'm not sure about the Asynchronous error, but just to make sure, are you confident all your form field ids are correct?  One thing that jumps out at me as a possible error is the AddWithValue() for @Last_Name.  You've got:

sqlCmd.Parameters.AddWithValue("@Last_Name", tbx_Last_Name)
Shouldn't it be:

sqlCmd.Parameters.AddWithValue("@Last_Name", tbx_Last_Name.Text)
???  Let me know! :-)
0
jinalCommented:
Hello ,

What is your connection string ?

Please add following to your connection string  "Asynchronous Processing=true"

for example

connectionstring ="server=localhost;integrated security=true;initial catalog=test;Asynchronous Processing=true"



0
jinalCommented:

Private Sub Process_Information()        
        Reg_Ip = Request.ServerVariables("HTTP_XFORWARDED_FOR")
        If Reg_Ip = "" Then Reg_Ip = Request.ServerVariables("REMOTE_ADDR")
        Dim sqlConnection As New System.Data.SqlClient.SqlConnection
        sqlConnection.ConnectionString = "conn String here"
        Dim sqlCmd As New System.Data.SqlClient.SqlCommand
        sqlCmd.CommandType = Data.CommandType.Text
        sqlCmd.Connection = sqlConnection
        sqlCmd.CommandText = "INSERT INTO dbo_users " _
        & "(Reg_Date, Reg_Ip, Prefix, User_Name, Password, Password_Hint_Question, Password_Hint, First_Name, Middle_Initial, Last_Name) " _
        & "VALUES (@Reg_Date,@Reg_Ip,@Prefix,@User_Name,@Password,@Password_Hint_Question,@Password_Hint,@First_Name,@Middle,@Last_Name)"
        sqlCmd.Parameters.AddWithValue("@Reg_Date", Today())
        sqlCmd.Parameters.AddWithValue("@Reg_Ip", Reg_Ip)
        sqlCmd.Parameters.AddWithValue("@Prefix", dd_Prefix.SelectedValue)
        sqlCmd.Parameters.AddWithValue("@User_Name", tbx_Email.Text)
        sqlCmd.Parameters.AddWithValue("@Password", tbx_Password.Text)
        sqlCmd.Parameters.AddWithValue("@Password_Hint_Question", dd_Password_Hint_Question.SelectedValue)
        sqlCmd.Parameters.AddWithValue("@Password_Hint", tbx_Password_Hint.Text)
        sqlCmd.Parameters.AddWithValue("@First_Name", tbx_First_Name.Text)
        sqlCmd.Parameters.AddWithValue("@Middle", tbx_Middle_Initial.Text)
        sqlCmd.Parameters.AddWithValue("@Last_Name", tbx_Last_Name)
        sqlCmd.Connection.Open()
        dim ar as IAsyncResult = sqlCmd.BeginExecuteNonQuery()
        while Not ar.IsCompleted
        End While
        int effected = sqlCmd.EndExecuteNonQuery();  
        sqlCmd.Connection.Close()
         
    End Sub

Open in new window

0
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

ddayx10Commented:
I think jinal is on the right track...why not just:

sqlCmd.ExecuteNonQuery();
0
OB1CanobieAuthor Commented:
jinal:

What is the line int effected = sqlcmd.endexecutenonquery(); ??

What is this doing?  I've got an error on this line.  Please help.
0
jinalCommented:
Try this.

Private Sub Process_Information()        
        Reg_Ip = Request.ServerVariables("HTTP_XFORWARDED_FOR")
        If Reg_Ip = "" Then Reg_Ip = Request.ServerVariables("REMOTE_ADDR")
        Dim sqlConnection As New System.Data.SqlClient.SqlConnection
        sqlConnection.ConnectionString = "conn String here"
        Dim sqlCmd As New System.Data.SqlClient.SqlCommand
        sqlCmd.CommandType = Data.CommandType.Text
        sqlCmd.Connection = sqlConnection
        sqlCmd.CommandText = "INSERT INTO dbo_users " _
        & "(Reg_Date, Reg_Ip, Prefix, User_Name, Password, Password_Hint_Question, Password_Hint, First_Name, Middle_Initial, Last_Name) " _
        & "VALUES (@Reg_Date,@Reg_Ip,@Prefix,@User_Name,@Password,@Password_Hint_Question,@Password_Hint,@First_Name,@Middle,@Last_Name)"
        sqlCmd.Parameters.AddWithValue("@Reg_Date", Today())
        sqlCmd.Parameters.AddWithValue("@Reg_Ip", Reg_Ip)
        sqlCmd.Parameters.AddWithValue("@Prefix", dd_Prefix.SelectedValue)
        sqlCmd.Parameters.AddWithValue("@User_Name", tbx_Email.Text)
        sqlCmd.Parameters.AddWithValue("@Password", tbx_Password.Text)
        sqlCmd.Parameters.AddWithValue("@Password_Hint_Question", dd_Password_Hint_Question.SelectedValue)
        sqlCmd.Parameters.AddWithValue("@Password_Hint", tbx_Password_Hint.Text)
        sqlCmd.Parameters.AddWithValue("@First_Name", tbx_First_Name.Text)
        sqlCmd.Parameters.AddWithValue("@Middle", tbx_Middle_Initial.Text)
        sqlCmd.Parameters.AddWithValue("@Last_Name", tbx_Last_Name)
        sqlCmd.Connection.Open()
        Dim ar as IAsyncResult = sqlCmd.BeginExecuteNonQuery()
        While Not ar.IsCompleted
        End While
        Dim effected as Integer = sqlCmd.EndExecuteNonQuery(ar);  
        sqlCmd.Connection.Close()
         
    End Sub

Open in new window

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
jinalCommented:
If still error then please put error detail over here.
0
Bobaran98Commented:
@jinal:  Is there something missing from that while loop?  Or is that simply a trick to throw code execution into a loop-- a wait-- until the execution completes?

@OB1Canobie:  Don't forget about that tbx_Last_Name.Text issue (line 21 in jinal's code).
0
OB1CanobieAuthor Commented:
Jinal, your code worked.  Bobaran92, thanks for you assistance.  Did not see the tbx_Last_Name did not have an assigned value.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
ASP.NET

From novice to tech pro — start learning today.