ASP.NET error when sending more than 256 characters from a textbox to SQL

Question

2.00/5 (1 vote)

See more:

Hi,

I have an ASP.NET website, that has many textboxes to be filled and to be written into SQL. I also have a WinForm application for this.

When I write more than 256 characters into a textbox in winform and INSERT or UPDATE it in SQL column (NVARCHAR(MAX)), have no problem, works fine.

When I try to do the same on my ASP net site, it gives me an error:

Must declare the scalar variable "@"

(yes, there is no variable name!). I don't use any predefinied sql connection string in ASP, i use only the old school method: 1 string with the query, one ExecuteNonQuery() method calling. I always use this way, and works fine in other cases.

I searched many things on google, but no success. I guess it is some IIS limitations or some HTTP limitation?!...

Can somebody tell me a simple solution to be able to upload and long text longer than 256 chars?

Many thanks

Posted 28-Sep-15 7:21am

DoomMaker79

Add a Solution

Comments

Wendelius 28-Sep-15 14:18pm

Even though you posted that you have solution I believe it would make sense to post the code how you build and execute the SQL statement. This way we could check if there's something to correct with code.

DoomMaker79 29-Sep-15 1:57am

you're right, there's my solution detailed

2 solutions

Solution 1

argh. I have a solution, but don't know why it works. so I have to use the cmd.parameters.add command in my c# code.

I used a class for sql writing, where I sent the whole string with comma separating, and the class got it into its string[]... nevermind. i thought i was old school, but not... :)

Posted 28-Sep-15 7:37am

DoomMaker79

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)

DoomMaker79 · Accepted Answer · 2015-09-28T19:57:00

Mika, you're right, so here's my solution:

before I solved it, I used a class for SQL inserts and updates. I passed 2 args to that class: a string with the values separating them with letter ß, and the name of the database, something like this: TableData.WriteID(columnString, db)

the columnString had this kind of string: "data1ßdata2ßdata3"

then the class splitted the incoming string (Split('ß')) into a string array and then I inserted/updated the sql (using NameValueCollection). This was not working. I got the sample from Mohammed Hadi. It's a really cool stuff.

Then I got back to the reeeeeal old school version:

C#

string sql = "INSERT INTO Table (ID,username,comment,date) VALUES (@id,@username,@comment,@date)";
SqlCommand cmd = new SqlCommand(sql, myConnection);//pre-definied myConnection
cmd.Parameters.Add("@id", id.Text);
cmd.Parameters.Add("@username", username.Text);
cmd.Parameters.Add("@comment", comment.Text);
cmd.Parameters.Add("@date", date.Text);
cmd.ExecuteNonQuery();

And this one's working!