how to get data from SQL to hide empty cell

Question

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

Roei Bar · 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 sharma · Answer

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 Bar · Answer

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?