Skip to main content

GridView and Item Template

When I first came across GridView I was unimpressed, there were a few things it did not do that a DataGrid did, and I immediately reverted back to the DataGrid.
Over the last few days I have been working on the GridView again, and have found it a great tool. And most of what I have below applies to DatraGrid, and DetailView too.
There are a few things that you should look at before giving up on it. The HTMLEncoding is the main thing I missed, which allows you to have html formatting in you data fields, and are displayed with them. Still have not figured out the difference between the two, and by heaven the help is one step away from useless. “This is used by programmers….” And same with the on events does not help to tell us it is used, not what raises it.

However the main reason for my post is the ItemTemplate. I found out it is easy to add them in design view and then click on the GridView select the little right arrow click Edit Fields then click convert into a Template Field for the fields you want to manipulate your way (initially I got this from: http://www.wherecanibuyit.co.uk/ASP/fully_editable_gridview.html) .

Once this is done in the code you can manipulate the code the way you like, including calling a sub routing. To do so just convert the Eval or Bind to the routine you want, and it is called with the parameters you pass, normally the DataField
A few lessons I learn regarding database manipulation when doing this were. Be wary of the database name, sometimes you need to specify the full name in the queries. Build you query in the query build and check that they work. Also I am not sure why but fields with spaces in the cause trouble. The Select query places “[“ and “]” around them and this works for select but the update and insert give problems, and any data field with html in it will not save unless you change your web config. Both these I am looking for alternative solutions (may require some code)

Of course all of this was inspired by a few fresh brews of quality coffee

Comments

Popular posts from this blog

SMTP servers of South Africa

SMTP Settings Below is a list of SMTP sites in South Africa, using this and the ISP Map you can try and find which one works best for you. Telkom smtp.saix.net (ADSL) smtp.telkomsa.co.za (56k dial up) smtp.telkomsa.net Internet Solutions smtp.isdsl.net (ADSL) smtp.dial-up.net (56k dial up on IS) smtp.layerone.net (3g backbone) Vodacom smtp.vodacom.co.za smtp.vodamail.co.za MTN smtp.mtn.co.za Cell C smtp.cellc.co.za (GPRS) mail.cmobile.co.za (also used by Virgin) ABSA mail.absa.co.za iBurst smtp.wbs.co.za smtp.iburst.co.za @lantic smtp.lantic.net (ADSL,Dialup, ISDN) Sentech smtp.sentech.co.za MWEB smtp.mweb.net (ADSL) - this is to be retired End June 2012, use below instead smtp.mweb.co.za (56k dial-up & ADSL & business) iAfrica smtp.uunet.co.za smtp.iafrica.com Neotel smtp.neotel.co.za Tiscali NOW MWeb smtp.tiscali.co.za Netactive NOW MWeb smtp.netactive.co.za Global smtp.global.co.za Hertzner Use y

Fixing winmail.dat problem - specifically in Quickbooks

For months we have had problems with attachments from Quickbooks. Having looked down many avenues I think we have found a fix or few: (See below for update) Here are a few websites that help out: Microsoft Outlook/Exchange MS-TNEF handling (aka "Winmail.dat", "Win.dat", or "Part 1.2" problem of unopenable email attachments) http://news.office-watch.com/t/n.aspx?a=716 KB958012 : When you use Outlook 2007 to send an e-mail message, the recipient of the message sees an attachment that is called Winmail.dat Essentially the summary is that there is a problem with Outlook trying to force Rich Text Format. so you need to turn that off. Mail users not receiving email in an Outlook derivative will have a problem. This format is called So: Go into Outlook On the "Tools" menu, click "Options", then click the "Mail Format" tab, and then the "Internet Format" button. Set "When sending Outlook Ri

Programmatically send email in Access using VBA and Outlook

When I first wrote my early Access system I used a function I setup in Outlook and then I called that. On upgrading I had a few problems with the older method then I found some help on the MSDN website here... and the related video. The first thing to do before starting the code is go into access, access the VBA (press Ctl+G) then click on "Tools" The "References" and then make sure you scroll down to "Microsoft Outlook ..." the version there will be determined by what version you have installed. This the code that I ended up with after looking at the site above Private olApp As Outlook.Application Private olNameSpace As Outlook.NameSpace ' The basics of this from MSDN site ' http://msdn.microsoft.com/en-us/library/ee208547(v=office.12).aspx Private Sub InitOutlook()  ' Initialize a session in Outlook   Set olApp = New Outlook.Application   'Return a reference to the MAPI layer   Set olNameSpace = olApp.GetNamespace("MA