how to create your own library like sqlhelper

Question

1.00/5 (2 votes)

See more:

Hi
I would like to create my own library like sqlhelper which is given by microsoft for data access layer
Can you help me ??

Posted 31-Aug-14 4:43am

vivek_2984

Add a Solution

Comments

[no name] 31-Aug-14 10:52am

You did not tell us what, exactly, you need help with.

OriginalGriff 31-Aug-14 10:53am

What have you tried?
Where are you stuck?

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

David Lee 145 · Answer 1 · 2014-08-31T07:25:00

Solution 1

You can make your own dll library like below page.

How to: Create and Use Assemblies Using the Command Line (C# and Visual Basic)
http://msdn.microsoft.com/en-us/library/3707x96z(v=vs.120).aspx[^]

This artcle is for data access with ADO.NET.
Using ADO.NET for beginners[^]

Posted 31-Aug-14 7:25am

David Lee 145

Comments

vivek_2984 31-Aug-14 13:47pm

HI
Thanks for reply , but I m trying to create my own dll which contain all method like
execute scalar, execute nonquery .. etc like we do use for sqlhelper .
I need to create for my company
pls help

Nelek 31-Aug-14 14:42pm

Step 1) Do a little research. Google is a good start point
Step 2) Start coding
Step 3) Compile and use the debug to solve little issues
Step 4) When you get a problem you don't know how to solve but at least you tried it, then come back and ask for something concrete with a snippet of the code giving problems

vivek_2984 2-Sep-14 11:00am

Nelek : please do not reply if u r not able answer the question , instead of writing something foolish on board just leave ...
It was simple question and I am able to solve the too.
So next if do not know it just leave it , either writing these foolish thing
Thanks

[no name] 2-Sep-14 18:50pm

No need to be rude to people. You did not ask any kind of a question or describe any kind of actual problem.

vivek_2984 2-Sep-14 21:35pm

let close this discussion , I able to achieve my objective.
It was answered in the same as it was given to me , we never ask question which we actually never try ..

vivek_2984 · Answer 2 · 2014-09-02T05:01:00

Solution 2

refer to this : I m able to solve my problem ..
http://www.totaldotnet.com/Article/ShowArticle136_CustomSqlHelper.aspx[^]

Posted 2-Sep-14 5:01am

vivek_2984

Comments

[no name] 2-Sep-14 18:49pm

Yeah... I guess since you are the only one that knows what the problem was.