data value field how to store in the DB table

Question

2.33/5 (3 votes)

See more:

CREATE TABLE [dbo].[Register](
[ID] [int] IDENTITY(1,1) NOT NULL,
[FirstName] [nvarchar](50) NULL,
[LastName] [nvarchar](50) NULL,
[Username] [nvarchar](50) NULL,
[Email] [nvarchar](50) NULL,
[Password] [nvarchar](50) NULL,
[Role] [nvarchar](50) NULL,
[Phone] [int] NULL,
[OrganisationID] [int] NOT NULL,
[CreatedAt] [datetime] NULL CONSTRAINT [DF__Register__Create__3D2915A8] DEFAULT (getdate()),
CONSTRAINT [PK_Register] PRIMARY KEY CLUSTERED
this is the table which i have created. here the organisation ID is foreign key and coming to my design part

i have
firstname, alstname,phone,email,password,role,organisationame after entering these these details, and clicked on submit button i m getting error as :

SQL

Cannot insert the value NULL into column 'OrganisationID', table 'Resource Management.dbo.Register'; column does not allow nulls. INSERT fails.
The statement has been terminated.

Posted 10-Jan-13 19:45pm

Dhritirao's

Updated 10-Jan-13 20:28pm

v5

Add a Solution

Comments

Sandeep Mewara 11-Jan-13 1:58am

Your question is not clear. You want to insert the dropdown field into which table and when?

Workflow? Someone in UI selects something in drodpown and then you want to save that in your database? OR you want to directly pick some value from table 1 in DB and save in Table2?

What is the role of dropdownlist herE?

prashant patil 4987 11-Jan-13 2:05am

hey angelina:
be clear your question... specify details of your question...

2 solutions

Solution 2

see your table creation query

SQL

[OrganisationID] [int] NOT NULL,

that's mean you can't enter the NULL value for that column.

Either you have to modify the [OrganisationID] to allow NULL or you have to insert the integer value for that column.

Posted 10-Jan-13 20:37pm

Tharaka MTR

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)

Sanjeev Alamuri · Accepted Answer · 2013-01-10T20:33:00

Solution 1

So the Table 'Resource Management.dbo.Register' itself say it wont accepts the null values for 'OrganisationID'.

So set the null value like this,

[OrganisationID] [int]= NULL

Otherwise pass OrganisationID from Your code.

Posted 10-Jan-13 20:33pm

Sanjeev Alamuri

Comments

Dhritirao's 11-Jan-13 2:40am

my doubt is how to pass the organisationid from the code

Sanjeev Alamuri 11-Jan-13 2:43am

so u have dropdown which contains OrganisationName and OrganisationId, the get the value of dropdown selected value by this,

int OrganisationID= int.Parse(drpOrganisaiton.SelectedVlaue);.