S.Vinothkumar

Difference between DataGrid and GridView

2010-07-23T00:47:00.000-07:00

Hi All !

I am back !!!

Difference between DataGrid and GridView:
==========================================

In .Net 2.0, we are using GridView. Since DataGrid and GridView are same we have some extra facilities and features in GridView than DataGrid.

By using GridView we can render it on Mobile Devices also, but DataGrid only use for web pages. Another key difference between DataGrid and GridView controls lies in the adaptive user interface.

In DataGrid paging, sorting, inserting, updating and deleting are implementing by coding. But in GridView automatically generates those things without user writing the code.
Sorting: In DataGrid code requires handling the SortCommand event and rebind grid required. In case of GridView no additional code required.
Paging: In DataGrid requires code to handle the PageIndexChanged event and rebind grid required. In case of GridView no additional code required. It also supports customized appearance.
Data binding: Like GridView DataGrid cannot bind with new datasource control in ASP.NET 2.0.
Updating data: DataGrid requires extensive code to update operation on data. GridView requires little code. Code like exceptions handling for database part.
Events: GridView supports events fired before and after database updates. In DataGrid fewer events supported as compared to GridView.

In DataGrid no image template column, whereas GridView have image template column
The GridView control is the successor to the DataGrid control. Like the DataGrid control, the GridView control was designed to display data in an HTML table. When bound to a data source, the DataGrid and GridView controls each display a row from a DataSource as a row in an output table.

Both the DataGrid and GridView controls are derived from the WebControl class. Although it has a similar object model to that of the DataGrid control, the GridView control also has a number of new features and advantages over the DataGrid control, which include:

Richer design-time capabilities.

Improved data source binding capabilities.

Automatic handling of sorting, paging, updates, and deletes.

Additional column types and design-time column operations.

A Customized pager user interface (UI) with the PagerTemplate property.

Differences between the GridView control and the DataGrid control include:

Different custom-paging support.

Different event models.

...S.VinothkumaR.

How to clear temporary internet foder by using C# in winforms?

2009-09-03T03:40:00.000-07:00

Here is the sample code for clearing temporary internet foder by using C# in winforms.

private void btnClear_Click(object sender, EventArgs e)
{
ClearAll(new DirectoryInfo(Environment.GetFolderPath(Environment.SpecialFolder.InternetCache)));
MessageBox.Show("Your temporary files has been cleaned.! ");
}

public void ClearAll(DirectoryInfo dirInfo)
{
foreach (FileInfo fileInfo in dirInfo.GetFiles())
{
try
{
fileInfo.Delete();
}
catch { }
}
foreach (DirectoryInfo subDirectory in dirInfo.GetDirectories())
{
ClearAll(subDirectory);
}
}

...S.VinotkumaR.

How to insert bulk values in to a table by using C#?

2009-08-19T03:16:00.000-07:00

The below method is used to bulk insert in to a table by using c# from a datatable.

using System.Data;
using System.Data.SqlClient;

public int BulkInsert(DataTable dt, string TableName, string ConnectionString)
{
int returnValue = -1;
SqlConnection oConn = new SqlConnection(ConnectionString);
oConn.Open();
SqlDataAdapter da = new SqlDataAdapter("SELECT * FROM " + TableName,oConn);
da.SelectCommand.Connection = oConn;
DataSet ds = new DataSet();
SqlCommandBuilder oCmd = new SqlCommandBuilder(da);
try
{
da.Fill(ds);
returnValue = da.Update(dt);
}
catch (Exception ex)
{
throw ex;
}
finally
{
oConn.Close();
oCmd.Dispose();
}
return returnValue;
}

...S.VinothkumaR.

Copy All Directories with Files using C#

2009-08-19T03:03:00.000-07:00

Here is the sample code for copying a directory with sub directories and all the files using C#.

public static void CopyAllDirectories(DirectoryInfo source, DirectoryInfo target)
{
if (Directory.Exists(target.FullName) == false)
{
Directory.CreateDirectory(target.FullName);
}

foreach (FileInfo fileInfo in source.GetFiles())
{ fileInfo.CopyTo(Path.Combine(target.ToString(),fileInfo.Name), true);
}
foreach (DirectoryInfo sourceSubDir in source.GetDirectories())
{
DirectoryInfo targetSubDir =
target.CreateSubdirectory(sourceSubDir.Name);
CopyAllDirectories (sourceSubDir, targetSubDir);
}
}

...S.VinothkumaR.

Scrollbar in down side of textbox.

2009-08-03T06:05:00.000-07:00

Scrollbar in down side of textbox.

Hi all, I have come to give a very simple solution for the below question. The question is

How to set scrollbar in end of the text in textbox when dynamically updating the text value?

Actually I have been developing a big application. On that application I needed to update the status of every action in my application. For the purpose of updating the status, I have used the textbox to show the status with multiline and vertical scrollbar properties. But I could see the vertical bar not going down when updating the status as shown in the below figure which is marked in red.

After googling few minutes I found we have some properties and methods in textboxes of visual studio are SelectionStart and ScrollToCaret method.

By using the above property and method I have found the solution for my question. See the below figure...

Code Snippet:

private void btnUpdate_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(txtStatus.Text))
txtStatus.Text = txtStatus.Text + Environment.NewLine;
txtStatus.Text = txtStatus.Text + "Status Updated...";

txtStatus.SelectionStart = txtStatus.Text.Length;
txtStatus.ScrollToCaret();
txtStatus.Refresh();
}

...S.VinothkumaR.

Barcode Generation using C#

2009-07-29T23:42:00.000-07:00

In this article, I am trying to give you a sample code for generating barcode image by using C#.

We can see in market for all products they are using barcode only. So the barcode is common one. When we try to programming with old language for barcode is very difficult. We needed to go third party component. But in .Net framework it is very easy to generate barcode image.

Barcode font

There is lot of free barcode fonts available in internet. We can search and download it for generating the barcode image. Here is the font which is I am using “Barcodefont.ttf”. We need to download this font and install in your fonts folder which is located in control panel.

For generating barcode image, we need to add the namespaces “System.Drawing, System.Drawing.Imaging” and the file management namespaces.

Sample Code

using System.Drawing.Text;
using System.Drawing;
using System.IO;
using System.Drawing.Imaging;

public string dirPath = "";

dirPath = Environment.CurrentDirectory;

private void GenerateBarCode()
{
try
{
string path = dirPath + "\\" + DateTime.Now.ToFileTimeUtc().ToString() + ".jpg";
PrivateFontCollection fontCollection = new PrivateFontCollection();
fontCollection.AddFontFile(dirPath + "\\BarcodeFont.ttf");
FontFamily fontFamily = new FontFamily("barcode font", fontCollection);
Font font = new Font(fontFamily, 40);

Bitmap bmp = new Bitmap(pbBarcodeImage.Width, pbBarcodeImage.Height);
Graphics graphics = Graphics.FromImage(bmp);
graphics.Clear(Color.White);
SizeF sizeF = graphics.MeasureString(txtEnter.Text.Trim(), font);
Brush brush = new SolidBrush(Color.Black);
graphics.DrawString(txtEnter.Text.Trim(), font, brush, 10, 10);
bmp.Save(path, ImageFormat.Jpeg);
bmp.Dispose();
pbBarcodeImage.Image = new Bitmap(path);
}
catch
{ }
}

Hence we are generating the barcode by using the above code.

...S.VinothkumaR.

Inserting Bulk Data in SQL Server from Text file

2009-07-01T03:07:00.000-07:00

There is a simple query to do this bulk insert in to sql server from a text file. The thing is that we have to keep a fully formatted text file with appropriate data’s which are to be inserted.

Here, we have a table to be inserted is,

The query for creating table,

CREATE TABLE Employee
(
FName varchar (100) NOT NULL,
LName varchar (100) NOT NULL,
Email varchar (100) NOT NULL
)

Then we have a text file with the bulk data’s like as follows,

vinoth,kumar,itvinoth83@gmail.com
emp1FName,emp1LName,emp1@company.com
emp2FName,emp2LName,emp2@company.com
emp3FName,emp3LName,emp3@company.com
emp4FName,emp4LName,emp4@company.com
emp5FName,emp5LName,emp5@company.com
emp6FName,emp6LName,emp6@company.com
emp7FName,emp7LName,emp7@company.com
emp8FName,emp8LName,emp8@company.com
emp9FName,emp9LName,emp9@company.com
emp10FName,emp10LName,emp10@company.com
emp11FName,emp11LName,emp11@company.com
emp12FName,emp12LName,emp12@company.com

Now the query for inserting bulk data is,

BULK INSERT Employee FROM 'c:\bulktext.txt' WITH (FIELDTERMINATOR = ',')

Now you can see the data's inserted in table by the select query as follows,

select * from Employee

The following image is being explained the above matters.

...S.VinothkumaR.

Multiple Colored texts in RichTextBox using C#

2009-06-27T00:26:00.000-07:00

This article is created for making multiple colored texts in a textbox. By using the SelectionText property in richtextbox we have created a sample application for multiple colored texts in Microsoft’s richtextbox control. Let us see how to make it in below code.

Font font = new Font("Tahoma", 8, FontStyle.Regular);
richTextBox1.SelectionFont = font;
richTextBox1.SelectionColor = Color.Red;
richTextBox1.SelectedText = Environment.NewLine + textBox1.Text;

By using the above code, we can make a multiple colored texts in our richtextbox. This is basically used for doing some chat application. We will have to show the other end of person’s text in different color in chat application. So that we can use this method. And we can create a simple method and calling in every time of showing the text in richtextbox with the parameters of like “textbox1.text, color,..etc”.

For more visit my article in codeproject here with more explanation.

...S.VinothkumaR.

How to sum previous rows value SqlServer?

2009-06-19T22:39:00.000-07:00

I needed to write a query for sum the values with the previous row value in current row of a column. So that I have written a single query after a long googled. Here I am trying to give you what I have done.

I have a table with three fields Id, Name and Mark. I have values of all fields like as follows.

Id Name Mark
--- ----- -----
1 aaaa 10
2 bbbb 20
3 cccc 30

Now I wants to get the results set of that table like as

Id Name Mark
--- ----- -----
1 aaaa 10
2 bbbb 30
3 cccc 60

So I need a single select query to do this performance. For that I have written a query using cross join.

Code Snippets for Table and Query

CREATE TABLE [dbo].[Marks]( [Id] [bigint] NOT NULL, [Name] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [Mark] [bigint] NOT NULL ) ON [PRIMARY]

select * from Marks

select a.Id, a.Name, sum(b.Mark) as Mark
from Marks a cross join Marks b
where b.Id <= a.Id group by a.Id, a.Name

Hence we have done the fetching the result set for sum of the previous rows in sql server.

For more ...

visit here

...S.VinothkumaR.

Multiple rows in a single row with separator in SqlServer

2009-06-16T03:53:00.000-07:00

Here is a simple way to make a single row value from multiple rows with a separator in SqlServer.

I have a table like the following…

Table Name: People

select * from people

Now I need the ‘Name’ column values where matching the value of ‘aaaa’ in to a single row. For this I have tried to make a query.

Just use the following query to get the solution.

declare @res varchar(1000)
select @res = coalesce(@res + ',', '') +Name
from people
WHERE Name = 'aaaa'

select @res

See the result…

...S.VinothkumaR.

Simple recursive function for string folding in C#

2009-06-11T05:29:00.001-07:00

Here is the sample function of string folding in c#. I just tried bind the body content of a mail in to a label box. For that I need to folding the string content. I have created a method to do this string folding as follows,

if (lblBody.Text.Length > 150)
{
lblBody.Text = lblbodystring(lblBody.Text,150);
}

//Simple recursive function for string folding.
private string lblbodystring(string bodyString, int Length)
{
string retVal = "";
if (bodyString.Length > Length)
{
retVal = bodyString.Substring(0, Length);
retVal = retVal + Environment.NewLine;
retVal = retVal + lblbodystring(bodyString.Substring(Length));
}
else
{
retVal = retVal + Environment.NewLine;
retVal = retVal + bodyString;
}
return retVal;
}

The thing is that we can use textbox with multiline attribute for this kind of process :). But I have used in label. So...

...S.VinothkumaR.

Query for importing data’s from XL to SqlServer DB

2009-06-11T04:25:00.000-07:00

Here is a simple query for importing data's from Microsoft Excel sheet to Sql Server database.

Just copy the following code and run in your sql server query window. Before that make XL sheet with the appropriate fields and values and place it in c drive or wherever you wants.

