I want to make a Stored Procedure but I am not sure how to call it from C#. I am new at a company and I am trying to understand their way of doing things and there isn't anyone who can answer my questions. It doesn't look like they use Stored Procedures so I can't copy the process on calling it. It looks like they do everything in one query string but I need to change it.
Here is the line of code to send the SQL string to the DB:
ArrayList dl = new ArrayList();
string sSQL = "SELECT * FROM Contacts";
Cm.ex(Cm.pldt, sSQL, null, null, null, null, dl, null, null, null, true);
Here is the definition for Cm:
public class Cm
public static string cp;
public static string plc;
public static string pld;
public static string pldt;
public static string plw;
public static string ex(string cmm, string fc, string cmt, Hashtable ch, string ot, Ob rob, ArrayList al, Ts gts, Dl gdl, Label rl, bool q);
I hope someone can help and if I need to provide more information please let me know.