>>>>>>>>Hi,
>>>>>>>>
>>>>>>>>I have a column in a table of type nchar(1). The value in this column is "A" or "I". I want to bind this column to a check box and show in the caption of the check box "Active" (for 'A') and "Inactive" for 'I'
>>>>>>>>
>>>>>>>>I tried the following binding code but get error:
>>>>>>>>
>>>>>>>>
>>>>>>>>this.chkStatus.DataBindings.Add("Checked", bindingSource1, "Status=='A'");
>>>>>>>>
>>>>>>>>
>>>>>>>>What am I doing wrong? TIA.
>>>>>>>
>>>>>>>Why not make your life easier and just change the type of the column to bit 1=Active 0=Inactive?
>>>>>>>True and False.
>>>>>>
>>>>>>Good point, Borislav. When I was writing the question I thought about the same. But I am sure, even if I change this column to a bit type there will be future cases where I may need to bind a check box to a string column.
>>>>>>Thank you.
>>>>>
>>>>>But how complex that could be?
>>>>>CheckBox has 3 values:
>>>>>True
>>>>>False
>>>>>NULL
>>>>>
>>>>>So you could handle it with a simple bit field that allow NULL :-)
>>>>
>>>>Excellent point, again. Thank you. (So, I see you moved to .NET world too. I am glad I am in a good company :)).
>>>
>>>No,
>>>I just know SQL Server :-)
>>
>>Then, before they put handcuffs on me for violating the forum etiquette <g>, quick question. In order to change the column in SQL Server from char to bit and not to lose the existing values, I would have to create a temp column to hold the values, right?
>
>For this case I will go with the new column and do an udate.
Thank you. This is what I thought I would have to do.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham