SQL Helper

What Is SQL Helper?

I’m sharing this with the sector as a result of we'd like otherwise to get right of entry to information – don’t you think? Honestly – I Needed to see if i could flex the C# stuff and run up knowledge get entry to with a unmarried dll and signle line of purposes.

Options

• Fetch information with signle line of functions
• Fetch data with custome column’s identify
• Fetch information with sorting
• Fetch data with diffrent form of joins
• Fetch information with paging
• SQL errors managing
• Complete dll supply code – (you can customise as your own manner)
• Construction time saving…

Demo Code

• Make A Selection All Rows With All function

  dTable.All("TableName");

• Fetch information with Choose function

  dTable.Make A Choice("TableName"); dTable.Select("TableName", "Columns"); dTable.Choose("TableName", "Columns", "Where"); dTable.Make A Choice("TableName", "Columns", "Sort", "SortType"); dTable.Make A Choice("TableName", "Columns", "The Place", "Sort", "SortType");

  Choose serve as could be very usefull and it has five overload methods.
  All parameters description is above this function.

• Fetch information with Where serve as

  dTable.Where("TableName", "The Place"); dTable.The Place("TableName", "Where", "Columns"); dTable.Where("TableName", "The Place", "Columns", "Kind", "SortType");

• Fetch knowledge with OrderBy serve as

  dTable.OrderBy("TableName", "Sort", "SortType"); dTable.OrderBy("TableName", "Type", "SortType", "Columns"); dTable.OrderBy("TableName", "Kind", "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", , "The Place"); dTable.Paged("TableName", "PageIndex", "PageSize", "Columns", , "The Place", "Kind", "SortType");

  you can fetch knowledge with paging and you paging consequence will return with MyResult magnificence.
  PageIndex you require to pass your present page index. that you require to turn in record.
  PageSize move your current page dimension.

Reinforce

Again, As I said at the starting, I’d be satisfied to help you in the event you have any questions when it comes to this code. I’ll do my perfect to help. If you might have a extra basic query relating to the code on CodeCanyon, chances are you'll contact me at right here. Thank You such a lot!.

For New options:

Though we will by no means discourage customers from developing solutions that solve their needs, the objectives of the SQL Helper are very focused. in the event you are looking to get new options merged again into the SQL Helper DLL, we highly encourage you to touch me at ajmerainfo@gmail.com or write comment on my CodeCanyon this product web page.

Thank You.

hit counter
FULL DOWNLOAD