December 29, 2008

This row already belongs to another table Exception in dataset, datatable, ado.net

Error / Exception:
This row already belongs to another table

This error occur when a row from a datatable is added to another dataTable.

as a row can only belong to only one table. so this exception occurs.
Source row may be selected using dataTable.Select() or find. or direct dtTable.Rows[0] etc.

in every case it will generate error. so to avoid this error.
You can use following to methods

1. add a new row in destination table and copy field one by one from source to destination.

2. using ImportRow
firsly clone the table.

DataTable dest = source.Clone() // it will copy the structure to the dest table.

now dest.ImportRow(dest.Rows[0]);

it will run sucessfully.

any doubt please comment

December 04, 2008

copy, transfer songs from iphone,ipod to pc/mac/laptop using widows & apple

Copying/transfer music|songs from apple iphone 3G,ipod nano,ipod touch,ipod classic, to desktop/mac and desktop/mac to iphone, sync and update your iphone,ipod using multiple computers
.
Itunes do not support the first feature to avoid piracy

"Not possible using ITunes' any version" you need some Itunes kind of software without restriction.

a lots of people search for copying data from iphone/ipod touch. so here is the solution.

a lot of good softwares are on net.
but some of the best one are following.

1. www.mediamonkey.com - I am personally using it for my Iphone. really cool- as i sync it with multiple machines, My office and Home.
it is very good free software to use. You can sync and copy songs without Itnues.
both free and paid version exist. but free one is cool as paid does not contain enough options to buy it.

2. www.getsharepod.com/ - gave some problem on 2.2 firmware. so did't used.
it is also good.

3. Amarok
4. iMPware
5 Floola

just google above software you will reach the site and read the details.

now download the software,transfer copy music from ipod to computer|laptop.
Enjoy and thanks the devlopers of the software.

November 11, 2008

MCTS-MCPD-NO OF QUESTIONS, PASSING MARKS, DURATION

I got a lot of comments and mail for these kindda questions. So i planned to write this article about that.

Passing Marks
Microsoft has not clearly mentioned the passing marks and out of marks.
But you need to score 80% to clear the exams.
Experience tell that MCTS(both) and MCPD are out of 1000 marks. you need minimum 800 to clear the exam.

No of Questions

Minimum 40 (most of the cases)
Maximum 50

Duration
2.30 - 3 hours according to questions.

these are the no's according to the my experience at time of giving the exams. It could change later by Microsoft.

Don't hesitate to comment if any question/query is in your mind.

October 07, 2008

server rejected one or more recipient addresses. The server response was: 550 5.7.1 Unable to relay

The server rejected one or more recipient addresses. The server response was: 550 5.7.1 Unable to relay for

Reason.

your connection ip or relay ip is not matching with ip you are using to send mails.

OPen iis from control-panel->administrative tools->internet information services.

now right click "default smtp virtual server" & selcect properties as shown in following image.


now select the appropriate IP in connection drop down that should match with the IP you are using to send mail.

now select the "Access" tab you will see the screen as follow



in Connection and Relay add same IP.

it will resolve the problem

Related Article(s):
The transport failed to connect to the server.

Generics Explanation benefit limitation

Generics: part of dot net type system where we have option to leave the type of member.
And that can be given by the consumer code.

Strong Type objects
type Safety.

Only the objects of the class will be allowed that was mentioned while declaring the object.

We can have other objects in the generics
Why.
• Reduced run-time errors The compiler cannot detect type errors when you cast to and from the Object class. For example, if you cast a string to an Object class and then attempt to cast that Object to an integer, the compiler will not catch the error. Instead, the runtime will throw an exception. Using generics allows the compiler to catch this type of bug before your program runs. Additionally, you can specify constraints to limit the classes used in a generic, enabling the compiler to detect an incompatible type.
• Improved performance Casting requires boxing and unboxing which steals processor time and slows performance. Using generics doesn't require casting or boxing, which improves run-time performance.

Limitation:

Essentially, you are limited to the capabilities of the base Object class when writing generic code
So we could not use the + or > operator.

