Tricks and tips in .net with easy codes

Simple version control using TortoiseSVN 1.7.7 Part 2

2012-07-29T01:20:00.001-07:00

Procedure 2 :

I guess you have read the first part : if not then for reference the link is :
Simple Version Control Using Tortoise SVN 1.7.7 Part 1

I have a project folder called Folder Locker somewhere in my hard disk which i want to control using SVN . For the viewing benefit i have put it inside the same directory but you can put them any different directories .
Now i will create a working repository for my project which by the way mean check out an d we will simply put a copy of our project or the main project itself into the working repository .For this I have created a folder "Sub Version Repo" and it looks like this .

Now we will check out the Repository into Sub Version Repo .
Its simple just right click on Sub Version Repo and click on SVN Checkout

This window will appear, where URL or repository has already taken repository path and my created My Project Folder we can delete the path and browse repository from anywhere . below this containing the sub version repo i.e. the check out directory , No need to change anything right now . Just click OK .

It will show Checkout finished got our first revision .
SVN does this numbering for their tracking purpose.
You will see a .svn file (if your view hidden files and folder property is set true), never ever delete these files , they are really important .

OK, now we will copy our project file into the
checked out directory "Sub Version Repo"
since they are not still added to our version controller it looks like this :

We need to add it

To add the project we will right click on the sub Version Repo go to
TortoiseSVN and at the bottom of the ling menu click on Add ,it will show a checked list of all the files and the folders inside the main directory . for the first time click ok .

This will add the project to the svn and now we will commit our project to the svn .Right click on the directory and click on svn commit . you will see all the files and folders are with green right arrow .
So this mean we have got a ready to work , completely version controlled project environment .

Now suppose we this workable project folder in another PC connected to the environment with tortoise svn installed . we don't need to copy and paste all the files . We can create URL of the project like this .

Right click inside the main directory, in the context men go to TortoiseSVN --> Repo browser
at the top of the window , int the text box beside the URL you will find the project folder url copy it to the different computer . there create a folder according the relevant name .
right click inside the directory .. in the context menu go to SVN check out , click it and in the text of URL of repository paste the copied link and click ok , all the project files will be successfully downloaded to the computer .

So that's for today , in next tutorial we will learn some basic using tips of svn .
If you find this article helpful please give your precious comment .

Simple version control using TortoiseSVN 1.7.7 Part 1

2012-07-28T22:22:00.000-07:00

Prelude :
In this tutorial i am going to demonstrate how to use a version control . But before that i will ask myself what is version control . There are several perfect definition you can find in the internet .To me its a system that controls the several versions of my project(any document) and by version it means any modification(Add/Modify/Delete) to the document .It is not much of a necessary when you are doing a project alone in your single PC , but in distributed architecture where several people working on a same project its the best possible way to control your project .

For further reference you can visit : http://en.wikipedia.org/wiki/Revision_control
OK , now this not a theoretical description of version controlling and that is why probably i am writing this article , because when i search internet i just needed a step by step procedure to work on Version Control using the user interface ( not using command line ) for the beginners and i didn't find any good. So if want more of a theoretical one there are thousand tutorials you can go through.

There are several s/w in market can be used for the system like :
Visual Source Safe , but in my demonstration i am going to use tortoiseSVN.
The current version of it is TortoiseSVN 1.7.7
you can download it from http://tortoisesvn.net/downloads.html as it is a open source software according to your OS ( 32 bit / 64 bit ). Its a simple installation . Do it . So our necessary environment is created .

Process 1 ( Creating Repository ) :
SVN repository is used to manage the files, folders, directories and any modifications made to the files, folders and directories .It contains the full history of the particular projects .
Create a folder on a directory which is always accessible and write permissible .
lets create C:\My Files\SVN Demonstration\Repository ( Rename it anything )

Its just an empty folder .
Lets create a repository here .
Right click on it , in the context menu TortoiseSVN click on Create Repository here , a small window will appear
click on Create folder structure .
it will create the folder structure inside repository .

Do not alter any of the files inside the created repository as it is very important .

I have a project folder merely small .
Create a folder for our Project in the newly created repository .
Right click on the folder Repository -->TortoiseSVN --> Repo-browser
and create a folder with relevant name

So our repository creation is complete and ready to use . The next part will be on the following link

Merge multiple rows into a single using T-Sql stuff function

2012-06-20T20:41:00.002-07:00

Some days ago i had a problem that I had a table of schemes they have unique scheme code , and a Manager table that contains all the managers . Multiple managers can be allotted to a scheme as well as a single can be . My requirement was to show all the managers under a scheme in a single row and column separated by comma . I wanted a small query and i was introduced to a new function stuff

For detail reference you can go through link :
http://msdn.microsoft.com/en-us/library/ms188043.aspx

So here is the example:

now if I use the simple stuff function ike

select STUFF((SELECT ','+FM.FUND_NAME FROM SCH_FUND SF INNER JOIN FUND_MANAGER FM ON SF.FUND_CODE=FM.FUND_CODE FOR XML PATH('')) , 1 , 1 , '' )

it will result

but to have the intended result i have done it like that

IF Object_ID('tempdb..#temp_sch_code') is Not Null

Begin

DROP TABLE #temp_sch_code

end

IF Object_ID('tempdb..#temp_result') is Not Null

Begin

DROP TABLE #temp_result

end

create table #temp_result -- because we will insert item into it in a loop

(

sch_code varchar(10),

FUND_MANAGERS VARCHAR(MAX)

)

declare @sch_code as varchar(10)

select sch_code,0 as ser_no into #temp_sch_code from SCHEME_INFO

