The Configurator & SQL

Yahoo Archive
1

Thanks Ted!

 

Brenda

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Tuesday, November 11, 2014 12:44 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] The Configurator & SQL

 

 

Here is an example.

 

 

 

 

 

 

 

Using C# to execute an existing "SQL View" found on a SQL Server database

using System.Data; using System.Data.SqlClient; class Program { static void Main(string[] args) { // Table to store the query results DataTable table = new DataTable();

Preview by Yahoo

 

 

From: "brenda mohr brenda@... [vantage]" <vantage@yahoogroups.com>
To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
Sent: Tuesday, November 11, 2014 11:58 AM
Subject: [Vantage] The Configurator & SQL

 

 

I am working with Development to get to the configurator input values.  They have sent me a script that will create a view in our SQL database.  So now I need to get that data back into another configurator session.  What I need, from the creative minds in the group, is an example of the C# code that would actually query the SQL view and pull in that data for me. 

 

Brenda

E10.0.700.2

 

 

 

2

I am working with Development to get to the configurator input values.  They have sent me a script that will create a view in our SQL database.  So now I need to get that data back into another configurator session.  What I need, from the creative minds in the group, is an example of the C# code that would actually query the SQL view and pull in that data for me. 

 

Brenda

E10.0.700.2

 

3
Hi Brenda,
This is a standard C# thing not necessarily an epicor one. A quick Google search should yield tons of examples of calling SQL within C#


Jose C Gomez
Software Engineer


T: 904.469.1524 mobile

Quis custodiet ipsos custodes?

On Tue, Nov 11, 2014 at 11:58 AM, brenda mohr brenda@... [vantage] <vantage@yahoogroups.com> wrote:

 
<div>
  
  
  <p>

I am working with Development to get to the configurator input values. They have sent me a script that will create a view in our SQL database.  So now I need to get that data back into another configurator session. What I need, from the creative minds in the group, is an example of the C# code that would actually query the SQL view and pull in that data for me.Â

Â

Brenda

E10.0.700.2

 

</div>
 


<div style="color:#fff;min-height:0;"></div>

4
Here is an example.

 
 
 
 
 
 
Using C# to execute an existing "SQL View" found on a SQL Server database
using System.Data; using System.Data.SqlClient; class Program { static void Main(string[] args) { // Table to store the query results DataTable table = new DataTable();
Preview by Yahoo
 

From: "brenda mohr brenda@... [vantage]" <vantage@yahoogroups.com>
To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
Sent: Tuesday, November 11, 2014 11:58 AM
Subject: [Vantage] The Configurator & SQL



I am working with Development to get to the configurator input values.  They have sent me a script that will create a view in our SQL database.  So now I need to get that data back into another configurator session.  What I need, from the creative minds in the group, is an example of the C# code that would actually query the SQL view and pull in that data for me. 
 
Brenda
E10.0.700.2