Need help in cmd.executenonquery() statement

Question

1.00/5 (1 vote)

See more:

Hi all

while insertion when the control is comming to cmd.executenonquery() statement the application use to hang and exit..
please tell me why it is happening..i am using vb.net 2008 and sql 2005

Posted 20-Sep-12 20:53pm

Code-Hunt

Add a Solution

Comments

Mehdi Gholam 21-Sep-12 3:09am

You really have to supply more information since we cannot see your environment or code you are using.

[no name] 21-Sep-12 3:13am

Please tell me what more u want..

Ganesh Nikam 21-Sep-12 4:41am

your code please

xErvender 23-Sep-12 23:50pm

your sql query pls

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

vangapally Naveen Kumar · Answer 1 · 2012-09-20T21:16:00

i think connection time is exipired use CommandTimeout property for setting time

see these links you may idea about this
http://forums.asp.net/t/1157123.aspx/1[^]
http://www.pcreview.co.uk/forums/oledb-hangs-executenonquery-t3398044.html[^]
http://forums.asp.net/t/1343831.aspx/1[^]
http://www.insidedhtml.com/forums/viewConverse.asp?d_id=20661[^]

BheemG · Answer 2 · 2012-09-20T21:18:00

Solution 2

Hi,

the issue is not know so use Try catch block so that in the exception we might come to know the exception which has been unhandeled. the reson might be the sql statement might be an error.

Execute the sql query in the sql or the database your using and check weather the statement is executing fine.

SQL connection might be the problem.

Happy coding...

Posted 20-Sep-12 21:18pm

BheemG

Comments

[no name] 21-Sep-12 3:43am

please tell me how to write the try catch block..

BheemG · Answer 3 · 2012-09-20T22:45:00

Yes here we go,

Try
    dim command as string= "Insert into table ("Name") values ("Beem")"
    MyConnection = New SqlConnection(ConfigurationManager.ConnectionStrings("DBO").ConnectionString)
    MyConnection.Open()
    Dim MyCommand As SqlCommand
    MyCommand = New SqlCommand(command, MyConnection)
    MyCommand.ExecuteNonQuery()
    DisposeConnection()
Catch ex As Exception

End Try

this is how it will look like try this....

Good luck...

Need help in cmd.executenonquery() statement

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0