while exists(select sch_code from #temp_sch_code where ser_no=0)

begin

select top 1 @sch_code=sch_code from #temp_sch_code where ser_no=0

INSERT INTO #temp_result

select @sch_code,STUFF((SELECT ','+FM.FUND_NAME FROM SCH_FUND SF INNER JOIN FUND_MANAGER FM ON SF.FUND_CODE=FM.FUND_CODE where SF.SCH_CODE=@sch_code FOR XML PATH('')) , 1 , 1 , '' )

update #temp_sch_code set ser_no=1 where sch_code = @sch_code

end

SELECT * from #temp_result

Which then returns :

Now i will explain a specific term

FOR XML PATH('')

Drag and Drop item between two list boxes when the source listbox is databound

2012-06-08T10:06:00.000-07:00

Hi , i am going to demonstrate an application where i will drag one item from a listbox and drop into another . The specialty here is that the source and the target both the list box will be data bound and so it will be a little tricky .

so lets first fill our source list box with data from database , but setting its datasource property .

listBox1.DataSource = dtable; // Some datatable contains data

listBox1.DisplayMember = "NAME";

listBox1.ValueMember = "Person_ID";

So this now looks like :

We declare a datatable globally which will change when the item is dropped .

DataTable dtableSelected = new DataTable();

dtableSelected.Columns.Add("Name");

dtableSelected.Columns.Add("Id");

DataColumn[] keys = new DataColumn[1];

DataColumn dc = dtableSelected.Columns["Id"];

keys[0] = dc;

dtableSelected.PrimaryKey = keys; // So that selected items are ubique

Now we will call the mousedown event for the source listbox where we will actually drag the selected items text and value field using DoDragDrop Function

private void listBox1_MouseDown(object sender, MouseEventArgs e)

{

if (listBox1.SelectedItems.Count == 0)

return;

DataRowView view = (DataRowView)listBox1.SelectedItem;

DragDropEffects dde1 = DoDragDrop(view,

DragDropEffects.All);

}

Next we will drop the dragged item into target listbox ( listbox2) So first we need to set the AllowDrop property of listbox2 to True . and call the next event .

private void listBox2_DragDrop(object sender, DragEventArgs e)

{

DataRowView drv = (DataRowView)e.Data.GetData(typeof(DataRowView));

try

{

DataRow dr = dtableSelected.NewRow();

dr["Name"] = drv["NAME"].ToString();

dr["Id"] = drv["Person_ID"].ToString();

dtableSelected.Rows.Add(dr);

listBox2.DataSource = dtableSelected;

listBox2.DisplayMember = "Name";

listBox2.ValueMember = "Id";

}

catch (ConstraintException ex)

{

MessageBox.Show(drv["NAME"].ToString() + "is already added to list ." + '\n' + '\n' + ex.Message.ToString());

}

And during dragging we will do just a bit effect

private void listBox2_DragOver(object sender, DragEventArgs e)

{

e.Effect = DragDropEffects.Move;

}

The code is pretty easy . And dragging effect always gives a cool and rel type effect .

Split a string into table rows

2012-05-28T08:08:00.000-07:00

Hi guys , this is a small demonstration where i am going to show how you can split a string joined by some delimiter ( here comma ) , and create table rows from them . This is because sometimes we have to send big string joined by a separator to our Stored procedure and we have to loop through each item of it .. so here is this .. Suppose we have a big string like 'Sun Day,Mon Day,Tues Day,Wednesday Day'
its better to take varchar(MAX) .. here is our code :

IF Object_ID('tempdb..#TempSch_Codes') is Not Null

Begin

DROP TABLE #TempSch_Codes

end

CREATE TABLE #TempSch_Codes (ITEM VARCHAR(Max),ISDONE INT,RowID int identity(1,1))

declare @name as varchar(MAX),

@intPos as int,

@portion as varchar(Max)

set @name='Sun Day,Mon Day,Tues Day,Wednesday Day' -- Main string --

while CHARINDEX(',',@name) > 0

begin

set @intPos=CHARINDEX(',',@name)

set @portion=SUBSTRING(@name,1,@intPos-1) -- get the particular portion ---

PRINT @portion

INSERT INTO #TempSch_Codes VALUES(LTRIM(@portion),0)

SET @name=REPLACE(@name,@portion+',','') -- refresh the main string again ---

end

PRINT @name

INSERT INTO #TempSch_Codes VALUES(LTRIM(@name),0)

SELECT * FROM #TempSch_Codes

Looping through the temporary table would give the result ..

Changing Datatype of a datatable column at runtime

2012-01-20T21:05:00.000-08:00

Suppose i have a datatable with data filled in .. but when i want to show the data in a grid view i want the date column ("dd / MMM / yyyy") to be formatted like yyyyMMdd ..this is more like a string .. so i will have to change the format of the data at the run time and bind it to the grid view . The datatable is
The common error when you want to change the data format , suppose for that case datetime to string is :
String was not recognized as a valid DateTime.Couldn't store <20110901> in date Column. Expected type is DateTime.

because when the data is filled in the column datatype is automatically set to datetime ...
now suppose we first change the type of the column datetime to string and then change the value ...
the error shows is :
Cannot change DataType of a column once it has data.

so we need the solution and we need empty datatable with respective columns datatype been changed and then insert the formatted value ... so our solution will be start by cloning a new data table from the current datatable .. hold all the data in an object array .. loop through it .. check the datacolumn if datetime ... if datetime then change the datatype of the cloned datatable to string .. then add the rows .. finally bind the cloned new data table to the gridview .. the code is following :

            DataSet ds = clsData.GetAllData();
            DataTable dt = ds.Tables["table"];

            DataTable formatDtble = dt.Clone();
            int countformat = 0;

            foreach (DataRow dr in dt.Rows)
            {
                object[] objData = dr.ItemArray;
                for (int i = 0; i < objData.Length; i++)
                {
                    DateTime date;

                    var val = objData[i].ToString();
                    if (DateTime.TryParse(val, out date))
                    {
                        date = Convert.ToDateTime(val);
                        string formatDt = date.ToString("yyyyMMdd");
                        val = formatDt;
                        if (countformat == 0)
                        {
                            formatDtble.Columns[i].DataType = typeof(string);
                        }
                        objData[i] = val.ToString();
                        formatDtble.Rows.Add(objData);
                    }
                }

                countformat = countformat + 1;

            }
            dataGridView1.DataSource =formatDtble;

Now the datatable looks like :

Thanks now .. this is for the case where you don't run a select statement with all the columns ie. more like a dynamic columns .. because if you fetch columns from database not dynamically then you can format it query .. not programmatically . bye bye ..

Items collection cannot be modified when the DataSource property is set - Problem is solved

2011-11-08T07:50:00.000-08:00

Its a common problem that several time we need to add a "-select item -" or some thing like that , at the top of the selection list like combo box , its no problem if we add item one by one in a loop but , it throws an exception while we set a datasource to the combo box , the error is "Items collection cannot be modified when the DataSource property is set." ,, but its solved if we deal it with datarow property , our common code is lie that ,,

combocategory.DataSource = ds.Tables["MST_CATEGORY"];
                    combocategory.DisplayMember = "CATEGORY_NAME";
                    combocategory.ValueMember = "CATEGORY_ID";
                    combocategory.Items.Insert(0, "-select-");

Now , we will change it to the following :

DataRow dr = ds.Tables["MST_CATEGORY"].NewRow(); // add a new row
dr[0] = "-- select --"; // add value to the row
ds.Tables["MST_CATEGORY"].Rows.InsertAt(dr, 0); // insert the row into the dataset

// at 0 position
                    combocategory.DataSource = ds.Tables["MST_CATEGORY"];
                    combocategory.DisplayMember = "CATEGORY_NAME";
                    combocategory.ValueMember = "CATEGORY_ID";

So problem is solved , Than you :)

Importance of GO statement in T-SQL

2011-10-15T10:30:00.000-07:00

We use 'GO' statement in sql server , programming , often we don't care about it , but its very important for long T_SQL programming , its actually batch terminator , as in my last article

http://mynecessarycode.blogspot.com/2011/10/get-nth-data-from-dattableabase-in-t.html#!/2011/10/get-nth-data-from-dattableabase-in-t.html

if i don't use the 'GO' keyword it will show error , i used GO so that i tell my program to do the rest of the wor after deleting the existing table

Easy way to export Excel data into a Datatable

2011-10-12T07:29:00.000-07:00

I have an excel file and i want to export all the data of the excel along with the headers into a DataTable for this i have the following excel file ,

i assume i don't know the last column name and all , so i will pass everything as a variable , to get the column name from the column index you must visit the following site
http://stackoverflow.com/questions/297213/translate-an-index-into-an-excel-column-name
, the function there "ColumnName" i have used

i am still giving you the function

string ColumnName(int index)
        {
            index -= 1; //adjust so it matches 0-indexed array rather than 1-indexed column

            int quotient = index / 26;
            if (quotient > 0)
                return ColumnName(quotient) + chars[index % 26].ToString();
            else
                return chars[index % 26].ToString();
        }
        private char[] chars = new char[] { 'A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J', 'K', 'L', 'M', 'N', 'O', 'P', 'Q', 'R', 'S', 'T', 'U', 'V', 'W', 'X', 'Y', 'Z' };

now the following code will export the excel into the datatable , read the comments as i have described the steps there : and the initializations are given in my previous posts , you can follow :
http://mynecessarycode.blogspot.com/2011/10/tips-and-tricks-on-manipulating-excel.html

the code is

exApp = new Excel.ApplicationClass(); // create application
            exApp.Visible = false;              // making application invisible

            exWb1 = exApp.Workbooks.Open(@"D:\Book1.xlsx", Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);
            Excel.Worksheet _sheet = (Excel.Worksheet)exWb1.Worksheets[1];

            var maxColCount = _sheet.UsedRange.Columns.Count;
            var maxColName = ColumnName(maxColCount);
            var maxRowCount = _sheet.UsedRange.Rows.Count;

            object[,] _val = (object[,])(_sheet.get_Range("A"+3,maxColName+maxRowCount)).Value2;
            #region here we create the datatable from the _val array

            DataTable dTable = new DataTable();

            // i starts from 1 as excel index always starts from 1
            for (int i = 1; i <= maxRowCount-2; i++) // since we dont count the first two rows
            {
                DataRow dRow = dTable.NewRow(); // add a new row
                for (int j = 1; j <= maxColCount; j++)
                {
                    if (i < 2)
                    {
                        // adding all the columns along with the same header as the excel
                        // it is added only in the first loop
                        dTable.Columns.Add(_sheet.get_Range(ColumnName(j)+1,ColumnName(j)+1).Value2.ToString());
                    }

                    // j-1 , since datatable index starts from 0
                    dRow[j - 1] = _val[i, j].ToString();
                }

                dTable.Rows.Add(dRow); // adding the row to the datatable
            }

            #endregion

            exWb1.Close(1, null, null);
            exApp.Quit();

so as long as you have the datatable you can manipulate it easily and show this anywhere .. thank you

Concepts of Range in Excel Application

2011-10-11T08:03:00.000-07:00

Range or Get_range() method is used widely in fetching data from excel sheet , but what is the exact meaning of range , suppose our previous work book Book1 which we had used , there except the heading the value started from A3 cell "Amit" and ends at the last cell D4 "9979" , so we need to fetch all the data s within this '
range , it is actually the two extreme ends of the excel , and this represents the rectangular area like this

So to get the full range of the data is retrieved by the following code :

var _value = ((Excel.Worksheet)exWb1.Worksheets[1]).get_Range("A3", "D" + ((Excel.Worksheet)exWb1.Worksheets[1]).UsedRange.Rows.Count).Value2;

object[,] _val = (object[,])((Excel.Worksheet)exWb1.Worksheets[1]).get_Range("A3", "D" + ((Excel.Worksheet)exWb1.Worksheets[1]).UsedRange.Rows.Count).Value2;

the used range is used to get the last used row of the excel .. as i have pass "D" the max column name , it can also be a variable

Tips and tricks on manipulating excel from codebehind in c# PART : 2

2011-10-11T07:20:00.000-07:00

Today i am going to demonstrate the following actions :

1) I have an excel with formatted headings , values and sheet name , i want to copy the entire work sheet to another excel workbook , like following

