Hi,
Field 'city' (char(20)) in a table of sqlserver contains 9 rows: some are filled, some are Null and some don't contain anything (empty). New York Paris Null
Toronto
Null Null Brussels
I created a datagridview in windows forms and want to get in variable 'city' either the name of the city or 'no city'.
private void dataGridView1_RowHeaderMouseClick(object sender, DataGridViewCellMouseEventArgs e) { string afb = dataGridView1.Rows[e.RowIndex].Cells[3].Value.ToString(); if (String.IsNullOrEmpty(afb)) // when Null or empty city = "no city"; else city = afb; MessageBox.Show(city); }
My problem is this: when i click in the rowheader (in the datagridview) of a filled city, i get the cityname: that's ok; when clicking in the rowheader of a NULL, i get "no city": this is also ok, but when i click in the rowheader of a empty city, i get nothing. Why? I thought String.IsNullOrEmpty checked Null and empty. How can i fix this?
I also tried with this code but same result: 'city' contains nothing when the field is empty. if (afb.Equals(System.DBNull.Value) || afb == "") city = "no city"; else city = afb;
I also tried with this: doesn't work either if (afb.Length == 0) city = "no city"; else city = afb;
Thanks