Monday, November 30, 2009

Paging in wrapPanel

Here is the paging Functionality in Wrap Panel
I have added Wrap panel using the namespace as shown in the image

Do not set width on wrap panel. Wrap panel loads image based on main page size changes
I have loaded images from xml and when the main window is resized paging changes based on that

public MainPage()
this.SizeChanged += new SizeChangedEventHandler(MainPage_SizeChanged);
webClient = new WebClient();
webClient.OpenReadCompleted += new OpenReadCompletedEventHandler(webClient_OpenReadCompleted);
webClient.OpenReadAsync(new Uri("Application.xml", UriKind.RelativeOrAbsolute));
this.Loaded += new RoutedEventHandler(MainPage_Loaded);

void MainPage_SizeChanged(object sender, SizeChangedEventArgs e)
private void Paging()
appHeight = this.ActualHeight;
appWidth = this.ActualWidth;
pageSize = Convert.ToInt32(Math.Floor(((this.ActualHeight) - 216) / 38));
if (pageSize != 0.0)
pagecount = Convert.ToInt32(Math.Ceiling(totalSize / pageSize));
if (pagecount != 1)
for (int i = 0; i <= pagecount; i++) {
HyperlinkButton href = new HyperlinkButton();
href.Content = i + 1;
href.Click += new RoutedEventHandler(href_Click);

void href_Click(object sender, RoutedEventArgs e)
HyperlinkButton hf = sender as HyperlinkButton; GetInteractivity(Convert.ToInt32(hf.Content));
void webClient_OpenReadCompleted(object sender, OpenReadCompletedEventArgs e)
xmlParser = new XMLParser(e.Result);
BindXML(); webClient.OpenReadCompleted -= new OpenReadCompletedEventHandler(webClient_OpenReadCompleted);
totalSize = interactivityList.Count; Paging();
catch (Exception ex) { }
private void GetInteractivity(double pgSize)
int startVal = Convert.ToInt32((pgSize - 1) * pageSize);
int endVal = Convert.ToInt32((pgSize) * pageSize);
endVal = endVal > Convert.ToInt32(totalSize) ? Convert.ToInt32(totalSize) : endVal;
for (int i = startVal; i <=endVal;i++)

Image img = new Image();
img.Width = 160;
img.Height = 160;
string imgpath = interactivityList[i].imagePath.ToString();
Uri uri = new Uri(imgpath, UriKind.Relative);
ImageSource src = new BitmapImage(uri);
img.Source = src;
img.Tag = interactivityList[i].xapfilePath;
img.MouseLeftButtonDown += new MouseButtonEventHandler(image1_MouseLeftButtonDown);
Rectangle rect = new Rectangle();
rect.Width = 100;
rect.Height = 100;
private void BindXML()
List elements = xmlParser.GetElements("Application");
if (elements.Count > 0)
for (int i = 0; i <= elements.Count; i++)

Interactivity interactivity = new Interactivity();
imageElement = elements[i].Element("ImagePath");
interactivity.imagePath = imageElement.Value.ToString();
xapElement = elements[i].Element("xapFilePath");
interactivity.xapfilePath = xapElement.Value.ToString();
} public class Interactivity
public string imagePath { get; set; }
public string xapfilePath { get; set; }


Replace <= with <

LoadXap File Dynamically through HTML page

How to load xap file dynamically in silverlight?
We can use xap loader class method or else u can load xap file via html Page.Here is my example to load the xap file dynamically
Lets Create a sample application and bind the image in tat application .I have created the project in the name of sampleapplication .

Now i have created the other project name loadXAP to load sampleapplication XAP file.I have added MyPage.htm Page in the web project,and add the following code as in the image

and add div with the Id 'silverlightControlHost' in the body tag .Now place the sample application Xap file in the ClientBin folder of loadXap Application.Now i have place thumbnail of image and when i click on the image it redirects to MyPage.htm file with the XAP filename as Query string .Here is the screen shot of the application

Thursday, October 22, 2009

Accordian Control Problem in Blend

