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

creating an insert with sqldatasource without a GV or FV

in sqldatasource do like this:
<InsertParameters>
                <asp:ControlParameter Name="Login" Type="String" ControlID="ACT_Login"  />
                <asp:ControlParameter Name="Date" Type="DateTime" ControlID = "ACT_Date" />
                <asp:ControlParameter Name="IP" Type="String"  ControlID = "ACT_IP"/>
            </InsertParameters>
notice that controlID is pointing to the ID of a textbox somewhere on the page (can be invisible or colored to blend in with the background). also note that controlparameter is used not just parameter.

Formview changes to Edit mode after inserted in Inserted mode. Possible issue with formview.visiblefalse and using viewstate such as smartnavigation=true

Protected Sub FormView1_ItemInserted(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.FormViewInsertedEventArgs) Handles FormView1.ItemInserted
REM Handling Insert Mode of FV
REM If a record has been inserted, the formview tends to change to Edit mode for some reason, probably because
REM the viewstate. Therefore this code enables it to revert back to Insert mode.
REM Rest in Formview.ModeChanged() and btn_New.load()
Session("Inserted") = "true"
REM Show alert on deleted
ScriptManager.RegisterStartupScript(Me, Me.[GetType](), "New", "alert('Successfully Added New Record');", True)
End Sub
Protected Sub FormView1_ModeChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles FormView1.ModeChanged
REM Handling Insert Mode of FV
REM If a record has been inserted, the formview tends to change to Edit mode for some reason, probably because
REM the viewstate. Therefore this code enables it to revert back to Insert mode.
REM Rest in Formview.ItemInserted() and btn_New.load()
If Session("Inserted") = "true" Then
Session("Inserted") = "false"
FormView1.ChangeMode(FormViewMode.Insert)
End If
End Sub
Protected Sub BTN_New_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles BTN_New.Click
REM Handling Insert Mode of FV
REM If a record has been inserted, the formview tends to change to Edit mode for some reason, probably because
REM the viewstate. Therefore this code enables it to revert back to Insert mode.
REM Rest in Formview.ItemInserted() and btn_New.load()
REM Since SQLDATASOURCE uses a WHERE clause on dates from and to, therefore its necessary to populate the fields before execution of filter.
If FTR_Date_of_Entry_From.Text.Trim = "" Then
FTR_Date_of_Entry_From.Text = "01 Jan 1900"
End If
If FTR_Date_of_Entry_To.Text.Trim = "" Then
FTR_Date_of_Entry_To.Text = "31 Dec 2090"
End If
If FTR_Date_of_Entry_From.Text.Trim = "" And FTR_Date_of_Entry_To.Text.Trim <> "" Then
FTR_Date_of_Entry_From.Text = "01 Jan 1900"
End If
If FTR_Date_of_Entry_To.Text.Trim = "" And FTR_Date_of_Entry_From.Text.Trim <> "" Then
FTR_Date_of_Entry_To.Text = "31 Dec 2090"
End If
REM Control visibility of controls
FormView1.Visible = True
GridView1.Visible = False
GridView_Login.Visible = False
ReportViewer1.Visible = False
RPT_Adjuster.Visible = False
GridView_Activity.Visible = False
GridView_Manage_Province.Visible = False
FormView_Manage_Province.Visible = False
GridView_Manage_District.Visible = False
FormView_Manage_District.Visible = False
GridView_Manage_Hospital.Visible = False
FormView_Manage_Hospital.Visible = False
FormView_Manage_Caterer_Name.Visible = False
GridView_Manage_Caterer_Name.Visible = False
FormView_Manage_Food_Item.Visible = False
GridView_Manage_Food_Item.Visible = False
FormView_Feedback.Visible = False
GridView_Feedback.Visible = False
REM ...Continuing with other commands
FormView1.ChangeMode(FormViewMode.Insert)
End Sub

Referencing values of selectcommand while item is being inserted / updated in GV / FV