hard coded path of the files i have given must be changed ..

i have declared the excel application and the workbook class globally

Excel.ApplicationClass exApp; // Excel application
Excel.Workbook exWb1; // first workbook
Excel.Workbook exWb2; // second workbook

following commented block it will be easy to understand

exApp = new Excel.ApplicationClass(); // create application
            exApp.Visible = false;              // making application invisible

            exWb1 = exApp.Workbooks.Open(@"D:\Book1.xlsx",Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing);
            // open an workbook
            // i have given hard code path of the excel , but you must pass as variable
            // now we will add an excel workbook to our application and copy the first excel sheet to
            // second
            exWb2 = exApp.Workbooks.Add(Type.Missing);

            // i will copy 1st into 2nd after the three by default sheets
            ((Excel.Worksheet)exWb1.Worksheets[1]).Copy(Type.Missing, exWb2.Worksheets[exWb2.Worksheets.Count]);
            exWb2.SaveAs(@"D:\Copy_of_Book1.xlsx", Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing,Excel.XlSaveAsAccessMode.xlNoChange, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);
            // saving file path is also hard coded here you must change

            exWb1.Close(0, null, null);
            exWb2.Close(0,null,null);

            exApp.Quit(); // dont forget to quit the application

the copied excel looked like this

2) Suppose i have some value in the third row first column of the Book1 of the first picture , in how many ways i can retrieve the value ??
    A) The easiest way using get range :
            var _value = ((Excel.Worksheet)exWb1.Worksheets[1]).get_Range("A3", "A3").Value2;
            MessageBox.Show(_value.ToString());
    B )

