Running SQL Server Compact on WINCE--Tutorial

Recently i had to use SQL server in WINCE which was installed on Friendly ARM device. I had to go through some R&D to find it. Got some errors in the beginning but finally was able to do so. Just to be simple on the new image of WINCE just copy these cab files from the pc and copy them to TEMP folder in the WINCE. You can find these cab files in the Program Files/SQL Server Compact in ARM folder. You will also need a .NET cab file which you can get from Framework installed directory. If you have Visual Studio 2008 installed you can get them easily you don't need to download these. The files are 1. NETCFv35.wce.armv4 2. sql.wce5.armv4i 3. sqlce.dev.ENU.wce5.armv4i 4. sqlce.repl.wce5.armv4i 5. sqlce.wce5.armv4i After copying these files in TEMP folder in WINCE double click...

Read the rest of this entry »

Posted in Sql Server Compact , WINCE

Image Store Save/Retrieve C# Web SQL Server using Handler/ Generic Handler

This tutorial is to guide you to save/retrieve image using C# in ASP.Net Web The saving image process is same as the windows form saving image process. You can get detail on my other tutorial which i wrote earlier which guide you to save/retrieve image in Windows Forms. You can read that tutorial from Click Here For you ease i will copy past the code to show you how you save image in SQL server using C#. 1. First of all we need a database in SQL Server which contains a table with only two columns one is 'id' of type 'int' and second is of 'image' of type 'image'. 2. Open SQL Server 2005 Express Management Studio and create new database. Name it according to your choice. 3. After successfully creating database create a table with two columns described in step 1. 4. Now Open Visual Studio...

Read the rest of this entry »

Posted in image retrieve , Image save , Image using handler , image web C#

Image Save/Retrieve C# Windows Form SQL Server

This tutorial will guide you to save or retrieve image from SQL Server in C#. 1. First of all we need a database in SQL Server which contains a table with only two columns one is 'id' of type 'int' and second is of 'image' of type 'image'. 2. Open SQL Server 2005 Express Management Studio and create new database. Name it according to your choice. 3. After successfully creating database create a table with two columns described in step 1. 4. Now Open Visual Studio 2008/2010. 5. Create a project of windows form. 6. In Design View of Form1(you can rename it to your choice) drag a control of picture box to the form with two buttons. 7. Change text of one button to Save and second to Retrieve. 8. Double click Save button to create event for double click. 9. In this event function, create...

Read the rest of this entry »

Posted in c# , image , image retrieve , Image save

♥♥ GENERAL KNOWLEDGE OF HOLY QURAN ♥♥

      GENERAL KNOWLEDGE OF HOLY QURAN.     No QUESTION ANSWER 1 How many Sura are in Holy Quran ? 114 2 How many Verses are in Holy Quran ? 6666 3 How many dots are in Holy Quran ? 1015030 4 How many over bar (zaber) are in Holy Quran ? 93243 5 How many under bar ( Zaer ) are in Holy Quran ? 39586 6 How many R u que are in Holy Quran ? 1000...

Read the rest of this entry »

Getting Specific Row in SQL 2000 & 2005

Here is the query to find the specific row in Sql 2000 SELECT ( SELECT SUM(1) FROM [Table_Name] WHERE [TableID]<=reg.[TableID] ) AS Row ,* FROM [Table_Name] AS reg WHERE ( SELECT SUM(1) FROM [Table_Name] WHERE [TableID]<=reg.[TableID] ) = 5 Note: 5 is the row number you want to find in the table. Now for SQL 2005 SELECT us.TableID FROM (SELECT ROW_NUMBER() OVER (ORDER BY [Table_Name].[TableID]) AS Row, [Table_Name].[TableID] FROM [Table_Name] ) us WHERE Row = 5 In this built in function ROW_NUMBER is used. Again '5' is the row number you are looking for. u can change it with the row number u want to fi...

Read the rest of this entry »

Multiple Selection in RadComboBox--- Getting selectedValue at server side-- Setting selected value javascript

This article shows how to select multiple items in radcombobox and to get these selected values at server side. Also it shows how to show selected value in radcombobox using javascript. 1.First of all declare radcombobox. <telerik:RadComboBox ID="ddlVehicleOwners" OnClientSelectedIndexChanging="onSelectedIndexChangingVehicleOwner" runat="server" Skin="WebBlue" OnClientDropDownClosed="HandleClose" LoadingMessage="Loading..." >                                             <ItemTemplate>                                                 <table...

Read the rest of this entry »

Posted in Drop Down , Drop Down List , Multiple , Multiple Selection , radcombox , Selection , telerik