Search

Custom Search

Subscribe via email

Enter your email address:

Delivered by FeedBurner

Thursday, October 21, 2010

formview final formatting

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

Posted by SH at 3:01 PM 0 comments

formview formatting

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%

Posted by SH at 3:00 PM 0 comments

set color and margins of page body document

<body style="color: black;margin-left:0px; margin-top:0px;margin-bottom:0px;margin-right:0px" bgcolor="#000000" >

Posted by SH at 3:00 PM 1 comments

Reportviewer overlapping on panel and other controls at bottom

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

Posted by SH at 2:59 PM 0 comments

Autokey primary key column selected as sequence in objectdatasource reportviewer

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>

Posted by SH at 2:58 PM 0 comments

IIS slow on vista

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

Posted by SH at 2:58 PM 1 comments

Formatting PDF from reportviewer (multiple page crossing problem)

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.
--

Posted by SH at 2:54 PM 0 comments
Subscribe to: Posts (Atom)

Labels

.ico (1) acunetix (1) adding controls dynamically (1) adding list item programatically (1) adding parameters (1) aligning (2) aligning buttons (1) and Bind() can only be used in the context (1) anonymous access (1) appending static dropdownlist items (1) asciibetical sort (1) asp.net (101) assembly (1) asterisk (1) auto increment (1) autopostback (1) autosize (1) aztech (5) behavior (1) boundfield (1) browser tab icon (1) busybox (1) bypass proxy (1) calculate totals in reportviewer (2) cangrow (1) cascading style sheets (1) case (1) CDbl (1) changemode (1) checkbox (1) columns (1) comments (1) comparing all values (1) comparing integer values (2) comparison (2) conditional IIF (1) confirmation box on delete (1) connection string (1) control (1) controlID (1) controlparameter (1) convert (1) convert format of currency or float or 0.0000 to 0.00 (1) convert image to pixels (1) converting dates (2) css (1) ctype (1) culture (1) currency (1) current date (1) current ports (1) data typeconversion (1) database (2) databind (1) databound (5) dataformatstring (1) date column (1) date format (3) date sort in gridview (1) db_datareader (1) db_datawriter (1) dd MMM yyyy (1) defaultmode (1) delete button (1) deleting (1) deleting rows (1) deploying website to IIS (3) deployment error (1) deployment to IIS (4) detecting formview move (3) difference between filterexpression and selectexpression (2) difference between publish and build in visual studio (1) directory security (1) display error on no data in reportviewer (2) distinct (1) DLL (1) DMZ (1) double value (1) double quotes in javascript (1) download reportviewer (5) download visual web developer (3) drill down (1) drilldown (1) drilldown dropdownlist (1) dropdownlist (4) dropdownlist showing double values on postback (2) DSL 605EU (5) dynamic DNS (1) dyndns (1) e.values (1) edit mode (1) embedded images (1) emptydatatemplate (1) enableclientscript (1) enableviewstate (1) error during selection in filter of non matching values (1) Eval() (1) event manager (1) excel to sql server (2) executiontime (1) expression (2) F5 key refresh (1) failed to load viewstate (1) favicon (1) favicon.ico (1) feedback (1) feedback module (1) field expression (1) file permissions (1) filter (3) filterexpression (2) filterparameters (1) findcontrol (1) firefox (1) firefox password problem (1) firewall (1) float (1) focus (1) font (1) footerrow (1) format currency (1) formatting date in reportviewer (1) formview (11) formviewmode (2) freeze screen (1) global ip (2) globals (1) gotreportviewer (1) grand total (1) gridview (18) gridview labels (3) handling dates (6) handling nulls (5) html (1) htmlencode (1) httphandler (1) icon in address bar (1) icon in browser (1) IIS (6) IIS 5 (2) IIS 7 (1) IIS admin tool (1) IIS error (1) iis installation (1) IIS manager (3) IIS personalization (1) IIS pool (3) IIS setup (1) IIS Unexpected error 0x8ffe2740 (1) image control (1) image sizing in reportviewer (1) importing html into excel (1) index was out of range (1) insert (4) insert image in reportviewer (1) inserting (1) insertparameters (1) integer (1) integer column (2) intellisense (1) iteminserted (1) iteminserting (2) itemupdating (2) javascript (6) javascript and smartnavigation (1) javascript intellisense (1) label (1) left align pagerstyle (1) listitem (1) live ip (2) load (1) maintain cursor on field after postback (1) maintainscrollbackposition (2) managing deletion (1) microsoft (2) modechanged (1) modechanging (1) money column (1) money field (1) monitor IIS errors (1) monitoring ports (1) ms excel (1) ms word (1) multiple values shown (1) natural sort (1) network service (3) newline character in reportviewer textbox (1) newmode (1) nirsoft (1) no data (1) non focus (1) non null (1) norows property (1) obfuscate (1) obfuscator (1) objectdatasource (3) onclientclick (1) onfocus (3) onkeyup (1) page expiry (1) page margins (1) page_load (1) pageindex (1) panel (1) parameterized query (1) pdf (1) permissions (2) port forwarding (2) port scanner (1) ports (2) postback losing focus problem (1) pre-compile tasks visual studio (1) prevent insert on refresh (1) prevent multiple records being added (1) preventing doubleclick (1) preventing multiple clicks (1) primary key (1) primary key column (1) profile (2) programming (1) protect asp.net code (2) publickeytoken (1) publish to DLL (2) publish website (2) putting blanks in formview (1) reboot router (1) referencing values of selectcommand (1) register asp.net (1) registerstartupscript (2) remove focus (1) removing a textbox (2) report header (1) reportaddin.msi (2) reporting services (3) reportviewer (11) reportviewer formatting A4 size PDF (1) reportviewer formatting for A4 size PDF (1) reportviewer header scroll problem (1) reportviewer showing header (1) reportviewer showing header constantly (1) reset autokeys (1) restart router (1) router (6) router interface (1) rows (1) schema (1) scriptmanager (1) scroll function (1) scroll to window location with javascript (1) scrolling scrollbar with javascript (1) selectcommand (1) selectedindexchanged (1) selectedrowstyle (1) selectedvalue (1) selectexpression (1) selecting control inside gridview (1) selecting null as 0 (1) selecting null as zero (1) selecting nulls (3) selecting row (1) selecting totals in t-sql using subquery (2) selecting week (1) server application unavailable (1) session state (2) session timeout (1) set focus on control on page load (1) setting tab order of controls (1) setup firewall (1) showtime (2) single quotes in javascript (1) sizing property (1) skype port 80 conflict (1) smartnavigation (3) smartnavigation errors (1) smartnavigation problems (2) smartnavigation solutions (1) sorting (1) sql server (47) sqldatasource (9) SSRS (5) start primary key column from 1 (1) static ip (1) string value (1) stylesheet (1) subquery (2) summary (1) system.web (1) t-sql (22) tab index (2) tab order (2) table (1) table of contents (1) table wrap (1) tables (1) tcp port (1) TD (1) telnet (1) templatefields (2) ternary IIF operator (2) textbox (4) textchanged (1) timeout (1) top row (1) totals in gridview footer (2) TR-068 WAN Access (1) trimming values (1) truncate table (1) try catch block (1) updating (1) validation (1) validationsummary (1) vb (76) version (1) viewstate (1) viewstate error (1) virtual directory (1) visiblefalse (1) visual studio 2008 (4) visual web developer (5) visual web developer 2005 (3) vwd (2) watch activity (1) watermark (1) web tunnel proxy (1) web.config (4) webforms (1) webserver (1) Website Vulnerabilities (1) where clause (1) windows CD (1) windows server (3) windows vista (2) windows xp (1) wrap line (2) wrapping text in reportviewer textbox (1) xp (2) XPath() (1)