not insert negative no in numeric datatype in sql server

Question

0.00/5 (No votes)

See more:

not insert negative no in numeric datatype in sql server
in insert query
insert into dbo.printing_list(batch_code,bill_no,date,sr_no,gross_wt,core_wt,nett_wt,c_id,category,operator)

here gross_wt,core_wt,nett_wt should not be negative

and not update the data if updated value is negative
in update query
update dbo.raw_in_godown set godown_quantity=godown_quantity-some_no
here updated godown_quantity should not be negative

Posted 2-Dec-13 22:33pm

Abhijeet pratap singh

Add a Solution

Comments

phil.o 3-Dec-13 4:36am

Please show your c# code. And format it so that it is readable.

thatraja 3-Dec-13 4:52am

Why this question? :( Logic of this answer could help you to achieve your thing.

1 solution

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)

OriginalGriff · Accepted Answer · 2013-12-02T23:06:00

Solution 1

You can't do that in SQL directly: you can either check in your C# code and not issue the SQL command, or you can write SQL stored procedures to do the insert and update functions and check there. But there is no simple way to prevent SQL from storing negative numbers.

Posted 2-Dec-13 23:06pm

OriginalGriff

Comments

Abhijeet pratap singh 3-Dec-13 6:58am

can you tell me how and what give in connection string for sql server
that the software run on each computer on creating msi file

OriginalGriff 3-Dec-13 7:11am

No. Nobody can.
The connection string needs to have the name of the SQL server instance and the login details that the database user is going to use when he connects to SQL. Both of these willl change depending on how SQL is configured when it is installed, and there is no "one string" which will fit all circumstances.

Abhijeet pratap singh 3-Dec-13 7:18am

then which database or technique i have to use that the software can run on each computer like other softwares iam developing software in c#.net

Abhijeet pratap singh 3-Dec-13 7:17am

then which database or technique i have to use that the software can run on each computer like other softwares iam developing software in c#.net

OriginalGriff 3-Dec-13 7:29am

That depends on what you need the database for: if you need it so that a single user can access it for example, it's completely different from if you need two or more people sharing the same data.

Abhijeet pratap singh 3-Dec-13 7:36am

i want both but currently i want for single user
thanks for reply u have great knowledge
so pls tell me for both but first for single user software which can run on each computer
i am developing a stock management software it almost done but now i want a software which installa n run on each computer

OriginalGriff 3-Dec-13 8:04am

Single user is easy - don't use SQL! Use SqlCE, or SqLite, or even Access - they all work fine for single user and and pretty simple to connect to as it is just a file.

Multi user means a server: SQLServer, MySql Oracle - they all work in much the same way. You don't connect to the database, you connect to the server, and that connects to the database and "servers" the information back to you. It's a lot more powerful because it copes with multiple users on the same DB at the same time, but that comes with complexity.
That complexity is reflected in the connection string: *There is no single connections string that will connect to all servers*

For example, my Production system uses an IP address, server instance (Full SQL server), and requires explicit username and password combination. My development system uses SqlServer Express via LocalHost and Windows login.
The connection strings for the two systems have only one element in common: the database name (and even that isn't guaranteed)

The best way to handle this is to keep the connection string in a config file and provide a version for each installation with "points" at the appropriate server instance. That is what I do!

Abhijeet pratap singh 3-Dec-13 8:43am

The best way to handle this is to keep the connection string in a config file and provide a version for each installation with "points" at the appropriate server instance. That is what I do!

pls explain more these lines

Abhijeet pratap singh 3-Dec-13 17:51pm

how to use ms-access for single user
with c#.net
give example

OriginalGriff 4-Dec-13 5:32am

Oh come on! Google:
https://www.google.co.uk/search?q=Use+access+c%23&oq=Use+access+c%23