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

POST as form using C# to Pay Provider

The Remote Post Form class I have used the code for the jigar site and added my own goodies, so all credit to him. Sorry about the flast formating but is the only way I could get a neatish post using System; using System.Collections.Generic; using System.Web; using System.Security.Cryptography; /// <summary> /// Remotely handle and Post form from http://www.jigar.net/articles/viewhtmlcontent78.aspx%20 /// </summary> public class RemotePost { private System.Collections.Specialized.NameValueCollection Inputs = new System.Collections.Specialized.NameValueCollection(); public string Url; public string Method; public string FormName; public RemotePost(string pURL) { // // TODO: Add constructor logic here // Url = pURL; Method = "post"; FormName = "frmRemotePost"; }   public void Add(string name, string value) { Inputs.Add(name, value); } public void

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

Bitcoin / Cryptocurrency – what is it and how can I benefit

What is it I started investigating Bitcoin when it was worth just over $1000 a bitcoin. I was interested in what it was and how it worked. A lot of people are saying we missed the boat, but I believe that everyone should at least try put a little money in now, or at least use a faucet (see below) to make a little micro-currency. You can read a Wiki article about bitcoin and its history etc. But what you need to know is that it is a currency, that is independent of country. No one really knows who invented the concept of a cryptocurrency since the person who published the paper used a nom de plume. All new cryptocurrencies work more or less the same way as Bitcoin. So as I explain below I interchange these terms. Bitcoin is the original cryptocurrency. How Bitcoin works The currency releases a coin based on a mathematical formula. There will never be more than 21 million bitcoins (other cryptocurrencies do not work like this). Each bitcoin can have divided into one hundred mil