INSERT INTO [dbo].[TableName] ([FieldName1] ,[FieldName2] ,[FieldName3] ,[FieldName4] FROM OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0', 'Data Source=C:\db.xls;Extended Properties=Excel 8.0')...[SheetName$]

that's it...

...S.VinothkumaR.

Silverlight - Introduction

2009-06-11T03:46:00.000-07:00

Microsoft Silverlight is a programmable web browser plug-in that enables features such as animation, vector graphics and audio-video playback that characterizes rich Internet applications.

Silverlight provides a retained mode graphics system similar to Windows Presentation Foundation, and integrates multimedia, graphics, animations and interactivity into a single runtime environment. In Silverlight applications, user interfaces are declared in XAML and programmed using a subset of the .NET Framework. XAML can be used for marking up the vector graphics and animations. Textual content created with Silverlight is searchable and indexable by search engines as it is not compiled, but represented as text (XAML).

Releases

1. Silverlight 1.0
2. Silverlight 2
3. Silverlight 3

Tools for Silverlight application

To developing Silverlight application, Microsoft has been released some set of tools. They are,

• Visual Studio 2008 with Service Pack 1
• Silverlight 2 Beta 2 SDK
• Expression Blend 2 July 2008 Preview

All of us known about Visual Studio. Expression Blend is Microsoft's user interface design tool for creating graphical interfaces for web and desktop applications. Blend is writing using the .NET Framework 3.0 and Windows Presentation Foundation (WPF). Microsoft Expression Blend does the same of Adobe Photoshop to edit your images as well as add effects to existing images.

How to create Silverlight applications?

There is a question in our mind raising that “How to create Silverlight applications?” Here is the answer for your question,

1. Use Visual Studio 2008 SP1 to create a new Silverlight project based on the Silverlight 2 Beta 2 Template. Visual Studio will do the necessary steps to add a single HTML page or a single website to host your Silverlight application. This is because Silverlight is a plug-in that renders in the browser.

2. Add your necessary XAML files needed for the user interface. This is similar to the forms that you would add to a Windows Form application.

3. Edit the XAML page using Expression Blend 2 July 2008 preview. Note that Because each page in Silverlight 2 Beta 2 is treated as a user control, only Expression Blend 2 July 2008 preview will be capable of opening these particular XAML files. Any older version of Expression Blend will throw an error message saying that it is unable to open that file type.

4. Switch to Visual Studio 2008 SP1 to write code behind files for the controls and pages that you created in Step 2.

5. Build and compile the application.

6. Host the same in IIS or any web server of your choice. For this demonstration, you will rely on Windows Vista for development and IIS for hosting the application.

...S.VinothkumaR.

Simple Collapse Panel - Windows application in C#

2009-06-11T03:35:00.000-07:00

Hi all, There is no option to collapsing functionality in panel control.

I have created a panel control with up/down arrow images. We can collapse this control by clicking those arrows. There are some property values allowing us the interval of collapsing time. The ScrollInterval value is used to set the interval time for collapsing animation. And the HeaderHeight property value is set to be the height of header part in this control. I just used some calculation to set the height value for this control in a certain loop. This much of calculation makes some animation to collapsing the control.

You can see the magic of this control by downloading the demo project which is available to download here.

The simple calculation of control’s height is possible to collapse the control. Just see the following code,

if (this.Height > this.lblTop.Height)
{
while (this.Height > this.lblTop.Height)
{
Application.DoEvents();
this.Height -= ScrollIntervalValue;
}
this.lblTop.ImageIndex = 1;
this.Height = this.lblTop.Height;
}
else if (this.Height == this.lblTop.Height)
{
int x = this.FixedHeight;
while (this.Height <= (x))
{
Application.DoEvents();
this.Height += ScrollIntervalValue;
}
this.lblTop.ImageIndex = 0;
this.Height = x;
}

Just refer the control in your application, and add the control in your form. Then set the property values of this control ScrollInterval and HeaderHeight as you want. If you don’t set those property values it might be taken by default values. Now build your project and run. By clicking the arrow images in collapse panel, you can see the magic.

For More…see my article in code project.

http://www.codeproject.com/KB/cs/CollapsePanel.aspx

...S.VinothkumaR.

How do we change the header BackColor and selected color in ListView using c#?

2009-06-03T00:41:00.000-07:00

How do we change the header BackColor and selected color in ListView using c#?

Yes, we can make it possible to change the header backcolor and style for ListView control. And also we can change the some styles in ListView control in the code behind. Here is the way to explain how it is possible.

There is property named “OwnerDraw” is used to do the style changing process by our code behind. Just we need to set that property as “true”.

I have a ListView control with the name of “lstView” in my sample form, and the code has been written as follows,

this.lstView.BackColor = System.Drawing.SystemColors.ControlText;
this.lstView.BorderStyle = System.Windows.Forms.BorderStyle.None;
this.lstView.Columns.AddRange(new System.Windows.Forms.ColumnHeader[] {
this.columnHeader1,
this.columnHeader2,
this.columnHeader3});
this.lstView.ForeColor = System.Drawing.SystemColors.ControlLightLight;
this.lstView.FullRowSelect = true;
this.lstView.HeaderStyle = System.Windows.Forms.ColumnHeaderStyle.Nonclickable;
this.lstView.Location = new System.Drawing.Point(2, 1);
this.lstView.MultiSelect = false;
this.lstView.Name = "lstView";
this.lstView.OwnerDraw = true;
this.lstView.View = System.Windows.Forms.View.Details;

private void lstView_DrawColumnHeader(object sender, DrawListViewColumnHeaderEventArgs e)
{
System.Drawing.Drawing2D.LinearGradientBrush GradientBrush = new System.Drawing.Drawing2D.LinearGradientBrush(e.Bounds, Color.Blue, Color.LightBlue, 270);

e.Graphics.FillRectangle(GradientBrush, e.Bounds);

e.Graphics.DrawRectangle(new Pen(new SolidBrush(Color.White), 2), e.Bounds.X + 1, e.Bounds.Y + 1, e.Bounds.Width - 2, e.Bounds.Height - 2);

e.Graphics.DrawString(e.Header.Text, new Font("Arial", 12), new SolidBrush(Color.Yellow), e.Bounds);
}

private void lstView_DrawItem(object sender, DrawListViewItemEventArgs e)
{
if (e.Item.Selected)
{
e.Graphics.FillRectangle(new SolidBrush(Color.DarkBlue), e.Bounds);
}
e.Graphics.DrawString(e.Item.Text, new Font("Arial", 10), new SolidBrush(Color.White), e.Bounds);
}

private void lstView_DrawSubItem(object sender, DrawListViewSubItemEventArgs e)
{
e.Graphics.DrawString(e.Item.Text, new Font("Arial", 10), new SolidBrush(Color.White), e.Bounds);
}

That's it...

...S.VinothkumaR.

How to change the header backcolor in datagridview C#

2009-06-01T23:49:00.001-07:00

Here I am trying to get the new design for my DataGridView header back color. So that, I have been tried a lot in Google and got the solution which is explained below.

Set the following properties for your DataGridView control by using the properties window.

EnableHeadersVisualStyles = False

RowHeadersBorderStyle = Raised

Then copy the following code in your Form_Load event.

DataGridViewCellStyle style = this.dataGridView1.ColumnHeadersDefaultCellStyle;
style.BackColor = Color.WhiteSmoke;
style.ForeColor = Color.Gray;
style.Font = new System.Drawing.Font("Arial", 10F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));

Now run your application, the header style would be changed and showing a new style that we wants.

...S.VinothkumaR.

What is OfType operator in LINQ?

2009-05-06T03:46:00.000-07:00

OfType operator in LINQ

OfType operator is used to return objects of a certain type. For example if we have an array of objects which contains strings, decimal, float and numbers or any other. We can use OfType operator to extract only strings or any particular type of values.

Here is an example to fetch the string values from an array of objects. See below,

private void Form1_Load(object sender, EventArgs e)
{
object[] values = {"test1",45,'c',"test2",34.67,12/12/2009,"test3",4.0,4.4f};
var strings = values.OfType();
int top = 10;
foreach (var s in strings)
{
Label lbl = new Label();
lbl.Top = top;
top = top + 30;
lbl.Text = s;
this.Controls.Add(lbl);
}
}

You just copy the above code in to Form_Load and run the solution. There will be shown the string values.

...S.VinothkumaR.

How to disable the Win Form’s Close Button ?

2009-05-06T02:10:00.000-07:00

Disable the Win Form’s Close Button using C#

Here is the simple way to disable the Form’s close button. Just copy the following code in your code behind. Then run the form, surely the close button would be disabled.

private const int CP_NOCLOSE_BUTTON = 0x200;
protected override CreateParams CreateParams
{
get
{
CreateParams myCp = base.CreateParams;
myCp.ClassStyle = myCp.ClassStyle | CP_NOCLOSE_BUTTON;
return myCp;
}
}

That's it...

S.VinothkumaR.

Differences between XBAP, WPF Standalone and Silverlight

2009-05-02T03:52:00.000-07:00

Differences between XBAP, WPF Standalone and Silverlight

WPF applications are divided into two categories.

• Standalone WPF Application
• XAML browser applications (XBAPs)

There is always a confusion between WPF, XBAP and Silverlight. Developers get confused which one to go for while designing a project. Here I will explain all the 3 technologies with the differences

Standalone WPF Application

- WPF applications are installed on end user's machine.

- Appear in Start Menu and Add/Remove Programs.

- Applications can be installed via MSI or ClickOnce.

- User can be offline and use the application. There is no need for Internet connection.

- Newer versions of the application may not be automatically installed in user's machine.

- WPF standalone applications can use WCF for communication.

- Applications run in its own window as other windows applications.

XAML Browser Application(XBAP)

- These type of applications are not installed in user's machine.

- They do not appear in the in Start Menu or Add/Remove Programs.

- Applications can be automatically deployed via ClickOnce.

- Applications are hosted in the browser process.

- Can be run only in IE and Firefox.

- Newer versions are always installed automatically into the user's machine.

- User must be online to use the application.

- XBAP is Windows only. We can run the application in Windows operating system only.

- XBAPs cannot use WCF.

- The user machine should have .NET framework 3.0 components.

Silverlight

- XBAP is IE and Firefox only. But Silverlight can run in any browser and platform.

- Silverlight is used for creating rich UI web application.

- User's machine don't need .NET framework.

- Can be embedded in HTML markup and rendered in any browser using the silverlight plug in.

- XABP has 99% features of WPF. But Silverlight is just a subset of WPF.

...S.VinothkumaR.

XBAP - Windows Presentation Foundation XAML Browser Applications

2009-05-02T03:45:00.000-07:00

XBAP - Windows Presentation Foundation XAML Browser Applications

XBAP – XAML Browser Application is a new windows technology used for creating Rich Internet Applications. It is used for creating heavyweight .Net applications.

XAML Browser Applications combines features of both Web applications and rich-client applications. While windows applications are normally compiled to an .exe file, browser applications are compiled to an extension .xbap and can be run inside Internet Explorer.

Like Web applications, XBAPs can be published to a Web server and launched from Internet Explorer. Like rich-client applications, XBAPs can take advantage of the capabilities of WPF. Developing XBAPs is also similar to rich-client development.

Implementing a XAML Browser Application (XBAP)

The simplest way to create a new XBAP project is with Microsoft Visual Studio:

1. On the File menu, point to New, and then click Project.
2. In the New Project dialog box, in the Project types pane, choose either Visual Basic or Visual
C#. In the Templates pane, click WPF Browser Application.
3. Assign a project name and click OK to create the new project.

The WPF Browser Application project template creates an XBAP application project that includes the following:

• An application definition, Application.xaml.
• A page, Page1.xaml.

You can add to those as required.

If you prefer developing with tools that require command-line compilation.

When you run an XBAP, it is launched in a browser window instead of a standalone window. When you debug an XBAP from Visual Studio, the application runs with Internet zone permission and will consequently throw security exceptions if those permissions are exceeded.

Deploying a XAML Browser Application

When you build a XBAP, the Microsoft build engine (MSBuild) produces the following three files as a minimum:

• An executable file. This contains the compiled code and has an .exe extension.
• An application manifest. This contains metadata associated with the application and has a
.manifest extension.
• A deployment manifest. This file contains the information that ClickOnce uses to deploy the
application and has an .xbap extension.

You publish XBAPs to a Web server (Microsoft Internet Information Services (IIS) or later). You do not need to install .NET Framework on the Web server, but you do need to register the WPF Multipurpose Internet Mail Extensions (MIME) types and file extensions.

To prepare your XBAP for deployment, copy the .exe and the associated manifests to your Web server. Create a hyperlink on a Web page to navigate to the deployment manifest. When the user clicks the link and navigates to the .xbap file, ClickOnce automatically handles the mechanics of downloading and launching the application.

Reference:

1. http://msdn.microsoft.com/en-us/library/aa970060.aspx
2. http://aspalliance.com/1824_Introduction_to_XAML_Browser_Applications_XBAP.1

...S.VinothkumaR.

How to create Vista Gadget

2009-04-28T22:33:00.000-07:00

We can create a Vista Sidebar Gadget by easily. Just follow the below steps then you are the owner of a sidebar gadget.

Step 1:

Create the following html file with the name of “HelloWorld.html”.

Step 2:

Create the following xml file with the name of “Gadget.xml”.

Step 3:

Create a folder called Helloworld.Gadget

Step 4:

1.Simply copy”%userprofile%\AppData\Local\Microsoft\Windows Sidebar\Gadgets” and paste in Windows explorer address bar.
2. When you get to that folder Copy and Paste the “HelloWorld.Gadget” folder there.

Step 5:

Add the gadget to your Sidebar and your done !

For more visit here …

...S.VinothkumaR.

How to get duration of an audio file in c# ?

2009-04-26T23:19:00.000-07:00

We can get the duration of an audio or video file by using the “Shell32” namespace in Visual Studio Dot Net. For that we need to add the reference of “Interop.Shell32.dll” in to our project. And follow the given method in below. By calling the following method with the parameter of full path of file name which might be an audio file or video file we can get the duration of that file.

private string GetDuration(string FileFullPath)
{
string duration = "";
string fName = FileFullPath.Substring(FileFullPath.LastIndexOf("\\") + 1);
string filePath = FileFullPath.Substring(0, FileFullPath.LastIndexOf("\\"));
Shell32.Shell shell = new Shell32.ShellClass();
Shell32.Folder folder = shell.NameSpace(filePath);
Shell32.FolderItem folderItem = folder.ParseName(fName);
if (folderItem != null)
{
duration = folder.GetDetailsOf(folderItem, 21);
}
folderItem = null;
folder = null;
shell = null;
return duration;
}

Hence we can get the duration of given file.

…S.VinothkumaR.

Find Age from given DateOfBirth using C#

2009-04-20T22:20:00.000-07:00

Hi all,

Just copy the following method in your class and call it with the parameters of date of birth and current date in DateTime format.

public string FindAge(DateTime dob, DateTime currentDate)
{
int years = currentDate.Year - dob.Year;
int months = 0;
int days = 0;
if(currentDate < dob.AddYears(Years) && Years != 0)
{
--years;
}
dob = dob.AddYears(years);
if (dob.Year == currentDate.Year)
{
months = currentDate.Month - dob.Month;
}
else
{
months = (12 - dob.Month) + currentDate.Month;
}
if(currentDate < dob.AddMonths(months) && months != 0)
{
--months;
}
dob = dob.AddMonths(months);
days = (currentDate - dob).Days;
return years + " years " + months + " months " + days + " days";
}

Copy the above code in your class...and call the method..enjoy... ;)

...S.VinothkumaR.

Code for moving the form by mouse clicking.

2009-04-16T06:08:00.000-07:00

Hi Viewers,

Here by I am trying to give you a sample code for moving the win form by clicking the mouse.

Just use the following code and test it.

using System.Runtime.InteropServices;

public const int WM_NCLBUTTONDOWN = 0xA1;

public const int HT_CAPTION = 0x2;

[DllImportAttribute("user32.dll")]
public static extern int SendMessage(IntPtr hWnd,int Msg, int wParam, int lParam);

[DllImportAttribute("user32.dll")]
public static extern bool ReleaseCapture();

private void Form1_MouseDown(object sender, MouseEventArgs e)
{
if (e.Button == MouseButtons.Left)
{
ReleaseCapture();
SendMessage(Handle, WM_NCLBUTTONDOWN, HT_CAPTION, 0);
}
}

Now you can implement the above code in your application and test it. Working fine for me

...S.VinothkumaR.

Add prerequisites of dotnet framework in visual studio setup project

2009-04-16T05:57:00.001-07:00

When we developing an application using any platform we should prepare our application to be deployed properly. Specially for dotnet, the prerequisites of dotnet framework is must. So here by I am explaining how to add framework to be installed before our application installation process.

After developing our .Net application we need to create a setup project. Just follow the steps mentioned in below.

