Query regarding Default value

Question

0.00/5 (No votes)

See more:

Dear Friends

i have a query which is discussed below. Please give your answers as soon as possible.

I have a table name Unit having columns Unitcode,unitname,Unitstatus,UnitOpeningDate.

In this table I have passed default value in unitstatus(not null) and unitopeningdate(null).

Now I have insert data from windows form. But my dataset does not contains the default value. and it gives some error while inserting the data .

Column 'UnitStatus' does not allow nulls.

My Cs code is :

C#

DataRow dataRow = globalCls.dataSet.Tables["tblUnit"].NewRow();
         //  dataRow["UnitStatus"] = (ddlActive.Text == "Active" ? "Y" : "N");
           dataRow["UnitCode"] = txtCode.Text;
           dataRow["UnitName"] = txtName.Text;
           dataRow["UnitAddress"] = txtAddress.Text;
         //  dataRow["UnitOpeningDate"] = DateTime.Now;
           globalCls.dataSet.Tables["tblUnit"].Rows.Add(dataRow);
           globalCls.sqlDataAdapter.Update(globalCls.dataSet.Tables["tblUnit"]);
           ClearData();

How to solve this problem.

Posted 26-Dec-11 23:34pm

Sunil.yadava09

Updated 26-Dec-11 23:35pm

Mehdi Gholam

v2

Add a Solution

Comments

Om Prakash Pant 27-Dec-11 5:35am

"Please give your answers as soon as possible" - Is this a Quiz?

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)

OriginalGriff · Answer 1 · 2011-12-26T23:38:00

Solution 1

You could try passing it a value for the "UnitStatus" column - it appears to be commented out in your code...

Posted 26-Dec-11 23:38pm

OriginalGriff

Tanveer A · Answer 2 · 2011-12-26T23:44:00

Solution 2

Dear sir,
you can not add table default value on dataset , you should explicitly
mention default value from front end.

Posted 26-Dec-11 23:44pm

Tanveer A

Supriya Srivastav · Answer 3 · 2011-12-27T02:19:00

SQL

Import Namespace Like,

          using System.Data.SqlTypes;

and insert null like (SqlDouble.Null) if field is double and (SqlInt16.Null) if field is int and SqlString.Null if it is varchar in database depending upon datatype.

To add default value to your dataset,You can try this :

DataSet dataset = new DataSet();
     dataset.Tables[0].Columns["Column_Name"].DefaultValue = "default_value";