Auto increment in GV and Reportviewer starting at 1

In reportviewer add a col in report and set it as =Rownumber(Nothing)
no need to add the primary key col cause it starts from 0.
In reportviewer add col based on PRIMARY KEY of the table which will create an auto increment col. For it to start at one open code of xsd file and add msdata:AutoIncrement="1 in
<xs:complexType>
            <xs:sequence>
              <xs:element name="Autokey" msdata:ReadOnly="true" msdata:AutoIncrement="1"  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>
In gridview add a col in aspx
  <asp:TemplateField HeaderText="S_No">
                <ItemTemplate>
                    <%# Container.DataItemIndex + 1 %>
                </ItemTemplate>
            </asp:TemplateField>
--

Selecting NULLS in reportviewer individual textbox fields

In order to eliminate 0 in integer fields and 01 jan 1900 in datetime fields that are gathered from the objectdatasource select statement, we set reportviewer textbox field expression as:
=IIF(Fields!No_of_Daigs.Value = 0, Nothing, Fields!No_of_Daigs.Value)

adding parameters in reportviewer

make sure to add parameters by selecting the xsd and then looking at the properties of DataTableAdapter. Choose the dots on Parameters in properties and add a new one making sure AllowDBNULL = true, providertype = nvarchar, dbtype=string.

Select Distinct and NON NULL values from SQLDATASOURCE

SELECT DISTINCT  [No_of_Daigs] FROM [Data] WHERE [No_of_Daigs] IS NOT NULL
--

use * in filter DDL to make sure erratic behavior in filtering records is not encountered

the heading says it all!

Choosing top row in DDL as NULL from SQLDATASOURCE

