Click here to Skip to main content

devausha asked:

Open original thread
I am stored values to datatable from database.
My datatable has following
jc_id  jc_name jc_car        jc_color  jc_plate jc_service  jc_spare jc_qty
1	asdfsa	Maruti800	red	123	NULL	    NULL	NULL
NULL	NULL	NULL		NULL	NULL	WaterWash   NULL	NULL
NULL    NULL    NULL            NULL    NULL    WaterWash   NULL         NULL
NULL    NULL    NULL            NULL    NULL    NULL        Star Wars   34.00
NULL    NULL    NULL            NULL    NULL    NULL        Shrek   43.00
 

In this datatable I want a jc_service column without null value
like
jc_service
WaterWash
WaterWash
 
I want to this copy this column only to another datatable how to do it?
Please help me...
Tags: C#, ASP.NET

Preview



When answering a question please:
  1. Read the question carefully.
  2. Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
  3. 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.
Let's work to help developers, not make them feel stupid.
Please note that all posts will be submitted under the The Code Project Open License (CPOL).



Advertise | Privacy | Mobile
Web03 | 2.8.140821.2 | Last Updated 26 Mar 2009
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100