DataGrid Null Value Special Case
-
Hi, I am facing some null value problem of a datagrid. It is a bit complicated, let me explain a bit. Table A: int AFieldX store a primary key of Table B where Table A will get BFieldY base on AFieldX. Unfortunately AFieldX can be null, so when my datagrid make an INNER JOIN between Table A and Table B, it return nothing and therefore the whole datagrid is empty. Can I know is there a work around for this as to ignore and continue to print even there is null value? Thanks in advance. J Liang
-
Hi, I am facing some null value problem of a datagrid. It is a bit complicated, let me explain a bit. Table A: int AFieldX store a primary key of Table B where Table A will get BFieldY base on AFieldX. Unfortunately AFieldX can be null, so when my datagrid make an INNER JOIN between Table A and Table B, it return nothing and therefore the whole datagrid is empty. Can I know is there a work around for this as to ignore and continue to print even there is null value? Thanks in advance. J Liang
J Liang wrote:
so when my datagrid make an INNER JOIN between Table A and Table B,
How datagrid can do Inner Join ? Do you mean in query ? SQL Server has a IsNull function, provided to convert null values to specified value. Will that solve your problem ?