Monday, June 29, 2009

Flex: Developing a Simple Video Player with

· 0 comments

This tutorial will explain you how to develop a video player in flex by making use of <mx:VideoDisplay>.

It is a very simple and easy to implement, within seconds you will be able to build and play videos.

<mx:VideoDisplay> is a flex component for playing video files.

In the below link, the author has beautifully explained the process with proper description and screenshots.

You can also view the demo and download the source code.

http://www.riacodes.com/flex/basic-video-player-in-flex/

Read More......

Friday, June 26, 2009

CRUD(Create/Insert/Update/Delete) with Asp.net MVC Framework, Linq To Sql (.dbml)

· 0 comments

This article will explain you how to create, read, insert, update, delete operations with asp.net mvc with Linq To Sql (.dbml).

Very nice article who are beginners with asp.net mvc framework.

http://blogs.microsoft.co.il/blogs/bursteg/archive/2009/02/03/create-a-strongly-typed-crud-ui-with-asp-net-mvc-rc.aspx

Read More......

Thursday, June 25, 2009

CRUD(Create/Insert/Update/Delete) with Asp.net MVC Framework, ADO.Net Entity Data Model

· 0 comments

This article will explain you how to create, read, insert, update, delete operations with asp.net mvc with ado.net entity model.


Very nice article who are beginners with asp.net mvc framework.


http://www.c-sharpcorner.com/UploadFile/dhananjaycoder/AuthorContactManager06102009052732AM/AuthorContactManager.aspx

Read More......

Thursday, June 18, 2009

Import Excel Spreadsheet Data into SQL Server Database Table

· 0 comments

There are many ways to import/export excel data into sql server table.


Using SqlBulkCopy Common Method for sql server 2005/2008:


http://davidhayden.com/blog/dave/archive/2006/05/31/2976.aspx


In SqlServer 2005 Using Integration Services


http://www.builderau.com.au/program/sqlserver/soa/How-to-import-an-Excel-file-into-SQL-Server-2005-using-Integration-Services/0,339028455,339285948,00.htm


Using Sql Server 2005 Import and Export Wizard


http://www.databasejournal.com/features/mssql/article.php/3580216/SQL-Server-2005-Import--Export-Wizard.htm


Using Sql Server 2008 Import and Export Wizard


http://dotnetslackers.com/articles/sql/Importing-MS-Excel-data-to-SQL-Server-2008.aspx

Read More......

Wednesday, June 3, 2009

Implementing Search in ASP.NET with Google CustomSearch

· 0 comments

Going to add search functionality for your website... why not let google do this task.. it would be easier and user friendly..

With those who are unaware of Google Custom Search :
"With Google Custom Search, you can harness the power of Google to create a customized search experience for your own website"


  • Include one or more websites, or specific webpages

  • Host the search box and results on your own website

  • Customize the look and feel of the results to match your site


For more info on google custom search click here

So lets see how to implement search in asp.net with google custom search..

Here is the step by step procedure very nicely explained in the below article..

http://dotnetslackers.com/articles/aspnet/Implementing-Search-in-ASP-NET-with-Google-Custom-Search.aspx

Read More......

Tuesday, June 2, 2009

Get Only Date from Datetime in Sql

· 0 comments

Sometimes we need to have only date from datetime field in sql.

There are number of ways to accomplish that:

Suppose we take current date

select getdate()

now to take only date from current date excluding time, we do as follows in various ways:




select DATEADD(dd, 0, DATEDIFF(dd, 0, GETDATE()))
select convert(varchar,getdate(),101)
select convert(char(8),getdate(),1)
select cast(cast(getdate() as int) as datetime)
select cast(convert(varchar,getdate(),110) as datetime)

Read More......

Monday, June 1, 2009

Adding eWorld.UI (Excentrics World) Calendar Popup, TimePicker.. etc in Asp.net

· 0 comments

You might be in need of Calendar popup or Time Picker in asp.net. I have being using eworld's calendar popup and time picker control since many years.. and all i can say that they are fantastic fully loaded with various features... No Need of taking a textbox and a calendar control for binding date.. and adding different validations for valid date, past and future date validation... now all that comes in one place just drag and drop one calendar popup control and it will give you access to multiple features..

Also there is no time picker control available in our asp.net toolbox.. i searched a lot over the internet and i found this one..

You can download the eworld ui toolkit from :

http://www.eworldui.net/Download.aspx

Toolkit is available for various .net versions whether it is 1.0, 2.0 or 3.5

Once Downloaded, unzip the rar file and install the given exe..

Also, Once done copy the eWorld.UI.dll and paste it in the bin folder of your web application and then right click the web site and add reference of that dll.

Then In the Visual Studio ->View ->Tool box -> Right Click ->Add Tab -> give Eworld Toolkit (as name) - > Right click ->choose items and browse to the eworld ui dll and once done you will see many contorls under that tab in the tool box..

I have been using

CalendarPopup

Time Picker

RangeValidator

CustomValidator

MaskedTextbox...

there are lots of other controls too which you can try at your lease..

Once done.. you can drag and drop the calendar popup on to the aspx page and you will see:

<ew:CalendarPopup ID="tb_startupdate"
runat="server" ControlDisplay="TextBoxImage" ImageUrl="~/Images/dtpicker.jpeg">
</ew:CalendarPopup>

Read More......