Generics is CLR Supported: Generics is supported by CLR itself. so its not a wrapper kind of thing like properties,namespace etc. Its recognized by the CLR. So in Meta Data Generics class is IL-ed. In realty its will be impossible to do that. Because a generic class can be instantiated with many types so it will blot the IL.

Generic Collection: Entire collection library was rewritten for the Generics.
Here is comparison list :
System.Collections vs. System.Collection.Generic or
Weakly vs Strongly type

ArrayList List
Hashtable Dictionary
Queue Queue
Stack Stack
SortedList SortedList
IEnumerable IEnumerable
IList IList
CollectionBase Collection

New Classes In Genric that do not have non generic equivalent.

SortedDictionary
KeyedCollection
LinkedList


Framework :2.0+
Visual studio: 2005 and 2008
please comment if you have any doubt and further want info. it will be updated very soon after your questions.

October 06, 2008

Exception-The transport failed to connect to the server.

Error/Exception: The transport failed to connect to the server.

Reason: if this is occurring while sending mails.

then it can be two reasons

1. you have given wrong smtp address.

2. your smtp server is not running.
type services.msc, all services will be displayed, search for smtp service.
and start it, if its stopped.

Right click on services and check "startup type" if "disabled" selected then select "automatic".
and test it.

if still any problem comment with the proper description.

Related Links
Exception-The transport failed to connect to the server.

postgresql-npgsql-array pass-error-invalid Syntax integer

something users want to test the function/procedure in npgsql postgres PL/pgSQL from command rather than from dot net program

sometimes could get the error:

"invalid input syntax for integer:" it means some assignment problem is there.

how to call a function passing a array.

select * from insert jet_map(387::int4,array[1,2,5]::int4[],array['1245,128','697638,697643','45,78']::varchar[]
,'ChangeItAfterTest'::varchar)

September 24, 2008

Just Chrom(ing).

I heard about the chrome on 2-sep-2008. I read full 37 pages chrome cartoon books. I was really waiting for at least two of the features that chrome has brought.

1. It was tab moving, Moving one tab to another window without losing state.

2. Avoid crashing of whole browser when a tab consume memory or malfunction.

3 Status bar comes when needed not reserve you screen area.

4. It increased my screen estate area now it is bigger.

5. Spell checker it there( I think Mozilla too have with plug in)

6 When u hower a link it display link bottom-left.



speed is very much same as Safari 3.1.

Missing Features:

1. I am still missing some of my productive firefox plugins that tell me about the pagerank, alexa-rank, my google bookmarks etc.

2. enable/disable javascript option

3 enable/disable images option.

it is out of beta now.

Will google be next evil?

Google itself says "Don't be evil", Is It true? let us find out.

Google, for some people Internet start with this name. it is buzz name in the Internet industry or dot com industry. Google is trying to capture each and every section of dot com. main businesses are following.

Search (killer)
Advertisement
Mail
Maps
IM
Social network.
Analytics
Online office
Bloggingg
Apps
Lang converter
Browser (new)

Google also has search database of people.
Google has been acquiring a lot of companies till date more than 50 companies.
[Link: copy to you browser]
en.wikipedia.org/wiki/List_of_acquisitions_by_Google



Is it a threat to start-up companies?.
Recently Pressmart(Indian company) spurned the Google bid. It was really a bold decision by PressMart.

"Nobody is evil, but it is the power that make them evil". So company who will have monoply in every field , what are the chances of that? i think anybody having little knowledge about internet can answer the question.

September 01, 2008

MS Certification HelpLine No

Ms has provided some helpline links related to certification Help:
India
BSNL : 18001021100
Bharti : 1800111100

Email : mcphelp(at)microsoft.com
iscres(at)microsoft.com

any help..... just put a comment.

clustered vs non-clustered Index sql server

Question: difference between clustered and non-clustered Indexing,

following are some compiled differences list. May be useful for you.
if useful & more info to add please comment if anything wrong please criticize

1. Only one clustered and 249 nonclustered indexes.

2. Clustered index can be on primary key and other.

3. If you don’t want to create clustered index on primary specify it.

4. SQL Server determines whether to use an index by examining only the first column defined in the index. For example, if you defined an index on FirstName, LastName and a query is looking for LastName, this index would not be used to satisfy the query.

July 18, 2008

I am now MCTS,MCPD