How to detect mouse right click or left click on windows form

2011-10-10T11:08:00.000-07:00

Its easy to find which mouse button is been clicked , so first just double click on form's mouse click event and add the following code :

        private void Form1_MouseClick(object sender, MouseEventArgs e)
        {
            if (e.Button == MouseButtons.Left)
            {
                MessageBox.Show("Left click");
            }
            if (e.Button == MouseButtons.Right)
            {
                MessageBox.Show("Right click");
            }
        }

Tips and tricks on manipulating excel from codebehind in c# PART : 1

2011-10-10T07:27:00.000-07:00

These days i am working so much with Excel i felt a need to post those small tricks in a listed manner , this will have a several part as excel is a vast application probably one of my personal favorite product of Microsoft , i am starting with a base , to use the inbuilt classes of excel we need to first add the
1 ) Microsoft.Office.Interop.Excel dll from reference , the version is 12.0.0.0 is good and u will also have to add the namespace , same name .. but since it is so big and may be in application stage you may have some ambiguity so it is better to use an alias like
2) using Excel=Microsoft.Office.Interop.Excel so from now we can use Excel to call all the methods first
we will create an excel application , we create a single application and work entirely on that , otherwise our process will slowdown

Create , excel application :

Excel.ApplicationClass exApp=new Excel.ApplicationClass();
exApp.Visible = true;

Quit Excel Application :

exApp.Quit();

Add Workbook with no template :

Excel.Workbook exWb1=exApp.Workbooks.Add(Type.Missing);

Close Workbook without saving and without showing any alert :

exWb1.Close(0, null, null);

Workbook by default contains three sheets .. if you want to add your own sheet and name it before or after these sheets then do the following :

Before :( suppose at the extreme left )
exWb1.Worksheets.Add(exWb1.Worksheets[1], Type.Missing, Type.Missing, Type.Missing);
((Excel.Worksheet)exWb1.Worksheets[1]).Name = "My sheet";

After : (extreme right )
exWb1.Worksheets.Add(Type.Missing, exWb1.Worksheets[exWb1.Worksheets.Count], Type.Missing, Type.Missing);
((Excel.Worksheet)exWb1.Worksheets[exWb1.Worksheets.Count]).Name = "My sheet";

Now lets delete any sheet
((Excel.Worksheet)exWb1.Worksheets[1]).Delete();
delete the first sheet
but suppose i have 3 sheets and want to delete only the first three sheets then you cant simply repeat the above function twice more only changing the index for 2 and 3 .. you must try it and see what happens , i was once suffered from that problem
so to delete such sheets we need this , lets add two new sheets and delete the previous three sheets right !!

exWb1.Worksheets.Add(Type.Missing, exWb1.Worksheets[exWb1.Worksheets.Count],2, Type.Missing);
            ((Excel.Worksheet)exWb1.Worksheets[exWb1.Worksheets.Count-1]).Name = "My sheet1";
            ((Excel.Worksheet)exWb1.Worksheets[exWb1.Worksheets.Count]).Name = "My sheet2";

            for (int i = 1; i <= 3; i++)
            {
                ((Excel.Worksheet)exWb1.Worksheets[1]).Delete();
            }

in the work sheet add method i have passed 2 in the parameter count , so that at a time two sheets added to the workbook
these samples may be familiar to you , but this is just the base and may be good for the beginners like me

create a dynamic j-query an image scroller from a database images PART - 2

2011-10-04T04:54:00.000-07:00

In the previous article of the dynamic image scroller i wrote the html part of the application .. no i will write the code behind section .. first part we will fetch the active images order by their position ascending ... we add a linq to sql class from "add new item" and drag our table into the linq to sql class .. whole my project now look like this

you can see the database at left side server explorer and the project file at right hand side in the solution explorer

protected void imageAlbum()
    {
        #region fetch the result set into images
        DataClassesDataContext _dataBase = new DataClassesDataContext();
        var images = from tbl in _dataBase.TBL_IMAGEs
                     where tbl.ACTIVE_FLAG == 1
                     orderby tbl.IMAGE_POSITION ascending
                     select new { imageName = tbl.IMAGE_NAME };
        #endregion

        #region create the html tag

        HtmlGenericControl dvMain = new HtmlGenericControl("div");
        dvMain.Attributes.Add("id", "gallery");
        HtmlGenericControl ulMain = new HtmlGenericControl("ul");

        foreach (var image in images)
        {
            HtmlGenericControl li = new HtmlGenericControl("li");
            HtmlAnchor a = new HtmlAnchor();
            a.HRef = @"~\photos\" + image.imageName + ".jpg";

            HtmlImage img = new HtmlImage();
            img.Height = 72;
            img.Width = 72;
            img.Src = @"~\photos\" + "thumb_" + image.imageName + ".jpg";

            a.Controls.Add(img);
            li.Controls.Add(a);
            ulMain.Controls.Add(li);
        }

        dvMain.Controls.Add(ulMain);
        image_container.Controls.Add(dvMain);

        #endregion
    }

call this function in the pageload section ..
you will understand how it works if you compare the html part from the html file you download in jquery site and how i created them from code behind .. as they both are the same ...

run this ... for any problem ask me ... if you want to add a title to each image then just add a column title to database .. fetch the value and add to the anchor element "a" as the title attribute ...

create a dynamic j-query an image scroller from a database images PART - 1

2011-10-03T19:11:00.000-07:00

We often use j query in our websites to make it look gorgeous .. but most of the time you see them they are basically static .. ie suppose there is an image scroller like this

http://leandrovieira.com/projects/jquery/lightbox/
you can download the whole package from here ...

but in this , our images are static that is every time you need to change the position or change the image itself you will have do it from the html which is very much hazardous ... so it dynamic website we need to make it dynamic .. we will have an image database an any change on it will reflect in the image scroller in our website ... for this what we need most is the use of namespaces are

