CODEWITHSUNDEEP
c#winformsdatagridview
Amit Kumar
Amit Kumar

Reputation: 11

Select statement showing null values in DataGridView

I'm facing a problem in my c# form, I'm populating datagridview in c# with access database 2007 by command

SELECT * FROM TBLMEMBERINFO WHERE NAME LIKE 'A*';

this gives null value even name exist in database......

also when i have tried this command directly in access 2007 sql view...then it works ..showing results for name starting with A...

please suggest a solution how can i populate datagridview with access2007 having name starting with A...

Upvotes: 1

Views: 104

Answers (1)

Net Dev
Net Dev

Reputation: 416

If you were using sql commands did you try doing somthing like this?

command.CommandText = "SELECT * FROM TBLMEMBERINFO WHERE NAME = 'A%'";

Upvotes: 3

Related Questions