SQLDataReader Code Generator

Save 15% On Pluralsight - Annual Subscription Only $299

Pluralsight courses
LinkedIn Premium uses PayScale to estimate job salaries

Save 15% On Pluralsight - Annual Subscription Only $299


Premium (Not Free) Video Tutorials

Free Video Tutorials & Free Tools

Here is a  that can save you a hours of programming time. The name of the tool is Ideal Tools Organizer, and it contains a very powerful built in tool called SQL to Grid. You can download the SqlDataReader Code Generator tool now by clicking on Ideal Tools Organizer.

SQLDataReader Code Generator: Overview of SQL to Grid

sqldatareader code generator,.net code generators,c-sharp, vb.net, asp.net

The purpose of the SQL To Grid Tool is to allow one to quickly generate the VB.NET or C-Sharp code needed to get data from a sql server query, or stored procedure, and display the results in a gridview.

The main task that you have to do in order to use SQL to Grid is to write a sql query or stored procedure. If you find it difficult to write a sql query, you may want to use SSMS to help you. In SSMS, if you right click while in the query window, you can select "Design in Query Editor" in order to get a very nice visual designer.

SQL To Grid uses sqldatareader to process each row. Each row is added to a datatable that is then bound to the gridview.

If you only want to generate code to get data out of a sql server database and do not care about going to a gridview, you can just delete the code that adds rows to a data table and binds the table to a gridview. This will leave you with a nice little loop that uses sqldatareader to read each row. The loop will get each column in the select statement and put it into field that you can easily manipulate.

SqlDataReader Code Generator: Benefits

1. Detail Code Eliminates the Need to Use FindControl

The advantage of using the SQL To Grid tool over using ADO.NET sqldatasource is that SQL To Grid generates all the detail code to make it easy for you to modify. SqlDataSource is a kind of fire-hose approach, but it is very difficult to find where to modify each field in the datarowbound event. SQL To Grid makes it where you do not have to use FindControl to try to find the column in each row.

2. ItemTemplates Make It Easy to Modify How Gridview Displays Information

Another advantage of SQL To Grid is that it generates item templates for each of the fields in the gridview so that you can easily modify how the information is diplayed in the gridview without having to manually create your own item templates.

SqlDataReader Code Generator: Inputs

Sql To Grid takes three types of inputs:

1. Connection Strings

Connection String allows you to specify the database, etc. to use. Do not put quotes around the connection string.

2. Sql Statement or Stored Procedure

The sql statement can involve multiple tables and be just about as complicated as you want to be.

3. Parameters

You have up to five parameters. If you are using a sql statement, the computer will find the parameters in your statement and prefill the parameter names for you. You need to include the @ in front of each parameter name.

SqlDataReader Code Generator: Outputs

Sql To Grid generates two types of output:

1. Code-Behind

The code-behind consists of some commented out using or import statements and a subroutine called ReadSql(). You will need to add the call to ReadSql in the load event for your page if you want to populate the gridview on page load.

2. ASPX Code for Gridview with ItemTemplates

The ItemTemplates make it easy for you to modify how the data is displayed in the gridview.

Related posts:

  1. SqlDataReader Example – VB.NET – SqlDataReader Example Source code example in VB.NET of SqlDataReader...
  2. VB.NET ASP.NET Table Load From SqlDataReader Source Code Example VB.NET ASP.NET Table Load From SqlDataReader Source Code Example...
  3. SqlDataReader Example – C# – SqlDataReader Example C# Source code example shows how to use SqlDataReader to...
  4. C# ASP.NET Table SqlDataReader Example – SqlDataReader Table Example C# ASP.NET C# ASP.NET Table SqlDataReader Example - SqlDataReader Table Example C#...
  5. Free online stuff generator list Here is an awesome list of online generating apps which...

Related posts brought to you by Yet Another Related Posts Plugin.

Speak Your Mind

Tell us what you're thinking...
and oh, if you want a pic to show with your comment, go get a gravatar!

Powered by WP Hashcash

This blog uses the cross-linker plugin developed by Web-Developers.Net