Hi ,
When the Accordian Control is added in silverlight. When you open in Blend You could not able to find the control in Expression Blend.

To View in the Blend You should add reference System.Windows.Controls.Layout.Toolkit. and System.Windows.Controls.Toolkit

Wednesday, October 14, 2009

ErrorCode:4001 ErrorType:MediaError AG_E_NETWORK_ERROR

Hi all,

ErrorCode:4001 ErrorType:MediaError AG_E_NETWORK_ERROR

I get the above error when i play a media file. It ruins my whole day.
At last i found by adding the media file in the Bin Debug/Release folder and in the web i have added in the client bin folder. It solve my issue

Wednesday, September 2, 2009

Search Query in sql

Hi ,I have the table name stipr and category with the following fields as follows
and category table with the field of
Now my requirement is i have to write the query with the different combination as followsfor ex:
declare @IPRdate datetime,@IPRNo nvarchar(50),@DeliveredTo nvarchar(50),@Classification nvarchar(50),@RequiredFor nvarchar(50),@STCategoryID nvarchar(50),@MainStatus nvarchar(50)
if @IPRdate !=null and @IPRNo=null and @DeliveredTo = null AND @Classification = null AND @RequiredFor = null AND @STCategoryID = null AND @MainStatus = nullBeginselect * from Store.STIPR,Store.STCategory where IPRdate=@IPRdateEndelse if @IPRdate !=null and @IPRNo !=null and @DeliveredTo = null AND @Classification = null AND @RequiredFor = null AND @STCategoryID = null AND @MainStatus = null
select * from Store.STIPR,Store.STCategory where IPRdate=@IPRdate and IPRNo=@IPRNo

After a long search i found the query using case then

select * from Store.STIPR,Store.STCategory where
iprdate = (case when @IPRdate is null then iprdate else @IPRdate end) and
iprno = (case when @IPRNo is null then iprno else @IPRNo end) and
deliveredto = (case when @DeliveredTo is null then deliveredto else @DeliveredTo end) and
classification = (case when @Classification is null then classification else @Classification end) and
requiredfor = (case when @RequiredFor is null then requiredfor else @RequiredFor end) and
stcategoryID = (case when @STCategoryID is null then stcategoryID else @STCategoryID end) and
mainstatus = (case when @MainStatus is null then mainstatus else @MainStatus end)

Friday, July 31, 2009

SilverLight Interview Questions

What are the types of containers in silver light?
dock panel-dock panel is used to arrange a set of objects around the edges of panel. Dock Panel’s Dock property enables you to specify the location of objects inside Dock Panel. If you set the LastChild Fill property to true (the default value) and the last element is allowed to resize, the last element added to the panel will resize to fill the remaining space. If the last element is set to a specific size, the last element will be set to the specified size and positioned in the middle of the remaining space. The order in which elements are added to the dock panel is important.
Wrap Panel-Wrap panel is used to wrap the content in the next line.

What is silverlight .js file?
silverlight.js is a helper file is used when adding a silverlight application to a web page via javascript .It contains more helper method like get silverlight,ongetsilverlight,etc.We can add silverlight application to a web page by an alternate way asusing objecttag in html element

Does Silverlight support ADO.NET? and How to load the data to Silverlight from database?
It Does not support .have to use via WCF service,

How to use the styles in Silverlight? Can we load the external CSS file into Silverlight?
NO, it is not possibel to load external css in silverlight.We can use setter property to in app.xaml to apply the style.
For ex:
In app.xaml
style x:Key="titleBorder" TargetType="Border"
setter property="Background" value="#ff0000"
if we r using brush then use Setter.value under
To use in the page
border style="{staticresource TitleBorder}>
textBlock text="GetData" style="{staticresource titleborder}"

can we use more than one xaml file in same project? explain?
yes we can use.To redirect from one xaml to other xaml
App app = (App)Application.Current;
app.UserName = txtUser.Text;
App.GoToPage(new Page2());

public static void GoToPage(UserControl nextPg)
App app = (App)Application.Current;
// Remove the displayed page
// Show the next page
to pass the parameter u can created property class and assign the value before passing parameter

