How to remove null values on button click?

Question

Hi guys, I have a form with button "Select All Emails". Now the problem I have if I click the button it will display all emails in that "ContactEmail" field from the database, if there is no email created it will show "NULL". Now what I want is not to show anything if the field is null (no email created). Below my controller code;

public JsonResult GetAllUser(EmployeeModel objModelMail, string to)
{
List Recyclers = new List();

using (WasteRecyclersEntities db = new WasteRecyclersEntities())
{
var query = from q in db.Recyclers
select q.ContactEmail;
return new JsonResult { Data = query.ToList(), JsonRequestBehavior = JsonRequestBehavior.AllowGet };
}

}

Mangesh G · Answer

var query = from q in db.Recyclers where q. ContactEmail !=null select q.ContactEmail try this

Dharmraj Thakur · Answer

Here is your solution... https://stackoverflow.com/questions/413084/equivalent-of-sql-isnull-in-linq

Mangesh G · Answer

Glad it Did Attie Happy Coding cheers !!!

Mangesh G · Answer

Did it worked ??

Mangesh G · Answer

Attie just return the JSON Converted string in that ModelState.isvalid condition http://www.c-sharpcorner.com/article/working-with-json-string-in-C-Sharp/ Refer this article for the same

Attie · Answer

Yes it did. I only needed this piece of code "where q.ContactEmail !=null"

Attie · Answer

Mangesh and Dharmraj thanks a lot for your assistance, I got the answer I needed. Much appreciated

Attie · Answer

Hi Mangesh and Dharmraj I want something like below. Using SQL Server Management Studio it's easy to do this, meaning to hide the null value, now to do this in my controller in MVC it's what I can't do. Because on button click I see emails in the forms, and fields without email I see "NULL" Correct one (SSMS) SELECT [ContactEmail] FROM [WasteRecyclers ].[dbo].[Recycler] where [ContactEmail] is not null MVC (NEED HELP HERE) public JsonResult GetAllUser() { List Recyclers = new List(); using (WasteRecyclersEntities db = new WasteRecyclersEntities()) { var query = from q in db.Recyclers select q.ContactEmail ; return new JsonResult { Data = query.ToList(), JsonRequestBehavior = JsonRequestBehavior.AllowGet }; } }