about c# windows form and DataGridView

Question

i have a datagridview in c# windows form . when i use SELECT * FROM table_name WHERE column_name IS NOT NULL datagridview don't return for me null rows . what should i do ?

i am sorry for my bad enghlish.

Answer 1

make solo learn a chatting community 😄😄😄

Answer 2

ok

Answer 3

not bad is good English ok

Answer 4

ok bye

Answer 5

hiii

Answer 6

u r asking SQL to return rows which don't have NULL for column_name, so it doesn't return rows which have NULL for mentioned column.
Wht u tring to query?

Answer 7

welkam

Answer 8

hii your Indian ya no

Answer 9

😂😂😂

Answer 10

kya

Answer 11

this is my code
private void Form2_Load(object sender, EventArgs e)
Connection.ConnectionString = @"connection Path";
Connection.Open();
Command.Connection = Connection;
Command.CommandText = "select Number , Name , Services from tbleOwner Where Name is null";
DataAdapter.SelectCommand = Command;
DataAdapter.Fill(Data , " O2");
Command.ExecuteNonQuery();
dataGridView.DataBindings.Clear();
dataGridView.DataBindings.Add("datasource" , Data , "O2");

but datagridview return for me all of data ! Where is my mistake ?

Answer 12

First try the same query in SQL, if u r not getting expected result it probably something to do with ur table​ otherwise it's code error.

Answer 13

I have tried many ways in sql but the result has not changed. I guess the problem is dataGridView.

Answer 14

if SQL provide expected result it's an code error. hope this helps:
https://msdn.microsoft.com/en-us/library/fbk67b6z(v=vs.110).aspx

Answer 15

yes

Answer 16

thank you ☺

Answer 17

bye 😊

Answer 18

no I'm from iran !

Answer 19

😐