how to adjust the view

Hi, as seen in the screenshot I have a small list at the top and a detailed list of te record at the bottom.
Why does it show in the yellow suddenly more colums, or is this normal ?
How can I adjust the field Studies so that it is show as a textbox, so I mean with more than one line in it ?
Also, children is a Boolean so it shows 1, but in SQL this is used as True, so if I do a edit here, it is still shown as 1, but I would need to change this everytime to True ? Can't I just show it as True instead of a 1 ?
Capture.JPG
troostersAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

kswathiCommented:
I think in your code you have highlighted the selected row, so it displays yellow, also displaying more fields.

For the children field check  the binding, check the datatype at the sql & asp.net.
You need   cast as bit to directly retrieve it as true/ false or if it is a nvarchar field you need to explicitly cast it/ convert it.

If you can share the code then Ican help you more.

Hope it helps.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
troostersAuthor Commented:
Code is in attachment
code.txt
0
troostersAuthor Commented:
Hello, can you please advise according to my code ? I'm not an expert on casting and such.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
ASP.NET

From novice to tech pro — start learning today.