Dear members and administrators,
Hello and a greeting of peace.
I've been doing a simple database web application, and I am using a [FONT="Courier New"]GridView[/FONT] in showing my data coming from SQL Server 2005. My table (named Student) in SQL Server has four fields (ID,FN,MN,LN).
In my search button, for example, I search for a Last Name, then the data coming from SQL Server will be displayed (if there is a match or if there are matches) with the help of [FONT="Courier New"]GridView[/FONT], but is there a way of adding extra columns (two columns for example) on the [FONT="Courier New"]GridView[/FONT] even I only have four fields?
And also, I noticed that the GridView gets the column name from my SQL Server. Is there a way to change it? (for example, instead of displaying LN I would like to change it to Last Name, etc.)
Thank you for reading this forum and may God bless us all.
Have a nice day.