Use on iteminserting or itemupdating
'REM ***** Changing all 0s in Integer Fields and 01 Jan 1900 in DateTime Field to NULL *****
'If (str_tmp_FV_Item__Temp_Date_of_EntryTextBox.ToUpper = "01 JAN 1900" Or str_tmp_FV_Item__Temp_Date_of_EntryTextBox.ToUpper = "1 JAN 1900") Then
' REM Referencing order of InsertCommand="INSERT INTO [Data] ([Province], [District], [Hospital], [Caterer_Name], [Date_of_Entry], [Date_of_Entry], [Food_Item], [No_of_Rotis], [No_of_Bene_Male], [No_of_Bene_Female], [Daily_Cost_Per_Person]) VALUES (@Province, @District, @Hospital, @Caterer_Name, @Date_of_Entry, @Date_of_Entry, @No_of_Daigs, @Food_Item, @No_of_Rotis, @No_of_Bene_Male, @No_of_Bene_Female, @Daily_Cost_Per_Person)"
' e.Values(4) = ""
'End If
'If str_tmp_FV_Item__Temp_No_of_DaigsTextBox = "0" Then
' REM Referencing order of InsertCommand="INSERT INTO [Data] ([Province], [District], [Hospital], [Caterer_Name], [Date_of_Entry], [Date_of_Entry], [Food_Item], [No_of_Rotis], [No_of_Bene_Male], [No_of_Bene_Female], [Daily_Cost_Per_Person]) VALUES (@Province, @District, @Hospital, @Caterer_Name, @Date_of_Entry, @Date_of_Entry, @No_of_Daigs, @Food_Item, @No_of_Rotis, @No_of_Bene_Male, @No_of_Bene_Female, @Daily_Cost_Per_Person)"
' e.Values(5) = ""
'End If
'If str_tmp_FV_Item__Temp_No_of_RotisTextBox = "0" Then
' REM Referencing order of InsertCommand="INSERT INTO [Data] ([Province], [District], [Hospital], [Caterer_Name], [Date_of_Entry], [Date_of_Entry], [Food_Item], [No_of_Rotis], [No_of_Bene_Male], [No_of_Bene_Female], [Daily_Cost_Per_Person]) VALUES (@Province, @District, @Hospital, @Caterer_Name, @Date_of_Entry, @Date_of_Entry, @No_of_Daigs, @Food_Item, @No_of_Rotis, @No_of_Bene_Male, @No_of_Bene_Female, @Daily_Cost_Per_Person)"
' e.Values(7) = ""
'End If
'If str_tmp_FV_Item__Temp_No_of_Bene_MaleTextBox = "0" Then
' REM Referencing order of InsertCommand="INSERT INTO [Data] ([Province], [District], [Hospital], [Caterer_Name], [Date_of_Entry], [Date_of_Entry], [Food_Item], [No_of_Rotis], [No_of_Bene_Male], [No_of_Bene_Female], [Daily_Cost_Per_Person]) VALUES (@Province, @District, @Hospital, @Caterer_Name, @Date_of_Entry, @Date_of_Entry, @No_of_Daigs, @Food_Item, @No_of_Rotis, @No_of_Bene_Male, @No_of_Bene_Female, @Daily_Cost_Per_Person)"
' e.Values(8) = ""
'End If
'If str_tmp_FV_Item__Temp_No_of_Bene_FemaleTextBox = "0" Then
' REM Referencing order of InsertCommand="INSERT INTO [Data] ([Province], [District], [Hospital], [Caterer_Name], [Date_of_Entry], [Date_of_Entry], [Food_Item], [No_of_Rotis], [No_of_Bene_Male], [No_of_Bene_Female], [Daily_Cost_Per_Person]) VALUES (@Province, @District, @Hospital, @Caterer_Name, @Date_of_Entry, @Date_of_Entry, @No_of_Daigs, @Food_Item, @No_of_Rotis, @No_of_Bene_Male, @No_of_Bene_Female, @Daily_Cost_Per_Person)"
' e.Values(9) = ""
'End If
'If str_tmp_FV_Item__Temp_Daily_Cost_Per_PersonTextBox = "0" Then
' REM Referencing order of InsertCommand="INSERT INTO [Data] ([Province], [District], [Hospital], [Caterer_Name], [Date_of_Entry], [Date_of_Entry], [Food_Item], [No_of_Rotis], [No_of_Bene_Male], [No_of_Bene_Female], [Daily_Cost_Per_Person]) VALUES (@Province, @District, @Hospital, @Caterer_Name, @Date_of_Entry, @Date_of_Entry, @No_of_Daigs, @Food_Item, @No_of_Rotis, @No_of_Bene_Male, @No_of_Bene_Female, @Daily_Cost_Per_Person)"
' e.Values(10) = ""
'End If

TRIMMING ALL values before insert into db

Put it in formview.iteminserting() or itemupdating()
REM ***** TRIMMING ALL values before insert into db *****
For i As Integer = 0 To e.Values.Values.Count - 1
e.Values(i) = e.Values(i).ToString().Trim()
Next

Doing the COMPARISON to see if INTEGER VALUES have Leading 0's

Put it in formview.iteminserting() or itemupdating()
REM ***** Doing the COMPARISON to see if INTEGER VALUES have Leading 0's *****
Dim Temp_Int As Integer
If Integer.TryParse(e.Values("No_of_Daigs"), Temp_Int) = True Then
e.Values("No_of_Daigs") = Temp_Int.ToString()
End If
If Integer.TryParse(e.Values("No_of_Rotis"), Temp_Int) = True Then
e.Values("No_of_Rotis") = Temp_Int.ToString()
End If
If Integer.TryParse(e.Values("No_of_Bene_Male"), Temp_Int) = True Then
e.Values("No_of_Bene_Male") = Temp_Int.ToString()
End If
If Integer.TryParse(e.Values("No_of_Bene_Female"), Temp_Int) = True Then
e.Values("No_of_Bene_Female") = Temp_Int.ToString()
End If
If Integer.TryParse(e.Values("Daily_Cost_Per_Person"), Temp_Int) = True Then
e.Values("Daily_Cost_Per_Person") = Temp_Int.ToString()
End If