Monday, June 22, 2009

Reset Identity column value in sql

( 'table'
[ , { NORESEED | { RESEED [ , new_reseed_value ] } } ]

NORESEED - The current identity value should not be changed.
RESEED - Change the identity value.
new_reseed_value - The new seed value to be used for the identity column.
WITH NO_INFOMSGS - Suppresses all information messages.


Friday, June 19, 2009

Update Dynamic Values in App.Config

Here is the code to update the dynamic values in app.config

Wednesday, June 17, 2009

Day Pilot Calendar Div problem in IE7 Browsers

Day Pilot Calendar Div problem in IE7 Browsers

Calendar does not set in the IE7 Where as It Works fine in Firefox. In Ie7 It get blocked. it ruins the whole day and at last i found the solution by

Set the parent div to position: relative

Read Me and License Agreement While Creating Window Setup

Here is the instruction to add readme and license agreement while creating Windows Setup:

1) Select File->New->Project.

2) In the project panes, select Setup and deployment projects. In the templates pane, select setup project.

3) Select File->Add project->Existing Project. And add your project

4) Select the "File System on Target Machine" in the File system editor.

5) To add the output, select View->Custom ActionàAdd Custom Action->project output. Select "Project" from the drop down-list. Select primary output from the output list.

6) Click the ok button.

7) To create a shortcut on the desktop, in the details pane select primary output from sample. Select action->create shortcut to primary output. Change the shortcut name. Drag the shortcut to the user's Desktop node in the left pane.

8) Right Click on the User Desktop Select Properties Window and Change the Condition Property to SHORTCUTDEMO

9) To add Read Me and License file follow the procedure

10) Create ReadMe.Rtf File and License.Rtf File and add it in the application folder in the file system editor Note: If the Content is not displayed in read me and license then there is a problem in rtf format file.

11) Select View à User Interface Editor and right click on start under install category and click Add Dialog menu.

12) In the Add Dialog box, select the Checkboxes (A), License Agreement, Read Me, and Splash dialog boxes, and then add them to the Start sequence.

13) Drag and drop the dialog boxes into the proper sequence

14) Select the License Agreement dialog box and view its properties window. Change the License File property to license.rtf.

15) Select the Read Me dialog box and select View | Properties Window to bring up its properties window. Change the Readme File property to readme.rtf.

16) To have the logo display on all of these additional default dialogs, set the Banner Bitmap property to developer.gif.

17) Use the Checkboxes (A) dialog box to ask the user whether the demo shortcut you placed in the User's Desktop folder should be installed or not. Modify the properties of this dialog box to match the Figure 5 screenshot.

18) Remember to set the CheckBox1Property to SHORTCUTDEMO. This value is the same as the Condition property that you set for the User's Desktop folder in the File System Editor. If the user selects this checkbox during installation, the value of the SHORTCUTDEMO condition is set to true. As a result, the shortcut installs on the user's desktop. If the user does not select this checkbox, the SHORTCUTDEMO condition is set to false and the shortcut does not install.

Wednesday, May 20, 2009

SqlQuery To Export Data from Excel to Sql

Here is the query to export the data from Excel to sqlserver

CREATE TABLE [dbo].[Addresses_Temp] (
[FirstName] VARCHAR(20),
[LastName] VARCHAR(20),
[Address] VARCHAR(50),
[City] VARCHAR(30),
[State] VARCHAR(2),

INSERT INTO [dbo].[Address_Temp] ( [FirstName], [LastName], [Address], [City], [State], [ZIP] )
SELECT [FirstName], [LastName], [Address], [City], [State], [ZIP]
FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=C:\Source\Addresses.xls;IMEX=1',
'SELECT * FROM [Sheet1$]')

To Access the function such as OPENROWSET Go to

Click on Surface Area Configuration For features

Sunday, May 10, 2009

WildCharacters in Sql

Here are the query results using Wild card Character.Consider below table

Now Consider the Query

Select * from student Where Name like ‘John%’.

It return results as name starts with john . You will get the result as