using System.Web.UI.HtmlControls; // for creating the html controls
using System.Xml.Linq; // i am gonna work on database using linq

after downloading the package you will find some folders css , images , js , photos and the html page , other than html we will copy all the folder and paste to the solution explorer of our website as we have no work there , they will work on their own
in the photos folder you will see two image one big and one thumb (small) ie when you create thumb it zoom , the zoom image is nothing but the bigger version of the thumbnail , now we will create the image database

CREATE TABLE [dbo].[TBL_IMAGE](
    [IMAGE_ID] [int] IDENTITY(1,1) NOT NULL,
    [IMAGE_NAME] [nvarchar](50) NULL,
    [IMAGE_POSITION] [int] NULL,
    [ACTIVE_FLAG] [tinyint] NULL,
CONSTRAINT [PK_TBL_IMAGE] PRIMARY KEY CLUSTERED
(
    [IMAGE_ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

and the insert the image name ( you can create your panel for inserting those image into the database )

INSERT INTO [TBL_IMAGE] VALUES ('image1',1,1)
INSERT INTO [TBL_IMAGE] VALUES ('image2',2,1)
INSERT INTO [TBL_IMAGE] VALUES ('image3',3,1)
INSERT INTO [TBL_IMAGE] VALUES ('image4',4,1)
INSERT INTO [TBL_IMAGE] VALUES ('image5',5,1)

now in our aspx.cs page we will have two region , one inner and one outer ..
in the outer region we will fetch data and in the inner region we will generate all the required html tages dynamically first drag all the required css and js file in the title section

so then our aspx page title will conatain these tags :
<script type="text/javascript" src="js/jquery.js"></script>
    <script type="text/javascript" src="js/jquery.lightbox-0.5.js"></script>
    <link rel="stylesheet" type="text/css" href="css/jquery.lightbox-0.5.css" media="screen" />
      <script type="text/javascript">
    $(function() {
        $('#gallery a').lightBox();
    });
    </script>
          <style type="text/css">
    /* jQuery lightBox plugin - Gallery style */
    #gallery {
        background-color: #444;
        padding: 10px;
        width: 520px;
    }
    #gallery ul { list-style: none; }
    #gallery ul li { display: inline; }
    #gallery ul img {
        border: 5px solid #3e3e3e;
        border-width: 5px 5px 20px;
    }
    #gallery ul a:hover img {
        border: 5px solid #fff;
        border-width: 5px 5px 20px;
        color: #fff;
    }
    #gallery ul a:hover { color: #fff; }
    </style>

in the body section we will create a div and make it dynamic so that we can access it from code behind . it will be our html code container .. tag looks like this :

<div id="image_container" runat="server">

    </div>

the next code behind part is on part 2 of this article . Read part 2 : PART 2
Continued ..

Create a method for fetching data into a dataset using any stored procedure with any nos of parameters

2011-09-27T11:45:00.000-07:00

A few days ago before i started work with entity data model and linq i worked with dataset a lot .. there i had to work with something like , i will create method to fetch data into dataset , ie i call it form other class i will simply pass the Stored procedure name and add the parameters .. that's all , so i had written the method in my base class and call it from the business layer .. that's way it add security to my application
Now the code for the base class was :

public DataSet FillDataSetUsingSP(SqlParameterCollection sql_param_col ,string sp_name)
        {
            DataSet ds = new DataSet();
            ConOpen(); // you must create the conopen method for opening the connection object
            SqlCommand cmd = new SqlCommand(sp_name,con);
             cmd.CommandType = CommandType.StoredProcedure;
                foreach (SqlParameter pm in sql_param_col)
                {
                    cmd.Parameters.AddWithValue(pm.ParameterName, pm.Value);
                }
                SqlDataAdapter da = new SqlDataAdapter(cmd);
                da.Fill(ds);


            return ds;

        }

so here our method is ready and we will call it in this way ..

ENTERPRISE_CLS encls = new ENTERPRISE_CLS(); // my base class name was ENTERPRISE_CLS
    public BUSINESS_ACCESS()
    {
        //
        // TODO: Add constructor logic here
        //
    }

    public DataSet Return_Data(string p, string q)
    {
        SqlParameterCollection spc = new SqlCommand().Parameters;

        spc.AddWithValue("@news_hdr", p);
        spc.AddWithValue("@news_lnk", q);
        DataSet ds = encls.FillDataSetUsingSP(spc, "retrieve_news_letter");
        return ds;
    }

we use SqlParameterCollection spc = new SqlCommand().Parameters;
to create the parameter collection and pass it , our stored procedure name is "retrieve_news_letter"

so if you have any query regarding this you can ask , i will soon create this for linq ...

Use one stored procedure inside PL/SQL block of another stored procedure

2011-09-26T08:45:00.000-07:00

You now how to use a stored procedure , i am just showing you how to use the result of one stored procedure inside another ... first i am creating a category and a subcategory .. one subcategory must have a category as parent .. i will simply use one stored procedure and i will also check whether the category exists or not .

the two code for creating two tables are :

CREATE TABLE [dbo].[CATAGORY](
    [CAT_ID] [int] IDENTITY(1,1) NOT NULL,
    [CAT_NAME] [varchar](50) NULL
) ON [PRIMARY]
and
CREATE TABLE [dbo].[SUB_CATAGORY](
    [SUB_CAT_ID] [int] NOT NULL,
    [CAT_ID] [int] NULL,
    [SUB_CAT_NAME] [varchar](50) NULL
) ON [PRIMARY]

Enter some values

INSERT INTO dbo.CATAGORY (CAT_NAME) VALUES ('INDIA')
INSERT INTO dbo.CATAGORY (CAT_NAME) VALUES ('AMERICA')
INSERT INTO dbo.CATAGORY (CAT_NAME) VALUES ('CHINA')
INSERT INTO dbo.CATAGORY (CAT_NAME) VALUES ('EUROPE')

Now i create a procedure that will get category name as input and result the category id in a out parameter

CREATE PROCEDURE SP_GET_CAT_ID
    @CAT_ID INT OUTPUT,
    @CAT_NAME VARCHAR(50)
AS BEGIN
    SELECT @CAT_ID=CAT_ID FROM dbo.CATAGORY WHERE CAT_NAME=@CAT_NAME
    PRINT @CAT_ID
    END

[ here i have simply get the category id inside the output parameter]
you can execute the query and see the result by the following query

