Best way to go about displaying varchar(MAX) fields; Gridview
-
Hey guys, I don't really have a problem, I'm just looking for the best way to do something. I have an entry form where some information needs to be entered into a SQL database, but it's in a (Two of these fields, actually) Varchar(MAX) field. So the information entered could be one line, or a paragraph. There's really no way for me to know. I need to display several fields from three different databases into a gridview (that's already done) including the two varchar(MAX) fields. So my question is, what would be the best way to go about this? I know I could just let it all just display in the gridview as is, but that would probably really make things look untidy and unorganized if there were paragraph style enteries for all 10 records displaying on a page. Any suggestions would help. Thanks, aqzman
-
Hey guys, I don't really have a problem, I'm just looking for the best way to do something. I have an entry form where some information needs to be entered into a SQL database, but it's in a (Two of these fields, actually) Varchar(MAX) field. So the information entered could be one line, or a paragraph. There's really no way for me to know. I need to display several fields from three different databases into a gridview (that's already done) including the two varchar(MAX) fields. So my question is, what would be the best way to go about this? I know I could just let it all just display in the gridview as is, but that would probably really make things look untidy and unorganized if there were paragraph style enteries for all 10 records displaying on a page. Any suggestions would help. Thanks, aqzman
Have you tried looking into Master-Detail view? You could have a DetailView created and on the select event display the two fields in the DetailView rather than the gridview.
Tarakeshwar Reddy MCP, CCIE Q(R&S) There are two kinds of people, those who do the work and those who take the credit. Try to be in the first group; there is less competition there. - Indira Gandhi
-
Hey guys, I don't really have a problem, I'm just looking for the best way to do something. I have an entry form where some information needs to be entered into a SQL database, but it's in a (Two of these fields, actually) Varchar(MAX) field. So the information entered could be one line, or a paragraph. There's really no way for me to know. I need to display several fields from three different databases into a gridview (that's already done) including the two varchar(MAX) fields. So my question is, what would be the best way to go about this? I know I could just let it all just display in the gridview as is, but that would probably really make things look untidy and unorganized if there were paragraph style enteries for all 10 records displaying on a page. Any suggestions would help. Thanks, aqzman
I have used a multi-line textbox. So then I can set the width and there is a scroll bar. The only issue is when you only have one line or no data at all then it looks a little weird to have a fixed multi-line textbox. I have written some code that checks the length and then decides which control to so. When there is big enough string I use the multi-line textbox if it is smaller then I just a label. Hope that helps. Ben
-
I have used a multi-line textbox. So then I can set the width and there is a scroll bar. The only issue is when you only have one line or no data at all then it looks a little weird to have a fixed multi-line textbox. I have written some code that checks the length and then decides which control to so. When there is big enough string I use the multi-line textbox if it is smaller then I just a label. Hope that helps. Ben