Select * from student Where Name like ‘%John’. It results as

Select * from student Where Name like ‘%John%’. It results as

Select * from student Where Class like ‘Fo_r’. '_' matches single character and replace it

Friday, May 8, 2009

What is a flat file?

A flat file is the name given to text, which can be read or written only sequentially.

Calculate Age from the DateOfBirth

Here is the program with the three line to calculate the age from the DOB

long yrs = 0;
DateTime bdayDate = new DateTime(2010, 07, 17);
TimeSpan ts = DateTime.Now.Subtract(bdayDate);
yrs = ts.Days / 365;

Saturday, April 25, 2009

Difference Between .net FrameWork 1.1,2.0,3.0,3.5

2.0 has some extendable features when compared to 1.1

1).net 2.0 supports web Request, web Response and web client classes

2).net 2.0 added the features of generic classes
3).net 2.0 added the feature of MultipleActiveResultSet,UserDefinedDataTypes,xmlDataTypes
4).net 2.0 UTF8Encoding is more faster than 1.1
5)When the file attachment u s

To read more Detail click the following link

Difference between 2.0 and 3.0 is

3.0 and 3.5 is similar, with the additional features of enhanced WCF Control, with Ajax , LinQ

Monday, February 2, 2009

Unsafe code may only appear if compiling with /unsafe in VisualStudio 2005

Here is the error which i got when using unsafe code
Unsafe code may only appear if compiling with /unsafe
Here is the solution for the above error
Add the following line under system.codedom /compilers
compiler language="C#;cs;csharp" extension=".cs" type="Microsoft.CSharp.CSharpCodeProvider, System, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" compilerOptions="/unsafe" /

UnSafe Code in C#

Here is some details about Unsafe in C#
Unsafe code is code which does not executed under full control of CLR. It can cause some problems therefore each use must be marked as "unsafe".
// unsafe context: can use pointers here
Generally speaking when you write any program in C# you create managed code. Managed code is executed under the control of Common Language Runtime (CLR). CRL causes that programmer do not need to manage memory and take care about memory's allocation and deallocation. CLR also allows you to write what is called 'unsafe code'.


  • Performance and flexibility, by using pointer you can access data and manipulate it in the most efficient way possible.
  • Compatibility, in most cases we still need to use old windows APIs, which use pointers extensively. Or third parties may supply DLLs that some of it’s functions need pointer parameters. Although this can be done by using DLLImport and System.IntPtr class, but in some cases it’s just much simpler to use pointer.
  • Memory Addresses, there is no way to know the memory address of some data without using pointers.


  • Complex syntax, to use pointers you need to go throw more complex syntax than we used to experience in C#.
  • Harder to use, you need be more careful and logical while using pointers, miss using pointer might lead to the following:
    • Overwrite other variables.
    • Stack overflow.
    • Access areas of memory that doesn’t contain any data as they do.
    • Overwrite some information of the code for the .net runtime, which will surely lead you application to crash.
  • Type-safety, using pointers will cause the code to fail in the .net type-safety checks, and of course if your Security policy don’t allow non type-safety code, then the .net framework will refuse to execute it.

Face Detection in Webapplication c#

Here is the web application to detect the face on the image .Face Detection is does by open CV (open source Computer vision).

It is a library programming unit aimed at facial Recognition, motion detection . Download open CV here and install it Here is the link for face detection in windows application . code that Modified from window application to web application.
To execute the application
Create Images Folder in the path of your website , place sample image as test.jpg .

Here is the code for aspx page
Add the following controls : file upload , Button,Image , HiddenField

Here is the code for aspx.cs page
public partial class _Default : System.Web.UI.Page
private string fileName;
private Guid imageId;
private Bitmap lastPic;
private clsFaceDetectionWrapper objFaceDetector = null;
private Pen myPen = new Pen(Color.Red, 2.0f);
Graphics picGraphics;
Graphics g;
private string filePath;
protected void Page_Load(object sender, EventArgs e)
objFaceDetector = clsFaceDetectionWrapper.GetSingletonInstance();
detectedImage.ImageUrl = Server.MapPath("./images/output.jpg");

