ajmerainfo supports this item


This author's response time can be up to 1 business day.

15 comments found.

look good but there is some question for you. Are you build dynamic query by function values. And then execute or you manage all the things by store procedure. As dynamic sql have sql injection problem and some security issue there. I will wait for your reply.:)

In all function we have following parameters that can inject by user. (Where, Sort, SortType).

TableName and Columns can’t inject by user In code I have take care for that. (FYI: It should not come from front side.)

About other field you require to take care from server side. just replace all parameters replace by single (‘) quote by double single quote (’’).

If you require more help from my side please let me know. or If you require code of how to prevent SQL Injection let me know I will mail you Extensions method.

Thanks. :)

Does this come with the source code?

Sorry, got my own answer from simply reading the description! Thanks


yes, SQL Helper comes with source code that you can customize it :)

How do i add it to my c# page? what is the namespace for the using sqlhelper….

Thanks, Huambo

Everything is in documents. You can use “DAL” namespace.

How do I discover the metadata of the database, like tables etc?

You need to write manfully. Just it looks like LINQ make own query and fast output.

Greetings, What you are saying is hat myrecords can be treated like a normal datatable? Huambo

What database does this support?

Ok it will not support mySQL or Oracle. Right?

Does it support MySQL?

It’s support only MSSQL

This library sounds delightful. Before I buy this source code I have one question: Does your code have parameterized SQL?

Hi I am trying to use this code MyResult result = SqlHelper.GetTables(“customers”); It is throwing error The type initializer for ‘DAL.SqlHelper’ threw an exception Am i missing something ? pls guide

Hi, I have sent you an email of the project. Its in dotnet 4.0 tx

You need to change connection string name in web.config file. Check my document http://ajmerainfo.com/sqlhelper/#Installation Do it like below code in web.config
<add name="ConnectionString" connectionString="[Your Connection String]"/>

Sorry for the silly mistake

Its working now !

Thanks for your support :)

can insert and update database ? or i can customize easy or not ,i want to buy now

please update or create new products for support I will buy it ,thank

Sure. I have already created new version but need to write document. I will write soon and will update here.

thank you

Good job, wish you big sales :)

Thank you.

Very nice job dude

Thank you.

Hi, I purchased and having a little challenge in getting this query working

Cities table – has Id, list of cities Comments table – has userI, Comments, dates, citiesForeignKey)

So, I want to get user comments in a city,

(GroupBy Cities, Between Jan and May, for userId James)


@smartgrid, Apologize for delay reply was on Vacation.

Right now you can’t do group by query here. I am going to release new version soon. Just Writing document for that one.

Is it possible to loop into the sql result or query and do some updating based on that result and possibly update other tables using sql helper?

Can this be used in desktop app vb.net? Thanks very much

Yes. It would be great. So I can add new features.

How do I display the fetched data to a DataGridView?

You can fetch data into MyResult with dataset/datatable and you can bind that one.

I have an Error “The type initializer for ‘DAL.SqlHelper’ threw an exception.”

Sorry it is suppose to be very straight forward and easy to use but somehow I cant get the result for the query, is the “result” thing like a resultset where it can be displayed on grid control for example? or is it a type of integer or decimal to display or assign to a variable? May I kindly request for a very simple project where you used the sql helper ? Thanks!

Can you please share your code with my email address for trobalshoot error? ajmerainfo@gmail.com

I don’t have sample project right now I made this almost like 6 years ago. I have created new version but writing document from long time but will release soon.