DECLARE @CAT_OUT INT
EXEC SP_GET_CAT_ID @CAT_OUT,'INDIA'

now i will use this stored procedure inside a new stored procedure

CREATE PROCEDURE SP_INSERT_SUBCATEGORY
    @CAT_NAME VARCHAR(50),
    @SUB_CAT_NAME VARCHAR(50)
AS BEGIN
    DECLARE @CAT_ID INT
        -- GET THE CATEGORY ID FROM PREVIOUS STORED PROCEDUTE INTO
        -- THE VARIABLE @CAT_ID
        EXEC SP_GET_CAT_ID @CAT_ID OUTPUT,@CAT_NAME

        -- CHECKING IF THE RETURN VALUE EXISTS THAT IS NULL
    IF @CAT_ID IS NOT NULL

            INSERT INTO dbo.SUB_CATAGORY (CAT_ID,SUB_CAT_NAME) VALUES (@CAT_ID,@SUB_CAT_NAME)

    ELSE
            PRINT ' NO SUCH CATEGORY EXISTS THERE !!!'

END

CHECK THE PROCEDURE BY EXECUTING

SP_INSERT_SUBCATEGORY 'AMERICA','WISCONSIN'

for an other value that does not belong to the category table you will get the error message .. . so you find it very secure because when you will need to add a sub category under a category you dont need much to write in code just call the second stored procedure ..

Problem with Result and Result Specified parameters in WCF service

2011-09-21T08:13:00.000-07:00

There is a common problem in wcf that you have two extra parameters *Result and *Result Specified while invoking the methods .. this means that the serialization format is not done .. so for this you simply need to add or replace the following code above your IService Interface :

[ServiceContract ( Namespace="http://www.yoursite.com/"),XmlSerializerFormat]

if you have already add the service to your IIS and create reference to your website then dont worry , simply do the following steps:
1) rebuild the service library
2)delete the previously added DLL file to your service website and add the rebuild dll , save the changes
3) the IIS will automatically reconfigure it since it is mapped to the file
4)in your application where you have referenced the service simply right click on App_WebReferences folder and click "Update Web/Service Reference" and the problem is solved , call the methods and no problem arise ...

thank you ...

Calling WCF Service Hosted in IIS and invoke the methods

2011-09-21T07:51:00.000-07:00

So far we have created a service and hosted the service in the IIS of our computer .. if you are straight to this page and want to view those article the you can go through the following links :
Part : 1
Part : 2
Part : 3

now our service url is "http://localhost/RegIIS/Service.svc" and if we run this in our browser ( i.e. simply copy and paste in the address bar ) then we will see the following

Our service has two Boolean methods
1) login , 2) registration
so we will invoke them from our application ... so for that first create a website , and create a form for log in as i am going to explain for log in , if you understand it you can invoke the method registration easily

i have created a form have two text boxes for user id and password , one log in button , and a label to show the message ... my form looks like this ,,

its not that good to look , make your own
log in and registration form ...

Now we will add the service reference to our website ,
for this right click on your solution explorer , click on "Add Web Reference" , in the opened window paste the service URL you have and hit "Go" ..
it will search the service and find it .. give a name to your namespace as we will need it later ..

I have given "RegestrationIIS" , now click Add Reference it will add all the file and folder structure to you solution ..

see the App_WebReference folder has been added automatically ..
now in our code behind we will add the namespace by calling it

using RegestrationIIS;

then we will create an instance of our class Service1 ( for good practice you should give proper name to your class )
RegestrationIIS.Service1 _service = new RegestrationIIS.Service1();

in our button click event i have declared a Boolean variable "result" that holds the result of login
we can call the method now
bool result = _service.login(txt_user_id.Text, txt_pwd.Text);

(you can probably have an error of two extra parameters result and result specified parameters you can solve them by reading my following article)
Click here to read the article

if it returns true the successful login else there is an error

so the full and final code goes like this :

using System;
using System.Configuration;
using System.Data;
using RegestrationIIS;

public partial class _Default : System.Web.UI.Page
{
    RegestrationIIS.Service1 _service = new RegestrationIIS.Service1();
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void btnlogin_Click(object sender, EventArgs e)
    {
        bool result = _service.login(txt_user_id.Text, txt_pwd.Text);
        if (result)
        {
            lblerror.Text = "Log in successfully";
        }
        else
        {
            lblerror.Text = "Error occurred .. try again";
            txt_pwd.Text = "";
        }
    }
}
so we have successfully invoke the methods of our WCF Service hosted in IIS in our website ... if there is any problem to understand anywhere you can post or email me at somabrata.roy1986@gmail.com ...

thank you now ..

Format and return all the texts from a website according to your neded pattern

2011-09-21T05:57:00.000-07:00

In my earlier blog post Click here to view my post I have mentioned a method DownloadString(string Url) which i have used to download all the contents from a web page , but to search a specific type of URL i had to format those texts because they were pretty haphazard and non-arranged , its like i need to wrap them up with my search pattern , i wanted to rearrange them with"<img " tag as i had to get all the strings that contains "<img src" tag , so my code here was :

suppose i have a string variable "string body" that containsall the text of the web page

string[] stringSeparators = new string[] { "<img" };

string[] _str_arr = body.Split(stringSeparators, StringSplitOptions.RemoveEmptyEntries);

the first line declares a string array holds all search of match pattern "stringSeparators "

in the next i have split the full string with the pattern with a "StringSplitOptions.RemoveEmptyEntries"
with which a have rejected all those strings that have return a null string or not matched to my pattern
watch carefully the following images

click the image link to see it bigger ,
anyway you can see that it returns an array with all element starting with "src" , obviously they are started with "<img" and they are all the image links ...

so that's it we get what we want

if you find it helpful or get any query please post comment here ..

thank you

Download all images from a web URL

2011-09-20T03:01:00.000-07:00

This is me demonstrating an application where you will get all the images from a web URL , and you can download them at once in a zip format , this is an application in process ,,, i have some of the functions i have used and i have written , i will modify this code to 100% accuracy soon till then you can try and work with this methods

I am adding an image of the application so that you understand it

static int count = 1;

static int image_count = 0;

private string DownloadString(string Url)

