SH Programmer - Cornwall

formview final formatting

2010-10-21T15:01:00.001-07:00

border: 0
cellspacing: 0
cellpadding: 0
FONT-SIZE: 9pt; MARGIN: 2px 2px 2px 5px; FONT-FAMILY: Arial

formview formatting

2010-10-21T15:00:00.003-07:00

cell width 0% for names of cols
put adjuster label in a row below, width 0%, cell 0%
txtboxes size same as in filter
val summary height 0%

set color and margins of page body document

2010-10-21T15:00:00.001-07:00

Reportviewer overlapping on panel and other controls at bottom

2010-10-21T14:59:00.001-07:00

Resolved it by adding an invisible label with length adjusted accordingly and making it visible along with the reportviewer.

Autokey primary key column selected as sequence in objectdatasource reportviewer

2010-10-21T14:58:00.003-07:00

open dataset1.xsd
edit it
add
<xs:element name="Autokey1" msdata:ReadOnly="true" msdata:Caption="Autokey" msprop:Generator_UserColumnName="Autokey1" msprop:Generator_ColumnPropNameInRow="Autokey1" msprop:Generator_ColumnVarNameInTable="columnAutokey1" msprop:Generator_ColumnPropNameInTable="Autokey1Column" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
full listing
<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="DataSet1" targetNamespace="http://tempuri.org/DataSet1.xsd" xmlns:mstns="http://tempuri.org/DataSet1.xsd" xmlns="http://tempuri.org/DataSet1.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
<xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Web.config" AppSettingsPropertyName="Lungar ProjectConnectionString" ConnectionStringObject="" IsAppSettingsProperty="True" Modifier="Assembly" Name="Lungar ProjectConnectionString (Web.config)" ParameterPrefix="@" PropertyReference="AppConfig.System.Configuration.ConfigurationManager.0.ConnectionStrings.Lungar ProjectConnectionString.ConnectionString" Provider="System.Data.SqlClient">
          </Connection>
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="DataTableAdapter" GeneratorDataComponentClassName="DataTableAdapter" Name="Data" UserDataComponentName="DataTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Lungar ProjectConnectionString (Web.config)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="False" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT
                            CONVERT(VARCHAR, (CASE WHEN Autokey IS NULL THEN
                          (SELECT     TOP 1 '' AS Autokey
                            FROM          Data) ELSE Autokey END), 1) AS Autokey,
                            CONVERT(VARCHAR, (CASE WHEN Province IS NULL THEN
                          (SELECT     TOP 1 '' AS Province
                            FROM          Data) ELSE Province END), 1) AS Province,
                            CONVERT(VARCHAR, (CASE WHEN District IS NULL THEN
                          (SELECT     TOP 1 '' AS District
                            FROM          Data) ELSE District END), 1) AS District,
                            CONVERT(VARCHAR, (CASE WHEN Hospital IS NULL THEN
                          (SELECT     TOP 1 '' AS Hospital
                            FROM          Data) ELSE Hospital END), 1) AS Hospital,
                            CONVERT(VARCHAR, (CASE WHEN Caterer_Name IS NULL THEN
                          (SELECT     TOP 1 '' AS Caterer_Name
                            FROM          Data) ELSE Caterer_Name END), 1) AS Caterer_Name,
                            CONVERT(CHAR(11), (CASE WHEN Date_of_Entry IS NULL THEN
                          (SELECT     TOP 1 '2/5/1981' AS Date_of_Entry
                            FROM          Data) ELSE Date_of_Entry END), 106) AS Date_of_Entry,
                            CASE WHEN Date_of_Entry = '01 Jan 1900' THEN
                          (SELECT     TOP 1 '' AS Date_of_Entry
                            FROM          Data) ELSE DATENAME(WEEKDAY, Date_of_Entry) END AS Week,
                            CONVERT(VARCHAR, (CASE WHEN No_of_Daigs IS NULL
                      THEN
                          (SELECT     TOP 1 '' AS No_of_Daigs
                            FROM          Data) ELSE No_of_Daigs END), 1) AS No_of_Daigs, CONVERT(VARCHAR, (CASE WHEN Food_Item IS NULL THEN
                          (SELECT     TOP 1 '' AS Food_Item
                            FROM          Data) ELSE Food_Item END), 1) AS Food_Item,
                            No_of_Rotis,
                            CONVERT(VARCHAR, (CASE WHEN No_of_Bene_Male IS NULL THEN
                          (SELECT     TOP 1 '' AS No_of_Bene_Male
                            FROM          Data) ELSE No_of_Bene_Male END), 1) AS No_of_Bene_Male, CONVERT(VARCHAR, (CASE WHEN No_of_Bene_Female IS NULL
                      THEN
                          (SELECT     TOP 1 '' AS No_of_Bene_Female
                            FROM          Data) ELSE No_of_Bene_Female END), 1) AS No_of_Bene_Female, CONVERT(VARCHAR, (CASE WHEN Daily_Cost_Per_Person IS NULL
                      THEN
                          (SELECT     TOP 1 '' AS Daily_Cost_Per_Person
                            FROM          Data) ELSE Daily_Cost_Per_Person END), 1) AS Daily_Cost_Per_Person, CONVERT(VARCHAR, (CASE WHEN Acc_Exp IS NULL
                      THEN
                          (SELECT     TOP 1 '' AS Acc_Exp
                            FROM          Data) ELSE Acc_Exp END), 1) AS Acc_Exp
