This author's response time can be up to 1 business day.
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.
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….
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.
What you are saying is hat myrecords can be treated like a normal datatable?
What database does this support?
It’s support MSSQL 2005, 2008, 2012 .
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?
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 ?
Can I have rest of code for that page?
So I can get more idea about your code and what is error?
Also can I have detail error message?
I have send you an email, pls check
What’s your dot net version? it should be 3.5+
Did you check your connection string?
It should be on web.config file.
Still if you have problem then
Can I have your code?
I have sent you an email of the project.
Its in dotnet 4.0
<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
You can execute any query very easily.
And you can get entire source code so you can customize however you like.
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.
Good job, wish you big sales
Very nice job dude
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
You can update records through DataSet of .Net object.
Also it will work with vb.net but document is for only c#.net
Thanks for the reply, May I kindly request if yo can make also a demo on how to do it?
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!
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.
Use, by you or one client, in a single end product which end users are not charged for. The total price includes the item price and a buyer fee.
Use, by you or one client, in a single end product which end users can be charged for. The total price includes the item price and a buyer fee.
View license details
Get it now and save up to $2
Deliver better projects faster. Photos, templates & courses
Unlimited downloads. Only $29/month
Learn almost anything with
Envato Tuts+ for free
25,000+ tutorials and 1,000+ courses
Designers matched perfectly to
you on Envato Studio
2000 artists ready to undertake your work