void DrawRectangle(int lx, int ly, int rx, int ry)
g.DrawRectangle(myPen, lx, ly, rx - lx, ry - ly);
void DrawCross(int x, int y)

protected void detectButton_Click(object sender, EventArgs e)
imageId = new Guid();
imageId = Guid.NewGuid();
if (imageUpload.HasFile)
fileName = imageUpload.FileName.ToString().
if (fileName.ToLower() == ".jpg" || fileName == ".gif" || fileName == ".jpeg" ||fileName == ".bmp" || fileName == ".png" || fileName == ".tif")
if (imageUpload.FileName != "")
pathHiddenField.Value = Server.MapPath("./images/" + imageId + "_" + imageUpload.FileName);
imageUpload.PostedFile.SaveAs(Server.MapPath("./images/" + imageId + "_" + imageUpload.FileName));
lastPic = new Bitmap(pathHiddenField.Value);
g = Graphics.FromImage(lastPic);
// here is the path to plave the cascade folder in the specified path.If Possible place the path cascade file in the execution path else modiy the face locatormethod and its coressponding dependabale method to get the path as arguments
String path = Server.MapPath("./XML/");
if (lastPic != null)
int faces = objFaceDetector.WrapDetectFaces(lastPic,path);

int lx, ly, rx, ry, res;
for (int f = 0; f < faces; f++)
objFaceDetector.WrapGetFaceCordinates(f, &lx, &ly, &rx, &ry); g.DrawRectangle(myPen, lx, ly, rx, ry);
Response.ContentType = "image/jpeg";
lastPic.Save(Server.MapPath("./Images/Test.jpg"), ImageFormat.Jpeg); } detectedImage.ImageUrl = Server.MapPath("./Images/Test.jpg"); detectedImage.DataBind();

Thursday, January 29, 2009

Import Sql Data To Excel

Here is the Procedure to load the sql data to excel with out writing lot of code

1)In Excel Click the Menu Data -> ImportExternalData -> NewDataBaseQuery

2)You will get the window Choose DataSource. Select New Datasource -> click OK

3)In Create New Data Source, give the name for the Datasource .Select the driver as SqlServer
in the driver type.Click connect

4)Sql Server Login window opens ,Specify the Server Name.Click options Select the Database by default it will assign Master Database .Click Ok

5)Now the datasource will be connected.Select the table name to import your data in to excel.Click OK

6)Query Wizard Opens to select columns

7)Click the option .In the Table Options window there is a option to list only the tables,views, systemTables.Choose as per ur need.In the Owner select dbo.which excludes system tables.Click Next.Click Next

8)In query wizard- finish select the option view data or edit query in Microsoft Finish.

9)To execute your procedure click on File-> Execute Sql -> select Procedure

10)To import the data click File -> cancel and return to Microsoft excel

Interface and abstract C#

Here is the situation of using abstract vs interface . you may get some basic idea of using interface and abstract

Consider about the Content Management system we generalize the content as

Interface Vs Abstract

Now Consider Content Contains behavior named publish . If the Publish contain some default behavior then the option would be abstract. If the publish is derived and make their own implementation, then no need to implement in base .In this situation the option would be Interface.

If I made content class as Interface then it is difficult to make changes in base class because if I add new method or property in content interface then I have to implement new method in every derive class. This can be overcome in abstract class by creating new method not an abstract type.

In terms of speed abstract is fast then interface because interface requires extra in-direction.

Dynamic GridView C#


Here is the code to create dynamic gridview with the styles applied

SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["Sql"].