- Go to File menu, select Add New Project and then select Setup And Deployment in under “Other Project Types”.

- Give a name to your project as your wish.

- Then select your setup project solution and add Primary output of your developed project. You just need to right click your setup project in solution explorer, click add --> Project Output --> select your project.

- Then add custom action by right clicking setup project --> view --> Custom Actions --> right click Custom Actions --> Add Custom Actions.

- Now we are going to add the prerequisites for your setup project.

- Select your setup project right click and go to properties then click the Prerequisites button.

- Now select .Net Framework 2.0 tick box after selecting the “Create setup program to install prerequisite components”.

- Then specify the install location for prerequisites by selecting the option box.

- Here I am selecting the second one “Download prerequisites from the same location as my application”.

- Click ok and apply then ok.

- Now build your setup project, the dotnet framework will be added in your debug folder.

That's it...

...S.VinothkumaR.

FileSystemWatcher in C#

2009-03-31T05:58:00.000-07:00

Hi all,

Here is the simple description to use FileSystemWatcher in your desktop application by using C#.

Just drag the FileSystemWatcher control in your form from under the Components tab in the toolbox.

And copy the following code in to load event,

private void Form1_Load(object sender, EventArgs e)
{
fileSystemWatcher.Path = flvPath;
fileSystemWatcher.Filter = "*.flv";
fileSystemWatcher.NotifyFilter = NotifyFilters.FileName | NotifyFilters.CreationTime | NotifyFilters.LastWrite;
fileSystemWatcher.EnableRaisingEvents = true;
}

If the file watcher found any newly created file, the following event will rise.

private void fileSystemWatcher_Created(object sender, FileSystemEventArgs e)
{
MessageBox.Show(e.Name + " created in " + e.FullPath);
}

An event is rising when a file deleted.

private void fileSystemWatcher_Deleted(object sender, FileSystemEventArgs e)
{
MessageBox.Show(e.Name + " changed in " + e.FullPath);
}

An event is rising when a file renamed.

private void fileSystemWatcher_Renamed(object sender, RenamedEventArgs e)
{
MessageBox.Show(e.Name + " renamed in " + e.FullPath);
}

That’s it…

...S.VinothkumaR.

How to generate an xml from TreeView using C#?

2009-03-31T05:07:00.000-07:00

Hi guys,

Here is the sample code for generating xml file from TreeView. I needed this for one of my project. I just referred lot of sites and finally came to conclusion with the following code. Just copy and paste this code and use it for yours.

using System.IO;

private static StreamWriter sr;

private void btnExportXML_Click(object sender, EventArgs e)
{
if (tvXML.Nodes.Count > 0) // Here tvXML is TreeView control
{
sr = new StreamWriter(path); // Here path is xml path
sr.Write("<" + tvXML.Nodes[0].Text + ">");
parseNode(tvXML.Nodes[0]);
sr.Close();
}
}

//Use the following method for getting value of each and every node

private static void parseNode(TreeNode tn)
{
IEnumerator ie = tn.Nodes.GetEnumerator();
string parentnode = "";
parentnode = tn.Text;
while (ie.MoveNext())
{
TreeNode ctn = (TreeNode)ie.Current;
if (ctn.GetNodeCount(true) == 0)
{
if (ctn.Tag != null)
{
sr.Write("<" + ctn.Text + ">");
sr.Write(ctn.Tag);
sr.Write("");
}
else
{
sr.Write("<" + ctn.Text + "/>");
}
}
else
{
sr.Write("<" + ctn.Text + ">");
}
if (ctn.GetNodeCount(true) > 0)
{
parseNode(ctn);
}
}
sr.Write("");
sr.WriteLine("");
}

...S.VinothkumaR.

How to bind Countries in a combobox using c#?

2009-03-11T09:44:00.000-07:00

Find the code below to bind countries in a combo box using C#.

public void BindCountries()
{
foreach (CultureInfo ci in CultureInfo.GetCultures(CultureTypes.AllCultures & ~CultureTypes.NeutralCultures))
{
RegionInfo ri = new RegionInfo(ci.LCID);
comboBox1.Items.Add(ri.EnglishName);
}
comboBox1.Sorted = true;
comboBox1.SelectedIndex = 0;
}

...S.VinothkumaR.

Using ClientScriptManager in C#

2009-02-11T04:04:00.000-08:00

We know that we all are using the script tag for JavaScript function in our web page. In the case of some situations we need to add the scripts in code behind by dynamically. So .Net Framework 2.0 introduced a class namely “ClientScriptManager” that is used to manage script in code behind.

Now we are going to about the ClientScriptManager class and its usage with some sample codes.

ClientScriptManager:

This class is used to manage client scripts in .Net. We can get the object of this class from Page.ClientScript. We need to register the client script by using the method of RegisterClientScriptBlock () which is from that object of ClientScriptManager.

The ClientScriptManager class uniquely identifies scripts by a key String and a Type. Scripts with the same key and type are considered duplicates. Using the script type helps to avoid confusing similar scripts from different user controls that might be in use on the page.

The ClientScriptManager class can be used to invoke client callbacks in situations when it is desirable to run server code from the client without performing a postback. This is referred to as performing an out-of-band callback to the server. In a client callback, a client script function sends an asynchronous request to an ASP.NET Web page. The Web page runs a modified version of its normal life cycle to process the callback. Use the GetCallbackEventReference method to obtain a reference to a client function that, when invoked, initiates a client callback to a server event.

(This is from MSDN)

Let we watch this in Code behind. Just use the following code in page load and run it.

1. RegisterClientScriptBlock()

In Page_Load,

