how to get data from SQL to hide empty cell

Dharmesh Sharma

hi how to get data by store producer from sql server to hide empty cell

i m get data but empty cell in my sql table also come in my datagrid i thing i remove empty cell in coding in c# or crete store producer to get only data cell without empty cell

please help in both store producer or c# coding

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Roei Bar17y ago
Accepted answer
you can do a simple TSQL Select
select * from TblName where

MotherBoard is not null

And

MotherBoard <> ''
this will make sure you dont get the empty MotherBoard Rows
Dharmesh Sharma17y ago
I have one table and fields are
id
Processor
MotherBoard

now the id is primary key and both field are varchar(50) ok
now i insert the value only processor and motherBoard is null

now again i am insert into motherboard and processor in null

now i am get data only processor the my grid has two rows look like this

in this image two field are empty because i m not insert the value its ok
but how to hide this field

please help me give sp in sql server or code in c#
thanks
Roei Bar17y ago
can you provide a bit more information about the sql tables and SP required, cause in order to help you out, i need additional information on the "Cells" that you dont want to show?