FROM         Data
WHERE     (Date_of_Entry BETWEEN @Date_of_Entry_From AND @Date_of_Entry_To) OR
                      (Date_of_Entry IS NULL)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="Date_of_Entry_From" ColumnName="CONVERT (CHAR(11), (CASE WHEN Date_of_Entry IS NULL THEN (SELECT TOP 1 '2/5/1981' AS Date_of_Entry FROM Data) ELSE Date_of_Entry END), 106)" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@Date_of_Entry_From" Precision="0" Scale="0" Size="8" SourceColumn="Date_of_Entry" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="Date_of_Entry_To" ColumnName="CONVERT (CHAR(11), (CASE WHEN Date_of_Entry IS NULL THEN (SELECT TOP 1 '2/5/1981' AS Date_of_Entry FROM Data) ELSE Date_of_Entry END), 106)" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@Date_of_Entry_To" Precision="0" Scale="0" Size="8" SourceColumn="Date_of_Entry" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Province" DataSetColumn="Province" />
              <Mapping SourceColumn="District" DataSetColumn="District" />
              <Mapping SourceColumn="Hospital" DataSetColumn="Hospital" />
              <Mapping SourceColumn="Caterer_Name" DataSetColumn="Caterer_Name" />
              <Mapping SourceColumn="Food_Item" DataSetColumn="Food_Item" />
              <Mapping SourceColumn="Date_of_Entry" DataSetColumn="Date_of_Entry" />
              <Mapping SourceColumn="Week" DataSetColumn="Week" />
              <Mapping SourceColumn="No_of_Daigs" DataSetColumn="No_of_Daigs" />
              <Mapping SourceColumn="No_of_Rotis" DataSetColumn="No_of_Rotis" />
              <Mapping SourceColumn="No_of_Bene_Male" DataSetColumn="No_of_Bene_Male" />
              <Mapping SourceColumn="No_of_Bene_Female" DataSetColumn="No_of_Bene_Female" />
              <Mapping SourceColumn="Daily_Cost_Per_Person" DataSetColumn="Daily_Cost_Per_Person" />
              <Mapping SourceColumn="Acc_Exp" DataSetColumn="Acc_Exp" />
              <Mapping SourceColumn="Autokey" DataSetColumn="Autokey1" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
        </Tables>
        <Sources>
        </Sources>
      </DataSource>
    </xs:appinfo>
