Because I always forget proc names ...

protected void Page_PreInit(object sender, EventArgs e)
{
string msg = "Fires 1";
}

protected void Page_Init(object sender, EventArgs e)
{
string msg = "Fires 2";
}


protected void Page_Load(object sender, EventArgs e)
{
string msg = "Fires 3";
}

protected override void OnPreRender(EventArgs e)
{
base.OnPreRender(e);
string msg = "Fires last";
}

WebDataGrid Numeric Pager Truncates List of Page Numbers

The WebDataGrid Numeric Pager was truncating the list of page numbers after reaching the end of the one line (table width) allocated for the pager display, as shown in the example below. There were scroll bars for the height and width of the data records, but no way to scroll past the end of the line of numbers and see page 21 in this example:



My solution was to create the following Css

<style type="text/css">
.tallPager {
height: 100px;
word-wrap: break-word;
text-align:left;
}
</style>

and apply it to the Paging property

  <Behaviors>
        <ig:Paging PageSize="25" PagerMode="Numeric" EnableInheritance="True"
             PagerCssClass="tallPager" />

etc...

The following shows the pager section for a different table, with the PagerCssClass ="tallPager"


Note: Word wraps can occur in the middle of a page number like 108:


Fortunately, I have a higher class of users and they were able to deal with that.

tsql INSERT INTO for bulk copy of records from SqlServer table to table

I have been using tsql

Select * into Tbl2 from Tbl1 where FName = 'David'

for a long time, as a shortcut to create new table Tbl2, a copy of Tbl1 including schema and data.

I'm glad I finally found out about :

Insert into Tbl2 ( LastName , FirstName , AdmitDate) select Last, First, RevDate from Tbl1 where FName = 'David'

to use when Tbl2 is already in existence.

Calling all Technical Women in Technology for...

What we have all been waiting for ...

A NJ Technical Women in Technology
Event


Register Now ->

Recommended Audiences: IT Professionals, Administrators, Developers, Architects

Are you a Technical Women in Technology?

Are you tired of always being surrounded by technical males that don't ____ (fill in the blank)?

Are you tired of trying to explain your technical issues to other women that just don't get it?

Are you looking to connect with other women with common interests?

Then, you may be interested in helping to form a Technical Women in Technology Group...

Refreshments: Appetizers & Water/Soda

Sponsors: Microsoft / SetFocus

Purpose:

To allow NJ Technical Women in Technology to meet and to discuss a future direction for a group



Event Updates: updates

Agenda:

Overview

Attendee Introductions

Panel Discussion (2-3 women sharing their experiences as a Technical Women in Technology

Future Direction Discussion - In-Person and/or Virtual meetings, frequency, meeting content, etc.



For Additional Information about how you can help kick start this community, please email melissa[@]sqldiva.com.

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;
              }


          }