SqlHelper not working at all...

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

Hi,

I am just new using the Microsoft Application Blocks .NET. I am using a custom one...

The problem is that when I call the SqlHelper parameter as "SqlHelper. " it only shows to me "Equals" or "ReferenceEquals". Why I can get the others...?

public void ExecuteNonQuery(SqlCommand sqlCmd) {...}
public SqlDataReader ExecuteReader(SqlCommand sqlCmd) {...}

What I am missing?

I did this:
1. I downloaded the MS Application Block .NET and then using the Data Access Block I ran my custom code there to get the .dll. Just cooy and paste to replace the original code... It gave to me an error with "missing XML comment" so I disable it.
2. Then I went to my C# code and added as Reference.
3.Finally I added it as "using Microsoft.ApplicationBlocks.Data;"

Posted 15-Sep-10 8:50am

jalmonte

Add a Solution

1 solution

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)

Sandeep Mewara · Accepted Answer · 2010-09-15T09:00:00

If you see closely, the methods exposed in the helper class are not 'static' methods and thus they are not associated with class directly. In order to access the methods, you need to create an object of the SqlHelper class.

Try:

C#

SqlHelper objSqlHelper = new SqlHelper();
// Now try objSqlHelper.  

// you should find all the methods present in the helper class in the intellisense.