Archive

Archive for June, 2009

Flex: Developing a Simple Video Player with

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/

Advertisements
Categories: Flex Tags: , , , ,

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

June 26, 2009 1 comment

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

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

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

Import Excel Spreadsheet Data into SQL Server Database Table

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

Implementing Search in ASP.NET with Google CustomSearch

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

Get Only Date from Datetime in Sql

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)

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

June 1, 2009 4 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>