datatable field check

Question

0.00/5 (No votes)

See more:

i having a data table which contains columns and rows..but there is no values on that fields..
in that data table some cell contains datas and some contains not.
how can i check a particular cell containing values or not .

Posted 21-May-13 22:54pm

geo thomas

Updated 21-May-13 23:19pm

v2

Add a Solution

Comments

Mayur Panchal 22-May-13 4:59am

field means ? a particular cell or whole column ?

geo thomas 22-May-13 5:03am

paricular cell

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)

Maciej Los · Answer 1 · 2013-05-21T22:58:00

Solution 1

1) Datatable[^] object
You need to check for DBNull.Value[^].

2) database
Use COALESCE (T-SQL)[^] function to replace NULL value with ownvalue:

SQL

SELECT COALESCE(numericcolumn,0) AS numericcolumn, COALESCE(textcolumn,"empty") AS textcolumn
FROM database

Posted 21-May-13 22:58pm

Maciej Los

Updated 21-May-13 23:34pm

v2

Comments

geo thomas 22-May-13 5:06am

how to check wether aparticular cell contain datas or not?

Maciej Los 22-May-13 5:08am

Follo the above link. At the end of page you'll find an example.

geo thomas 22-May-13 5:15am

its not what i am lookin for..
am having a data table in sql server 2005.
on a particular row some columesw doent have any datas..
how can i check that cell contain values or not.

string a = "select Break1_Start,Break1_End,Break2_Start,Break2_End,Break3_Start,Break3_End from Attendance_Register where Employee_ID='" + da.remEMP(ei) + "' and Date='"+ d +"' ";
dt = da.getdetails(a);
// dt is datatable obj
//getdetails() which is used to get data from database

Maciej Los 22-May-13 5:34am

See my answer after update ;)

geo thomas 22-May-13 5:52am

srry..this is not what i am looking for..

gvprabu 22-May-13 7:49am

I think, he need to do this in C#