</xs:annotation>
<xs:element name="DataSet1" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="DataSet1" msprop:Generator_DataSetName="DataSet1">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Data" msprop:Generator_UserTableName="Data" msprop:Generator_RowDeletedName="DataRowDeleted" msprop:Generator_RowChangedName="DataRowChanged" msprop:Generator_RowClassName="DataRow" msprop:Generator_RowChangingName="DataRowChanging" msprop:Generator_RowEvArgName="DataRowChangeEvent" msprop:Generator_RowEvHandlerName="DataRowChangeEventHandler" msprop:Generator_TableClassName="DataDataTable" msprop:Generator_TableVarName="tableData" msprop:Generator_RowDeletingName="DataRowDeleting" msprop:Generator_TablePropName="Data">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Autokey" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="Autokey" msprop:Generator_ColumnVarNameInTable="columnAutokey" msprop:Generator_ColumnPropNameInRow="Autokey" msprop:Generator_ColumnPropNameInTable="AutokeyColumn" type="xs:int" />
              <xs:element name="Province" msprop:Generator_UserColumnName="Province" msprop:Generator_ColumnVarNameInTable="columnProvince" msprop:Generator_ColumnPropNameInRow="Province" msprop:Generator_ColumnPropNameInTable="ProvinceColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="District" msprop:Generator_UserColumnName="District" msprop:Generator_ColumnVarNameInTable="columnDistrict" msprop:Generator_ColumnPropNameInRow="District" msprop:Generator_ColumnPropNameInTable="DistrictColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Hospital" msprop:Generator_UserColumnName="Hospital" msprop:Generator_ColumnVarNameInTable="columnHospital" msprop:Generator_ColumnPropNameInRow="Hospital" msprop:Generator_ColumnPropNameInTable="HospitalColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Caterer_Name" msprop:Generator_UserColumnName="Caterer_Name" msprop:Generator_ColumnVarNameInTable="columnCaterer_Name" msprop:Generator_ColumnPropNameInRow="Caterer_Name" msprop:Generator_ColumnPropNameInTable="Caterer_NameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Food_Item" msprop:Generator_UserColumnName="Food_Item" msprop:Generator_ColumnVarNameInTable="columnFood_Item" msprop:Generator_ColumnPropNameInRow="Food_Item" msprop:Generator_ColumnPropNameInTable="Food_ItemColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Week" msprop:Generator_UserColumnName="Week" msprop:Generator_ColumnPropNameInRow="Week" msprop:Generator_ColumnVarNameInTable="columnWeek" msprop:Generator_ColumnPropNameInTable="WeekColumn" type="xs:string" minOccurs="0" />
              <xs:element name="Date_of_Entry" msdata:ReadOnly="true" msprop:Generator_UserColumnName="Date_of_Entry" msprop:Generator_ColumnPropNameInRow="Date_of_Entry" msprop:Generator_ColumnVarNameInTable="columnDate_of_Entry" msprop:Generator_ColumnPropNameInTable="Date_of_EntryColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="11" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="No_of_Daigs" msdata:ReadOnly="true" msprop:Generator_UserColumnName="No_of_Daigs" msprop:Generator_ColumnPropNameInRow="No_of_Daigs" msprop:Generator_ColumnVarNameInTable="columnNo_of_Daigs" msprop:Generator_ColumnPropNameInTable="No_of_DaigsColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="No_of_Rotis" msdata:ReadOnly="true" msprop:Generator_UserColumnName="No_of_Rotis" msprop:Generator_ColumnPropNameInRow="No_of_Rotis" msprop:Generator_ColumnVarNameInTable="columnNo_of_Rotis" msprop:Generator_ColumnPropNameInTable="No_of_RotisColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="No_of_Bene_Male" msdata:ReadOnly="true" msprop:Generator_UserColumnName="No_of_Bene_Male" msprop:Generator_ColumnPropNameInRow="No_of_Bene_Male" msprop:Generator_ColumnVarNameInTable="columnNo_of_Bene_Male" msprop:Generator_ColumnPropNameInTable="No_of_Bene_MaleColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="No_of_Bene_Female" msdata:ReadOnly="true" msprop:Generator_UserColumnName="No_of_Bene_Female" msprop:Generator_ColumnPropNameInRow="No_of_Bene_Female" msprop:Generator_ColumnVarNameInTable="columnNo_of_Bene_Female" msprop:Generator_ColumnPropNameInTable="No_of_Bene_FemaleColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Daily_Cost_Per_Person" msdata:ReadOnly="true" msprop:Generator_UserColumnName="Daily_Cost_Per_Person" msprop:Generator_ColumnPropNameInRow="Daily_Cost_Per_Person" msprop:Generator_ColumnVarNameInTable="columnDaily_Cost_Per_Person" msprop:Generator_ColumnPropNameInTable="Daily_Cost_Per_PersonColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Acc_Exp" msdata:ReadOnly="true" msprop:Generator_UserColumnName="Acc_Exp" msprop:Generator_ColumnPropNameInRow="Acc_Exp" msprop:Generator_ColumnVarNameInTable="columnAcc_Exp" msprop:Generator_ColumnPropNameInTable="Acc_ExpColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Autokey1" msdata:ReadOnly="true" msdata:Caption="Autokey" msprop:Generator_UserColumnName="Autokey1" msprop:Generator_ColumnPropNameInRow="Autokey1" msprop:Generator_ColumnVarNameInTable="columnAutokey1" msprop:Generator_ColumnPropNameInTable="Autokey1Column" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