{

// Open a connection

HttpWebRequest WebRequestObject = (HttpWebRequest)HttpWebRequest.Create(Url);

// You can also specify additional header values like

// the user agent or the referer:

WebRequestObject.UserAgent = ".NET Framework/2.0";

WebRequestObject.Referer = "http://www.example.com/";

// Request response:

WebResponse Response = WebRequestObject.GetResponse();

// Open data stream:

Stream WebStream = Response.GetResponseStream();

// Create reader object:

StreamReader Reader = new StreamReader(WebStream);

// Read the entire stream content:

string PageContent = Reader.ReadToEnd();

// Cleanup

Reader.Close();

WebStream.Close();

Response.Close();

txtcontent.Text = PageContent;

return PageContent;

}

private void ReaDImageTag(string body)

{

try

{

string web_url = getUrl(txturl.Text);

string[] stringSeparators = new string[] { "<img" };

string[] _str_arr = body.Split(stringSeparators, StringSplitOptions.RemoveEmptyEntries);

string final_go_to_url = "";

ArrayList _str_url = new ArrayList();

for (int i = 1; i < _str_arr.Count(); i++)

{

string p = _str_arr.ElementAt(i).ToString();

if (p.Contains("src="))

{

string q = Regex.Replace(p, "[\n\r\t]", " ");

int start_index = q.IndexOf("src=");

int start_index_mod = start_index + 5;

string str_url = q.Substring(start_index_mod, 100);

int f_occr_of_invertd_com = str_url.IndexOf('"',start_index_mod+1);

string finalUrl = str_url.Substring(0, f_occr_of_invertd_com);

if (finalUrl.StartsWith("http://"))

{

final_go_to_url = finalUrl;

}

else

{

if (finalUrl.StartsWith(@"/"))

{

final_go_to_url = web_url + finalUrl;

}

else

{

final_go_to_url = web_url + @"/" + finalUrl;

}

HtmlAnchor ha = new HtmlAnchor();

HtmlImage img = new HtmlImage();

img.Src = final_go_to_url;

img.Height = 100;

img.Width = 100;

ha.HRef = final_go_to_url;

ha.Target = "_blank";

HtmlGenericControl br = new HtmlGenericControl("br");

ha.Controls.Add(img);

div_link.Controls.Add(ha);

div_link.Controls.Add(br);

}

count = count + 1;

image_count = image_count + 1;

}

lblcount.Text = "Images found in the url" + " " + image_count.ToString();

}

catch (Exception ex)

{

Response.Write(ex.Message.ToString());

}

private string getUrl(string url)

{

string host_name = "";

string[] array_host = new string[] { ".com",".co.in",".net",".org",".co.uk"};

for (int i = 0; i < array_host.Count(); i++)

{

if (url.Contains(array_host[i].ToString()))

{

host_name = array_host[i].ToString();

break;

}

else

{

}

int index = url.LastIndexOf(host_name);

string str_url = url.Substring(0, index + host_name.Length);

return str_url;

}

How to hit offcampus in a good IT company

2011-09-19T19:26:00.000-07:00

This is specially for the MCA students who does not always get all the facilities of on campus job but capable in all aspects . I am not a consultant but i have gone through the same thing . I also didn't get job in campus at my college , I worked as a fresher in a small software company for 1year , but Now i am in position where i wanted to to see me and i got work of my domain .

I am just going to give you some steps that i followed , and hope you will find this helpful:

1) Make your domain knowledge as strong as possible (eg. if you are in IT software make your Database knowledge strong for whatever language you use ) anyways keep updating your knowledge

2) Make a resume that will highlight your projects and work that you have done so far , add details .

3)Create your profile in all sorts of big job portals because may be they send irrelevant email all the time , but lots of consultants are there who looks for fresher resume and give opportunity . To start your career with job given by a consultancy is not that bad as after gaining some experience you will be at a good position

4) Keep updating your profile once in week , that will make your resume available to the recruiter .

5)Don't sit at home idly , if you get any job in your domain do it for any salary but look for their contract first .

6)If you have some discrepancy in your academics then a 1yr experience in IT industry will remove that , as the recruiter will try to find what you know in that domain , not what you scored at you 12th,Graduation or Masters

7) To reach to the recruiter directly , try search with keyword in Google like that "Your domain"+location(don't give if you have no problems to travel anywhere in India)+"Fresher"+"job" (optional) Google will show you thousands of results and thousands of companies . Go to their sites go to career page there will be either a form to enter , upload your cv or their will be email-id of the HR , mail your resume with a cover letter , a cover letter yo can use if you want .

8) Subscribe your email-id to any kind of job sites

Go for all opportunities , the recruiters will find you , Job will be at your door . One year may be needed , but after that you will get placed surely

Thank you friend ... if you find my advice helpful you can subscribe or enlist yourself in the followers list.

Part 3 : Host WCF application in IIS

2011-09-18T09:09:00.000-07:00

Step 1 : We will add a website of wcfService : right click on solution --> add niew item --> website --> select wcfservice , give name "WCFServiceRegestration" it will add a service file Service.svc it will add two more file in the appcode folder , but we will delete them as we dont need them

Step 2 : We will add the reference the dll file of our wcf service in the website

Step 3 : open the svc file and add the following code
<%@ ServiceHost Language="C#" Debug="true" Service="ServiceRegistration.Service1" %>
Service="ServiceRegistration.Service1" follow the namespace.class hierarchy of your Service1.cs class in the wcf class , you can understand ... its too easy for you now
RightClick on the service file and click browse , so you will get the service WSDL :
http://localhost:1547/WCFServiceRegestration/Service.svc

Step 4: Now lets edit our configuration file , right click on the the web.config file and click "Edit WCF Configuration"
the next part will be explained to the video , you will get it best from the following youtube video
Go to the URL but at the end of the section i will show you how to host in IIS 5.1 version

Step 5 : go to run section -- click inetmgr --> enter it will open IIS Manager , go to websites -->right click Default Websites --> New --> Virtual Directory , it will open Virtula directory creation wizard --> click next --> Give alias (any name ) ("RegIIS") --> Click Next --> browse the website path and -->click next --> check browse , read and run as script click next and finish

Step 6 : It will add the web site in the list in the left website tree view click and it will show the files at the right panel right click on the service and click browse it will open the service in the browser and you will get the service URL as "http://localhost/RegIIS/Service.svc" so you can see service location is independent of the port number it is published in the IIS and you computer is acting as window server

