AJAX Calendar Demonstration

by Kareem Allam 16. April 2013 16:09

Default calendar:

<asp:TextBox runat="server" ID="Date1" /><br />
        <ajaxToolkit:CalendarExtender ID="defaultCalendarExtender" runat="server" TargetControlID="Date1" />

 

 


 

Calendar with a custom style and formatted date:

 

<asp:TextBox runat="server" ID="Date2" /><br />
        <ajaxToolkit:CalendarExtender ID="customCalendarExtender" runat="server"
            TargetControlID="Date2"
            CssClass="MyCalendar"
            Format="MMMM d, yyyy" />

 

 


 

Calendar with an associated button:

 

<asp:TextBox runat="server" ID="Date5" />
        <asp:Image runat="Server" ID="Image1" ImageUrl="Calendar_scheduleHS.png" /><br />
        <ajaxToolkit:CalendarExtender ID="calendarButtonExtender" runat="server"
            TargetControlID="Date5"
            PopupButtonID="Image1" />

 

If you enjoyed this post, make sure you subscribe to my RSS feed!

SQL Server Data Types

by Kareem Allam 4. November 2011 19:00

Data Type

Size

Range

TINYINT(n)

1 byte

0 to 255 (unsigned)

SMALLINT(n)

2 bytes

-32,768 to 32,767

INT(n)

4 bytes

Approximately plus or minus 2 billion (-2,147,483,648 to 2,147,483,647)

BIGINT(n)

8 bytes

Approximately plus or minus 10 billion billion or 10 million trillion or 10 thousand quadrillion or 10 quintillion (-9,223,372,036,854,775,808 to 9,223,372,036,854,775,807)

FLOAT(n)

4 bytes if n < 25 or 8 bytes if 24 < n < 54

n decimal places

REAL

4 bytes

 

DECIMAL(n,d)

5 to 17 bytes

n digits before and after the decimal point, d decimal places

SMALLMONEY

4 bytes

-214,748.3648 to 214,748.3647

MONEY

8 bytes

-922,337,203,685,477.5808 to 922,337,203,685,477.5807

SMALLDATETIME

4 bytes

01/01/1900 00:00 to 06/06/2079 23:59

DATETIME

8 bytes

01/01/1753 to 31/12/9999

DATETIME2

6 to 8 bytes

01/01/0001 to 31/12/9999. Intended as a replacement for SMALLDATETIME and DATETIME

DATETIMEOFFSET

8 to 10 bytes

01/01/0001 to 31/12/9999, includes space for timezone offset

DATE

3 bytes

01/01/0001 to 31/12/9999

TIME

3 to 5 bytes

Accurate to 100 nanoseconds

CHAR(n)

fixed length, 1 byte per character (n), up to 8000

Consumes n bytes of storage

NCHAR(n)

2 bytes per field length (n)

Stores unicode characters

VARCHAR(n)

variable length, 1 byte per character (n), up to 8000

Consumes 1 byte per character stored, up to n bytes

VARCHAR(MAX)

2 bytes per character stored

Maximum 2GB. Replacement for TEXT datatype

NVARCHAR(n)

2 bytes per character stored (n), up to 4000

Stores unicode characters

NVARCHAR(MAX)

2 byte per character stored

Maximum 2GB. Replacement for NTEXT datatype

BIT

1 bit

Null, 0 or 1

BINARY

Fixed width binary data

Up to 8000 bytes

VARBINARY

Variable width binary data

Up to 8000 bytes

VARBINARY(MAX)

Variable width binary data

Up to 2GB

XML

Stores XML documents

XML Schema collection can be defined to verify documents

If you enjoyed this post, make sure you subscribe to my RSS feed!

Get value of checked item in CheckedListBox

by Kareem Allam 18. September 2011 18:31

 after bind CheckedListBox with data you can get value of checked items


For i As Integer = 0 To CheckedListBox1.CheckedItems.Count - 1
                    Dim XDRV As DataRowView = CType(CheckedListBox1.CheckedItems(i), DataRowView)
                    Dim XDR As DataRow = XDRV.Row
                    Dim XDisplayMember As String = XDR(CheckedListBox1.DisplayMember).ToString()
                    Dim XValueMember As String = XDR(CheckedListBox1.ValueMember).ToString()
                    MsgBox("DisplayMember : " & XDisplayMember & "   - ValueMember : " & XValueMember )
Next

 now you can use the value or Display of checked items in CheckedListBox from the 2 variables XDisplayMemberXValueMember in the loop

 

hope to be useful ,,, 


If you enjoyed this post, make sure you subscribe to my RSS feed!

About EgDev.com

If you would like to find value services with excellent quality and cost effectiveness and with a focus on speed , Just Follow

 Egypt Development Freelance Team.

Month List

Page List