Solved

Creating an Asynchronous Connection in asp.net vb

Posted on 2009-07-10
9
488 Views
Last Modified: 2012-05-07
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

0
Comment
Question by:OB1Canobie
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
  • 2
  • +1
9 Comments
 
LVL 8

Expert Comment

by:Bobaran98
ID: 24828647
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
 
LVL 15

Expert Comment

by:jinal
ID: 24828659
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
 
LVL 15

Expert Comment

by:jinal
ID: 24828676

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
Webinar: Aligning, Automating, Winning

Join Dan Russo, Senior Manager of Operations Intelligence, for an in-depth discussion on how Dealertrack, leading provider of integrated digital solutions for the automotive industry, transformed their DevOps processes to increase collaboration and move with greater velocity.

 
LVL 20

Expert Comment

by:ddayx10
ID: 24828700
I think jinal is on the right track...why not just:

sqlCmd.ExecuteNonQuery();
0
 

Author Comment

by:OB1Canobie
ID: 24831182
jinal:

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

What is this doing?  I've got an error on this line.  Please help.
0
 
LVL 15

Accepted Solution

by:
jinal earned 400 total points
ID: 24831231
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
 
LVL 15

Expert Comment

by:jinal
ID: 24831232
If still error then please put error detail over here.
0
 
LVL 8

Assisted Solution

by:Bobaran98
Bobaran98 earned 100 total points
ID: 24831336
@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
 

Author Closing Comment

by:OB1Canobie
ID: 31602296
Jinal, your code worked.  Bobaran92, thanks for you assistance.  Did not see the tbx_Last_Name did not have an assigned value.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Enums (shorthand for ‘enumerations’) are not often used by programmers but they can be quite valuable when they are.  What are they? An Enum is just a type of variable like a string or an Integer, but in this case one that you create that contains…
If you find yourself in this situation “I have used SELECT DISTINCT but I’m getting duplicates” then I'm sorry to say you are using the wrong SQL technique as it only does one thing which is: produces whole rows that are unique. If the results you a…
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question