</xs:element>
</xs:schema>

IIS slow on vista

2010-10-21T14:58:00.001-07:00

http://forums.iis.net/t/1100987.aspx
conn str props: http://weblogs.asp.net/wallen/archive/2005/03/22/395496.aspx
add in conn str of web.config Min Pool Size=5

Formatting PDF from reportviewer (multiple page crossing problem)

2010-10-21T14:54:00.007-07:00

use ratio calc
http://www.continuum2.com/js_ratio.php

In the Report Properties dialog if I set Page width to 8.27in and Page height to 11.69in then the Page Setup dialog of ReportViewer defaults to A4.
In the Report Properties dialog if I set Page width to 11.69in and Page height to 8.27in then the Page Setup dialog of ReportViewer defaults to A4, and Orientation defaults to Landscape.
--

customvalidator for date and tracing

2010-10-21T14:54:00.005-07:00

put trace="true" in aspx top declaration
usually some other thing is altering the state during page load of the control to be validated. sometimes the field is being used as a filter and that effects other controls thru its sqldatasource.

Using Tracing in asp.net

2010-10-21T14:54:00.003-07:00

http://www.asp101.com/articles/robert/tracing/default.asp

Always keep sqldatasource of formview inside the formview

2010-10-21T14:54:00.001-07:00

The importance of this is that if you are referring to a control inside the fv through a parameter like filter or select then it wont be able to access it otherwise.

customvalidators problem with button firing

2010-10-21T14:53:00.001-07:00

If VAL_FTR_Date_of_Entry_From.IsValid = True Then
use this kind of comparison on whatever control is accessing the control directly or indirectly thru for e.g an sqldatasource, and put this comparison usually on the button or the sub that is triggering the conflict command so that they run only after the validation is complete.

validation check for null values

2010-10-21T14:52:00.003-07:00

make sure validateemptytext=true in custom validator
then do as normal
    Dim TXT_Province As TextBox
        TXT_Province = CType(FormView_Manage_Province.FindControl("ProvinceTextBox"), TextBox)
        If TXT_Province.Text.Trim = "" Then
            args.IsValid = False
        Else
            args.IsValid = True
        End If

validating phone numbers, allowing only numbers and dashes

2010-10-21T14:52:00.001-07:00

Use custom validator.
Protected Sub VAL_FV_Manage_Caterer_Name_Caterer_Telephone_ServerValidate(ByVal source As Object, ByVal args As System.Web.UI.WebControls.ServerValidateEventArgs)
        Dim ValidChars As String = "0123456789-,"
        Dim RepChar As Char
        'Dim sText As String = tmp_SupplierPhoneTextBox.Text
        Dim sText As String
        sText = CType(FormView_Manage_Caterer_Name.FindControl("Caterer_TelephoneTextBox"), TextBox).Text
        Dim i As Integer
        For i = 0 To sText.Length - 1 Step i + 1
            RepChar = sText.Chars(i)
            If ValidChars.IndexOf(RepChar) = -1 Then
                args.IsValid = False
                Return
            End If
        Next
        args.IsValid = True
    End Sub

Formview giving error when changing mode to insert : Violation of PRIMARY KEY constraint

2010-10-21T14:51:00.001-07:00

if Violation of PRIMARY KEY constraint on changemode to insert do it on modechanged event of formview:
Protected Sub FormView_Manage_Province_ModeChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles FormView_Manage_Province.ModeChanged
        If FormView_Manage_Province.CurrentMode = FormViewMode.ReadOnly Then
            FormView_Manage_Province.ChangeMode(FormViewMode.Insert)
        End If
    End Sub

