Call store procedure in Kinetic Function not working

Kinetic ERP
21

Thanks this is helpful, but not able to read my data.

This is my code and I am trying to use sqlreader but don’t get it how to use:

Blockquote
Assembly System_Data_SqlClient = Assembly.Load(“System.Data.SqlClient”);
Type typeSqlCommand = System_Data_SqlClient.GetType(“System.Data.SqlClient.SqlCommand”);
Type typeSqlConnection = System_Data_SqlClient.GetType(“System.Data.SqlClient.SqlConnection”);
using (dynamic conn = Activator.CreateInstance(typeSqlConnection,“Data Source=DLT-ERP-tsDB01;Initial Catalog=EpicorDev;User ID=EpiReports;Password=p@ssword123”) )
{
conn.Open();
string cmdText = “spReport_InvoiceEditList”; //sql commands
using (dynamic command = Activator.CreateInstance(typeSqlCommand, new object{ cmdText, conn }) )
{
command.Parameters.Add(“@GroupID”, SqlDbType.VarChar).Value = GroupID;
command.CommandType = System.Data.CommandType.StoredProcedure;
//command.ExecuteNonQuery();
using(SqlDataReader reader = command.ExecuteReader())
** {**
** }**
}
conn.Close();
}

22

Also I got this error while saving BPM

Blockquote
The type name ‘SqlDataReader’ could not be found in the namespace ‘System.Data.SqlClient’.

23

I can’t get into my other environment at the moment, but I have an example for SQLDataReader.

24

great