Doing the COMPARISON to see if INTEGER VALUES are 0's

Put it in formview.iteminserting() or itemupdating()
REM ***** Doing the COMPARISON to see if INTEGER VALUES are 0's *****
If e.Values("No_of_Daigs") = "0" Then
e.Values("No_of_Daigs") = ""
End If
If e.Values("No_of_Rotis") = "0" Then
e.Values("No_of_Rotis") = ""
End If
If e.Values("No_of_Bene_Male") = "0" Then
e.Values("No_of_Bene_Male") = ""
End If
If e.Values("No_of_Bene_Female") = "0" Then
e.Values("No_of_Bene_Female") = ""
End If
If e.Values("Daily_Cost_Per_Person") = "0" Then
e.Values("Daily_Cost_Per_Person") = ""
End If

Doing the COMPARISON to see if ALL are NULL

Put it in formview.iteminserting() or itemupdating()
REM ***** Doing the COMPARISON to see if ALL are NULL *****
Dim null_count As Integer = 0
For i As Integer = 0 To e.Values.Values.Count - 1
REM If any value is not null, let it insert
If e.Values(i) = "" Then
null_count += 1
End If
Next
If null_count = e.Values.Values.Count Then
ScriptManager.RegisterStartupScript(Me, Me.[GetType](), "Not Inserted", "alert('Record not inserted, all fields are blank.');", True)
e.Cancel = True
End If

Full Website Webserver configuration: Port Forwarding on Router to configure global ip of router to work with local webserver of local pc / Setup of IIS / Firewall Setup

Select Application -> Port Forwarding

Add static IP in router

Publish Post

Make sure IP address added in LAN properties (little computer on taskbar) has a static ip defined instead of automatic.

See your own ip which is defined as IP Addres after doing ipconfig from cmd

IIS Setup: In IIS manager set port 8000 and set ip to all unassigned.

In port forwarding of router add a new user rule

Keep web access control off..making sure to place 0.0.0.0 in remote ip and remote netmask if you plan to turn it on

Keep firewall on

In PC firewall do like this:

Do not enable DMZ in router

Deployment to IIS (XP and Windows Server)

Deployment to IIS (XP and Windows Server)

· This procedure assumes integrated security method is used.
· In physical folder properties give permission to user ASPNET
· Browse to C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data and give permission to DB and its log file there.
· Go into Sql server management studio, select security folder -> logins folder ...choose most of the
· Required logins especially ASPNET and NETWORK SERVICE, select properties, choose User Mapping and select the db in question and then select 'db_datareader' and 'db_datawriter' role memberships.
· To prevent firefox from asking for authentication…go into IIS manager and select properties of the virtual directory...choose directory security...press edit...click browse on anonymous access...specify an admin password for the current pc...put its password..uncheck allow iis to control password...press ok. Troubleshooting: Make sure to set it to anonymous password or reset the password if system administrator password is changed.
· Conn. Str in web.config <add name="Lungar ProjectConnectionString" connectionString="Data Source=(local);Initial Catalog=LP;User Id=sa; Password=admin;Persist Security Info=True;Min Pool Size=5" providerName="System.Data.SqlClient" /> (only for Windows Server 2003)
· Change DB Name to LP in SSMS (only for Windows Server 2003)
· Select version 2.0 in IIS website or Virtual Directory properties ASP.NET tab.
Make sure file permissions of the directory are given to child objects as well if contents in the directory is copied again.

IIS Setup and Configuration for Windows Server 2003

Web.config:

<add name="Lungar ProjectConnectionString" connectionString="Data Source=(local);Initial Catalog=LP;User Id=sa; Password=admin;Persist Security Info=True;Min Pool Size=5" providerName="System.Data.SqlClient" />

IIS:

Set Anonymous login in directory security to Login (Machine Name)\Administrator, Password Pakistan (system password).

Port Forwarding

http://portforward.com/english/routers/port_forwarding/Aztech/DSL605EW/Warcraft_III.htm
http://portforward.com/english/routers/port_forwarding/Aztech/DSL605EU/HTTP.htm
http://portforward.com/networking/staticip.htm

Configuring Dynamic DNS DynDNS on Router

Working Bypass Proxy

http://www.mywebtunnel.com/

IIS 5 not re-installing from windows CD, giving error like cannot copy statxmem.dl_

In cmd prompt run:
esentutl /g %WinDir%\security\database\secedit.sdb
esentutl /p %windir%\security\database\secedit.sdb
http://p2p.wrox.com/general-net/27450-iis-installation-problem.html

Register ASP.NET again – Error: Server Application Unavailable

c:\windows\microsoft.net\framework\v2.0.50727\aspnet_regiis -i
http://blog.crowe.co.nz/blog/archive/2005/08/30/242.aspx
Also check if web.config conn str is correct
Make not aspnet and network service have file permissions

Event Manager to monitor IIS Errors

Use event manager (start -> admin tools) to watch activity of errors

Monitoring Current Ports on PC

Download www.nirsoft.com Currports v1.82