page level error checking for update / delete / insert and general errors

2010-10-21T14:49:00.001-07:00

put in main aspx.
Protected Sub Page_Error(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Error
        ' BEGIN - catching errors due to referential integrity constraints
        ' getting the exception
        Dim objErr As Exception = Server.GetLastError().GetBaseException()
        Dim tempMsg As String
        Dim tempStrAndErrCompDELETE As Boolean
        Dim tempStrAndErrComp As Boolean
        ' getting the message from objerr (the real exception raised)
        Dim tempErrorMessage As String
        tempErrorMessage = objErr.Message.ToString()
        ' comparing variables for violations
        tempStrAndErrCompDELETE = tempErrorMessage.Contains("DELETE")
        tempStrAndErrComp = tempErrorMessage.Contains("")
        ' looking for DELETE violation
        If (tempStrAndErrCompDELETE = True) Then
            tempMsg = "This is a non-critical error. There was an error during DELETE operation. This was because the record you tried to delete is already being used. If a record is already being used in another table then deleting it would also delete its entry from there and that would create null references. For further explanation of this please contact Saad Hashmi, Asst. IT Programmer." _
                      + vbCrLf + " Error: " + tempErrorMessage
            Server.Transfer("TempErrorAdmin.aspx?request_tempMsg=" + tempMsg)
            ' looking for GENERAL violation
        ElseIf (tempStrAndErrComp = True) Then
            tempMsg = "This is a critical general error. For further explanation of this please contact Saad Hashmi, Asst. IT Programmer." _
                    + " Error: " + tempErrorMessage
            Server.Transfer("TempErrorAdmin.aspx?request_tempMsg=" + tempMsg)
        End If
        ' clearing the server error raised
        Server.ClearError()
    End Sub
make a TempErrorAdmin.aspx page and place code...

Partial Class TempErrorAdmin
    Inherits System.Web.UI.Page
    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        Dim tmp_lbl_ErrorLabel As Label
        tmp_lbl_ErrorLabel = CType(FindControl("ErrorLabel"), Label)
        tmp_lbl_ErrorLabel.Text = Request.QueryString("request_tempMsg")
    End Sub
    Protected Sub btn_back_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btn_back.Click
        ' If the querystring had a DELETE in it then transfer it back
        ' to requesting page on press of BACK BUTTON.
        ' However if querystring had something other than DELETE then transfer
        ' to default.aspx.
        ' This is because if querystring was something other than DELETE (or a ref. integrity violation)
        ' then the requesting page will transfer it back to error page since its a critical error.
        Dim temp_PreviousPage As String
        Dim tempStrAndErrCompDELETE As Boolean
        Dim tempStrAndErrComp As Boolean
        'Dim tmp_ContentPlaceHolder As ContentPlaceHolder = CType(Master.FindControl("ContentPlaceHolder1"), ContentPlaceHolder)
        Dim tmp_lbl_ErrorLabel As Label = CType(FindControl("ErrorLabel"), Label)
        tmp_lbl_ErrorLabel.Text = Request.QueryString("request_tempMsg")
        ' comparing variables for violations
        tempStrAndErrCompDELETE = tmp_lbl_ErrorLabel.Text.Contains("DELETE")
        tempStrAndErrComp = tmp_lbl_ErrorLabel.Text.Contains("")
        ' looking for DELETE violation
        If (tempStrAndErrCompDELETE = True) Then
            temp_PreviousPage = Request.UrlReferrer.ToString
            Response.Redirect(temp_PreviousPage)
            ' looking for GENERAL violation
        ElseIf (tempStrAndErrComp = True) Then
            temp_PreviousPage = "Default.aspx"
            Response.Redirect(temp_PreviousPage)
        End If
    End Sub
End Class

adding new line in string or textbox

2010-10-21T14:48:00.005-07:00

vbCrLf. or environment.NewLine or <br> ..use <br> inside the string.
e.g
tempMsg = "This is a non-critical error. There was an error during DELETE operation. This was because the record you tried to delete is already being used. If a record is already being used in another table then deleting it would also delete its entry from there and that would create null references. For further explanation of this please contact Saad Hashmi, Asst. IT Programmer." + Environment.NewLine + " Error: " + tempErrorMessage
e.g
tempMsg = "This is a non-critical error. There was an error during DELETE operation. This was because the record you tried to delete is already being used. If a record is already being used in another table then deleting it would also delete its entry from there and that would create null references. For further explanation of this please contact Saad Hashmi, Asst. IT Programmer." + vbCrLf + " Error: " + tempErrorMessage

changing linkbutton to button in GV and FV

2010-10-21T14:48:00.003-07:00

just replace word linkbutton with button, make sure to do it in closing tag as well.

adding button in GV

2010-10-21T14:48:00.001-07:00

<asp:CommandField ShowEditButton="True" ButtonType="Button" />
putting value buttontype

capturing key press enter to click a button

2010-10-21T14:47:00.003-07:00

http://www.codeproject.com/KB/aspnet/EnterKeyToButtonClick.aspx
im implementing panel method

DefaultButton="btnSearch2"
im putting panel inside the editview of the FV for login.

changing selected value in dropdownlist in start

2010-10-21T14:47:00.001-07:00

Protected Sub FormView1_ModeChanging(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.FormViewModeEventArgs) Handles FormView1.ModeChanging
        If FormView1.CurrentMode = FormViewMode.Edit Then
            Dim tmp_DDL_Login As DropDownList = CType(FormView1.FindControl("DDL_Login"), DropDownList)
            tmp_DDL_Login.Items.FindByValue(3).Selected = True
        End If
    End Sub
http://www.dotnet247.com/247reference/msgs/21/108986.aspx
make sure if the textbox was bound before to sqldatasource then remove bindings as well.

Gridview SORTING Int/float/money fields - sorting gridview in natural order (alphanumerically / asciibetically)

2010-10-21T14:46:00.003-07:00

-convert any money or float or int or money type to int in a convert() statement in t-sql to remove any .00. trailing zeros
CONVERT(INT, [Daily_Cost_Per_Person], 1) AS Daily_Cost_Per_Person
-do same as above in DDL sqldatasource.
-convert in filterexpression any int/float/money to string
FilterExpression = "
(CONVERT(Daily_Cost_Per_Person,'System.String') LIKE '{0}')
"
-later on add zeros to the number in the GV and FV while its being rendered:
http://forums.asp.net/t/1114891.aspx
--other methods---
http://www.codeproject.com/KB/string/NaturalSortComparer.aspx
http://www.codinghorror.com/blog/2007/12/sorting-for-humans-natural-sort-order.html
http://tablesorter.com/docs/
--

gridview theme glassy black

2010-10-21T14:46:00.001-07:00

http://weblogs.asp.net/kevinbrammer/archive/2008/02/24/glassy-black-gridview-theme.aspx
--

Error during delete in gridview...Error "You have specified that your delete command compares all values on SqlDataSource"

2010-10-21T14:45:00.001-07:00

Delete ConflictDetection="CompareAllValues" from sqldatasource
also...
Turn the col into an itemtemplate in gridview
make sure there is not Eval instead of Bind in EditItemtemplate
<Columns>
                    <asp:CommandField ShowDeleteButton="True" />
                    <asp:TemplateField HeaderText="Food_Item" SortExpression="Food_Item">
                        <EditItemTemplate>
                            <asp:Label ID="Label1" runat="server" Text='<%# Bind("Food_Item") %>'></asp:Label>
                        </EditItemTemplate>
                        <ItemTemplate>
                            <asp:Label ID="Label1" runat="server" Text='<%# Bind("Food_Item") %>'></asp:Label>
                        </ItemTemplate>
                    </asp:TemplateField>
                </Columns>
--

Adding * in DDL as initial value

2010-10-21T14:44:00.001-07:00

<asp:DropDownList ID="FTR_Province" runat="server"
                DataSourceID="SqlDataSource1_Province" DataTextField="Province"
                DataValueField="Province" AppendDataBoundItems="true" AutoPostBack="True">
                <asp:ListItem Value="*">*</asp:ListItem>

Master/Detail filtering with two DDLs

2010-10-21T14:38:00.001-07:00

Technorati Tags: master/detail

http://www.asp.net/data-access/tutorials/master-detail-filtering-with-two-dropdownlists-vb