.net - How to find if a value is NULL in SQL Server using c# -

-

i know values null in datatable in c# returned executedatatable of sqlhelper class.

string select = "select * testtable"; string val="";  datatable  dt=dbcon.executedatatable(select); foreach (datarow dr in dt.rows) {    foreach (datacolumn  dc in dt.columns )    {        if(dr[dc].equals (null))        {           val ="null";        }         else          {           val = dr[dc].tostring();        }    } }

but unfortunately didn't find way it. please let me know if there way. thank in advance.

as david m's method, can use datarow.isnull:

if (dr.isnull(dc))

Comments

Post a Comment

Popular posts from this blog

List<T>().Add problem C# -

-
i made list hold object in it, , i'll read it. if give index list, same object results. here code: list<tempids> treedids = new list<tempids>(); tempids tempids = new tempids(); foreach (itemgrouptreed treed in itemtreedcoll) { //idleri listeye alıyoruz daha sonra karşılaştırma yapmak için tempids.treedid = treed.id; tempids.treeparentid = treed.treeparentid; treedids.insert(treedids.count, tempids); //---- //eğer ilk gelen detay id ile methoda gelen id bir ise collectiona ekliyoruz. if (tempids.treedid == grouptreedid) { treedtempcoll.add(treed); } else { //burada karşılaştırma yapıyoruz. (int = 0; < treedids.count; i++) { if (tempids...
Read more

Javascript natural sort array/object and maintain index association -

-
i have array of items follows in javascript: var users = array(); users[562] = 'testuser3'; users[16] = 'testuser6'; users[834] = 'testuser1'; users[823] = 'testuser4'; users[23] = 'testuser2'; users[917] = 'testuser5'; i need sort array following output: users[834] = 'testuser1'; users[23] = 'testuser2'; users[562] = 'testuser3'; users[823] = 'testuser4'; users[917] = 'testuser5'; users[16] = 'testuser6'; notice how sorted value of array , value-to-index association maintained after array sorted (that critical). have looked solution this, tried making it, have hit wall. by way, aware technically not array since mean indices iterating 0 through n n+1 counting number proceeding n. define it, requirement project still same. also, if makes difference, not using jquery. the order of elements of array defined index. if specify values in different order, values stored in or...
Read more