SqlCommand com = new SqlCommand("GetArticles", con);
com.CommandType = CommandType.StoredProcedure;
SqlDataAdapter ada = new SqlDataAdapter(com);
DataSet ds = new DataSet();
for (int i = 0; i <>
if (ds.Tables[i].Rows.Count > 0)
GridView gvDynamicArticle = new GridView();
gvDynamicArticle.Width = Unit.Pixel(700);
gvDynamicArticle.BorderWidth = Unit.Pixel(0);
gvDynamicArticle.Caption = "
" + ds.Tables[i].Rows[0]["Category"].ToString() + " Articles

gvDynamicArticle.AutoGenerateColumns = false;
gvDynamicArticle.AlternatingRowStyle.BackColor = Color.Brown;
gvDynamicArticle.ShowFooter = true;
TemplateField tf = null;
tf = new TemplateField();
tf.HeaderTemplate = new DynamicGridViewTextTemplate("ArticleID", DataControlRowType.Header);
tf.ItemTemplate = new DynamicGridViewTextTemplate("ArticleID", DataControlRowType.DataRow);
tf.FooterTemplate = new DynamicGridViewTextTemplate(DataControlRowType.Footer, ds.Tables[i].Rows.Count);
tf = new TemplateField();
tf.HeaderTemplate = new DynamicGridViewTextTemplate("Title", DataControlRowType.Header);
tf.ItemTemplate = new DynamicGridViewTextTemplate("Title", DataControlRowType.DataRow);
tf = new TemplateField();
tf.HeaderTemplate = new DynamicGridViewTextTemplate("Description", DataControlRowType.Header);
tf.ItemTemplate = new DynamicGridViewTextTemplate("Description", DataControlRowType.DataRow);
tf = new TemplateField();
tf.HeaderTemplate = new DynamicGridViewURLTemplate("Title", "URL", DataControlRowType.Header);
tf.ItemTemplate = new DynamicGridViewURLTemplate("Title", "URL", DataControlRowType.DataRow);
tf = new TemplateField();
tf.HeaderTemplate = new DynamicGridViewTextTemplate("Author", DataControlRowType.Header);
tf.ItemTemplate = new DynamicGridViewTextTemplate("CreatedBy", DataControlRowType.DataRow);
gvDynamicArticle.DataSource = ds.Tables[i];


public class DynamicGridViewTextTemplate : ITemplate
string _ColName;
DataControlRowType _rowType;
int _Count;

public DynamicGridViewTextTemplate(string ColName, DataControlRowType RowType)
_ColName = ColName;
_rowType = RowType;
public DynamicGridViewTextTemplate(DataControlRowType RowType, int ArticleCount)
_rowType = RowType;
_Count = ArticleCount;
public void InstantiateIn(System.Web.UI.Control container)
switch (_rowType)
case DataControlRowType.Header:
Literal lc = new Literal();
lc.Text = "" + _ColName + "";
case DataControlRowType.DataRow:
Label lbl = new Label();
lbl.DataBinding += new EventHandler(this.lbl_DataBind);
case DataControlRowType.Footer:

Literal lc1 = new Literal();
lc1.Text = " ";
private void lbl_DataBind(Object sender, EventArgs e)
Label lbl = (Label)sender;
GridViewRow row = (GridViewRow)lbl.NamingContainer;
lbl.Text =DataBinder.Eval(row.DataItem, _ColName).ToString();

public class DynamicGridViewURLTemplate : ITemplate
string _ColNameText;
string _ColNameURL;
DataControlRowType _rowType;

public DynamicGridViewURLTemplate(string ColNameText, string ColNameURL, DataControlRowType RowType)
_ColNameText = ColNameText;
_rowType = RowType;
_ColNameURL = ColNameURL;
public void InstantiateIn(System.Web.UI.Control container)
switch (_rowType)
case DataControlRowType.Header:
Literal lc = new Literal();
lc.Text = "" + _ColNameURL + "";
case DataControlRowType.DataRow:
HyperLink hpl = new HyperLink();
hpl.Target = "_blank";
hpl.DataBinding += new EventHandler(this.hpl_DataBind);
private void hpl_DataBind(Object sender, EventArgs e)
HyperLink hpl = (HyperLink)sender;
GridViewRow row = (GridViewRow)hpl.NamingContainer;
hpl.NavigateUrl = DataBinder.Eval(row.DataItem, _ColNameURL).ToString();
hpl.Text = "
" + DataBinder.Eval(row.DataItem, _ColNameText).ToString() + "