Include a derived control in my aspx page

register control at top of page giving it a TagPrefix:

<%@ Register Assembly="iProjectName" Namespace="iNamespceInCsFile" TagPrefix="ifc" %>

use tag prefix and control name in aspx

<ig:TemplateDataField Key="key1" Width="30px">
     <ItemTemplate>
     <ifc:CtrlClass ID="id1" runat="server" Text='<%# Eval "BoundCol1") %>' />
     </ItemTemplate>
</ig:TemplateDataField>

"CtrlClass" is the derived control class name, which is in a cs file name doesn't matter, but namespace is "iNamespceInCsFile" in project ="iProjectName".

public class Comment2 : TextBox
{ etc ...

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.

Leading zeros in tsql

select right ('StringOfZerosAsManyAsMaxNeededMoreIsOK'
+ cast ( AnIntegerLiteralOrIntVariable as varchar)
, IntLiteralWhichIsTotalLengthOfNeededString)

declare @counter int
set @counter = 126
select right ('000000' + cast ( @counter as varchar) , 6 )

result:
000126


declare @counter int
set @counter = 12345678
select right ('000000000' + cast ( @counter as varchar) , 6 )

result:
345678



declare @counter int
set @counter = 123
select right ('00' + cast ( @counter as varchar) , 6 )

result:
00123



declare @counter int
set @counter = 123
select right ('0000' + cast ( 123 as varchar) , 9 )

result:
000126

Crystal Reports like in db selection formula

{vTimeTrackDataAll4.ContactName} like '*'+{?pEmpName}+'*' and
{vTimeTrackDataAll4.StartTime} >= {?pStartDate} and
{vTimeTrackDataAll4.StartTime} <= {?pEndDate}

javascript on mouseover lv and doubleclick event

protected void ListView1_ItemDataBound(object sender, ListViewItemEventArgs e)
{
// not uploaded data
// this is done everytime the page is refreshed.

if (e.Item.ItemType == ListViewItemType.DataItem)
{


if (res & e.Row.DataItemIndex == theRowIndex)
{
GridView1.Rows[theRowIndex].Attributes.Add("onmouseover", "this.style.backgroundColor='PeachPuff'");
GridView1.Rows[theRowIndex].Attributes.Add("onmouseout", "this.style.backgroundColor='Beige'");
}

// Get the LinkButton control in the 9th cell
LinkButton _doubleClickButton = (LinkButton)e.Row.Cells[9].Controls[0];
// Get the javascript which is assigned to this LinkButton
string _jsDouble =
ClientScript.GetPostBackClientHyperlink(_doubleClickButton, "");
// Add this JavaScript to the ondblclick Attribute of the row
e.Row.Attributes["ondblclick"] = _jsDouble;

right click already defined
LinkButton _rightClickButton = (LinkButton)e.Row.Cells[10].Controls[0];
Get the javascript which is assigned to this LinkButton
string _jsDouble2 =
ClientScript.GetPostBackClientHyperlink(_rightClickButton, "");
Add this JavaScript to the ondblclick Attribute of the row
e.Row.Attributes["mousemove"] = _jsDouble2;
}
}