sqlparameter method data adding

Question

4.00/5 (1 vote)

See more:

Hi All,

I Used Three Data In DataBase like product, price and discount.
I give default value of discount as 0.

sql is

create table products(product nvarchar(max),
                  price numeric(18,2),
                  discount numeric(18,2) default 0)

code behind is

com = New SqlCommand(";INSERT INTO products (product,price ,discount ) VALUES(@C1, @C2, @C3)";, con)
      com.Parameters.AddWithValue("@C1", TextBox1.Text)
      com.Parameters.AddWithValue("@C2", TextBox2.Text)
      com.Parameters.AddWithValue("@C3", TextBox3.Text)
      com.ExecuteNonQuery()
      MsgBox("added")

and also try this

com.CommandText = "INSERT INTO Products (Product, Price, Discount) VALUES (@p1, @p2, @p3)"
        com.Connection = con

        Dim parameter As SqlParameter
        parameter = New SqlParameter("p1", System.Data.SqlDbType.NVarChar, 2000)
        parameter.Value = TextBox1.Text
        com.Parameters.Add(parameter)


        parameter = New SqlParameter("p2", System.Data.SqlDbType.Decimal)
        parameter.Value = TextBox2.Text
        com.Parameters.Add(parameter)



        parameter = New SqlParameter("p3", System.Data.SqlDbType.Decimal)
        parameter.Value = TextBox3.Text
        com.Parameters.Add(parameter)
        Try
            com.ExecuteNonQuery()
        Catch ex As Exception
            MsgBox(ex.Message)
        End Try

I miss Default those two methods also show an error, field to enter input.
When I Run The Program, it shows error like (Incorrect Syntax Near ')' (Or) can't convert string to int.

Please Help Me For This

In those two program we enter all input it give result. If didn't enter any input it shows error in database allow null to all data, and give default value also.

Posted 9-Apr-11 1:33am

Member 7732172

Updated 9-Apr-11 3:00am

Dalek Dave

v5

Add a Solution

Comments

Dalek Dave 9-Apr-11 9:00am

Edited for Grammar, Readability and Clarity.

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)

Espen Harlinn · Answer 1 · 2011-04-09T04:36:00

Please consider changing

SQL

create table products(product nvarchar(max),
                  price numeric(18,2),
                  discount numeric(18,2) default 0)

into something like

SQL

create table product_categories
(
 id bigint IDENTITY not null primary key,
 name nvarchar(255) not null, 
 CONSTRAINT UNQ_PRODUCT_CATEGORY_NAME UNIQUE(NAME)
)
go
create table products
(
 id bigint IDENTITY not null primary key,
 name nvarchar(255) not null, 
 Category bigint not null,
 description nvarchar(max),
 CONSTRAINT FK_PRODUCT_CATEGORY FOREIGN KEY(Category) REFERENCES product_categories(id),
 CONSTRAINT UNQ_PRODUCT_NAME UNIQUE(Category,name)
)
go
create table product_price
(
 id bigint IDENTITY not null primary key,
 product bigint not null,
 fromTime dateTime2 not null default SYSDATETIME(),
 price numeric(18,2),
 discount numeric(18,2) default 0,
 CONSTRAINT FK_product_price_PRODUCT FOREIGN KEY(product) REFERENCES products(id),
 CONSTRAINT UNQ_PRODUCT_PRICE UNIQUE(product,fromTime)
)
go

What you've got isn't very useful, and consider decomposing it even further, as discount doesn't really belong together with the base price for the product at a given time ...

Regards
Espen Harlinn

Rakesh From Patna · Answer 2 · 2011-04-09T02:19:00

XML

You try this:-
<pre>com = New SqlCommand("INSERT INTO products (product,price ,discount ) VALUES(@C1, @C2, @C3)", con)
      com.Parameters.Add(new SqlParameter("@C1", TextBox1.Text));
      com.Parameters.Add(new SqlParameter("@C2", TextBox2.Text));
      com.Parameters.Add(new SqlParameter("@C3", TextBox3.Text));
con.open();
      com.ExecuteNonQuery()
      MsgBox("added")
</pre>
IN your 2nd method add "@" synpole all sql parmameter for Example
In your second method you write
<pre>
 parameter = New SqlParameter("p1", System.Data.SqlDbType.NVarChar, 2000)
</pre>
but you try this
<pre>
 parameter = New SqlParameter("@p1", System.Data.SqlDbType.NVarChar, 2000)
</pre>
I hope work successfully

Wendelius · Answer 3 · 2011-04-09T01:38:00

Solution 1

The error message doesn't make sense. Are you sure it's coming from these statements?

In the first try, try modifying:

com = New SqlCommand("INSERT INTO products (product,price ,discount ) VALUES(@C1, @C2, @C3)", con)

And the second try, that was my mistake. use @ before the parameter names. Like:

parameter = New SqlParameter("@p1", System.Data.SqlDbType.NVarChar, 2000)

Posted 9-Apr-11 1:38am

Wendelius

Comments

Espen Harlinn 9-Apr-11 10:37am

Good reply, nice and simple - my 5

Wendelius 9-Apr-11 11:49am

Thanks :)

sqlparameter method data adding

3 solutions

Solution 3

Solution 2

Solution 1

Add your solution here

Preview 0