How to find 1st, 2nd or 5th character from a string?

Question

Hi Members,

 

Greetings of the day...

 

In my project of C# WinApp, there is a holiday planner that defines week-end and sets date accordingly. to do so, there are 7 CheckBoxes show days i.e. Sunday, Monday, Tuesday etc.

 

I save the details in Access database, in a single column as YNNNNNN. first Y if Sunday is checked else N and so on. now I don't know how to fetch the details.

 

I want the CheckBoxes get checked as per the YNNNNNN means only the CheckBox of Sunday will be checked. if the sequence is YNNYNNN then CheckBoxes of Sunday and Wednesday is checked and not others.

 

I am trying to get the data as dataset then something like if 1st letter is Y then check, if 2nd letter is N then uncheck. 

 

How to do this?

 

Thank You.

 

Mayank Jani.