Step 7 : if there is any problem occurring with permission go for the following steps
right click on the site at the left panel RegIIS --> All Taks --> Permissions Wizard --> click next --> check select new security settings from a template --> click on public website --> next --> check on "replace all directory ,,, ( recommended )" click next and finish

In the next tutorial i will invoke the Service from a new application

Now you can invoke the wcf service methods without visual studio compiler ,,, first search for the phrase "wcftestclient" in windows search , get the path from title bar , copy it
go to command prompt change directory with cd - "copied url " -- hit enter , then type "wcftestclient http://localhost/RegIIS/Service.svc "

and hit enter , bingo the wcf test client will be opened and your service will be added

PART 2 : Simple Login Control Using WCF Service and Linq

2011-09-18T08:17:00.000-07:00

Now lets drag the table into the RegDB.dbml section it will create the DataClass MST_USER ,

Lets create a method for registration , where user will enter the four fields name,email,user id and password in IService.cs file we will declare the data member and the method in the Service contract , copy paste the following code inside the namespace :

[ServiceContract ( Namespace="http://www.yoursite.com/"),XmlSerializerFormat] **
    public interface IService1
    {
        [OperationContract]
        bool registration(string name, string email, string uid, string pwd);

        [OperationContract]
        bool login(string uid, string pwd);

    }

    // Use a data contract as illustrated in the sample below to add composite types to service operations
    [DataContract]
    public class UserInformation
    {
        string _name;
        string _email_id;
        string _user_id;
        string _password;

        public UserInformation(string name, string email, string uid, string pwd)
        {
            _name = name;
            _email_id = email;
            _user_id = uid;
            _password = pwd;
        }

        [DataMember]
        public string Name
        {
            get { return _name; }
            set { _name = value; }
        }

        [DataMember]
        public string EmailId
        {
            get { return _email_id; }
            set { _email_id = value; }
        }
        [DataMember]
        public string UserId
        {
            get { return _user_id; }
            set { _user_id = value; }
        }

        [DataMember]
        public string Password
        {
            get { return _password; }
            set { _password = value; }
        }
    }

we have declared two boolean methods registration for registering and login for login , return true if successful , any ways now we will call this methods in the Service.cs class , copy and paste the following code inside your Service.cs class namespace :

   public class Service1 : IService1
    {
        public bool registration(string name,string email,string uid,string pwd)
        {
            RegDBDataContext rdbc = new RegDBDataContext();
            MST_USER mu = new MST_USER { NAME = name, EMAIL_ID = email, USER_ID = uid, PASSWORD = pwd };
            try
            {
                rdbc.MST_USERs.InsertOnSubmit(mu);
                rdbc.SubmitChanges();
                return true;
            }
            catch
            {
                return false;
            }

        }

        public bool login(string uid, string pwd)
        {
            RegDBDataContext rdbc = new RegDBDataContext();
            var messages = from p in rdbc.MST_USERs
                           where p.USER_ID == uid && p.PASSWORD == pwd
                           select p;

            if (messages.Count() > 0)
            {
                return true;
            }
            else
            {
                return false;
            }

        }

    }
our wcf service is now ready , lets invoke the methods and see whether its working correctly , so run the project after the successful build it will open the wcftestclient environment and add the service

we will click on any of the method it will let us to pass the required parameters then click invoke to invoke the methods , it will return the result in the below response section , you can also view the xml format , give some relevant parameters and test your service

so here our wcf service for registration and login is done , in the next tutorial we will host this wcf application in IIS and invoke the methods

In the next tutorial we will host this wcf application in IIS , Follow the link
Part 3 : Host WCF in IIS

** Read the following article
Click here to read

2011-09-15T12:20:00.001-07:00

/// <summary>
/// Loop through the work sheets of the excel file and set the column value
/// </summary>
/// <param name="ExcelFilePath">Excel File Path</param>
/// <param name="_XmlFilePath">Xml File Path</param>
public void LoopThroughSheet(string ExcelFilePath, string _XmlFilePath)
{
try
{
_ExcelFilePath = ExcelFilePath;

XmlDocument doc = new XmlDocument();
doc.Load(_XmlFilePath);
XmlNodeList _x_node = doc.GetElementsByTagName("name");

_ReadOnlyOrNot = false;
OpenExcel();

foreach (Worksheet ws in _ExcelWorkBook.Sheets)
{

if (GetUsedRowCount(ws.Name) > 1)
{
int _count_used_rows = GetUsedRowCount(ws.Name);
int _start_index;
for (_start_index = 2; _start_index < _count_used_rows + 1; _start_index++)
{
if (FetchCellData(_start_index, 1, ws.Name) != "")
{

if (i < _x_node.Count)
{
SetCellData(_start_index, 2, ws.Name, _x_node.Item(i).InnerText);
i = i + 1;
}
else
{
i = 0;
SetCellData(_start_index, 2, ws.Name, _x_node.Item(i).InnerText);
i = i + 1;
}

}
else
{
break;
}
}
i = 0;
}
else
{
break;
}

}
SaveExcelAs("excel_test.xslx");

CloseExcel(false);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}

}

Tricks and tips in .net with easy codes

Simple version control using TortoiseSVN 1.7.7 Part 2

Simple version control using TortoiseSVN 1.7.7 Part 1

Merge multiple rows into a single using T-Sql stuff function

Drag and Drop item between two list boxes when the source listbox is databound

Split a string into table rows

Changing Datatype of a datatable column at runtime

Items collection cannot be modified when the DataSource property is set - Problem is solved

Importance of GO statement in T-SQL

Easy way to export Excel data into a Datatable

Concepts of Range in Excel Application

Tips and tricks on manipulating excel from codebehind in c# PART : 2

How to detect mouse right click or left click on windows form

Tips and tricks on manipulating excel from codebehind in c# PART : 1

create a dynamic j-query an image scroller from a database images PART - 2

create a dynamic j-query an image scroller from a database images PART - 1

Create a method for fetching data into a dataset using any stored procedure with any nos of parameters

Use one stored procedure inside PL/SQL block of another stored procedure

Problem with *Result and *Result Specified parameters in WCF service

Calling WCF Service Hosted in IIS and invoke the methods

Format and return all the texts from a website according to your neded pattern

Download all images from a web URL

How to hit offcampus in a good IT company

Part 3 : Host WCF application in IIS

PART 2 : Simple Login Control Using WCF Service and Linq

Problem with Result and Result Specified parameters in WCF service