Comparison of ig bound Templated Checkbox to boolean BoundDataField

Shows up as text "true" or "false":
        <ig:BoundDataField DataFieldName="IsCostSaving" Key="IsCostSaving" width="30px">
            <Header Text="Cost Saving" />
          </ig:BoundDataField>    

Shows up as a checkbox with checked value picked up from bound field:
         <ig:TemplateDataField Key="cb1" width="30px">
            <Header Text="Cost Saving" />
               <ItemTemplate>
                 <asp:CheckBox ID="cb1" runat="server"  Checked='<%# Eval("IsCostSaving") %>' Enabled="false"  />
                </ItemTemplate>
          </ig:TemplateDataField>

Looping thru Infragistics WebDataGrid on the Server

Took me a while to find this. With some help from ig, thank you Chandradeep!

         protected void Button1_Click(object sender, EventArgs e)
          {
              //  loop thru selected cells and get their values 
                 foreach (GridRecordItem itm in WebDataGrid1.Behaviors.Selection.SelectedCells)
                  {
                      object ttt = itm.Text ;
                  }
            
              // example of  looping thru selected rows and getting values of columns
              foreach (GridRecord row in WebDataGrid1.Behaviors.Selection.SelectedRows)
              {
                  object ttt = row;
                  GridRecordItem itm = row.Items[0];
                  string sffssdf = itm.Text;
                  itm = row.Items[1];
                  sffssdf = itm.Text;
                  itm = row.Items[2];
                  sffssdf = itm.Text;
              }

              // example of  looping thru all rows and getting values of columns
              foreach (GridRecord row in WebDataGrid1.Rows)
              // foreach (GridRecordItem row in WebDataGrid1.Behaviors.Selection.SelectedCells)
              {
                  object ttt = row;
                  GridRecordItem itm = row.Items[0];
                              
                  string sffssdf =   itm.Text;
                  itm = row.Items[1];
                  sffssdf = itm.Text;
                  itm = row.Items[2];
                  sffssdf = itm.Text;
              }

              // example of  looping thru all rows and getting values of a checkbox in a column template field!!!!!
              foreach (GridRecord row in WebDataGrid1.Rows)
              // foreach (GridRecordItem row in WebDataGrid1.Behaviors.Selection.SelectedCells)
              {
                  CheckBox theCB = (CheckBox)row.Items[0].FindControl("cb1");
                  bool ischecked = theCB.Checked;
                  object ttt = row;
                  GridRecordItem itm = row.Items[0];


                  string sffssdf = itm.Text;
                  itm = row.Items[1];
                  sffssdf = itm.Text;
                  itm = row.Items[2];
                  sffssdf = itm.Text;
              }


          }

Case sensitive column contents in SqlServer

Use the following t-sql code to make the contents of a column case sensitive regardless of the default db setting:

alter table TheTableName alter column TheColumnName TypeOfColEgVarchar(20)OrChar(6) collate Latin1_General_CS_AS

for example:
alter table People alter column LastName varchar(20) collate Latin1_General_CS_AS

Am using this in SqlServer 2005.