Select Count * (count total of records)

August 30, 2011 - Posted in Access, ASP.NET, MS SQL - Permalink

VB.NET


Protected Sub Page_Load(sender As Object, e As System.EventArgs) Handles Me.Load
If Not Page.IsPostBack Then
 Try
 '/ access db connection - MS Access 2007/10 
 '  driver * you can define your own sql connection
 Dim ConnDB As New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;
                                   Data Source=" & Server.MapPath("my_db.accdb"))

'/ open connection
    ConnDB.Open()
     Dim cmd As New OleDbCommand("select count(*) from table1 WHERE 
                                  location = 'My_Location'", ConnDB)
     Dim count As Integer = CInt(cmd.ExecuteScalar())

      If count >= 90 Then '/ if count >= do this
        lblMsg1.Text = "There is 90 or more records!"
      Else
        lblMsg1.Text = "Total number of records is " & count.ToString()
      End If

   Catch ex As Exception
     Throw New Exception(ex.Message)
     Finally
   ConnDB.close()
   End Try
End If

End Sub

VB.NET date and time format

August 29, 2011 - Posted in Applications, ASP.NET, Date and Time Format - Permalink

Date as Monday, August 29, 2011


Protected Sub Page_Load(sender As Object, e As System.EventArgs) Handles Me.Load
    Dim dd As Date = Date.Today
    label1.Text = String.Format("{0:dddd, MMMM d, yyyy}", dd)

End Sub

Other formats…


' - month/day numbers without/with leading zeroes
String.Format("{0:M/d/yyyy}", dt);            ' "8/29/2011"
String.Format("{0:MM/dd/yyyy}", dt);          ' "08/29/2011"

' - day/month names
String.Format("{0:ddd, MMM d, yyyy}", dt);    ' "Sun, Aug 29, 2011"
String.Format("{0:dddd, MMMM d, yyyy}", dt);  ' "Sunday, August 29, 2011"

' - two/four digit year
String.Format("{0:MM/dd/yy}", dt);            ' "08/29/11"
String.Format("{0:MM/dd/yyyy}", dt);          ' "09/29/2011"

… and more formats


String.Format("{0:t}", dt);  ' "11:31 AM"                        
                             ' ShortTime
String.Format("{0:d}", dt);  ' "8/29/2011"
                             ' ShortDate
String.Format("{0:T}", dt);  ' "11:31:12 AM"
                             ' LongTime
String.Format("{0:D}", dt);  ' "Monday, August 29, 2011"
                             ' LongDate
String.Format("{0:f}", dt);  ' "Monday, August 29, 2011 11:31 AM"
                             ' LongDate+ShortTime
String.Format("{0:F}", dt);  ' "Monday, August 29, 2011 11:31:12 AM" 
                             ' FullDateTime
String.Format("{0:g}", dt);  ' "8/29/2011 11:31 PM"
                             ' ShortDate+ShortTime
String.Format("{0:G}", dt);  ' "3/9/2008 4:05:07 PM"
                             ' ShortDate+LongTime
String.Format("{0:m}", dt);  ' "August 29"                        
                             ' MonthDay
String.Format("{0:y}", dt);  ' "August, 2011"                     
                             ' YearMonth
String.Format("{0:r}", dt);  ' "Mon, 29 Aug 2011 14:27:52 GMT"   
                             ' RFC1123
String.Format("{0:s}", dt);  ' "2011-08-29T14:27:52"             
                             ' SortableDateTime
String.Format("{0:u}", dt);  ' "2011-08-29 14:27:52Z"
                             ' UniversalSortableDateTime

View related posts
– VB.NET – Date in code behind
– Month, day and year code behind format

ASP.NET Validation Controls

August 26, 2011 - Posted in Validation Controls - Permalink

RequiredFieldValidator


asp:TextBox Id="UserName" runat="server" />
/asp:TextBox>*

asp:RequiredFieldValidator 
    id="valUserNameRequired"
    ControlToValidate="UserName"
    ValidationGroup="Form1"
    ErrorMessage="UserName is a required field."
    Display="None" Runat="server">

CompareValidator [password]


asp:TextBox Id="UserName" runat="server" />
/asp:TextBox>*

asp:CompareValidator id="valComparePassword"
    ControlToValidate="ConfirmPassword"
    ValidationGroup="Form1"
    ErrorMessage="Password fields must match." 
    ControlToCompare="txtPassword" 
    Display="None"
    EnableClientScript="true" 
    Runat="server"/>

CompareValidator [date]


asp:TextBox Id="date" runat="server" />
/asp:TextBox>*

asp:CompareValidator id="valDate"
    Type="Date"
    ControlToValidate="Date"
    Operator="DataTypeCheck"
    ValidationGroup="Form1"
    ErrorMessage="mm/dd/yyyy"  
    Display="None"
    Runat="server"/>

RegularExpressionValidator [email]


asp:TextBox ID="email" runat="server" ToolTip="you@emailprovider.com"> 
/asp:TextBox>

asp:RegularExpressionValidator 
    ID="valEmail" runat="server" 
    ErrorMessage="Invalid email format!" 
    ValidationGroup="Form1" 
    ControlToValidate="email" 
    ValidationExpression="\w+([-+.']\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*"> 
/asp:RegularExpressionValidator>

RegularExpressionValidator [phone]


asp:TextBox ID="phone" runat="server" ToolTip="(333) 444-5678"> 
/asp:TextBox>

asp:RegularExpressionValidator 
    ID="valPhone" runat="server" 
    ErrorMessage="(333) 444-5678" 
    ValidationGroup="Form1" 
    ControlToValidate="phone" 
    ValidationExpression="\(\d{3}\) \d{3}\-\d{4}"> 
/asp:RegularExpressionValidator>

RegularExpressionValidator [date]


asp:TextBox ID="date" runat="server" ToolTip="mm/dd/yyyy"> 
/asp:TextBox>

asp:RegularExpressionValidator 
    ID="valDate" runat="server" 
    ErrorMessage="mm/dd/yyyy" 
    ValidationGroup="Form1" 
    ControlToValidate="date" 
    ValidationExpression="^\d{1,2}/\d{1,2}/\d\d\d\d$"> 
/asp:RegularExpressionValidator>

RegularExpressionValidator [number]


asp:TextBox ID="user_id" runat="server" ToolTip="06"> 
/asp:TextBox>

asp:RegularExpressionValidator 
    ID="valNumber" runat="server" 
    ErrorMessage="Numbers only" 
    ValidationGroup="Form1" 
    ControlToValidate="user_id" 
    ValidationExpression="^\d+$"> 
/asp:RegularExpressionValidator>

RegularExpressionValidator [number, 2 decimals]


asp:TextBox ID="amount" runat="server" ToolTip="34.56"> 
/asp:TextBox>

asp:RegularExpressionValidator 
    ID="valAmoun" runat="server" 
    ErrorMessage="Two decimals number" 
    ValidationGroup="Form1" 
    ControlToValidate="amount" 
    ValidationExpression="^\d*\.\d{2}$"> 
/asp:RegularExpressionValidator>

Regular ExpressionValidator [username, exact lenght ]


asp:RegularExpressionValidator 
    ID="InputLenghtDefined" runat="server" 
    display="dynamic" ControlToValidate="usnCheck" 
    ErrorMessage="Username must be one word 4 - 20 characters!" 
    ValidationExpression="[^\s]{4,20}" />
/asp:RegularExpressionValidator>

Once you drag RegularExpressionValidator on the “Designer”, in design view select the Requarexpressioncvalidator control. In “Properties” on the right-hand side there is a ValidationExpression field. Select expression that you would like to use from a list of expressions provided by .NET. Once you choose the expression you want there is a Validation expression: textbox that holds the regex used for the validator.

See some examples on Microsoft Support website (KB316662), or better yet this this source.

« Older Entries
Newer Entries »