I cleared my MCPD exam last week. I enjoyed the learning, learned a lot of new things.
the main benefit i got are

Understanding the different new concepts that usually do not come in practice.
but if you know you will like to use it in the regular programming.While reading the MS self paced book i got clear view of

Threading.
Security
Collection
Serialization
Templates
Testing
Asynchronous Programming(Really cool)
Monitoring and deploying apps
Visual studio's different testing capabilities.

now thinking to strong my sql server skill by MCITP
which include two exams 70-331, 70-441,first one is prerequisite for second one.

i just downloaded the books those are very informative.
How to pass the microsoft certification

Microsoft retiring Some exams be careful

Fee structure of MCTS MCPD

Microsof exams center in your city

Questions, passing marks, Duration

Microsoft retiring,closing old exams

March 31, 2009 Ms will retire the following exams, so please don't go for these.
This is microsoft's policy to close the exams.

• 70-300
• 70-310
• 70-315
• 70-316
• 70-301
• 70-305
• 70-306
• 70-320
• 70-728
• 70-729
• 70-330
• 70-340

How to study/Clear/Pass the MCTS MCPD MCITP

I got alot of queries in various mails and comments so i decided to write this article.
To clear the examination you don't have to go to any center. Just purchase microsoft self paced kit for the

various exams(70-528,536,547,548,431,441)as mentioned in my
previous article

Even you can download a pdf from the internet. Try the questions at end of each chapter, also do the

practice question. Cd come in pack if you purchase hard copy there are a lot of examples and practicle

question.

Second Way is read dump but that is not recommended approach , you will learn nothing and that will be

only a tag, that will not work if your are going for interview coz you will be caught easily.

Related Articles

I don't understand why micorosft still providing all the question in exam that are already available through dumps in market.Microsoft please change the questions regulary. All registered centers should fetch fresh questions from the servers on daily basis.

I am now MCTS, MCPD

Fee structure of MCTS MCPD

Microsof exams center in your city

Questions, passing marks, Duration

July 09, 2008

Unable to start debugging on the web server. Debugging failed because integrated Windows authentication is not enabled

Microsoft Visual Studio
Unable to start debugging on the web server. Debugging failed because integrated Windows authentication is not enabled. Please see Help for assistance.

This comes when integrated "Windows authentication" is disabled in IIS.

Resolution:

Go to IIS.

in websites right click the desired website on which error is coming , then select properties, then "Directory Security" tab, then "Edit..." under "Anonymous access and authentication control" section on selection this a dialog box will open check the "Integrated Window authentication" press ok, ok.

it will resolve the problem.

July 07, 2008

MCTS,MCPD Fee Strucutre ( Microsof exams)


Microsoft exams are less costly then any other exams in industry. eg. Java or Oracle.

Starting with the MCTS which consist of two exams 528 and 536 same for windows and distributed MCTS.

Each exam paper costs Rs. 2250 - 3000

70-528 - 2250
70-536 - 2250
70-547 - 2200

Same is for any other Microsoft exam.
How to pass the microsoft certification

Microsoft retiring Some exams be careful

I am now MCTS, MCPD

Questions, passing marks, Duration

July 05, 2008

Location - prometric center for microsoft exam.

To give a exam for any of Microsoft certificate.
You can go to any prometric center in your city.
NIIT,Aptech are some of the name those have prometric center for the exams.
you have to go there , Pay and sit for the exam.

Depending on your city, at least 2-3 days before you have to book your exam.

if you want to search in your city. Please go through this link.
http://www.register.prometric.com/Index.asp
select country/state then Microsoft then exam no. it will show the no of exams.
if any other info required do comment.
More articles.

Certification demystified

How to pass the microsoft certification

Microsoft retiring Some exams be careful

I am now MCTS, MCPD

July 01, 2008

iPhone 3G

Finally on 9-jun-2008, Apple kicks the butts of iphone 2.5G users with the launch of cheaper 3G with Maps and many more features. Apple usually do this as on first 3-4 months after launch it was sold over $500 then dropped the price and 4gb version. With the recent launch of new version it surprise the users and market.
I also felt the heat as only two months ago i spent $430 on device. Its now a like a black box in comparison to the 3g one. Following are the changes.

