August 2005 - Bilal Haidar [MVP]

Bilal Haidar [MVP]

Home
Contact

Syndication

All Links

Blogs I Read

My Articles

JavaScript & CSS

Date & Time

SQL Server 2000/2005

Articles I Read

ASP.NET Free Controls

MVFP (Most Valuable Forum Posts)

Archives

Sort by: Most Recent | Most Viewed | Most Commented

Time Difference in MS SQL

A very common question on the ASP.NET Forums: >> How to subtract two dates and get the time difference? The answer is in this UDF. It takes as input two parameters: 1- StartDate 2- EndDate It will return the time difference in this format: (-) HH...

Published Tue, Aug 30 2005 1:57 PM by simple
Identity Columns in MS SQL Server

When working with Identity Columns in MS SQL Server, and specially when testing your database and inserting some junk data for the sake of testing, you ask yourself, how would I reset my Identity Columns to their original values after I finish testing...

Published Tue, Aug 30 2005 12:17 PM by simple
Dynamic SQL Query Revisted

Based on Richard Dudley's comment on my previous post, here is an updated version of the Dynamic SQL Query: CREATE PROCEDURE [ dbo ] . [ GetReport ] ( @ID INT , @Type INT ) AS DECLARE @strQuery NVARCHAR ( 4000 ) DECLARE @parameterList NVARCHAR ( 4000...

Published Wed, Aug 24 2005 3:13 PM by simple
Dynamic SQL Query

This is a neat way of creating a Dynamic Query: CREATE PROCEDURE [ dbo ] . [ GetReport ] ( @ID INT , @Type INT ) AS DECLARE @strQuery NVARCHAR ( 2000 ) SET @strQuery = 'SELECT * FROM Reports WHERE ( (Reports.ID = ' + CAST ( @ID AS NVARCHAR ( 5 ) ) + ...

Published Tue, Aug 23 2005 1:25 PM by simple
Upload Multiple Files At Once

Check this nice trick to upload multiple files at once: http://the-stickman.com/web-development/javascript/upload-multiple-files-with-a-single-file-element/ Regards

Published Mon, Aug 22 2005 3:42 PM by simple
Another DateTime info

Check the following valuable MSDN page. DateTime Formats Regards

Published Wed, Aug 17 2005 10:43 PM by simple
DropDownList Customized Data Bind

I was trying to bind the DropDownList without using ObjectDataSource in ASP.NET 2.0, in such a way, I want to have all ListItems inside the DropDownList as (FirstName, LastName). How would I do such thing in ASP.NET x.x ? Here is the question ListItem...

Published Wed, Aug 17 2005 4:20 PM by simple
DatePicker Free Control

David Truxall, in his article, A n ASP.NET Composite Control for US and UK dates , shows how to develop a date picker control in asp.net together with a validator. Based on that articles, I have done some improvements to that control. In the projects...

Published Tue, Aug 16 2005 1:27 PM by simple
Windows 2003 Important Articles

I passed by a very important website which offers great articles on configuring Windows 2003 Server: http://www.simongibson.com/ Hope you like it. Regards

Published Thu, Aug 11 2005 9:55 PM by simple
DateTime Formatting in ASP.NET 2.0

This is a nice summarized sample code on how to format DateTime instances: // This code example demonstrates the String.Format() method. // Formatting for this example uses the "en-US" culture. using System; class Sample { enum Color {Yellow = 1, Blue...

Published Wed, Aug 10 2005 9:26 AM by simple

Filed under: ASP.NET 2.0
Interaction between Master Pages & Cotent Page