protected void Page_Load(object sender, EventArgs e)
{
//Get the ClientScript property as an object of ClientScriptManager from Page object.
ClientScriptManager client = this.Page.ClientScript;
//Check the script block is not already registered
if (!client.IsClientScriptBlockRegistered(this.GetType(), "Alert"))
{
client.RegisterClientScriptBlock(this.GetType(), "Alert", "alert('Welcome !')", true);

2. RegisterStartupScript()

RegisterClientScriptBlock and RegisterStartupScript both the methods are using to fire during the startup of page. But the difference is that the RegisterClientScriptBlock method will fire the script “after the form open tag but before the page controls”. And the RegisterStartupScript method will fire the script “after page controls but before the form close tag”. So the first method won’t get the controls value in run time.

For example, we are having a label box with the text “Vinoth” in a form, and then call the script as follows,

ClientScriptManager client = this.Page.ClientScript;
if (!client.IsStartupScriptRegistered(this.GetType(), "Alert"))
{
client.RegisterStartupScript(this.GetType(), "Alert", "alert(document.getElementById('lblName.Text'))", true);
}

...S.VinothkumaR.

How do I change the color of the title bar in a Win Forms .Net app using c#?

2009-02-02T04:24:00.000-08:00

We can use the WM_NCPAINT Message to do that. We must have to code for override the WndProc method to change the color of title bar in a Win Forms. Here I have done that with the following code. You can do that by using the code below.

using System.Runtime.InteropServices;

[DllImport("user32.dll")]
static extern int ReleaseDC(IntPtr hWnd, IntPtr hDc);

[DllImport("User32.dll")]
private static extern IntPtr GetWindowDC(IntPtr hWnd);

protected override void WndProc(ref Message m)
{
base.WndProc(ref m);
const int WM_NCPAINT = 0x85;
if (m.Msg == WM_NCPAINT)
{
IntPtr hdc = GetWindowDC(m.HWnd);
if ((int)hdc != 0)
{
Graphics g = Graphics.FromHdc(hdc);
g.FillRectangle(Brushes.Green,new Rectangle(0,0,300,22));
g.Flush();
ReleaseDC(m.HWnd, hdc);
}
}
}

That’s it…

…S.VinothkumaR.

Creating a database with filestream using (C#) SMO in DotNet 3.5.

2009-01-30T04:39:00.000-08:00

The following code will help you to do the creating database with filestream.

Here am using the SMO from Visual Studio Dot Net 3.5. Smo object is very useful to do the sqlserver manipulations from code end. However we could create a db with filestream. Just go thru the following code and use it.

using Microsoft.SqlServer.Management.Smo;

string dbName = "DBName";
string dbServerMachineName = "MachineName";

string mdfFile = mdfDirectory+@"\" + dbName + ".mdf";
string ldfFile = ldfDirectory + @"\" + dbName + "_log.ldf";
string FilesDir = FilesDirectory +@"\" + dbName;

Microsoft.SqlServer.Management.Smo.Server server = new Microsoft.SqlServer.Management.Smo.Server(dbServerMachineName);

Database database = new Database(server, dbName);
//Adding Primary FileGroup
database.FileGroups.Add(new FileGroup(database, "PRIMARY"));
//Adding FileStream FileGroup
database.FileGroups.Add(new FileGroup(database, "FileStreamTest", true));
//Adding Files for Primary FileGroup
DataFile dtPrimary = new DataFile(database.FileGroups["PRIMARY"], "PriValue", mdfFile);
dtPrimary.Size = 77.0 * 1024.0;
dtPrimary.GrowthType = FileGrowthType.KB;
dtPrimary.Growth = 1.0 * 1024.0;
database.FileGroups["PRIMARY"].Files.Add(dtPrimary);
//Adding Files for FileStream FileGroup
database.FileGroups["FileStreamTest "].Files.Add(new DataFile(database.FileGroups["FileStreamTest "], " FileStreamTest Values", FilesDir));
//Adding LogFile
LogFile logFile = new LogFile(database, "PriValue_log", ldfFile);
logFile.Size = 7.0 * 1024.0;
logFile.GrowthType = FileGrowthType.Percent;
logFile.Growth = 10.0;
database.LogFiles.Add(logFile);
//Create database.
database.Create();
database.Refresh();

...S.VinothkumaR.

How to restore a DataBase from .bak file using (C#) SMO in DotNet 3.5?

2009-01-27T05:07:00.000-08:00

The following code will help you to do this restore processing.

using Microsoft.SqlServer.Management.Smo;

string backupFile="Backupfile";//.bak file

string dbName = "DBName";

string dbServerMachineName = "MachineName";

Microsoft.SqlServer.Management.Smo.Server server = new Microsoft.SqlServer.Management.Smo.Server(dbServerMachineName);

Database database = new Database(server, dbName);

//If Need

database.Create();

database.Refresh();

//Restoring

Restore restore = new Restore();

restore.NoRecovery = false;

restore.Action = RestoreActionType.Database;

BackupDeviceItem bdi = default(BackupDeviceItem);

bdi = new BackupDeviceItem(backupFile, DeviceType.File);

restore.Devices.Add(bdi);

restore.Database = dbName;

restore.ReplaceDatabase = true;

restore.PercentCompleteNotification = 10;

restore.SqlRestore(server);

database.Refresh();

database.SetOnline();

server.Refresh();

...S.VinothkumaR.

How to taking backup a database using (c#) DotNet framework 3.5? Or using SMO?

2009-01-27T04:00:00.000-08:00

How to taking backup a database using (c#) DotNet framework 3.5? Or using SMO?

Add the following reference in your project for using SMO through “Add Reference”.

- Microsoft.SqlServer.ConnectionInfo

- Microsoft.SqlServer.Management.Sdk.Sfc

- Microsoft.SqlServer.Smo

- Microsoft.SqlServer.SmoExtended

- Microsoft.SqlServer.SqlEnum

Now, you can use the following code for taking backup of given database using SMO.

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.IO;

using Microsoft.SqlServer.Management.Smo;

string MachineName="Your MachineName";

string DBName="Your DBName";

string backupName = "tempBackup";

Microsoft.SqlServer.Management.Smo.Server server = new Microsoft.SqlServer.Management.Smo.Server(MachineName);

Database db = server.Databases[DBName];

//To Avoid TimeOut Exception

server.ConnectionContext.StatementTimeout = 60 * 60;

RecoveryModel recoverymodel = db.DatabaseOptions.RecoveryModel;

//Define a Backup object variable.

Backup backup = new Backup();

backup.CompressionOption = BackupCompressionOptions.On;

//Specify the type of backup, the description, the name, and the database to be backed up.

backup.Action = BackupActionType.Database;

backup.BackupSetDescription = "Full backup of " + DBName + ".";

backup.BackupSetName = backupName;

backup.Database = DBName;

//Declare a BackupDeviceItem

BackupDeviceItem bdi = default(BackupDeviceItem);

bdi = new BackupDeviceItem(@"C:\ " + backupName + ".bak", DeviceType.File);

//Add the device to the Backup object.

backup.Devices.Add(bdi);

//Set the Incremental property to False to specify that this is a full database backup.

backup.Incremental = false;

//Set the expiration date.

System.DateTime backupdate = new System.DateTime();

backupdate = new System.DateTime(2008, 10, 5);

backup.ExpirationDate = backupdate;

//Specify that the log must be truncated after the backup is complete.

backup.LogTruncation = BackupTruncateLogType.Truncate;

//Run SqlBackup to perform the full database backup on the instance of SQL Server.

backup.SqlBackup(server);

//Remove the backup device from the Backup object.

backup.Devices.Remove(bdi);

That's it...

...S.VinothkumaR.

How to write entry in EventViewer using C#?

2009-01-26T23:41:00.000-08:00

Hi all,

Just copy the following method in your project and call that method. It will write an entry in your EventViewer.

public void testEventLogEntry()

{

if (!System.Diagnostics.EventLog.SourceExists("MyTest.WinService"))

System.Diagnostics.EventLog.CreateEventSource(

"MyTest.WinService", "Application");

System.Diagnostics.EventLog eventLog = new System.Diagnostics.EventLog();

eventLog.Source = "MyTest.WinService";

eventLog.WriteEntry("Test");

}

...S.VinothkumaR.

How to get BitmapSource from System.Drawing.Bitmap in C# 3.5

2009-01-09T07:18:00.000-08:00

public BitmapSource getBitmapSourceFromBitmap(Bitmap bmp)

{

BitmapSource returnSource = null;

try

{

returnSource = System.Windows.Interop.Imaging.CreateBitmapSourceFromHBitmap(bmp.GetHbitmap(),

IntPtr.Zero, Int32Rect.Empty, BitmapSizeOptions.FromEmptyOptions());

}

catch { returnSource = null; }

return returnSource;

}

...S.VinothkumaR.

Getting Bitmap from Base64String in C#

2009-01-09T07:01:00.000-08:00

Use the following code for getting Bitmap from Base64String.

public Bitmap getBitmapFromBase64String(string base64Value)

{

Bitmap img = null;

byte[] imgData = Convert.FromBase64String(base64Value);

using (MemoryStream ms = new MemoryStream())

{

ms.Write(imgData, 0, imgData.Length);

img = (Bitmap)Image.FromStream(ms, true);

ms.Close();

ms.Dispose();

}

return img;

}

....S.VinothkumaR.

Displaying an Image in an aspx page as OutputStream using C#

2009-01-09T06:13:00.000-08:00

Dear Viewers,

Here am going to give a solution to display an image in an aspx page as OutputStream by using c#.

First of all we need to remove all code in that aspx except the line of page tag (i.e., <%@ Page Language="C#")

In Page_Load

Do the code behind as follows,

Response.ContentType = "image/jpeg";
System.Drawing.Image img = System.Drawing.Image.FromFile(@"C:\test.jpg");
img.Save(Response.OutputStream, System.Drawing.Imaging.ImageFormat.Jpeg);

Yes, this the way to save image in aspx page as OutputStream.

...S.VinothkumaR.

Getting Images from FTP using C#

2009-01-09T05:42:00.000-08:00

Hi all,

Here the sample for getting an Image from ftp file path using C#.

using System.Net;

string path = "ftp://dev-ftp.test.com/" + folderName + "\\" + fileName;

FtpWebRequest ftp;

ftp = (FtpWebRequest)FtpWebRequest.Create(new Uri(path));

ftp.Credentials = new NetworkCredential(username, password);

ftp.Method = WebRequestMethods.Ftp.DownloadFile;

using (FtpWebResponse response = (FtpWebResponse)ftp.GetResponse())

{

using (Stream responseStream = response.GetResponseStream())

{

using (FileStream fs = new FileStream(localPath+fileName, FileMode.Create))

{

byte[] buffer = new byte[102400];

int read = 0;

{

read = responseStream.Read(buffer, 0, buffer.Length);

fs.Write(buffer, 0, read);

fs.Flush();

} while (!(read == 0));

fs.Flush();

fs.Close();

response.Close();

responseStream.Close();

Hence we can save an image in to our local file path from ftp file path.

That's it....

...S.VinothkumaR.

Difference between <% %>, <%= %>, <%# %>?

2008-12-08T22:17:00.000-08:00

Whenever we are going to write code inside the <% %> then that piece of code will treated as server side code generally vbscript.

When we are accessing any server side variable into the HTML (in .aspx) side then we use <%= %>.

When we are using any binding control like repeater, gridview… etc then to bind the particular column with the database value then we are using <%# %> when the Autogenerate column of the binding controls are FALSE

For Example:

Text='<%#Eval("FirstName") %>' this tag put inside the Text property of the control inside the datagrid like (textbox, label etc....)

...S.VinothkumaR.

Image Resizing by WPF: Using System.Windows.Media.Imaging;

2008-12-08T22:11:00.000-08:00

Here is the example of getting resized image by using Imaging namespace in DotNet 3.0.

Same three reference need to add for resizing the image also. PresentationCore, WindowsBase and PresentationFramework.

private void ResizeImage(string SourceImagePath, string ImageType, string TargetImagePath, int decodePixelWidth, int decodePixelHeight)

{

newWidth = 0;

newHeight = 0;

getResizableHeightWidth(SourceImagePath, decodePixelWidth, decodePixelHeight);

byte[] imageBytes = LoadImageData(SourceImagePath);

ImageSource imageSource = CreateResizedImage(imageBytes, newWidth, newHeight);

imageBytes = GetEncodedImageData(imageSource, ImageType);

SaveImageData(imageBytes, TargetImagePath);

}

LoadImageData, GetEncodedImageData and SaveImageData methods are given in last post. Here the CreateResizedImage method is given in below.

//Method for getting resized image by given image data byte array with width and height.

ImageSource CreateResizedImage(byte[] imageData, int width, int height)

{

BitmapImage bmpImage = new BitmapImage();

bmpImage.BeginInit();

if (width > 0)

{

bmpImage.DecodePixelWidth = width;

}

if (height > 0)

{

bmpImage.DecodePixelHeight = height;

}

bmpImage.StreamSource = new MemoryStream(imageData);

bmpImage.CreateOptions = BitmapCreateOptions.None;

bmpImage.CacheOption = BitmapCacheOption.OnLoad;

bmpImage.EndInit();

Rect rect = new Rect(0, 0, width, height);

DrawingVisual drawingVisual = new DrawingVisual();

using (DrawingContext drawingContext = drawingVisual.RenderOpen())

{

drawingContext.DrawImage(bmpImage, rect);

}

RenderTargetBitmap resizedImage = new RenderTargetBitmap(

(int)rect.Width, (int)rect.Height, // Resized dimensions

96, 96, // Default DPI values

PixelFormats.Default); // Default pixel format

resizedImage.Render(drawingVisual);

return resizedImage;

}

//Method for getting resizable height and width by given height and width.

private void getResizableHeightWidth(string ImagePath, int maxWidth, int maxHeight)

{

System.Drawing.Image image = new Bitmap(ImagePath);

int width = image.Width;

int height = image.Height;

double widthFactor = (Convert.ToDouble(width) / Convert.ToDouble(maxWidth));

double heightFactor = (Convert.ToDouble(height) / Convert.ToDouble(maxHeight));

newWidth=0;

newHeight=0;

if (widthFactor > heightFactor)

{

newWidth = Convert.ToInt32(Convert.ToDouble(width) / widthFactor);

newHeight = Convert.ToInt32(Convert.ToDouble(height) / widthFactor);

}

else

{

newWidth = Convert.ToInt32(Convert.ToDouble(width) / heightFactor);

newHeight = Convert.ToInt32(Convert.ToDouble(height) / heightFactor);

}

if (newHeight == 0)

{

newHeight = 1;

}

if (newWidth == 0)

{

newWidth = 1;

}

That’s it.

...S.VinothkumaR.

Image Cropping by WPF: Using System.Windows.Media.Imaging;

2008-12-08T22:06:00.000-08:00

Introducing System.Windows.Media.Imaging namespace provides types that are used to encode and decode bitmap images.

Here I am going to explain a sample application which is used to cropping images. Imaging namespace is in under Windows Presentation Foundation will do the image manipulation in simple manner.

First of all, we need to add the following reference in our project.

- PresentationCore

- PresentationFramework

- WindowsBase

Then use the following namespace,

using System.Windows.Media;

using System.Windows.Media.Imaging;

The method for creating crop images with passing appropriate parameters as follows,

//Method for Creating Crop Image

private void CreateCropImage(int x, int y, int width, int height, string SourceImagePath, string TargetImagePath, string ImageType)

{

byte[] imgBytest = LoadImageData(SourceImagePath);

System.Drawing.Image img=new Bitmap(SourceImagePath);

CroppedBitmap cb = new CroppedBitmap((BitmapSource)CreateImage(imgBytest,img.Width,img.Height), new Int32Rect(x, y, width, height));

ImageSource imageSource = cb;

byte[] imageBytes = GetEncodedImageData(imageSource, ImageType);

SaveImageData(imageBytes, TargetImagePath);

}

//Method for getting image bytes from image's source path by using FileStream.

private static byte[] LoadImageData(string filePath)

{

FileStream fs = new FileStream(filePath, FileMode.Open, FileAccess.Read);

BinaryReader br = new BinaryReader(fs);

byte[] imageBytes = br.ReadBytes((int)fs.Length);

br.Close();

fs.Close();

return imageBytes;

}

//Method for getting cropped image.

private static ImageSource CreateImage(byte[] imageData, int decodePixelWidth, int decodePixelHeight)

{

if (imageData == null) return null;

BitmapImage result = new BitmapImage();

result.BeginInit();

if (decodePixelWidth > 0)

{

result.DecodePixelWidth = decodePixelWidth;

}

if (decodePixelHeight > 0)

{

result.DecodePixelHeight = decodePixelHeight;

}

result.StreamSource = new MemoryStream(imageData);

result.CreateOptions = BitmapCreateOptions.None;

result.CacheOption = BitmapCacheOption.OnLoad;

result.EndInit();

return result;

}

//Method for getting encoded image data for the cropped image.

internal byte[] GetEncodedImageData(ImageSource image, string preferredFormat)

{

byte[] returnData = null;

BitmapEncoder encoder = null;

switch (preferredFormat.ToLower())

{

case ".jpg":

case ".jpeg":

encoder = new JpegBitmapEncoder();

break;

case ".bmp":

encoder = new BmpBitmapEncoder();

break;

case ".png":

encoder = new PngBitmapEncoder();

break;

case ".tif":

case ".tiff":

encoder = new TiffBitmapEncoder();

break;

case ".gif":

encoder = new GifBitmapEncoder();

break;

case ".wmp":

encoder = new WmpBitmapEncoder();

break;

}

if (image is BitmapSource)

{

MemoryStream stream = new MemoryStream();

encoder.Frames.Add(BitmapFrame.Create(image as BitmapSource));

encoder.Save(stream);

stream.Seek(0, SeekOrigin.Begin);

returnData = new byte[stream.Length];

BinaryReader br = new BinaryReader(stream);

br.Read(returnData, 0, (int)stream.Length);

br.Close();

stream.Close();

}

return returnData;

}

//Method for saving the image data as image in to spec

private static void SaveImageData(byte[] imageData, string filePath)

{

FileStream fs = new FileStream(filePath, FileMode.Create, FileAccess.Write);

BinaryWriter bw = new BinaryWriter(fs);

bw.Write(imageData);

bw.Close();

fs.Close();

}

That's it...

...S.VinothkumaR.

Windows Presentation Foundation.

2008-11-26T12:40:00.000-08:00

I think all of you getting pretty confusion why need to explain about WPF cause of lot explanation available in more pages. Actually I am going to post some Image manipulation functionalism in upcoming posts. So here is the introduction to WPF.

The Windows Presentation Foundation is a Graphical subsystem in .Net Framework 3.0 which uses a markup language, known as XAML for rich user interface development. WPF formerly code named Avalon. WCF – Indigo, CardSpace – InfoCard, WF – WorkFlow. WPF is included with Windows Vista, Windows Server 2008, Windows XP Service Pack 2 or later and Windows Server 2003.

It provides a clear separation between the user interface and the business logic. A WPF application can be deployed on the desktop or hosted in a web browser. So we can create a wide range of both standalone and browser-hosted applications.

It aims to unify a number of application services: user interface, 2D and 3D drawing, fixed and adaptive documents, advanced typography, vector graphics, raster graphics, animation, data binding, audio and video.

Some examples are Yahoo! Messenger and the New York Times Reader, as well as the Contoso Healthcare Sample Application. WPF is included in the Microsoft .NET Framework, so you can build applications that incorporate other elements of the .NET Framework class library.

I hope this will make you some ideas in WPF. Let we stop the introduction of WPF from here.

...S.VinothkumaR.

Image Resize using C#.

2008-11-26T12:34:00.000-08:00

Use the following method to resize an image.

public Image ResizeImage(Image image, int maxWidth, int maxHeight)
{
if (image == null)
{
return image;
}
int width = image.Width;
int height = image.Height;

double widthFactor = (Convert.ToDouble(width) / Convert.ToDouble(maxWidth));
double heightFactor = (Convert.ToDouble(height) / Convert.ToDouble(maxHeight));

if (widthFactor <>
{
// Skip resize
return image;
}
else
{
int newWidth;
int newHeight;
if (widthFactor > heightFactor)
{
newWidth = Convert.ToInt32(Convert.ToDouble(width) / widthFactor);
newHeight = Convert.ToInt32(Convert.ToDouble(height) / widthFactor);
}
else
{
newWidth = Convert.ToInt32(Convert.ToDouble(width) / heightFactor);
newHeight = Convert.ToInt32(Convert.ToDouble(height) / heightFactor);
}
if (newHeight == 0)
{
newHeight = 1;
}
if (newWidth == 0)
{
newWidth = 1;
}
Bitmap bitmap = new Bitmap(newWidth, newHeight, System.Drawing.Imaging.PixelFormat.Format24bppRgb);
bitmap.SetResolution(96, 96);

Graphics graphics = Graphics.FromImage(bitmap);
graphics.SmoothingMode = System.Drawing.Drawing2D.SmoothingMode.AntiAlias;
graphics.InterpolationMode = System.Drawing.Drawing2D.InterpolationMode.HighQualityBicubic;
graphics.DrawImage(image, 0, 0, newWidth, newHeight);
image.Dispose();
return bitmap;
}
}

...S.VinothkumaR.

Bytes to GB MB Conversion using C#

2008-11-26T12:27:00.000-08:00

Hi all,

Just copy the following method to getting file size with GB or MB formatted.

private string GetFileSize(long Bytes)
{
if (Bytes >= 1073741824)
{
Decimal size = Decimal.Divide(Bytes, 1073741824);
return String.Format("{0:##.##} GB", size);
}
else if (Bytes >= 1048576)
{ Decimal size = Decimal.Divide(Bytes, 1048576);
return String.Format("{0:##.##} MB", size);
}
else if (Bytes >= 1024)
{ Decimal size = Decimal.Divide(Bytes, 1024);
return String.Format("{0:##.##} KB", size);
}
else if (Bytes > 0 & Bytes <>
{ Decimal size = Bytes;
return String.Format("{0:##.##} Bytes", size);
}
else
{
return "0 Bytes";
}
}

...S.VinothkumaR.

Cropping Image

2008-11-21T01:34:00.000-08:00

Use the following code to crop an image by C#.

public Image CropImage(Image img, int cropLeft, int cropTop, int cropWidth, int cropHeight)
{
Bitmap bmp = new Bitmap(img);
Rectangle rect = new Rectangle(cropLeft, cropTop, cropWidth, cropHeight);
Bitmap croppedBmp = bmp.Clone(rect, bmp.PixelFormat);
return croppedBmp;
}

....S.VinothkumaR.

Cropping an Image with best quality using C#

2008-11-21T01:23:00.000-08:00

Hi all,

Here is the sample code for getting cropped image with the best quality. Try it out.

public Image CropImage(Image img, int left, int top, int width, int height)
{

try

{

Bitmap bmp = new Bitmap(width, height, PixelFormat.Format24bppRgb);

bmp.SetResolution(80, 60);

Graphics graphics = Graphics.FromImage(bmp);

graphics.SmoothingMode = SmoothingMode.AntiAlias;

graphics.InterpolationMode = InterpolationMode.HighQualityBicubic;

graphics.PixelOffsetMode = PixelOffsetMode.HighQuality;

graphics.DrawImage(img, new Rectangle(0, 0, width, height), left, top, width, height, GraphicsUnit.Pixel);

img.Dispose();

bmp.Dispose();

graphics.Dispose();

return bmp;
}

catch (Exception ex)

{

MessageBox.Show(ex.Message);

return null;

}
}

that's it....

...S.VinothkumaR.

Query for getting number of employee by department wise.

2008-11-18T04:06:00.000-08:00

Hi all,

Here I am having the following two tables.

Table : Department

Id Name

--- ----

1 IT

2 Maths

3 Science

Table: Employee

Id Name DeptId

--- ---- ------

1 aaa 2

2 vvv 2

3 eee 2

4 www 1

5 yyy 2

6 ppp 3

7 ooo 1

8 rrr 3

9 uuu 1

10 iii 3

Now, I need to get the number of employee in each department. How to do?

Here is the query for that.

select dept.Name as DepartmentName,count(*) as NoOfEmp from Department dept

INNER JOIN Employee emp on emp.DeptId=dept.Id group by dept.Name

By running this query, we can get the values like as follows.

DepartmentName NoOfEmp

-------------- -------

IT 3

Maths 4

Science 3

That's it...

...S.VinothkumaR.

Getting the GridViewRow from checkbox checked event.

2008-11-13T05:33:00.000-08:00

Get the GridView Row when a checkbox clicked from a GridView.

Here I’m going to give a sample code for getting the selected GridView Row from a Gridview when a checkbox clicked from that gridview.

protected void chkSelect_CheckedChanged(object sender, EventArgs e)

{

CheckBox selectChkBox = (CheckBox)sender;

GridViewRow row = (GridViewRow)( selectChkBox.Parent.Parent);

int index = row.RowIndex;

}

Here the “index” is the row of GridView.

...S.VinothkumaR.

What is the difference between a == b and a.equals(b) ?

2008-10-30T04:21:00.001-07:00

a == b means comparision between two variables.

a.equals(b) means comparision between two objects.

...S.VinothkumaR.

What is the difference between Int.parse and Convert.ToInt32

2008-10-30T04:07:00.000-07:00

Both the int.Parse and Convert.ToInt32 will return the same result. But the null handling only difference between them.

For example,
string str = "15";
int Val1= Convert.ToInt32(str);
int Val2= int.Parse(str);

From the above code, both Val1 and Val2 return the value as 15. Suppose the string value str has null value, Convert.ToInt32 will return zero and int.Parse will throw ArgumentNullException error.

For example,
string str=null;
int Val1= Convert.ToInt32(str);
int Val2 = int.Parse(str); //This will throw ArgumentNullException Error

That's it...

S.VinothkumaR.

Get xml from a URL

2008-10-13T05:30:00.000-07:00

Get xml from a URL

Hi all,
Using HTTPWebRequest and Response, we can easily get the xml file. FYI, see the below code.

First of all, we need to add the following namespaces in our application.

using System.Xml;
using System.IO;
using System.Text;
using System.Net;

Just copy the following code in your button_click event (or as your wish whichever event).

string url = "your url";
Uri fileUrl = new Uri(url);
HttpWebRequest request = (HttpWebRequest)WebRequest.Create(fileUrl);
HttpWebResponse response = (HttpWebResponse)request.GetResponse();
Stream receiveStream = response.GetResponseStream();
Encoding encode = System.Text.Encoding.GetEncoding("utf-8");
StreamReader reader = new StreamReader(receiveStream, encode);
string strValue = reader.ReadToEnd();

Now the whole xml file in strValue variable.

...S.VinothkumaR.

Swapping values between two variables without using temp variable.

2008-09-09T23:05:00.000-07:00

There is an easy way to swapping values of two variables by using a temporary variable. But here am trying to get interchanged values between those variables without using any temporary variable. Just look in to this…

public int a = 10;

public int b = 20;

//Before swapping

textBox1.Text = a.ToString();

textBox2.Text = b.ToString();

//After swapping

a = a + b;

b = a - b;

a = a - b;

textBox1.Text = a.ToString();

textBox2.Text = b.ToString();

This has been coded in a windows application using C#.

…S.VinothkumaR.

How to combine two data tables?

2008-08-29T03:52:00.000-07:00

I just am getting a situation to combine two data tables. Actually in my end, I had two datasets with two data tables in each of them. I needed to combine first data table in first dataset with first data table in second dataset. Similarly second data table in first dataset to second data table in second dataset.

On that moment I just found the way to merge data tables by using DataTable.Merge() method.

Then I combined my data tables as follows,

ds1.Tables[0].Merge(ds2.Tables[0], false,MissingSchemaAction.Add);
ds1.Tables[1].Merge(ds2.Tables[1], false, MissingSchemaAction.Add);

return ds1;

N.B: Here ds1 is first dataset, ds2 is second dataset.

...S.VinothkumaR.

Selecting Top N Number of Rows - SQL Server 2005

2008-08-29T02:44:00.000-07:00

Hi all,

We can get rows from a particular table by using the Select query as follows,

select * from [Table_Name]

If we need 10 rows, we can use Top query like as follows,

select top 10 * from [Table_Name]

Suppose we need to pass the number of rows count as parameter…How to do?

Yes, the way of using ROW_NUMBER(), we can do that. For more, see the following example,

First we are going to create a table namely TestCount.

create table TestCount(SNo int, Name varchar(200))

Insert values in to that table.

insert into TestCount(SNo,Name) values(1,'aaa')
insert into TestCount(SNo,Name) values(2,'bbb')
insert into TestCount(SNo,Name) values(3,'ccc')
insert into TestCount(SNo,Name) values(4,'ddd')
insert into TestCount(SNo,Name) values(5,'eee')
insert into TestCount(SNo,Name) values(6,'fff')
insert into TestCount(SNo,Name) values(7,'ggg')
insert into TestCount(SNo,Name) values(8,'hhh')
insert into TestCount(SNo,Name) values(9,'iii')
insert into TestCount(SNo,Name) values(10,'jjj')

Now use the following query to get top n number of rows.

declare @Count int
set @Count = 5
SELECT SNo,Name FROM
(select ROW_NUMBER() over (order by [SNo])
as Row, * FROM
(SELECT SNo,Name FROM TestCount)
as userquery)
as
SelectionWithRowNumbers WHERE Row >0 AND Row<=@Count

That’s it. Hence we can get top n number of rows from a table.

…S.VinothkumaR.

Creating an Excel application in Dot Net.

2008-08-28T01:19:00.000-07:00

We can do the creation of excel application in Dot Net by using the interoperability services. The interoperability services make it easy to work with COM Capable Applications such as Word and Excel.

First of all we need to create a reference in our project to Excel object library by using add reference. You can get an “Add Reference” dialog box when clicking the add reference, choose com tab and select “Microsoft Excel 9.0 Object Library” as follows.

After adding this library we can get Interop.Excel.dll and Interop.Office.dll files in our bin folder. Using these dll files we can manipulate excel like excel file creation, opening and updating.

When we ready to write code, first create an object of Excel.Application, Excel._Workbook and Excel._Worksheet. These are going to be used in creation of excel application.

How to create excel application?

This is the way to create an excel application. See the following code for help us to create an excel application.

protected void btnCreateExcel_Click(object sender, EventArgs e)
{
try
{
file = @"C:\temp\test.xls";
ex = new Excel.Application();
Excel._Workbook wb;
Excel._Worksheet ws;
wb = (Excel._Workbook)(ex.Workbooks.Add(Missing.Value));
ws = (Excel._Worksheet)(wb.Sheets["Sheet1"]);
ws.Name = "MyFirstSheet";
ws.Cells[1, 1] = "Test1";
ws.Cells[1, 2] = "Test2";
ws.Cells[2, 1] = "Test3";
ws.Cells[2, 2] = "Test4";
ws.Cells[3, 1] = "Test5";
ws.Cells[3, 2] = "Test6";
ws.get_Range("A1", "A3").Font.Bold = true;
ws.get_Range("A1", "C3").EntireColumn.AutoFit();
//wb.SaveAs(file, Excel.XlFileFormat.xlCSV, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Excel.XlSaveAsAccessMode.xlNoChange, Type.Missing, Type.Missing, Type.Missing, Type.Missing);
wb.SaveCopyAs(file);
wb.Close(null, null, null);
ex.Workbooks.Close();
ex.Quit();
System.Runtime.InteropServices.Marshal.ReleaseComObject(ws);
System.Runtime.InteropServices.Marshal.ReleaseComObject(wb);
System.Runtime.InteropServices.Marshal.ReleaseComObject(ex);
}
catch (Exception ex)
{
Response.Write("Error: \n" + ex.ToString());
}
}

By using the above code, now we have created an excel application test.xls.

How to open an excel application and how can update with that application?

Workbooks.Open method is used to open an excel application. Then we can assign the values of some particular cells and will save that application by using the save method. For more, see the following code.

protected void btnChangeExcel_Click(object sender, EventArgs e)
{
try
{
file = @"C:\temp\test.xls";
ex = new Excel.ApplicationClass();
Excel._Workbook wbObj = null;
Excel._Worksheet wsObj = null;
Excel.Range rngObj = null;
wbObj = ex.Workbooks.Open(file, 0, false, 5, "", "", false, Excel.XlPlatform.xlWindows, "", true, false, 0, true);
wsObj = (Excel._Worksheet)wbObj.Worksheets[1];
wsObj.Cells[1, 1] = "1";
wsObj.Cells[1, 2] = "2";
wsObj.Cells[1, 3] = "3";
wsObj.Cells[2, 1] = "A";
wsObj.Cells[2, 2] = "B";
wsObj.Cells[2, 3] = "C";
rngObj = wsObj.get_Range("A1", "C2");
rngObj.EntireRow.AutoFit();
rngObj.EntireColumn.AutoFit();
wbObj.Save();
wbObj.Close(null, null, null);
ex.Workbooks.Close();
ex.Quit();
System.Runtime.InteropServices.Marshal.ReleaseComObject(rngObj);
System.Runtime.InteropServices.Marshal.ReleaseComObject(wsObj);
System.Runtime.InteropServices.Marshal.ReleaseComObject(wbObj);
System.Runtime.InteropServices.Marshal.ReleaseComObject(ex);
}
catch (Exception ex)
{
Response.Write("Error: \n" + ex.ToString());
}
}

That’s it. Hence we have created an excel application and updating some particular cells in that application.

...S.VinothkumaR.

How to find the queries which are use the most CPU time and most IO?

2008-08-04T04:21:00.000-07:00

Most of us wanted to know which queries are use the most CPU time and most IO in a db server.

We can get that information using the dynamic management view, such as dm_exec_query_stats and dm_exec_sql_text.

For this, first of all we need to create the following procedure.

USE [master]
GO
IF EXISTS (SELECT * FROM sys.objects WHERE object_id =
OBJECT_ID(N'[dbo].[dba_TOP_Queries_Average]')
AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[dba_TOP_Queries_Average]
go
CREATE procedure dba_TOP_Queries_Average @topcount int=10,
@type varchar(10) ='cpu'
as
begin try
select Top (@topcount )
creation_time
, last_execution_time
,rank() over(order by (total_worker_time+0.0)/
execution_count desc,
sql_handle,statement_start_offset ) as row_no
, (rank() over(order by (total_worker_time+0.0)/
execution_count desc,
sql_handle,statement_start_offset ))%2 as l1
, (total_worker_time+0.0)/1000 as total_worker_time
, (total_worker_time+0.0)/(execution_count*1000)
as [AvgCPUTime]
, total_logical_reads as [LogicalReads]
, total_logical_writes as [LogicalWrites]
, execution_count
, total_logical_reads+total_logical_writes as [AggIO]
, (total_logical_reads+total_logical_writes)/
(execution_count+0.0) as [AvgIO]
, case when sql_handle IS NULL
then ' '
else ( substring(st.text,(qs.statement_start_offset+2)/2,
(case when qs.statement_end_offset = -1
then len(convert(nvarchar(MAX),st.text))*2
else qs.statement_end_offset
end - qs.statement_start_offset) /2 ) )
end as query_text
, db_name(st.dbid) as db_name
, st.objectid as object_id
from sys.dm_exec_query_stats qs
cross apply sys.dm_exec_sql_text(sql_handle) st
where total_worker_time > 0
order by case when @type='cpu' then (total_worker_time+0.0)/(execution_count*1000)
else (total_logical_reads+total_logical_writes)/(execution_count+0.0) end desc
end try
begin catch
select -100 as row_no
, 1 as l1, 1 as create_time,1 as last_execution_time,1 as total_worker_time,1 as AvgCPUTime,1 as LogicalReads,1
as LogicalWrites
, ERROR_NUMBER() as execution_count
, ERROR_SEVERITY() as AggIO
, ERROR_STATE() as AvgIO
, ERROR_MESSAGE() as query_text
, 0 as db_name
, 0 as object_name
end catch

Now we can get the top 10 queries based on the CPU usage. By default our procedure will return top 10 queries. Because we given the topcount as 10.

For example,

exec [dbo].[dba_TOP_Queries_Average]

If we need to get top 10 queries based on the average I/O usage, do as following.

exec [dbo].[dba_TOP_Queries_Average] @type = 'Avg'

If we need to get top n queries,

exec [dbo].[dba_TOP_Queries_Average] @topcount =14, @type = 'Avg'
exec [dbo].[dba_TOP_Queries_Average] @topcount =14, @type = 'cpu'

That’s it…

...S.VinothkumaR

GROUP BY, HAVING, SUM, AVG, and COUNT(*)

2008-08-01T23:04:00.000-07:00

Here is the simple example of using the clauses like where, Having, Group By and the aggregations like Count, Sum and Avg.

First we will have a simple and a small table ‘order’ with data’s as follows,
ORDER STATE AMOUNT
------+-------+-------------
1234 NY 10.00
1235 TX 15.00
1236 CA 20.00
1237 TX 25.00
1238 CA 30.00
1237 NY 35.00
1238 NY 40.00

Using Aggregation:

Aggregation combines rows together and performs some operation on their combined values. Very common aggregations are COUNT, SUM, and AVG.

SELECT COUNT(*) as count,SUM(amount) as sum,AVG(amount) as avg FROM orders

this query will return as,

count sum avg
-----+------+-----
7 175 25

Using Where Clause:
If we need to get result with the basis of any state, use the following query.
SELECT COUNT(*) as count,SUM(amount) as sum,AVG(amount) as avg FROM orders WHERE state = 'NY'

this will return as,
count sum avg
----+------+----------
3 85 28.33333

As from the above results, there is the average has a repeating decimal. So we can use the Round function.

Using Group By Clause:

The GROUP BY clause says that the aggregations should be performed for the distinct values of a column or columns.

SELECT state, COUNT(*) as count,SUM(amount) as sum, ROUND(AVG(amount),0) as avg FROM orders GROUP BY state

This will return as,

STATE count sum avg
------+-----+------+----
NY 3 85 28
TX 2 40 20
CA 2 50 25

Using Having Clause:

The HAVING clause lets us put a filter on the results after the aggregation has taken place. If we need to know which state having average amount of Rs.25 or more, use the following code.

SELECT state, COUNT(*) as count,SUM(amount) as sum, ROUND(AVG(amount),0) as avg FROM orders GROUP BY state HAVING AVG(amount) >= 25

Result of this query,

state count sum avg
------+-----+------+----
NY 3 85 28
CA 2 50 25

Now we can pull results out of a database in a single query with the use of combine the WHERE, GROUP BY, and HAVING as follows,

SELECT state, COUNT(*),SUM(amount) as sum, ROUND(AVG(amount),0) as avg FROM orders WHERE amount > 20 GROUP BY state HAVING avg(amount) >= 30

That's it....

...S.VinothkumaR.

Creating chart with Crystal Report application.

2008-08-01T07:02:00.000-07:00

Crystal Report also supports the creation of charts. Now we are going to see how we can display a chart showing the percentages of a particular product ordered by the each customer.
Add new crystal report in our solution and do as the following steps.

1. Add the following tables to the report
Customers
Order Details
Orders
Products
2. Choose the following fields to display:
Customers.CompanyName
Products.ProductName
Order Details.Quantity
3. Group the report by Customers.CompanyName.
4. For the Summaries section, ensure that only Sum of Order Details.Quantity is present.
5. In the Chart dialog, check the Pie Chart option.

Now, add a new Parameter Field to the report and name the parameter Product_Name. Click the Select Expert button and bind the parameter to the Products.ProductName field of the report.

Finally, add the following controls to Form1:
- Label
- ComboBox
- Button
Write the code as following to view chart,

private void Form1_Load(object sender, EventArgs e)
{
string connStr = "Data Source=.\\SQLEXPRESS;Initial Catalog=myDB;Integrated Security=True";
string sql = "SELECT CustomerID FROM Customers";
SqlConnection conn = new SqlConnection(connStr);
SqlCommand comm = new SqlCommand(sql, conn);
conn.Open();
SqlDataReader reader = comm.ExecuteReader;
while (reader.Read)
{
comboBox1.Items.Add(reader(0));
}
conn.Close();
sql = "SELECT ProductName from Products";
comm.CommandText = sql;
conn.Open();
reader = comm.ExecuteReader;
while (reader.Read)
{
ComboBox2.Items.Add(reader(0));
}
conn.Close();
}

In button click event,

private void btnViewReport_Click(object sender, System.EventArgs e)
{
CrystalReport2 report = new CrystalReport2();
report.SetParameterValue("Product_Name", ComboBox2.Text);
{
Form2.CrystalReportViewer1.ReportSource = report;
Form2.ShowDialog();
}
}

That’s it… Now you can test with running the application.

...S.VinothkumaR.

Adding parameters to the Crystal Report:

2008-08-01T06:51:00.000-07:00

We can pass parameters to report during runtime. For that you need to follow the steps as below…
Main Report view -- > right click on the parameter fields items located in the field explorer
-- > select new -- > specify Customer_ID as the name -- > click ok -- > In the choose field dialog, choose CustomerId and click ok.

Now click the Select Expert button which is in the toolbar of Visual Studio 2005. In the Select Expert dialog, set the value of the control as CustomerId is equal to Customer_ID.

Now create a wizard in form1 using follows,
- Label (CustomerID )
- Combo Box (comboBox1)
- Button(ViewReports)

Write code in form1 code behind as follows to add parameters to report.

using System.Data;
using System.Data.SqlClient;

private void Form1_Load(object sender, EventArgs e)
{
string connStr = "Data Source=.\\SQLEXPRESS;Initial Catalog=myDB;Integrated Security=True";
string sql = "SELECT CustomerID FROM Customers";
SqlConnection conn = new SqlConnection(connStr);
SqlCommand comm = new SqlCommand(sql, conn);
conn.Open();
SqlDataReader reader = comm.ExecuteReader;
while (reader.Read)
{
comboBox1.Items.Add(reader(0));
}
conn.Close();
}

Now switch to button click event,
private void btnViewReport_Click(object sender, System.EventArgs e)
{
CrystalReport1 report = new CrystalReport1();
report.SetParameterValue("Customer_ID", ComboBox1.Text);
{
Form2.CrystalReportViewer1.ReportSource = report;
Form2.ShowDialog();
}
}

That’s it. Now you can test the application by running.

...S.VinothkumaR.

Crystal Report using in DotNet

2008-07-28T06:50:00.000-07:00

Hi all,

I am going to explain how to create a report by using Crystal Report in DotNet here.

Generating Report:
----------------------

To create a report using crystal report, just follow the steps mentioned below which is very useful to using crystal repot.

In Visual Studio 2005, create new project with a name as your wish. Add a new item to the project by right clicking on the project name in solution explorer. Select the crystal report template with a name as your wish.

Now you are in Crystal Report Gallery dialog. Now you should choose the “Using the Report Wizard” and “Standard” options and click OK.

The Standard Report Creation Wizard dialog will appear. Now you should choose the data source to connect SQL Server 2005. For that just expand the Create New Connection data source and expand the OLEDB(ADO) item. Then select an OLEDB provider “SQL Native Client” for SQL Server 2005 databases.

Now we need to provide the connection information for the database. Type the server name and check the Integrity Security checkbox. Then click the dropdown list next to the database item and select the database. Click the next to continue, in next dialog finish to configuring the data source.

Now you need to choose the tables to use for the report. Expand your database and select the tables by using > button.

Click the next to continue. Here you need to confirm the relationships between the various tables you have selected. Then click the next to continue.

Now you should choose the fields to use for the report by using > button. Then click next, in the next dialog you should choose the field to group the report.

Clicks next to continue there will three dialogs seemed. Just give next and next, in final dialog you can select report style finally click finish then your report will be ready.
Previewing Report:
---------------------

After creating the report, you can preview that by clicking the Main Report Preview button which is in the bottom of report.

Viewing your Report in Windows Form:
--------------------------------------------

If you want to see the report in windows form, you will need to use the CrystalReportViewer control.

First you will need to add a new windows form to the project. And add the CrystalReportViewer control in to your form. Now add a button control in to form and named it as “ViewReport”.

Then write code as below in the button clicked event.

CrystalReport1 report = new CrystalReport1();
{
Form2.CrystalReportViewer1.ReportSource = report;
Form2.ShowDialog();
}

...S.VinothkumaR.

Diamond inheritance / Ambiguities in inheritance

2008-07-03T06:00:00.001-07:00

Hi friends,
Here I am explained the Diamond Inheritance and Ambiguities in inheritance. Just watch out the below image and with my explonation.

The above figure illustrates the diamond inheritance. The class IOS is the base class for both IStream and OStream classes. Each of those classes formed with single inheritance. The class IOStream inherits from both IStream and OStream classes. This class object will provide the functionality of both IOStream and OStream classes. In multiple inheritance hierarchies, the situation described in above figure is referred to as Diamond Inheritance.

There would be seemed a problem in IOStream class. Because the class IOStream contain two copies of the members of class IOS. One inherited via the class IStream and another one inherited via the class OStream. Such a situation would be ambiguous and would result in a compilation error. Because the compiler wouldn’t know which version of members from class IOS to use.

In this situation, the virtual base class solves the problem of inheriting duplicate copies of an indirect base class.

...S.VinothkumaR.

Converting xml to string in C#

2008-07-03T01:46:00.000-07:00

Hi friends,
Here is the simple code for converting xml to string.
string strXML = "";
StringReader reader = new StringReader("C:\\test.xml");
XmlDocument doc = new XmlDocument();
doc.Load(reader);
if (doc != null)
{
StringWriter writer = new StringWriter();
doc.Save(writer);
strXML = writer.ToString();
}
doc = null;

...S.VinothkumaR.

2008-07-02T05:46:00.000-07:00

Hi all,
Here I have listed the JavascriptCode, Numerical code and Hex code for some symbols. Find out from the following images.

...S.VinothkumaR.

Difference between Stack and Heap

2008-07-01T06:28:00.000-07:00

Stack:
- Variables of value type are allocated in stack.
- Memory allocation of stack is speader than heap.
- If the object is small we should use value type (stack).
Heap:
- Variables of reference type are allocated in heap.
- Memory allocation is slow.
- If the object is big one, using reference type is fine (heap).

...S.VinothkumaR.

Difference between Session state and Application state

2008-06-30T03:28:00.000-07:00

Session state and Application state both are support the same type of objects and maintain information on the server.

Session state:
- The session object is used to maintain the session of each user. A user gets a session id when he enters in to an application. This Id will delete when he leave from that application. If he enters again he will get a different session Id.
- Session allows information to be stored in one page and access in another page and support any type of object.

Application state:

- But the application object, the Id is maintained for whole application.
- Application state allows storing global objects that can be accessed by any client.
...S.VinothkumaR.

Difference between View State and Session State

2008-06-30T02:42:00.000-07:00

Session state and view state are used to keep on certain data.

View State:

- View state is maintained in page level only.
- View state of one page is not visible in another page.
- View state information stored in client only.
- View state persist the values of particular page in the client (browser) when post back operation done.
- View state used to persist page-instance-specific data.

Session State:
- Session state is maintained in session level.
- Session state value is available in all pages within a user session.
- Session state information stored in server.
- Session state persist the data of particular user in the server. This data available till user close the browser or session time completes.
- Session state used to persist the user-specific data on the server side.

...S.VinothkumaR.

How to send Authenticated Emails?

2008-06-26T04:33:00.000-07:00

Here is sample for sending Authenticated emails.
private void SendMail()
{
try
{
MailMessage mail = new MailMessage();
mail.From = new MailAddress("vinothnat@hotmail.com", "Vinothkumar");
mail.To.Add(new MailAddress("vinoth_nat@hotmail.com", "S.Vinothkumar"));
//To property is a generic collection. So we can add as many recipients as we like
mail.Subject = "TestMail";
mail.Body = "I am testing the mail with credentials.";
mail.IsBodyHtml = true;
SmtpClient smtp = new SmtpClient("localhost");
smtp.DeliveryMethod = SmtpDeliveryMethod.Network;
NetworkCredential credential = new NetworkCredential("username", "password");
smtp.UseDefaultCredentials = false;
smtp.Credentials = credential;
smtp.Send(mail);
}
catch (Exception ex)
{
Response.Write(ex.ToString());
}
}

...S.VinothkumaR.

Sql Server Function to get number of working days in given days.

2008-06-20T23:11:00.000-07:00

Here is an example to get the number of working days in given couple of days.

CREATE FUNCTION dbo.GetWorkingDays
(
@startDate SMALLDATETIME,
@endDate SMALLDATETIME
)
RETURNS INT
AS
BEGIN
DECLARE @WDays INT;
SET @WDays = DATEDIFF(DAY, @startDate, @endDate)+1;
RETURN
(
SELECT @WDays / 7 * 5 + @WDays % 7 -
(
SELECT COUNT(*) FROM
(
SELECT 1 AS d
UNION ALL SELECT 2
UNION ALL SELECT 3
UNION ALL SELECT 4
UNION ALL SELECT 5
UNION ALL SELECT 6
UNION ALL SELECT
) weekdays
WHERE d <= @WDays % 7
AND DATENAME(WEEKDAY, @endDate - d + 1)
IN
(
'Saturday',
'Sunday'
)
)
);
END
GO
PRINT dbo.getWorkingDays('20080601', '20080630')

...S.VinothkumaR.

SQL Server Function to get Number Of Days in a month.

2008-06-20T23:05:00.000-07:00

Here is an example to getting number of days in a month.

CREATE FUNCTION dbo.GetNumberOfDays
(
@inMonth DATETIME
)
RETURNS INT
AS
BEGIN
Declare @Days int
Set @Days=0
set @Days=CASE WHEN MONTH(@inMonth) IN (1,3,5,7,8,10,12) THEN 31
WHEN MONTH(@inMonth) IN (4,6,9,11) THEN 30
ELSE CASE WHEN (YEAR(@inMonth) % 4 = 0 AND YEAR(@inMonth) % 100!=0) OR (YEAR(@inMonth) % 400=0) THEN 29
ELSE 28 END
END
Return
(
select @Days
);
END

PRINT dbo.GetNumberOfDays(getDate())

...S.VinothkumaR.

Easy way to find browsers in JavaScript

2008-06-20T05:02:00.000-07:00

Hi all,
Here I have written a JavaScript function to get the browser.

function myBrowser()

{

var browser=navigator.userAgent.toLowerCase();

if (browser.indexOf("msie") != -1)

return 'Internet Explorer';

if (browser.indexOf("firefox") != -1)

return 'Firefox';

if (browser.indexOf("opera") != -1)

return 'Opera';

if (browser.indexOf("safari") != -1)

return 'Safari';

if (browser.indexOf("netscape") != -1)

return 'Netscape';

if (browser.indexOf("mozilla/5.0") != -1)

return 'Mozilla';

if (browser.indexOf("staroffice") != -1)

return 'Star Office';

if (browser.indexOf("webtv") != -1)

return 'WebTV';

if (browser.indexOf("beonex") != -1)

return 'Beonex';

if (browser.indexOf("chimera") != -1)

return 'Chimera';

if (browser.indexOf("netpositive") != -1)

return 'NetPositive';

if (browser.indexOf("phoenix") != -1)

return 'Phoenix';

if (browser.indexOf("skipstone") != -1)

return 'SkipStone';

}

...S.VinothkumaR.

Alternate to location.href

2008-06-13T02:37:00.000-07:00

Hi all,
Actually the location.href functionality is some times not working in firefox . So we can use the following way is the alternative for "location.href."

top.window.opener.location.href

...S.VinothkumaR.

OPENDATASOURCE

2008-05-27T02:23:00.000-07:00

It provides ad hoc connection information as part of four – part object name without using a linked server name.

Syntax:
OPENDATASOURCE( provider_name, init_string )

provider_name is the name registered as the PROGID of the OLE DB provider used to access the data source. provider_name is a char data type, with no default value.

init_string is the connection string passed to the IDataInitialize interface of the destination provider. The provider string syntax is based on keyword-value pairs separated by semicolons, that is, "keyword1=value; keyword2=value."

The following lists the most commonly used keywords in the init_string argument.

Keyword : Data Source
OLE DB property : DBPROP_INIT_DATASOURCE
Valid values and Description :
Name of the data source to connect to. Different providers interpret this in different ways. For SQL Server OLE DB provider, this indicates the name of the server. For Jet OLE DB provider, this indicates the full path of the .mdb file or .xls file.

Keyword : Location
OLE DB property : DBPROP_INIT_LOCATION
Valid values and Description : Location of the database to connect to.

Keyword : Extended Properties
OLE DB property : DBPROP_INIT_PROVIDERSTRING
Valid values and Description : The provider-specific connect-string.

Keyword : Connect timeout
OLE DB property : DBPROP_INIT_TIMEOUT
Valid values and Description : Time-out value after which the connection attempt fails.

Keyword : User ID
OLE DB property : DBPROP_AUTH_USERID
Valid values and Description : User ID to be used for the connection.

Keyword : Password
OLE DB property : DBPROP_AUTH_PASSWORD
Valid values and Description : Password to be used for the connection.

Keyword : Catalog
OLE DB property : DBPROP_INIT_CATALOG
Valid values and Description : The name of the initial or default catalog when connecting to the data source.

Examples
This example accesses data from a table on another instance of SQL Server.

SELECT * FROM OPENDATASOURCE('SQLOLEDB','Data Source=ServerName;User ID=MyUID;Password=MyPass').Northwind.dbo.Categories

This is an example of a query against an Excel spreadsheet through the OLE DB provider for Jet.

SELECT * FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0','Data Source="c:\Finance\account.xls";User ID=Admin;Password=;Extended properties=Excel 5.0')...xactions

...S.VinothkumaR.

How to import data from Excel to SQL Server?

2008-05-27T02:10:00.000-07:00

We can import data from Excel to SQL Server by using SQL Server distributed queries.

We can import data for a specific purpose by using the OPENDATASOURCE or the OPENROWSET function. The following code samples will help us to import data from excel customer’s worksheet into new SQL Server tables.

SELECT * INTO tblXLImport1 FROM OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0', 'Data Source=C:\test.xls;Extended Properties=Excel 8.0')...[Customers$]

SELECT * INTO tblXLImport2 FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=C:\test.xls', [Customers$])

SELECT * INTO tblXLImport3 FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=C:\test.xls', 'SELECT * FROM [Customers$]')

//Here Customers$ means the name of worksheet.

Simple sample query:

SELECT * FROM OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0',
'Data Source=C:\students.xls;Extended Properties=Excel 8.0')...[Students$]

...S.VinothkumaR.

Simple Cursor Programme

2008-04-18T11:36:00.000-07:00

Hi all,
Here is a simple sample for cursor.

declare testCur CURSOR For //Cursor declaring for

select top 10 * from tblUsers

Open testCur //Open the cursor

Fetch next from testCur //Fetch the first record

while @@FETCH_STATUS = 0

Fetch next from testCur //Fetch the next record while status = 0

CLOSE testCur //Close cursor

deallocate testCur //Deallocate the cursor.

...S.VinothkumaR.

Grant permission to all stored procedures.

2008-04-18T11:24:00.000-07:00

Hi all,

I am continuing my posts here for a long gape...

Here is a query for granting permission to all stored procedures in a database. Check it out...

create PROCEDURE stpGrantPermissionToAllSP @user sysname
AS
SET NOCOUNT ON
-- 1 - Variable declarations
DECLARE @CMD1 varchar(8000)
DECLARE @MAXOID int
DECLARE @OwnerName varchar(128)
DECLARE @ObjectName varchar(128)

-- 2 - Create temporary table
CREATE TABLE #StoredProcedures
(OID int IDENTITY (1,1),
StoredProcOwner varchar(128) NOT NULL,
StoredProcName varchar(128) NOT NULL)

-- 3 - Populate temporary table
INSERT INTO #StoredProcedures (StoredProcOwner, StoredProcName)
SELECT u.[Name], o.[Name]
FROM dbo.sysobjects o
INNER JOIN dbo.sysusers u
ON o.uid = u.uid
WHERE o.Type = 'P'
AND o.[Name] NOT LIKE 'dt_%'

-- 4 - Capture the @MAXOID value
SELECT @MAXOID = MAX(OID) FROM #StoredProcedures

-- 5 - WHILE loop
WHILE @MAXOID > 0
BEGIN

-- 6 - Initialize the variables
SELECT @OwnerName = StoredProcOwner,
@ObjectName = StoredProcName
FROM #StoredProcedures
WHERE OID = @MAXOID

-- 7 - Build the string
SELECT @CMD1 = 'GRANT EXEC ON ' + '[' + @OwnerName + ']' + '.' + '[' + @ObjectName + ']' + ' TO ' + @user

-- 8 - Execute the string
-- SELECT @CMD1

-- 9 - Decrement @MAXOID
SET @MAXOID = @MAXOID - 1
END

-- 10 - Drop the temporary table
DROP TABLE #StoredProcedures
SET NOCOUNT OFF
GO
exec stpGrantPermissionToAllSP 'username'

...S.VinothkumaR.

DataTable,DataRow,DataView sorting.

2008-03-13T22:49:00.000-07:00

Hi all,

Just check the data sorting by using dataview in below.

SqlConnection sql=new SqlConnection("Connection String");
SqlCommand cmd=new SqlCommand("SampleProcedure",sql);
cmd.CommandType=CommandType.StoredProcedure;
SqlDataAdapter da=new SqlDataAdapter(cmd);
DataSet ds=new DataSet();
da.Fill(ds);
if(ds.Tables[0].Rows.Count>0)
{
DataTable dt=new DataTable();
dt.Columns.Add("Score",typeof(double));
dt.Columns.Add("Name",typeof(string));
DataRow dr;
foreach(DataRow drow in ds.Tables[0].Rows)
{
dr = dt.NewRow();
dr["Score"] = drow ["intScore"];
dr["Name"]=drow ["strGameName"];
dt.Rows.Add(dr);
}
DataView dv=dt.DefaultView;
dv.Sort="Score desc";
DataGrid drg=new DataGrid();
drg.DataSource=dv; //drg is DataGrid
drg.DataBind();
this.Controls.Add(drg);
}

...S.VinothkumaR

Double Formatting.

2008-03-13T22:42:00.000-07:00

Here is sample for double formatting by using C#.

Double dblScore = 2.0;
string str = dblScore.ToString("#,##0.0;(#,##0.0);00.0");

...S.Vinothkumar.

Check the valid Email Address using JavaScript

2008-01-24T21:32:00.000-08:00

Hi all,

Use the following code for check the valid email address.

var filterEmail = /^([a-zA-Z0-9_\.\-])+\@(([a-zA-Z])+\.)+([a-zA-Z]{2,4})+$/;
if(filterEmail.test(Email))//Check the Email Format.
{
//..........
}

...S.VinothkumaR.

Check the phone number for valid using JavaScript

2008-01-24T21:30:00.000-08:00

Hi all,

Use the following code for checking the valid phone number.

var filter = /^([0-9])+$/;
if (filter.test(textValue))
{
// ...Code here
}

...S.VinothkumaR.

Checking the Name for valid Characters in JavaScript

2008-01-24T21:27:00.000-08:00

Hi all,

Use the following code for check the valid characters in name field.

var filter = /^([a-zA-Z',.\0-9 ])+$/;
if (filter.test(textValue))
{
// ...Code here
}

...S.VinothkumaR.

Getting Drive Volume Information in C#

2007-12-20T06:18:00.000-08:00

It's very easy to getting Volume Information of our logical drives by using kernel32.dll

Just copy and paste the following code then run it...that's it. :)

using System.Runtime.InteropServices;

[DllImport("kernel32.dll", CharSet = CharSet.Auto)]
static extern bool GetVolumeInformation(string Volume,
StringBuilder VolumeName, uint VolumeNameSize,
out uint SerialNumber, out uint SerialNumberLength, out uint flags,
StringBuilder fs, uint fs_size);

private void Form1_Load(object sender, EventArgs e)
{
uint serialNum, serialNumLength, flags;
StringBuilder volumename = new StringBuilder(256);
StringBuilder fstype = new StringBuilder(256);
bool ok = false;
Cursor.Current = Cursors.WaitCursor;
foreach (string drives in Environment.GetLogicalDrives())
{
ok = GetVolumeInformation(drives, volumename, (uint)volumename.Capacity - 1, out serialNum,
out serialNumLength, out flags, fstype, (uint)fstype.Capacity - 1);
if (ok)
{
lblVolume.Text = lblVolume.Text + "\n Volume Information of " + drives + "\n";
lblVolume.Text = lblVolume.Text + "\nSerialNumber of is..... " + serialNum.ToString() + " \n";
if (volumename != null)
{
lblVolume.Text = lblVolume.Text + "VolumeName is..... " + volumename.ToString() + " \n";
}
if (fstype != null)
{
lblVolume.Text = lblVolume.Text + "FileType is..... " + fstype.ToString() + " \n";
}
}
ok = false;
}
Cursor.Current = Cursors.Default;
}

Hope this will helpful to you....

...S.VinothkumaR.

Nokia Secret Codes

2007-12-19T02:44:00.000-08:00

*#06# for checking the IMEI (International Mobile Equipment Identity).

*#7780# reset to factory settings.

*#67705646# This will clear the LCD display(operator logo).

*#0000# To view software version.

*#2820# Bluetooth device address.

*#746025625# Sim clock allowed status.

#pw+1234567890+1# Shows if sim have restrictions.

*#92702689# - takes you to a secret menu where you may find some of the information below:

1. Displays Serial Number.

2. Displays the Month and Year of Manufacture

3. Displays (if there) the date where the phone was purchased (MMYY)

4. Displays the date of the last repair - if found (0000)

5. Shows life timer of phone (time passes since last start)

*#3370# - Enhanced Full Rate Codec (EFR) activation. Increase signal strength, better signal reception. It also help if u want to use GPRS and the service is not responding or too slow. Phone battery will drain faster though.

*#3370* - (EFR) deactivation. Phone will automatically restart. Increase battery life by 30% because phone receives less signal from network.

*#4720# - Half Rate Codec activation.

*#4720* - Half Rate Codec deactivation. The phone will automatically restart

If you forgot wallet code for Nokia S60 phone, use this code reset: *#7370925538#

Note, your data in the wallet will be erased. Phone will ask you the lock code. Default lock code is: 12345

Press *#3925538# to delete the contents and code of wallet.

Unlock service provider: Insert sim, turn phone on and press vol up(arrow keys) for 3 seconds, should say pin code. Press C,then press * message should flash, press * again and 04*pin*pin*pin# \

*#7328748263373738# resets security code.

Default security code is 12345

Change closed caller group (settings >security settings>user groups) to 00000 and ure phone will sound the message tone when you are near a radar speed trap. Setting it to 500 will cause your phone 2 set off security alarms at shop exits, gr8 for practical jokes! (works with some of the Nokia phones.) Press and hold "0" on the main screen to open wap browser.

...S.VinothkumaR.

Getting Disk Space using Management.

2007-12-11T04:17:00.000-08:00

Hi all,

Here is I'm going to getting disk space and free space using WMI. For that we must add refference System.Management.dll. The below is coding ...check it out...

using System.Management;

RadioButton rdDrives;
private void Form1_Load(object sender, EventArgs e)
{
int i = 10;
foreach (string drives in Environment.GetLogicalDrives())
{
rdDrives = new RadioButton();
rdDrives.Text = drives;
rdDrives.Top = i+20;
this.Controls.Add(rdDrives);
Application.DoEvents();
i = i + 40;
}
}

private void btnGetDiskSpace_Click(object sender, EventArgs e)
{
string drive = "";
RadioButton rd;
//Control[] control = this.Controls.Find("RadioButton", false);
for (int j = 0; j < rd =" (RadioButton)this.Controls[j];" drive =" rd.Text;" drive =" drive.Substring(0,">

private void getSize(string drive)
{
ManagementObject diskSize = new ManagementObject("win32_logicaldisk.deviceid=\"" + drive + ":\"");
diskSize.Get();
lblSize.Text = "Disk Space in " + drive + " is :" + diskSize["Size"] + " bytes";
lblFreeSpace.Text = "Free space in " +drive +" is :" + diskSize["FreeSpace"] + " bytes";
}

OutPut:

That's it..

...S.VinothkumaR.

Getting Disk Information using DriveInfo in C#

2007-12-11T04:11:00.000-08:00

Hi all,

I'm going to display all disk's information (VolumeLable, File System, Total Space, FreeSpace ...etc). Here is the code...check it out.

private void Form1_Load(object sender, EventArgs e)
{
DriveInfo[] allDrives = DriveInfo.GetDrives();
Label lbl;
int i = 0;
foreach (DriveInfo d in allDrives)
{
lbl = new Label();
lbl.AutoSize = true;
lbl.Text = "Drive: " + d.Name.Substring(0,1) + "\n";
lbl.Text = lbl.Text + "FileType: " + d.DriveType + "\n";
if (d.IsReady)
{
lbl.Text = lbl.Text + "Volume label: " + d.VolumeLabel+ "\n";
lbl.Text = lbl.Text + "File system: " + d.DriveFormat + "\n";
lbl.Text = lbl.Text + "Available space to current user: " + d.AvailableFreeSpace + "bytes\n";
lbl.Text = lbl.Text + "Total available space: " + d.TotalFreeSpace + "\n";
lbl.Text = lbl.Text + "Total size of drive: " + d.TotalSize + "\n";
}
lbl.Top = i;
this.Controls.Add(lbl);
i = i + 110;
}
}

That's it...

...S.VinothkumaR.

Convert .wav to .mp3 using Lame.exe in C#

2007-11-29T22:04:00.000-08:00

public void mciConvertWavMP3(string fileName, bool waitFlag)
{
//maxLen is in ms (1000 = 1 second)
string outfile= "-b 32 --resample 22.05 -m m \""+pworkingDir+fileName + "\" \"" + pworkingDir+fileName.Replace(".wav",".mp3")+"\"";
System.Diagnostics.ProcessStartInfo psi=new System.Diagnostics.ProcessStartInfo();
psi.FileName="\""+pworkingDir+"lame.exe"+"\"";
psi.Arguments=outfile;
//psi.WorkingDirectory=pworkingDir;
psi.WindowStyle=System.Diagnostics.ProcessWindowStyle.Minimized;
System.Diagnostics.Process p=System.Diagnostics.Process.Start(psi);
if (waitFlag)
{
p.WaitForExit();
// wait for exit of called application
}
}

This code will help us to convert .wav file in to .mp3

...S.VinothkumaR.

Compress mp3 file using Lame.exe in C#

2007-11-29T21:55:00.000-08:00

We can compress mp3 file using Lame.exe easily as follows. The following code will help us to reduce the mp3 file’s size without losing much more of quality. For that we need to put lame.exe file in our folder. Find lame.exe and download it.

Code:

private void mp3Encode(string srcFileName, string targetFileName)
{
if (!string.IsNullOrEmpty(srcFileName) &&
!string.IsNullOrEmpty(targetFileName))
{
try
{
string workingDir = AppDomain.CurrentDomain.BaseDirectory + "\\";
string outfile = "-V9 -q0 --resample 32 -B56 --verbose " + '"' + srcFileName + "\" \"" +
targetFileName + "\"";
System.Diagnostics.ProcessStartInfo psi = new System.Diagnostics.ProcessStartInfo();
psi.FileName = workingDir + "lame.exe";
psi.Arguments = outfile;
psi.WindowStyle = System.Diagnostics.ProcessWindowStyle.Hidden;
p = System.Diagnostics.Process.Start(psi);
while (p.HasExited == false)
{
Thread.Sleep(10);
Application.DoEvents();
}
p.Dispose();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}

private void frmConvertor_FormClosing(object sender, FormClosingEventArgs e)
{
if (p != null)
{
p.Dispose();
}
}

Hope this will help us to reduce our mp3 file’s size…

....S.VinothkumaR.

mciSendString in C#

2007-11-29T21:46:00.000-08:00

The mciSendString function sends a command string to an MCI device. The device that the command is sent to is specified in the command string.

Code:

using System.Runtime.InteropServices;

[DllImport("winmm.dll")]
private static extern long mciSendString(string strCommand, StringBuilder strReturn, int iReturnLength, IntPtr oCallback);

public string playCommand;
public string fileName;
public bool isPlay = false;
public bool isStop = false;

private void frmPlayer_Load(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(fileName))
{
try
{
if (File.Exists(fileName))
{
if (isPlay)
{
playCommand = "Close MediaFile";
mciSendString(playCommand, null, 0, IntPtr.Zero);
isPlay = false;
isStop = true;
}
playCommand = "open \"" + fileName + "\" type mpegvideo alias MediaFile";
mciSendString(playCommand, null, 0, IntPtr.Zero);
playCommand = "play MediaFile";
mciSendString(playCommand, null, 0, IntPtr.Zero);
isPlay = true;
btnPlayPlayer.Enabled = true;
btnPause.Enabled = true;
btnStop.Enabled = true;
}
else
{
isPlay = false;
btnPlayPlayer.Enabled = false;
btnPause.Enabled = false;
btnStop.Enabled = false;
MessageBox.Show("Invalid File!");
}
}
catch (Exception ex)
{
isPlay = false;
btnPlayPlayer.Enabled = false;
btnPause.Enabled = false;
btnStop.Enabled = false;
MessageBox.Show(ex.Message);
}
}
}

private void btnPlayPlayer_Click(object sender, EventArgs e)
{
if (!isPlay)
{
if (isStop)
{
playCommand = "open \"" + fileName + "\" type mpegvideo alias MediaFile";
mciSendString(playCommand, null, 0, IntPtr.Zero);
playCommand = "play MediaFile";
mciSendString(playCommand, null, 0, IntPtr.Zero);
isPlay = true;
isStop = false;
}
else
{
playCommand = "play MediaFile";
mciSendString(playCommand, null, 0, IntPtr.Zero);
isPlay = true;
}
}
}

private void btnPause_Click(object sender, EventArgs e)
{
if (isPlay)
{
playCommand = "pause MediaFile";
mciSendString(playCommand, null, 0, IntPtr.Zero);
isPlay = false;
}
}

private void btnStop_Click(object sender, EventArgs e)
{
if (isPlay)
{
playCommand = "Close MediaFile";
mciSendString(playCommand, null, 0, IntPtr.Zero);
isPlay = false;
isStop = true;
}
}

This coding will help us to play media file…

....S.VinothkumaR.

Launch Configuration for Android application in Eclipse

2007-11-21T23:28:00.000-08:00

Before you can run and debug your application in Eclipse, you must create a launch configuration for it. A launch configuration specifies the project to launch, the Activity to start, the emulator options to use, and so on.

To create a launch configuration for the application, follow these steps:

1. Select Run > Open Run Dialog... or Run > Open Debug Dialog... as appropriate.

2. In the project type list on the left, right-click Android Application and select New.

3. Enter a name for your configuration.

4. On the Android tab, browse for the project and Activity to start.

5. On the Emulator tab, set the desired screen and network properties

6. You can set additional options on the Common tab as desired.

7. Press Apply to save the launch configuration, or press Run or Debug (as appropriate).

....S.VinothkumaR.

Creating an Android application in Eclipse

2007-11-21T23:24:00.000-08:00

The ADT plugin provides a New Project Wizard that you can use to quickly create an Eclipse project for new or existing code. To create the project, follow these steps:

1. Select File > New > Project
2. Select Android > Android Project, and press Next
3. Select the contents for the project:

- Select Create new project in workspace to start a project for new code.

Enter the project name, the base package name, the name of a single Activity class to create as a stub .java file, and a name to use for your application.

- Select Create project from existing source to start a project from existing code. Use this option if you want to build and run any of the sample applications included with the SDK. The sample applications are located in the samples/ directory in the SDK.

Browse to the directory containing the existing source code and click OK. If the directory contains a valid Android manifest file, the ADT plugin fills in the package, activity, and application names for you.

4. Press Finish.

The ADT plugin creates the these folders and files for you as appropriate for the type of project:

- src/ A folder that includes your stub .java Activity file.
- res/ A folder for your resources.
- AndroidManifest.xml The manifest for your project.

.....S.VinothkumaR.

Download and Install Android SDK

2007-11-21T23:13:00.000-08:00

You can download the Android SDK at here...

We can develop Android application using eclipse IDE. For that we have to update the eclipse plugin as follows.

1. Start Eclipse, then select Help > Software Updates > Find and Install....

2. In the dialog that appears, select Search for new features to install and press Next.

3. Press New Remote Site.

4. In the resulting dialog box, enter a name for the remote site (e.g. Android Plugin) and enter this as its URL:

https://dl-ssl.google.com/android/eclipse/

Press OK.

5. You should now see the new site added to the search list (and checked). Press Finish.

6. In the subsequent Search Results dialog box, select the checkbox for Android Plugin > Eclipse Integration > Android Development Tools and press Next.

7. Read the license agreement and then select Accept terms of the license agreement, if appropriate. Press Next.

8. Press Finish.

9. The ADT plugin is not signed; you can accept the installation anyway by pressing Install All.
10. Restart Eclipse.

11. After restart, update your Eclipse preferences to point to the SDK directory:

a) Select Window > Preferences... to open the Preferences panel. (Mac OS X: Eclipse > Preferences)

b) Select Android from the left panel.

c) For the SDK Location in the main panel, press Browse... and locate the SDK directory.

d) Press Apply, then OK.

Updating the ADT Plugin

To update the ADT plugin to the latest version, follow these steps:

1. Select Help > Software Updates > Find and Install....
2. Select Search for updates of the currently installed features and press Finish.
3. If any update for ADT is available, select and install.

Alternatively,

1. Select Help > Software Updates > Manage Configuration.
2. Navigate down the tree and select Android Development Tools
3. Select Scan for Updates under Available Tasks.

That's it...

...S.VinothkumaR.

Android

2007-11-21T23:10:00.000-08:00

The Android platform is a software stack for mobile devices including an operating system, middleware and key applications. Developers can create applications for the platform using the Android SDK. Applications are written using the Java programming language and run on Dalvik, a custom virtual machine designed for embedded use which runs on top of a Linux kernel.

If you want to know how to develop applications for Android, you can visit the google android page...

Image Uploading in ASP.NET using C#

2007-11-21T22:34:00.000-08:00

This is way I’m trying to explain an image uploading in asp.net using C#.

Here is I’m going to post image in to an url with image byte array. On there a page will save that image byte array in to image in given path.

POST IMAGE

As I mentioned above, the following method is going to use post image.

using System.Net;
using System.Text;
using System.IO;
using System.Drawing.Imaging;
using System.Drawing;

private void postImage()
{
HttpWebRequest request;
request = (HttpWebRequest)HttpWebRequest.Create("url");
request.KeepAlive = true;
request.Method = "POST";
byte[] byteArray = ConvertImageToByteArray((System.Drawing.Image)new Bitmap(@"C:\test.jpg"), ImageFormat.Jpeg);
request.ContentType = "image/JPEG";
request.ContentLength = byteArray.Length;
Stream newStream = request.GetRequestStream();
newStream.Write(byteArray, 0, byteArray.Length);
newStream.Close();
}

private static byte[] ConvertImageToByteArray(System.Drawing.Image imageToConvert,ImageFormat formatOfImage)
{
byte[] Ret;
try
{

using (MemoryStream ms = new MemoryStream())
{
imageToConvert.Save(ms, formatOfImage);
Ret = ms.ToArray();
}
}
catch (Exception) { throw; }

return Ret;
}

From above the method postImage() will post the image in to given url as byte array. And the method ConvertImageToByteArray(System.Drawing.Image imageToConvert,ImageFormat formatOfImage) will help us for getting byte array from an image.

UPLOAD IMAGE

The following code will help us save the image….

using System.IO;
using System.Drawing;
using System.Drawing.Imaging;
using System.Net;
using System.Text;

protected void Page_Load(object sender, EventArgs e)
{
try
{
string dirPath = Server.MapPath("Asset") + "\\" ;
Guid imgId = Guid.NewGuid();
string imgPath = dirPath + "\\" + imgId.ToString() + ".jpg";
Response.ContentType = "image/JPEG";
System.Drawing.Image img = Bitmap.FromStream(Page.Request.InputStream);
img.Save(imgPath, ImageFormat.Jpeg);
}
catch { }
}

That's it....

...S.VinothkumaR.

Getting byte array from an image.

2007-11-21T22:29:00.000-08:00

private static byte[] ConvertImageToByteArray(System.Drawing.Image imageToConvert,ImageFormat formatOfImage)
{
byte[] Ret;
try
{

using (MemoryStream ms = new MemoryStream())
{
imageToConvert.Save(ms, formatOfImage);
Ret = ms.ToArray();
}
}
catch (Exception) { throw; }

return Ret;
}

...S.VinothkumaR.

Boxing And UnBoxing

2007-11-15T04:30:00.000-08:00

Boxing and Unboxing are two important portions of .NET technology. Boxing is nothing but converting a value type object to a reference type object. Unboxing is completely explicit.

Now let us get an idea regarding reference type and value type objects. We all know that a new operator returns the memory address of an object that is allocated from the managed memory (a pool of memory). We usually store this address in a variable for our convenience. These types of variables are known as reference variables. However, the value type variables are not supposed to have the references; they always used to have the object itself and not the reference to it.

Now if we consider the statement written above in Listing 3, the C# compiler will detect System.Int32 as a value type and the object is not allocated from the memory heap, assuming this as an unmanaged one.

In a general way we should declare a type as a value type if the following are true.

1. The type should be a primitive type.
2. The type does not need to be inherited from any other types available.
3. No other types should also be derived from it.

This example shows how an integer type is converted to a reference type using the boxing and then unboxed from the object type to the integer type.

class Test
{
static void Main()
{
int i = 1; // i is an integer. It is a value type variable.
object o = i;
// boxing is happening. The integer type is parsed to //object type
int j = (int)o;
// unboxing is happening. The object type is unboxed to //the value type
}
}

Leap Year checking in Javascript

2007-11-15T01:43:00.000-08:00

Hi all,

Here is I'm going to check the given year is leap or not...How to do....check it out..

I don't state that this code is perfect but it does work.

Just copy and paste the following function in to script tag inside the header tag so that it can be called from anywhere in this HTML document.

function isleap()
{
var yr=document.getElementById("year").value;
if ((parseInt(yr)%4) == 0)
{
if (parseInt(yr)%100 == 0)
{
if (parseInt(yr)%400 != 0)
{
alert("Not Leap");
return "false";
}
if (parseInt(yr)%400 == 0)
{
alert("Leap");
return "true";
}
}
if (parseInt(yr)%100 != 0)
{
alert("Leap");
return "true";
}
}
if ((parseInt(yr)%4) != 0)
{
alert("Not Leap");
return "false";
}
}

Basically this code gives the rules to check if a year is a leap year. If the year is no divisible by 4 then it is not a leap year. If the year is divisible by 100 but not by 400 then it is not a leap year. Otherwise the remaining options leave us with a leap year so I hard coded what to do. The Reason I have coded in what to do otherwise is to highlight the two different statements of verifying that something does match and verifying something does not match.

Just call this script function where you want...as follows,

onclick="isleap()"

that's it....

...S.VinothkumaR.

Caching in ASP.NET 2.0

2007-11-13T05:51:00.000-08:00

Here is the different kind of caching that you can use in your web applications:

· Output Caching

· Fragment Caching

· Data Caching

· Cache Configuration

Output Caching

Performance is improved in an ASP.NET application by caching the rendered markup and serving the cached version of the markup until the cache expires. For example, if you have a page that displays user information from a database, caching will help improve performance by serving the page from memory instead of making a connection to the database on each page request.

You can cache a page by using the OutputCache API or simply by using the @OutputCache directive.

<%@ Page Language=”C#” %>

<%@ OutputCache Duration=”15” VaryByParam=”none” %>

The above cache directive will cache the page for 15 minutes.

So output caching is great for when you want to cache an entire page.

Fragment Caching

In many situations caching the entire page just isn’t going to cut it, for some reason or another you require specific sections of the page to display live information. One way to improve performance is to analyze your page and identify objects that require a substantial overhead to run. You can build a list of these objects that are expensive to run, and then cache them for a period of time using fragment caching.

For example, say your page default.aspx consists of three user controls. After looking over the code, you identified that you can cache one of them. You can simply add the caching directive to the top of the user control:

<%@ Control %>

<%@ OutputCache Duration=”5” VaryByParam=”none” %>

Now keep in mind that the actual page that contains the control is not cached, only the user control. This means that the default.aspx page will be rendered each and every page request, but the user control is only ‘run’ every 15 minutes.

Data Caching

So we know that we can cache an entire page, or a fragment of a page by caching down to the user control level. Wouldn’t it be great if we could cache down to the object level? The good news is you can with ASP.NET Data caching.

The cache consists of a dictionary collection that is private to each application in memory. To insert items in the cache simply provide the collection with a unique name:

Cache[“someKey”] = myObject;

Retrieving the object form the cache:

myObject = (MyObject)Cache[“someKey”];

It is a good time to point out that you should always remember to check for null, and be sure to caste to your datatype.

Cache Configuration

If you are familiar with how caching worked in ASP.NET 1.0, you realize that managing all the cache directions for all your pages could potentially get out of hand. ASP.NET 2.0 introduces Cache Profiles that helps you centrally manage your cache. Cache settings can be inherited by your pages, and overridden if required by using the OutputCache directive.

The page directive looks pretty much the same, expect this time it references a cache profile that you defined in your web.config file.

So each and every page that references the ‘myCacheProfile1’ can be centrally managed in the web.config, this means that any changes to the cache settings in the web.config file will be automatically changed on all your referenced pages.

...S.VinothkumaR.