SELECT     NULL AS Autokey
UNION ALL
SELECT DISTINCT Autokey
FROM         Data
http://forums.asp.net/p/1561253/3864962.aspx
---------
however above method might not work in integer fields.
use http://imar.spaanjaars.com/281/how-do-i-add-an-additional-item-to-a-databound-dropdownlist-control-in-aspnet
In ASP.NET 2.0 and onwards things are much easier. The DropDownList control and other list controls now have a AppendDataBoundItems ⁽⁷⁾ property. With this property set to true, a call to DataBind leaves all existing items in the list. That allows you to add the extra items declaratively in the markup:
<asp:DropDownList ID="DropDownList1" runat="server"
AppendDataBoundItems="true">
<asp:ListItem Value="*">Please select a country</asp:ListItem>
</asp:DropDownList>
That's it. No more messing around with code in the code behind to add the item. Just set AppendDataBoundItems to true and the manually added item stays where it was.
Make sure there is a * in "value" above on listitem.
--------
The above method does not work in whole unless accompanied by converting to varchar of any int value fields in sqldatasource. I converted them all to varchar to be on safe side.
SelectCommand="SELECT CONVERT(VARCHAR, [Autokey], 1) AS 'Autokey', CONVERT(VARCHAR,[Province], 1) AS 'Province', CONVERT(VARCHAR, [District], 1) AS 'District', CONVERT(VARCHAR, [Hospital], 1) AS 'Hospital', CONVERT(VARCHAR, [Caterer_Name], 1) AS 'Caterer_Name', CONVERT(VARCHAR, [Date_of_Entry], 1) AS 'Date_of_Entry', CONVERT(VARCHAR, [No_of_Daigs], 1) AS 'No_of_Daigs', CONVERT(VARCHAR, [Food_Item], 1) AS 'Food_Item', CONVERT(VARCHAR, [No_of_Rotis], 1) AS 'No_of_Rotis', CONVERT(VARCHAR, [No_of_Bene_Male], 1) AS No_of_Bene_Male, CONVERT(VARCHAR, [No_of_Bene_Female], 1) AS No_of_Bene_Female, CONVERT(VARCHAR, [Daily_Cost_Per_Person], 1) AS Daily_Cost_Per_Person, CONVERT(VARCHAR, [Acc_Exp], 1) AS Acc_Exp FROM [Data]"
also make sure in select statement of sqldatasource of the individual dropdownlist, you use the t-sql as such in order to eliminate all possible nulls and get all distinct values
SELECT
        CONVERT(VARCHAR, [Autokey], 1) AS 'Autokey',
        CONVERT(VARCHAR, [Province], 1) AS 'Province',
        CONVERT(VARCHAR, [District], 1) AS 'District',
        CONVERT(VARCHAR, [Hospital], 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(VARCHAR, [Date_of_Entry], 1) AS 'Date_of_Entry',
        CONVERT(VARCHAR, [No_of_Daigs], 1) AS 'No_of_Daigs',
        CONVERT(VARCHAR, [Food_Item], 1) AS 'Food_Item',
        CONVERT(VARCHAR, [No_of_Rotis], 1) AS 'No_of_Rotis',
        CONVERT(VARCHAR, [No_of_Bene_Male], 1) AS No_of_Bene_Male,
        CONVERT(VARCHAR, [No_of_Bene_Female], 1) AS No_of_Bene_Female,
        CONVERT(VARCHAR, [Daily_Cost_Per_Person], 1) AS Daily_Cost_Per_Person,
        CONVERT(VARCHAR, [Acc_Exp], 1) AS Acc_Exp
FROM [Data]
http://forums.asp.net/t/1250459.aspx
The key code here is
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,
this converts int to string as well as selects null as a value
full example
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(VARCHAR,
        (CASE
            WHEN Date_of_Entry IS NULL THEN
            (SELECT TOP 1 '' AS Date_of_Entry FROM Data)
            ELSE Date_of_Entry
        END), 1) AS Date_of_Entry,
        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,
        CONVERT(VARCHAR,
        (CASE
            WHEN No_of_Rotis IS NULL THEN
            (SELECT TOP 1 '' AS No_of_Rotis FROM Data)
            ELSE No_of_Rotis
        END), 1) AS 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
--------------
Formview stuck on first record even when clicking edit button from gridview do:
  Protected Sub BTN_GV_Details_Click(ByVal sender As Object, ByVal e As System.EventArgs)
        FormView1.ChangeMode(FormViewMode.ReadOnly)
        FormView1.ChangeMode(FormViewMode.Edit)
    End Sub
basically change mode of formview to readonly and then to edit. make sure this is implemented on the select button of gridview NOT the edit button, so that selectcommand of sqldatasource is executed first.
also you need to make sure that commandname = "select" on both edit and select buttons of the gridview.
<asp:GridView ID="GridView1" runat="server" AllowPaging="True"
        AllowSorting="True" AutoGenerateColumns="False" DataKeyNames="Autokey"
        DataSourceID="SqlDataSource1">
        <Columns>
            <asp:TemplateField ShowHeader="False">
                <ItemTemplate>
                    <asp:LinkButton ID="GV_Edit_button" runat="server" CausesValidation="False"
                        OnClick="GV_Edit_button_Click" Text="Edit" CommandName="Select"></asp:LinkButton>
                </ItemTemplate>
            </asp:TemplateField>
            <asp:TemplateField >
               <ItemTemplate>
                  <asp:LinkButton ID="GV_Details_button" runat="server" Text="Details..."
                       onclick="GV_Details_button_Click" CommandName="Select"></asp:LinkButton>
               </ItemTemplate>
-------------
if error such as 'FV_Edit_DDL_Caterer_Name' has a SelectedValue which is invalid because it does not exist in the list of items.
Parameter name: value
this means null value is not being found in the supporting table. no need to add a null row in the supporting table. what you need to do instead is put a - in the listitem of the dropdownlist in edititemtemplate and insertitemtemplate of the formview. the reason we are putting value "-" in our case is because we are taking - as null from the sqldatasource select statement. in normal instances you would take "" to select null value.
e.g
Caterer_Name:&nbsp;<asp:DropDownList ID="FV_Edit_DDL_Caterer_Name" runat="server" DataSourceID="SqlDataSource1_Caterer"
                    DataTextField="Caterer_Name" DataValueField="Caterer_Name" SelectedValue='<%# Bind("Caterer_Name") %>' AppendDataBoundItems="true">
                    <asp:ListItem Value="-"></asp:ListItem>
                </asp:DropDownList>&nbsp;
------
set NULLDISPLAYTEXT property of the column in gridview to dash - to display dashes for nulls.

Convert date format to 1 jan 2000 style in sqldatasource

CONVERT(CHAR(11), Book.BookPurchaseDate, 106) AS 'BookPurchaseDate',

difference between filterexpression and selectexpression

If you explore the SqlDataSource's properties you'll notice the FilterExpression and FilterParameters properties. You may be wondering why we aren't using these two properties and how the FilterParameters collection differs from the SelectParameters collection. The FilterExpression and FilterParameters are properties designed for filtering the results returned by the database. That is, with these two properties, after the records have been returned from the backend database, these results are further filtered by the FilterExpression and FilterParameters before being handed over to the data Web control or programmer whose code is requesting the data source's data. Using a parameterized query and SelectParameters, on the other hand, performs the filtering on the database side.
As you probably can guess, filtering on the database side is much more efficient than bringing back all data to the data source control and then having it filter the results. However, there are times when would want to use the FilterExpression and FilterParameters properties - in fact, both techniques can be used in tandem. For our examples now, stick with the parameterized queries and SelectParameters and just remember that the SelectParameters specify the parameter values that are sent in the database's SELECT query whereas the FilterParameters are those parameters used to filter the data returned from the database (and would only be set if there was a FilterExpression value defined).
http://www.4guysfromrolla.com/demos/printPage.aspx?path=/articles/030106-1.aspx
--

Setting Gridview labels to NULL

Protected Sub GridView1_DataBound(ByVal sender As Object, ByVal e As System.EventArgs) Handles GridView1.DataBound
        REM Assigning EMPTY values to integer and datetime labels in GV
        REM Note that it will not involve any text fields
        REM Taking total rows in GV
        Dim tmp_Total_GV_Rows As String = GridView1.Rows.Count
        REM Recursively going through each GV row, last recursion inside will be at 0 therefore > 0 is necessary
        While tmp_Total_GV_Rows > 0
            REM Decreasing value of row holder to cover all rows, must be on top to start indexing appropriately since it goes from 0 onwards.
            tmp_Total_GV_Rows = tmp_Total_GV_Rows - 1
            REM --Integer Field GV_LBL_Date_of_Entry--
            REM Seeing if the item contains the value in question
            If CType(GridView1.Rows(tmp_Total_GV_Rows).Cells(5).FindControl("GV_LBL_Date_of_Entry"), Label).Text() = "01 Jan 1900" Then
                REM Changing the value in question
                CType(GridView1.Rows(tmp_Total_GV_Rows).Cells(5).FindControl("GV_LBL_Date_of_Entry"), Label).Text() = ""
            End If
            REM --Integer Field GV_LBL_No_of_Daigs--
            REM Seeing if the item contains the value in question
            If CType(GridView1.Rows(tmp_Total_GV_Rows).Cells(6).FindControl("GV_LBL_No_of_Daigs"), Label).Text() = "0" Then
                REM Changing the value in question
                CType(GridView1.Rows(tmp_Total_GV_Rows).Cells(6).FindControl("GV_LBL_No_of_Daigs"), Label).Text() = ""
            End If
            REM --Integer Field GV_LBL_No_of_Rotis--
            REM Seeing if the item contains the value in question
            If CType(GridView1.Rows(tmp_Total_GV_Rows).Cells(7).FindControl("GV_LBL_No_of_Rotis"), Label).Text() = "0" Then
                REM Changing the value in question
                CType(GridView1.Rows(tmp_Total_GV_Rows).Cells(7).FindControl("GV_LBL_No_of_Rotis"), Label).Text() = ""
            End If
            REM --Integer Field GV_LBL_No_of_Bene_Male--
            REM Seeing if the item contains the value in question
            If CType(GridView1.Rows(tmp_Total_GV_Rows).Cells(8).FindControl("GV_LBL_No_of_Bene_Male"), Label).Text() = "0" Then
                REM Changing the value in question
                CType(GridView1.Rows(tmp_Total_GV_Rows).Cells(8).FindControl("GV_LBL_No_of_Bene_Male"), Label).Text() = ""
            End If
            REM --Integer Field GV_LBL_No_of_Bene_Female--
            REM Seeing if the item contains the value in question
            If CType(GridView1.Rows(tmp_Total_GV_Rows).Cells(9).FindControl("GV_LBL_No_of_Bene_Female"), Label).Text() = "0" Then
                REM Changing the value in question
                CType(GridView1.Rows(tmp_Total_GV_Rows).Cells(9).FindControl("GV_LBL_No_of_Bene_Female"), Label).Text() = ""
            End If
            REM --Integer Field GV_LBL_Daily_Cost_Per_Person--
            REM Seeing if the item contains the value in question
            If CType(GridView1.Rows(tmp_Total_GV_Rows).Cells(10).FindControl("GV_LBL_Daily_Cost_Per_Person"), Label).Text() = "0.00" Then
                REM Changing the value in question
                CType(GridView1.Rows(tmp_Total_GV_Rows).Cells(10).FindControl("GV_LBL_Daily_Cost_Per_Person"), Label).Text() = ""
            End If
            REM --Integer Field GV_LBL_Acc_Exp--
            REM Seeing if the item contains the value in question
            If CType(GridView1.Rows(tmp_Total_GV_Rows).Cells(11).FindControl("GV_LBL_Acc_Exp"), Label).Text() = "0" Then
                REM Changing the value in question
                CType(GridView1.Rows(tmp_Total_GV_Rows).Cells(11).FindControl("GV_LBL_Acc_Exp"), Label).Text() = ""
            End If
        End While
    End Sub

Format currency in reportviewer, Gridview and Formview

--- Formview---


REM -- Currency Field Daily_Cost_Per_PersonLabel
            Dim tmp_FV_Item__Temp_Daily_Cost_Per_PersonLabel As Label
            tmp_FV_Item__Temp_Daily_Cost_Per_PersonLabel = CType(FormView1.FindControl("Daily_Cost_Per_PersonLabel"), Label)
            Dim str_tmp_FV_Item__Temp_Daily_Cost_Per_PersonLabel As String = tmp_FV_Item__Temp_Daily_Cost_Per_PersonLabel.Text
            If str_tmp_FV_Item__Temp_Daily_Cost_Per_PersonLabel = "0.00" Then
                tmp_FV_Item__Temp_Daily_Cost_Per_PersonLabel.Text = ""
            Else
                REM Putting Rs. Currency Symbol in front of FV row text
                tmp_FV_Item__Temp_Daily_Cost_Per_PersonLabel.Text = "Rs. " + tmp_FV_Item__Temp_Daily_Cost_Per_PersonLabel.Text
            End If
Full text:
Protected Sub FormView1_DataBound(ByVal sender As Object, ByVal e As System.EventArgs) Handles FormView1.DataBound
        'FormView1.ChangeMode(FormViewMode.Edit)
        ' If FormView1.Visible = True Then
        ' FormView1.Visible = True
        REM Setting Integer and Date textfields in Item view of Formview to BLANK
        REM In Readonly Mode
        If FormView1.CurrentMode = FormViewMode.ReadOnly Then
            REM -- DateTime Field Date_of_EntryLabel
            Dim tmp_FV_Item__Temp_Date_of_EntryLabel As Label
            tmp_FV_Item__Temp_Date_of_EntryLabel = CType(FormView1.FindControl("Date_of_EntryLabel"), Label)
            Dim str_tmp_FV_Item__Temp_Date_of_EntryLabel As String = tmp_FV_Item__Temp_Date_of_EntryLabel.Text
            If str_tmp_FV_Item__Temp_Date_of_EntryLabel = "01 Jan 1900" Then
                tmp_FV_Item__Temp_Date_of_EntryLabel.Text = ""
            End If
            REM -- Integer Field No_of_DaigsLabel
            Dim tmp_FV_Item__Temp_No_of_DaigsLabel As Label
            tmp_FV_Item__Temp_No_of_DaigsLabel = CType(FormView1.FindControl("No_of_DaigsLabel"), Label)
            Dim str_tmp_FV_Item__Temp_No_of_DaigsLabel As String = tmp_FV_Item__Temp_No_of_DaigsLabel.Text
            If str_tmp_FV_Item__Temp_No_of_DaigsLabel = "0" Then
                tmp_FV_Item__Temp_No_of_DaigsLabel.Text = ""
            End If
            REM -- Integer Field No_of_RotisLabel
            Dim tmp_FV_Item__Temp_No_of_RotisLabel As Label
            tmp_FV_Item__Temp_No_of_RotisLabel = CType(FormView1.FindControl("No_of_RotisLabel"), Label)
            Dim str_tmp_FV_Item__Temp_No_of_RotisLabel As String = tmp_FV_Item__Temp_No_of_RotisLabel.Text
            If str_tmp_FV_Item__Temp_No_of_RotisLabel = "0" Then
                tmp_FV_Item__Temp_No_of_RotisLabel.Text = ""
            End If
            REM -- Integer Field No_of_Bene_MaleLabel
            Dim tmp_FV_Item__Temp_No_of_Bene_MaleLabel As Label
            tmp_FV_Item__Temp_No_of_Bene_MaleLabel = CType(FormView1.FindControl("No_of_Bene_MaleLabel"), Label)
            Dim str_tmp_FV_Item__Temp_No_of_Bene_MaleLabel As String = tmp_FV_Item__Temp_No_of_Bene_MaleLabel.Text
            If str_tmp_FV_Item__Temp_No_of_Bene_MaleLabel = "0" Then
                tmp_FV_Item__Temp_No_of_Bene_MaleLabel.Text = ""
            End If
            REM -- Integer Field No_of_Bene_FemaleLabel
            Dim tmp_FV_Item__Temp_No_of_Bene_FemaleLabel As Label
            tmp_FV_Item__Temp_No_of_Bene_FemaleLabel = CType(FormView1.FindControl("No_of_Bene_FemaleLabel"), Label)
            Dim str_tmp_FV_Item__Temp_No_of_Bene_FemaleLabel As String = tmp_FV_Item__Temp_No_of_Bene_FemaleLabel.Text
            If str_tmp_FV_Item__Temp_No_of_Bene_FemaleLabel = "0" Then
                tmp_FV_Item__Temp_No_of_Bene_FemaleLabel.Text = ""
            End If
            REM -- Currency Field Daily_Cost_Per_PersonLabel
            Dim tmp_FV_Item__Temp_Daily_Cost_Per_PersonLabel As Label
            tmp_FV_Item__Temp_Daily_Cost_Per_PersonLabel = CType(FormView1.FindControl("Daily_Cost_Per_PersonLabel"), Label)
            Dim str_tmp_FV_Item__Temp_Daily_Cost_Per_PersonLabel As String = tmp_FV_Item__Temp_Daily_Cost_Per_PersonLabel.Text
            If str_tmp_FV_Item__Temp_Daily_Cost_Per_PersonLabel = "0.00" Then
                tmp_FV_Item__Temp_Daily_Cost_Per_PersonLabel.Text = ""
            Else
                REM Putting Rs. Currency Symbol in front of FV row text
                tmp_FV_Item__Temp_Daily_Cost_Per_PersonLabel.Text = "Rs. " + tmp_FV_Item__Temp_Daily_Cost_Per_PersonLabel.Text
            End If
            REM -- Integer Field Acc_ExpLabel
            Dim tmp_FV_Item__Temp_Acc_ExpLabel As Label
            tmp_FV_Item__Temp_Acc_ExpLabel = CType(FormView1.FindControl("Acc_ExpLabel"), Label)
            Dim str_tmp_FV_Item__Temp_Acc_ExpLabel As String = tmp_FV_Item__Temp_Acc_ExpLabel.Text
            If str_tmp_FV_Item__Temp_Acc_ExpLabel = "0" Then
                tmp_FV_Item__Temp_Acc_ExpLabel.Text = ""
            End If
        End If
        REM In Insert Mode
        If FormView1.CurrentMode = FormViewMode.Insert Then
            REM -- DateTime Field Date_of_EntryText
            Dim tmp_FV_Item__Temp_Date_of_EntryText As TextBox
            tmp_FV_Item__Temp_Date_of_EntryText = CType(FormView1.FindControl("Date_of_EntryTextBox"), TextBox)
            Dim str_tmp_FV_Item__Temp_Date_of_EntryText As String = tmp_FV_Item__Temp_Date_of_EntryText.Text
            If str_tmp_FV_Item__Temp_Date_of_EntryText = "01 Jan 1900" Then
                tmp_FV_Item__Temp_Date_of_EntryText.Text = ""
            End If
            REM -- Integer Field No_of_DaigsText
            Dim tmp_FV_Item__Temp_No_of_DaigsText As TextBox
            tmp_FV_Item__Temp_No_of_DaigsText = CType(FormView1.FindControl("No_of_DaigsTextBox"), TextBox)
            Dim str_tmp_FV_Item__Temp_No_of_DaigsText As String = tmp_FV_Item__Temp_No_of_DaigsText.Text
            If str_tmp_FV_Item__Temp_No_of_DaigsText = "0" Then
                tmp_FV_Item__Temp_No_of_DaigsText.Text = ""
            End If
            REM -- Integer Field No_of_RotisText
            Dim tmp_FV_Item__Temp_No_of_RotisText As TextBox
            tmp_FV_Item__Temp_No_of_RotisText = CType(FormView1.FindControl("No_of_RotisTextBox"), TextBox)
            Dim str_tmp_FV_Item__Temp_No_of_RotisText As String = tmp_FV_Item__Temp_No_of_RotisText.Text
            If str_tmp_FV_Item__Temp_No_of_RotisText = "0" Then
                tmp_FV_Item__Temp_No_of_RotisText.Text = ""
            End If
            REM -- Integer Field No_of_Bene_MaleText
            Dim tmp_FV_Item__Temp_No_of_Bene_MaleText As TextBox
            tmp_FV_Item__Temp_No_of_Bene_MaleText = CType(FormView1.FindControl("No_of_Bene_MaleTextBox"), TextBox)
            Dim str_tmp_FV_Item__Temp_No_of_Bene_MaleText As String = tmp_FV_Item__Temp_No_of_Bene_MaleText.Text
            If str_tmp_FV_Item__Temp_No_of_Bene_MaleText = "0" Then
                tmp_FV_Item__Temp_No_of_Bene_MaleText.Text = ""
            End If
            REM -- Integer Field No_of_Bene_FemaleText
            Dim tmp_FV_Item__Temp_No_of_Bene_FemaleText As TextBox
            tmp_FV_Item__Temp_No_of_Bene_FemaleText = CType(FormView1.FindControl("No_of_Bene_FemaleTextBox"), TextBox)
            Dim str_tmp_FV_Item__Temp_No_of_Bene_FemaleText As String = tmp_FV_Item__Temp_No_of_Bene_FemaleText.Text
            If str_tmp_FV_Item__Temp_No_of_Bene_FemaleText = "0" Then
                tmp_FV_Item__Temp_No_of_Bene_FemaleText.Text = ""
            End If
            REM -- Currency Field Daily_Cost_Per_PersonText
            Dim tmp_FV_Item__Temp_Daily_Cost_Per_PersonText As TextBox
            tmp_FV_Item__Temp_Daily_Cost_Per_PersonText = CType(FormView1.FindControl("Daily_Cost_Per_PersonTextBox"), TextBox)
            Dim str_tmp_FV_Item__Temp_Daily_Cost_Per_PersonText As String = tmp_FV_Item__Temp_Daily_Cost_Per_PersonText.Text
            If str_tmp_FV_Item__Temp_Daily_Cost_Per_PersonText = "0.00" Then
                tmp_FV_Item__Temp_Daily_Cost_Per_PersonText.Text = ""
            End If
            REM -- Integer Field Acc_ExpText
            Dim tmp_FV_Item__Temp_Acc_ExpText As TextBox
            tmp_FV_Item__Temp_Acc_ExpText = CType(FormView1.FindControl("Acc_ExpTextBox"), TextBox)
            Dim str_tmp_FV_Item__Temp_Acc_ExpText As String = tmp_FV_Item__Temp_Acc_ExpText.Text
            If str_tmp_FV_Item__Temp_Acc_ExpText = "0" Then
                tmp_FV_Item__Temp_Acc_ExpText.Text = ""
            End If
        End If
        REM In Edit Mode setting integer and datetime fields to blank
        If FormView1.Visible = True And FormView1.CurrentMode = FormViewMode.Edit Then
            REM -- DateTime Field Date_of_EntryText
            Dim tmp_FV_Item__Temp_Date_of_EntryText As TextBox
            tmp_FV_Item__Temp_Date_of_EntryText = CType(FormView1.FindControl("Date_of_EntryTextBox"), TextBox)
            Dim str_tmp_FV_Item__Temp_Date_of_EntryText As String = tmp_FV_Item__Temp_Date_of_EntryText.Text
            If str_tmp_FV_Item__Temp_Date_of_EntryText = "01 Jan 1900" Then
                tmp_FV_Item__Temp_Date_of_EntryText.Text = ""
            End If
            REM -- Integer Field No_of_DaigsText
            Dim tmp_FV_Item__Temp_No_of_DaigsText As TextBox
            tmp_FV_Item__Temp_No_of_DaigsText = CType(FormView1.FindControl("No_of_DaigsTextBox"), TextBox)
            Dim str_tmp_FV_Item__Temp_No_of_DaigsText As String = tmp_FV_Item__Temp_No_of_DaigsText.Text
            If str_tmp_FV_Item__Temp_No_of_DaigsText = "0" Then
                tmp_FV_Item__Temp_No_of_DaigsText.Text = ""
            End If
            REM -- Integer Field No_of_RotisText
            Dim tmp_FV_Item__Temp_No_of_RotisText As TextBox
            tmp_FV_Item__Temp_No_of_RotisText = CType(FormView1.FindControl("No_of_RotisTextBox"), TextBox)
            Dim str_tmp_FV_Item__Temp_No_of_RotisText As String = tmp_FV_Item__Temp_No_of_RotisText.Text
            If str_tmp_FV_Item__Temp_No_of_RotisText = "0" Then
                tmp_FV_Item__Temp_No_of_RotisText.Text = ""
            End If
            REM -- Integer Field No_of_Bene_MaleText
            Dim tmp_FV_Item__Temp_No_of_Bene_MaleText As TextBox
            tmp_FV_Item__Temp_No_of_Bene_MaleText = CType(FormView1.FindControl("No_of_Bene_MaleTextBox"), TextBox)
            Dim str_tmp_FV_Item__Temp_No_of_Bene_MaleText As String = tmp_FV_Item__Temp_No_of_Bene_MaleText.Text
            If str_tmp_FV_Item__Temp_No_of_Bene_MaleText = "0" Then
                tmp_FV_Item__Temp_No_of_Bene_MaleText.Text = ""
            End If
            REM -- Integer Field No_of_Bene_FemaleText
            Dim tmp_FV_Item__Temp_No_of_Bene_FemaleText As TextBox
            tmp_FV_Item__Temp_No_of_Bene_FemaleText = CType(FormView1.FindControl("No_of_Bene_FemaleTextBox"), TextBox)
            Dim str_tmp_FV_Item__Temp_No_of_Bene_FemaleText As String = tmp_FV_Item__Temp_No_of_Bene_FemaleText.Text
            If str_tmp_FV_Item__Temp_No_of_Bene_FemaleText = "0" Then
                tmp_FV_Item__Temp_No_of_Bene_FemaleText.Text = ""
            End If
            REM -- Currency Field Daily_Cost_Per_PersonText
            Dim tmp_FV_Item__Temp_Daily_Cost_Per_PersonText As TextBox
            tmp_FV_Item__Temp_Daily_Cost_Per_PersonText = CType(FormView1.FindControl("Daily_Cost_Per_PersonTextBox"), TextBox)
            Dim str_tmp_FV_Item__Temp_Daily_Cost_Per_PersonText As String = tmp_FV_Item__Temp_Daily_Cost_Per_PersonText.Text
            If str_tmp_FV_Item__Temp_Daily_Cost_Per_PersonText = "0.00" Then
                tmp_FV_Item__Temp_Daily_Cost_Per_PersonText.Text = ""
            End If
            REM -- Integer Field Acc_ExpText
            Dim tmp_FV_Item__Temp_Acc_ExpText As TextBox
            tmp_FV_Item__Temp_Acc_ExpText = CType(FormView1.FindControl("Acc_ExpTextBox"), TextBox)
            Dim str_tmp_FV_Item__Temp_Acc_ExpText As String = tmp_FV_Item__Temp_Acc_ExpText.Text
            If str_tmp_FV_Item__Temp_Acc_ExpText = "0" Then
                tmp_FV_Item__Temp_Acc_ExpText.Text = ""
            End If
        End If
        'End If
    End Sub

--- Gridview---

REM Seeing if the item contains the value in question
            If CType(GridView1.Rows(tmp_Total_GV_Rows).Cells(10).FindControl("GV_LBL_Daily_Cost_Per_Person"), Label).Text() = "0.00" Then
                REM Changing the value in question
                CType(GridView1.Rows(tmp_Total_GV_Rows).Cells(10).FindControl("GV_LBL_Daily_Cost_Per_Person"), Label).Text() = ""
            Else
                REM Putting Rs. Currency Symbol in front of the row text
                CType(GridView1.Rows(tmp_Total_GV_Rows).Cells(10).FindControl("GV_LBL_Daily_Cost_Per_Person"), Label).Text() = "Rs. " + CType(GridView1.Rows(tmp_Total_GV_Rows).Cells(10).FindControl("GV_LBL_Daily_Cost_Per_Person"), Label).Text()
FUll listing:
Protected Sub GridView1_DataBound(ByVal sender As Object, ByVal e As System.EventArgs) Handles GridView1.DataBound
        REM Assigning EMPTY values to integer and datetime labels in GV
        REM Note that it will not involve any text fields
        REM Taking total rows in GV
        Dim tmp_Total_GV_Rows As String = GridView1.Rows.Count
        REM Recursively going through each GV row, last recursion inside will be at 0 therefore > 0 is necessary
        While tmp_Total_GV_Rows > 0
            REM Decreasing value of row holder to cover all rows, must be on top to start indexing appropriately since it goes from 0 onwards.
            tmp_Total_GV_Rows = tmp_Total_GV_Rows - 1
            'CType(GridView1.Rows(tmp_Total_GV_Rows).Cells(5).FindControl("GV_LBL_Date_of_Entry"), Label).Text() = CType(GridView1.Rows(tmp_Total_GV_Rows).Cells(5).FindControl("GV_LBL_Date_of_Entry"), Label).Text.ToString("dd MMM yyyy, ddd")
            REM --DateTime Field GV_LBL_Date_of_Entry--
            REM Seeing if the item contains the value in question
            If CType(GridView1.Rows(tmp_Total_GV_Rows).Cells(5).FindControl("GV_LBL_Date_of_Entry"), Label).Text() = "01 Jan 1900" Then
                REM Changing the value in question
                CType(GridView1.Rows(tmp_Total_GV_Rows).Cells(5).FindControl("GV_LBL_Date_of_Entry"), Label).Text() = ""
            End If
            REM --Integer Field GV_LBL_No_of_Daigs--
            REM Seeing if the item contains the value in question
            If CType(GridView1.Rows(tmp_Total_GV_Rows).Cells(6).FindControl("GV_LBL_No_of_Daigs"), Label).Text() = "0" Then
                REM Changing the value in question
                CType(GridView1.Rows(tmp_Total_GV_Rows).Cells(6).FindControl("GV_LBL_No_of_Daigs"), Label).Text() = ""
            End If
            REM --Integer Field GV_LBL_No_of_Rotis--
            REM Seeing if the item contains the value in question
            If CType(GridView1.Rows(tmp_Total_GV_Rows).Cells(7).FindControl("GV_LBL_No_of_Rotis"), Label).Text() = "0" Then
                REM Changing the value in question
                CType(GridView1.Rows(tmp_Total_GV_Rows).Cells(7).FindControl("GV_LBL_No_of_Rotis"), Label).Text() = ""
            End If
            REM --Integer Field GV_LBL_No_of_Bene_Male--
            REM Seeing if the item contains the value in question
            If CType(GridView1.Rows(tmp_Total_GV_Rows).Cells(8).FindControl("GV_LBL_No_of_Bene_Male"), Label).Text() = "0" Then
                REM Changing the value in question
                CType(GridView1.Rows(tmp_Total_GV_Rows).Cells(8).FindControl("GV_LBL_No_of_Bene_Male"), Label).Text() = ""
            End If
            REM --Integer Field GV_LBL_No_of_Bene_Female--
            REM Seeing if the item contains the value in question
            If CType(GridView1.Rows(tmp_Total_GV_Rows).Cells(9).FindControl("GV_LBL_No_of_Bene_Female"), Label).Text() = "0" Then
                REM Changing the value in question
                CType(GridView1.Rows(tmp_Total_GV_Rows).Cells(9).FindControl("GV_LBL_No_of_Bene_Female"), Label).Text() = ""
            End If
            REM --Currency Field GV_LBL_Daily_Cost_Per_Person--
            REM Seeing if the item contains the value in question
            If CType(GridView1.Rows(tmp_Total_GV_Rows).Cells(10).FindControl("GV_LBL_Daily_Cost_Per_Person"), Label).Text() = "0.00" Then
                REM Changing the value in question
                CType(GridView1.Rows(tmp_Total_GV_Rows).Cells(10).FindControl("GV_LBL_Daily_Cost_Per_Person"), Label).Text() = ""
            Else
                REM Putting Rs. Currency Symbol in front of the row text
                CType(GridView1.Rows(tmp_Total_GV_Rows).Cells(10).FindControl("GV_LBL_Daily_Cost_Per_Person"), Label).Text() = "Rs. " + CType(GridView1.Rows(tmp_Total_GV_Rows).Cells(10).FindControl("GV_LBL_Daily_Cost_Per_Person"), Label).Text()
            End If
            REM --Integer Field GV_LBL_Acc_Exp--
            REM Seeing if the item contains the value in question
            If CType(GridView1.Rows(tmp_Total_GV_Rows).Cells(11).FindControl("GV_LBL_Acc_Exp"), Label).Text() = "0" Then
                REM Changing the value in question
                CType(GridView1.Rows(tmp_Total_GV_Rows).Cells(11).FindControl("GV_LBL_Acc_Exp"), Label).Text() = ""
            End If
        End While
    End Sub

--- Reportviewer ---

=Format(Fields!Daily_Cost_Per_Person.Value, "Rs.00")
Common VB functions are applied.
For some reason the integer is not to be denoted by anything, only the zeros are dot. It works.

Selecting null instead of 0 or 01/01/1900 in int and date columns in FV

  Protected Sub FormView1_DataBound(ByVal sender As Object, ByVal e As System.EventArgs) Handles FormView1.DataBound
        If FormView1.CurrentMode = FormViewMode.ReadOnly Then
            Dim tmp_LBL1 As Label
            tmp_LBL1 = CType(FormView1.FindControl("No_of_DaigsLabel"), Label)
            Dim str_tmp_LBL1 As String = tmp_LBL1.Text
            If str_tmp_LBL1 = "0" Then
                tmp_LBL1.Text = ""
            End If
        End If
    End Sub

Reportviewer Changes to make it work for VWD 2005

http://forums.asp.net/t/1362315.aspx
dear friend
I had this problem and solve it by this :
I delete all of Temporary Asp files on : C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files
and then ( optional ) you can delete you user Temporary Internet Files on : C:\Documents and Settings\YourUserName\Local Settings\temporary internet files
base solution : put these line of code to your web.config file
<add assembly="Microsoft.ReportViewer.WebForms, Version=9.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>
<add assembly="Microsoft.ReportViewer.Common, Version=9.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>
you also should comment your previous assembly version on <asssembly> section like :
<!--<add assembly="Microsoft.ReportViewer.WebForms, Version=8.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>-->
<!--<add assembly="Microsoft.Reporting.WebForms, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"/>-->
and you may have some other related assemlby to version 8.0.0 ,  like
<add path="Reserved.ReportViewerWebControl.axd" verb="*" type="Microsoft.Reporting.WebForms.HttpHandler, Microsoft.ReportViewer.WebForms, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" validate="false"/>
change them to version 9.0.0 ,
please let me know was it helpful for you or not , please mark this as answer if it worked for following users , thank you

Report server link VWD 2005

http://download.microsoft.com/download/4/4/D/44DBDE61-B385-4FC2-A67D-48053B8F9FAD/SQLServer2005_ReportAddin.msi

Link for VWD 2005 and Reportviewer

http://gotreportviewer.com/
http://go.microsoft.com/fwlink/?LinkId=51413&amp;clcid=0x409
http://www.microsoft.com/downloads/details.aspx?familyid=8a166cac-758d-45c8-b637-dd7726e61367&displaylang=en
--
http://gotreportviewer.com/
http://go.microsoft.com/fwlink/?LinkId=51413&amp;clcid=0x409

Get primary key value of GV by GridView1.SelectedValue

The heading says it all!

Creating marked_to_delete button in GV

Protected Sub GridView1_SelectedIndexChanged1(ByVal sender As Object, ByVal e As System.EventArgs) Handles GridView1.SelectedIndexChanged
If Session("Marked_to_Delete") = "off" Then
FormView1.Visible = True
End If
REM Binding the Formview with Gridview so that the Formview changes with Gridview selection
FormView1.PageIndex = ((GridView1.PageIndex * GridView1.PageSize) + GridView1.SelectedIndex)
REM Necessary for gridview selectedrow to avail its original selectedrow color which is lightsteelblue
GridView1.SelectedRowStyle.BackColor = Drawing.Color.LightSteelBlue
GridView1.SelectedRowStyle.Font.Bold = True
REM Handling Marked_to_Delete
If Session("Marked_to_Delete") = "clicked" Then
ACT_Autokey.Text = GridView1.SelectedValue
SqlDataSource_Marked_to_Delete.Update()
GridView1.DataBind()
Session("Marked_to_Delete") = "off"
ScriptManager.RegisterStartupScript(Me, Me.[GetType](), "Marked_to_be_Deleted", "alert('Successfully Marked to be Deleted');", True)
End If
End Sub
Protected Sub GV_Marked_to_Delete_button_Click(ByVal sender As Object, ByVal e As System.EventArgs)
REM Handling Marked_to_Delete
Session("Marked_to_Delete") = "clicked"
End Sub
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
REM Handling Marked_to_Delete
Session("Marked_to_Delete") = "off"

In sqldatasource
UpdateCommand="UPDATE [Data] SET [Marked_to_Delete] = 'True' WHERE [Autokey] = @original_Autokey" >
<UpdateParameters>
<asp:Parameter Name="Marked_to_Delete" Type="Boolean" />
<asp:ControlParameter Name="original_Autokey" Type="Int16" ControlID="ACT_Autokey" />
---

Selecting a row in footerrow of gv

CType(GridView1.FooterRow.FindControl("GV_LBL_FOOTER_GrandTotal_Total_Daily_Cost"), Label)
---

Keep align label to top in a table when next row is going to be expanded with another control

Set Valign of TD (cell) to top
Set top padding of TD (cell) to 5 or something.

page goes on top during validationsummary update even if maintainscrollbackposition or smartnavigation is on

set enableclientscript=false in all validators including the summary

detecting what mode the Formview would be changed to in modechanging

If (e.NewMode = FormViewMode.[Insert]) Then