What is SQL Helper?
I’m sharing this with the world because we need another way to access data – don’t you think? Truthfully – I wanted to see if I could flex the C# stuff and run up data access with a single dll and signle line of functions.
Features
- Fetch data with signle line of functions
- Fetch data with custome column’s name
- Fetch data with sorting
- Fetch data with diffrent type of joins
- Fetch data with paging
- SQL error handling
- Full dll source code – (You can customize as your own way)
- Development time saving…
Demo Code
-
Select All Rows With All function
dTable.All("TableName");
-
Fetch data with Select function
dTable.Select("TableName");
dTable.Select("TableName", "Columns");
dTable.Select("TableName", "Columns", "Where");
dTable.Select("TableName", "Columns", "Sort", "SortType");
dTable.Select("TableName", "Columns", "Where", "Sort", "SortType");
Select function is very usefull and it has five overload methods.
All parameters description is above this function.
-
Fetch data with Where function
dTable.Where("TableName", "Where");
dTable.Where("TableName", "Where", "Columns");
dTable.Where("TableName", "Where", "Columns", "Sort", "SortType");
-
Fetch data with OrderBy function
dTable.OrderBy("TableName", "Sort", "SortType");
dTable.OrderBy("TableName", "Sort", "SortType", "Columns");
dTable.OrderBy("TableName", "Sort", "SortType", "Columns", "Where");
-
Fetch data with Paged function
dTable.Paged("TableName", "PageIndex", "PageSize");
dTable.Paged("TableName", "PageIndex", "PageSize", "Columns");
dTable.Paged("TableName", "PageIndex", "PageSize", "Columns", , "Where");
dTable.Paged("TableName", "PageIndex", "PageSize", "Columns", , "Where", "Sort", "SortType");
You can fetch data with paging and you paging result will return with MyResult class.
PageIndex you require to pass your current page index. which you require to show in list.
PageSize pass your current page size.
Support
Once again, As I said at the beginning, I’d be glad to help you if you have any questions relating to this code.
I’ll do my best to assist. If you have a more general question relating to the code on CodeCanyon,
you might contact me at here. Thanks so much!.
For new features:
Though we will never discourage users from developing solutions that solve their needs,
the goals of the SQL Helper are very focused. If you are looking to get new features merged back into the SQL Helper DLL,
we highly encourage you to contact me at ajmerainfo@gmail.com or write
comment on my CodeCanyon this product page.
Thanks.
hit counter