Have you ever needed to fire an event in the Content Page based on a button click in the Master Page and access some data sent from the Master Page to the Content Page? Place this in the Content Page: protected void Page_Init( object sender, EventArgs...

Published Tue, Aug 09 2005 2:16 PM by simple
SuperDropDownList 1.0

Hello: I have uploaded a new control on my personal website, under the title SuperDropDownList . What this control does is the following: 1- Insert a default ListItem at the top of the data bounded DropDownList 2- Adds a RequiredFieldValidator to check...

Published Mon, Aug 08 2005 10:20 AM by simple

Filed under: ASP.NET 2.0
Modal Dialog Window Caching Problem

Hello: Suppose you open a Modal Dialog window inside your ASP.NET page. In that dialog window, you have a GridView, DataGrid, or whatever control. Do some changes on that control, you will see that the data has changed right? Ok, then close the dialog...

Published Sun, Aug 07 2005 12:34 AM by simple

Filed under: ASP.NET 2.0
CheckBoxField in GridView

In the new data control, GridView, you have a new column called CheckBoxField, this column, accepts a boolean value and display a CheckBox either selected or not and disabled. What if you want to retreive the value from that column, to see if the CheckBox...

Published Sun, Aug 07 2005 12:17 AM by simple

Filed under: ASP.NET 2.0
DropDownList Tip

Hi: I was binding the DropDownList on an ASPX page in the Page_Load as follows: this .TypesDDL.DataSourceID = this .TypesDDL.DataSourceID; Then, after all I was adding the following: this .TypesDDL.Items.Insert(0, new ListItem(”text”, “value”...

Published Sat, Aug 06 2005 4:35 PM by simple

Filed under: ASP.NET 2.0
Access Selected GridViewRow in GridView

Hello: I was working last night around 3:00 AM, and I found out that in my GridView Column's list, I have added a TemplateField of type LinkButton with CommandName=”EditRec”, in such a way, when the Edit link button is clicked, I want to access...

Published Sat, Aug 06 2005 1:05 PM by simple

Filed under: ASP.NET 2.0
CompositeControl in ASP.NET 2.0 Beta2

A very important link that shows an example on using CompositeControl class in ASP.NET 2.0 Beta2. http://msdn2.microsoft.com/library/3257x3ea(en-us,vs.80).aspx Hope you will like it. Regards

Published Wed, Aug 03 2005 3:42 PM by simple
The ASPAlliance Times - 2nd August 2005 Issue

I just received by email the ASPAlliance Times – 2 nd August Issue and noticed that my article: A Customizable Login Server Control is one of the F ive M ost P opular A rticles on ASPAlliance.com . I am so proud and honored to have this achievement...

Published Tue, Aug 02 2005 11:46 PM by simple
ASP.NET 2.0 Web Part Framework Presentation

Yesterday, Monday August 1, 2005. My colleague Wessam Zeidan and I, presented the second session, titled with ASP.NET 2.0 Web Part Framework, in the Community Nights event. This event, is held by LebDev , the 1 st .NET user group in Lebanon, sponsored...

Published Tue, Aug 02 2005 1:17 PM by simple
Insert a New Record Using GridView

Here is a nice link to insert a new record into the database: http://fredrik.nsquared2.com/viewpost.aspx?PostID=155 Regards

Published Mon, Aug 01 2005 3:22 PM by simple

Filed under: ASP.NET 2.0

1 2 Next >

August 2005 - Bilal Haidar [MVP]

Syndication

Recent Posts

Tags

All Links

Blogs I Read

My Articles

JavaScript & CSS

Date & Time

SQL Server 2000/2005

Articles I Read

ASP.NET Free Controls

MVFP (Most Valuable Forum Posts)

Archives

Time Difference in MS SQL

Identity Columns in MS SQL Server

Dynamic SQL Query Revisted

Dynamic SQL Query

Upload Multiple Files At Once

Another DateTime info

DropDownList Customized Data Bind

DatePicker Free Control

Windows 2003 Important Articles

DateTime Formatting in ASP.NET 2.0

Interaction between Master Pages & Cotent Page

SuperDropDownList 1.0

Modal Dialog Window Caching Problem

CheckBoxField in GridView

DropDownList Tip

Access Selected GridViewRow in GridView

CompositeControl in ASP.NET 2.0 Beta2

The ASPAlliance Times - 2nd August 2005 Issue

ASP.NET 2.0 Web Part Framework Presentation

Insert a New Record Using GridView