Object reference not set to an instance of an object.

Question

1.00/5 (1 vote)

See more:

Whenever I add anything to TextBox2 and execute the statement below I get this error:

Object reference not set to an instance of an object.

Code:

VB

Try
    connStr = "connectionstring works"
    cmdStr = "INSERT INTO posts (post) VALUES @post;"
    Using conn As New SqlConnection(connStr)
        Using cmd As New SqlCommand(cmdStr, conn)
            conn.Open()
            cmd.Parameters.AddWithValue("@post", TextBox2.Text)
            cmd.ExecuteNonQuery()
            conn.Close()
            cmd.Dispose()
            conn.Dispose()
        End Using
    End Using
Catch ex As Exception
    TextBox6.Text = ex.ToString()
End Try

I have some jQuery code that messes with TextBox2.

JavaScript

    <script src="../Scripts/jquery-1.4.1.js" type="text/javascript"></script>
    <script type="text/javascript">
        $(document).ready(function () {
           $("#<%= TextBox2.ClientID %>").keypress(function (e) {
                var maxCount = 500;
                var strCount = $("#<%= TextBox2.ClientID %>").val().length;
                if (strCount < maxCount) {
                    $("#<%= TextBox3.ClientID %>").val(strCount);
                    $("#<%= Label4.ClientID %>").text("");
                    $("#<%= Button4.ClientID %>").trigger('click');
                } else {
                    e.preventDefault();
                    $("#<%= TextBox3.ClientID %>").val("(Over 500 Keypress Limit)");
                    $("#<%= Label4.ClientID %>").text("_____Click anywhere on TextBox to Edit______");
                }
            });
      });
</script>

Posted 24-Jun-14 9:21am

Teledextri

Updated 24-Jun-14 9:32am

v5

Add a Solution

Comments

PIEBALDconsult 24-Jun-14 16:01pm

Which line does the debugger say has the problem?

2 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)

Thanks7872 · Answer 1 · 2014-06-24T19:06:00

This may not be the actual answer to the question but below three statements are not required

VB

conn.Close()
cmd.Dispose()
conn.Dispose()

For better explanation see this : http://msdn.microsoft.com/en-us/library/htd05whh.aspx[^]

Further, i recommend you to remove the Try catch blocks,they are not meant for such scenarios. Put the debugger at first line of code and step through it. Debugger will stop on the line where the error is. Look at the variables involved into it. See the best answer to this error : object reference not set to an instance of an object. in c#[^]

Regards..

Maciej Los · Answer 2 · 2014-06-24T09:43:00

Solution 1

Replace:

SQL

INSERT INTO posts (post) VALUES @post;

with:

SQL

INSERT INTO posts (post) VALUES (@post);

The rest part of code looks good.

I'd strongly recommend to verify ConnectionString[^].

Posted 24-Jun-14 9:43am

Maciej Los

Comments

Teledextri 24-Jun-14 15:56pm

Not my SQL Statement.

Teledextri 24-Jun-14 16:01pm

Not my Connectionstring