I have a datagridview in my winform. I fill it with sql query. I call the column names like that:
This is my sql query:
SELECT SF.ID, SF.TARIH AS 'TAR?H', M.AD AS 'Mü?TER? ADI' FROM TABLE1 SF AND TABLE2 M
These column names have Turkish and space characters as you see. When i try to filter datagridview, i use this code:
(datagridview.DataSource as DataTable).DefaultView.RowFilter =
string.Format("'Mü?TER? ADI' LIKE '%{0}%'", textbox.Text.ToUpper());
It doesn't work. If i call the column name in sql query like that M.AD AS 'MAD'
and in code like that "MAD LIKE '%{0}%'"
it works. But i need to call column name as 'Mü?TER? ADI'
. How can i do that? Thx for any help.
See Question&Answers more detail:
os 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…