Price difference:

8GB ---- 16GB
Old $399 ---- $499
3g $199 ---- $299

Features:

Hardware: -- Software

GPS -- Better Email Management
3G -- Contacts Search
Flush Jack(any headphone) -- Email Attachment Support
Battery Life -- Mobile Me(sync features,$99 subscribe)
Multi-color(only 16gb) -- MS exchange sync
Hard Buttons -- Improved Sdk.

Software changes will also be available to the old users free of cost.

Still it lacks:
Bluetooth Transfer
IPod's quality on Speakers phone.
Phone quality (as not mentioned by apple about improvements)
Video Recorder
Audio Recorder
Weight
Camera Quality still same

It also made a threat to the market leaders like black berry and Nokia in enterprise phone market as with $199 we can call it gPhone not Google its Gareeb-Phone (poor people Phone).

Lets wait 10 days and see the reviews.

how to install multiple ie Internet Explorer

Recently i found a very good software link.

you can install multiple/different version of internet explorer in your system side by side.it removes the Microsoft Windows' limitation
URL: http://tredosoft.com/Multiple_IE

install and enjoy.

April 30, 2008

iPhone experience


Last week i purchased an Apple iPhone. Its security needs to break (Unlock) to run any other network other than at&t so i did. now i am running it on Airtel (Garv se bolo "Hello").
As it is from Apple it is very Innovative. I am damn fan of its tapping and finger touch technology. It is far away from any other high tech phone in market. but one thing it lacks in its phone features mean calling , alarm , speaker phone, network strength are not of very good; Nokia is the master of these features you can't beat Nokia in calling and network strength features. So for these features Apple need to do a lot of work. like me Sergy Brin is also a fan of iPhone
see this.
http://bits.blogs.nytimes.com/2008/01/31/sergey-brins-iphone-adventure-in-davos/

iPhone lacks in following:

Network strength
Alarm
Speaker phone
camera zoom features
no Video
3G.

Iphone is master of:

User Interface (Greatest feature main reason to buy)
Camera Quality (if picture taken from close.)
built-in iPod (obvious)
Browsing (awesome no phone currently give u such experience)
and third party tools that can be installed on iphone after jail-breaking it.
Photo browsing.

Popular apps on iPhone

Google Maps (great)
Track Ball (Control your computer)
Terminal (like unix)
safari (a full featured browser on this little device)
RSS
youTube downloader
stock and weather (from yahoo)
dictionaries
chat tools.

you can use iphone as a remote of your pc & mac using
trackball app (vnc server required on pc you connecting to )

You can also develop apps but for that prerequisite is mac. Because sdk available is only for mac.
i wanted to start it. but i don not have mac.

legally apple does not allow installing third party apps. but hacker community broke the security just after the release of iPhone.

There is rumour that apple is coming with next generation phone(3g) very soon it might be a unlocked version.

In India it will launch in 3rd quarter of this year possibly with Vodafone

March 28, 2008

Join the 'Earth Hour' by switching off all lights this Saturday 8.30 PM - 9.30 PM. Just for one hour.

Join the 'Earth Hour' by switching off all lights this Saturday 8.30 PM - 9.30 PM. Just for one hour. ---------------------------------------------------------------------------------------- Close to a billion people from 825 cities across the world would join this fight and pledge to bring about a change! Leading corporates across the world would also be supporting the cause.

The 'Earth Hour' was initiated by WorldWide Fund for nature (WWF) just two years ago in Sydney, as a show of solidarity against Climate Change, when 2.2 million homes and businesses switched off their lights. Just for one hour. The movement has today spread to more than 80 countries.

January 16, 2008

clustered vs non-clustered Index sql server

Question: difference between clustered and non-clustered Indexing,

following are some compiled differences list. May be useful for you.
if useful & more info to add please comment if anything wrong please criticize

1. Only one clustered and 249 nonclustered indexes.

2. Clustered index can be on primary key and other.

3. If you don’t want to create clustered index on primary specify it.

4. SQL Server determines whether to use an index by examining only the first column defined in the index. For example, if you defined an index on FirstName, LastName and a query is looking for LastName, this index would not be used to satisfy the query.